June 2, 2008 at 1:39 pm
Guys,
I can connect the sql server instance through management studio and I can also create a DSN to the same sql server instance. But when the application tries to establish the connection i get the following error
I have checked the following
SQL BROWSER is started
TCP/IP default port 1434 is enabled
At this point I am not sure how to proceed further to trouble shoot this issue.
System.Exception: 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) ---> System.Data.SqlClient.SqlException: 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)
Any suggestions and inputs would help.
Thanks
June 2, 2008 at 1:47 pm
I would like to say there is no issue on your SQL Server. You may check your application server and see whether or not the setting there is correct.
June 2, 2008 at 4:09 pm
If the SQL BROWSER service is started you can connect to the server by refering server name and the instance name. Otherwise you have to specify the port#.
In this case, I beleive you should check your application. it seems nothing to do with sql server side.
Susantha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply