SQL Server 2005 Error 26. Any Ideas please.
-
Hi Folks I wonder if anyone has any ideas that could help me. I've written an application in VS 2005. I use Inno Setup for Installation, which I have used previously with success. When I go to install the program on another machine I get the following error 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) I've checked my Sql Area Configuration and can confirm that I allow remote connections although via using TCP/IP only and have also tried TCP/IP and named pipes. I've checked the SQL Browser and this is also running. I've checked my Connection strings and these are fine. Can someone help please? Thanks alot.:confused:
Kris MCP
-
Hi Folks I wonder if anyone has any ideas that could help me. I've written an application in VS 2005. I use Inno Setup for Installation, which I have used previously with success. When I go to install the program on another machine I get the following error 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) I've checked my Sql Area Configuration and can confirm that I allow remote connections although via using TCP/IP only and have also tried TCP/IP and named pipes. I've checked the SQL Browser and this is also running. I've checked my Connection strings and these are fine. Can someone help please? Thanks alot.:confused:
Kris MCP
It seems like some configuration issues, below link might be help you: http://www.datamasker.com/SSE2005_NetworkCfg.htm[^]
Parwej Ahamad R & D with IIS 5.0/6.0
-
It seems like some configuration issues, below link might be help you: http://www.datamasker.com/SSE2005_NetworkCfg.htm[^]
Parwej Ahamad R & D with IIS 5.0/6.0
-
Hi Still no go I'm afraid. I went to IP Addresses and checked all enabled. I've kept it so I can enable Dynamic ports as a little unsure of this. :-\
Kris MCP
Any firewall between the servers?
--------------------------- Blogging about SQL, Technology and many other things
-
Any firewall between the servers?
--------------------------- Blogging about SQL, Technology and many other things