September 24, 2009 at 11:07 pm
An error has occured when I am establishing connection from web server to DB server using .net application
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: 25 - Connection string is not valid)
I have
0. Active Active cluster
1. firewall is on both nodes disabled
should I disable the sql browser service because I am using 2 specific ports for both instances ???
Thanks
September 24, 2009 at 11:26 pm
I don’t think that you should disable the SQL Browser. As far as I know the browser helps when you have named instance on your machine, so if you have a named instance the browser must be working. If you don’t have named instance you can disable the browser because it is not being used. As for your problem – Can you connect to the server from other work stations? Can you connect to the server with SSMS or another software from any work station? If the answer for this is yes, then the problem is not with the SQL Server. By default the server writes in the error log the details about failed login. If you didn’t change this setting I suggest that you’ll check the error log and find out what is the error state. After you’ll find it use this URL http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx%5B/url%5D to find out the reason that the login failed.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply