Good day! I'm trying to make remote connections to SQL Express and it seems that it is not working.
Below are the steps that I did
- TCP/IP enable in the "Protocols for SQLExpress" node
- Since I'm not going to use SQL browser, I clear out the value for "TCP Dynamic Ports" and instead create my own TCP Port number
- I add my windows authentication to the dbase that I want to try to connect remotely
- Add the sqlsrver.exe to the exceptions of the firewall but even I turned-off the firewall already it still not connecting.
My error message is
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "
Is there any step that fail to apply?
Thanks in advance.
It already worked. I just included the port number to my connection. (Bummer! How come I forgot to include it... :))
No comments:
Post a Comment