SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
-
Hello, I have a problem trying to connect a remote sql server. The 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) DEVSQL computer name RealitySolutions instance name Using a windows application on a LAN. my connection string is: connectionString="server=DEVSQL\REALITYSOLUTIONS; database=ServiceMaster; Integrated Security=True This is what I have done: Enabled TCP/IP and named pipes and share memory protocals on my instance in configuratoin management. surface area configuration I have enabled enabled remote connection using TCP and Named pipes. I still get the above error message. Any help will be most grateful, and I think i have tried everything. Thanks Steve
-
Hello, I have a problem trying to connect a remote sql server. The 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) DEVSQL computer name RealitySolutions instance name Using a windows application on a LAN. my connection string is: connectionString="server=DEVSQL\REALITYSOLUTIONS; database=ServiceMaster; Integrated Security=True This is what I have done: Enabled TCP/IP and named pipes and share memory protocals on my instance in configuratoin management. surface area configuration I have enabled enabled remote connection using TCP and Named pipes. I still get the above error message. Any help will be most grateful, and I think i have tried everything. Thanks Steve
-
if connect to server on otder machine,use machine-IP\instance-id,otherwise use "(local)". btw,maybe need config the client-network information with SQL Server Client Network Utility,the server-ip and port,etc.
Hello, thanks for your reply. But i think the ip address would be used for connecting to a remote server on the internet. Local would be the local server on my machine not a remote one. How do i config client-network information with sql server? Not sure about this. Thanks in advance, Steve
-
Hello, thanks for your reply. But i think the ip address would be used for connecting to a remote server on the internet. Local would be the local server on my machine not a remote one. How do i config client-network information with sql server? Not sure about this. Thanks in advance, Steve
Data Source="SQLServerIP\InstanceName";Initial Catalog="DataBase";Persist Security Info=True;User ID="UserID";Password="Password" Obviously the " are just to separate the required values and what you will modifiy.
-
Data Source="SQLServerIP\InstanceName";Initial Catalog="DataBase";Persist Security Info=True;User ID="UserID";Password="Password" Obviously the " are just to separate the required values and what you will modifiy.
Hello private_void, Thanks for your reply. I have noticed you are using that connection string with a sql security. Currently I have my sql server setup for Windows authenication. That is why I never had the pwd or username. Just wondering, can you connect remotely with windows authentication? If so, have I missed something about windows user account? security login? Please if you have any idea about windows authentication. thanks very much, Steve
-
Hello private_void, Thanks for your reply. I have noticed you are using that connection string with a sql security. Currently I have my sql server setup for Windows authenication. That is why I never had the pwd or username. Just wondering, can you connect remotely with windows authentication? If so, have I missed something about windows user account? security login? Please if you have any idea about windows authentication. thanks very much, Steve
-
try to config an alias for "DEVSQL" with sql server client network utility. ps: DEVSQL <=> IP on Lan i have only use SSPI in same machine,not lan or internet yet.:p
Thanks for your reply yahao, But I am sure what you mean by:
yahao wrote:
config an alias for "DEVSQL" with sql server client network utility
How will this help solve the current problem? I have connected to sql server many times. This the first time remotely. The server I am using is 2005 developer edition. Many thanks again, Steve
-
Thanks for your reply yahao, But I am sure what you mean by:
yahao wrote:
config an alias for "DEVSQL" with sql server client network utility
How will this help solve the current problem? I have connected to sql server many times. This the first time remotely. The server I am using is 2005 developer edition. Many thanks again, Steve
-
Hello private_void, Thanks for your reply. I have noticed you are using that connection string with a sql security. Currently I have my sql server setup for Windows authenication. That is why I never had the pwd or username. Just wondering, can you connect remotely with windows authentication? If so, have I missed something about windows user account? security login? Please if you have any idea about windows authentication. thanks very much, Steve
Well I think you should use the IP address. This should be a static IP. If it is not that could be why you are having problems. When you enable the connections via Pipes you should reboot the Server. I don't see anything wrong with your connection string and yes SQL 2005 does allow Windows Authentication, but you still have to set up a Login under Security\Logins. The user name should be Domain\WindowsUserAccount. If you have any questions regarding connections strings there is a great website; http://www.connectionstrings.com. Hope this helps.