Friday, February 10, 2012

can't connect server

I'm using light free version of SQL server 2005 and

Express Manager , until this time everything was OK. But now I cant using it , I cant connect the server (using windows connection) .

That is error alert:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Does anybody know where is problem?

Have a look in the screencast section on my site, especially the Screencast "enable remote connections"

That should help, feel free to comment about that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanx for link, but things don't changed(

I'm programming on C#, then compiler get on conn.Open() it shows an exeption:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Where is the problem?

|||OK, first make sure that the service is started properly on the machine which is named in the connectionstring. Could it be that there are any firewalls blocking the communication ? YOu will have to open port 1433 and 1434 for a proper established communiation if you have choosen the default port. If you did not choose the above mentioned default ports you will have to open them in the firewall and if you don′t have SQL Browser started as a service on your machine (which is a sort of discovery mechanism for the clients connecting to SQL Server) name the port after the Servername\instanceName combination. Thats the next part which will lead me to the question if you have a default instance or a named instance. default instances are normally only represented by the machinename they are running on, named instances have the instance name appended in the following format Servname\InstanceName. If you additionally don′t have browser started (as mentioned above the name combination would be something like ServerName\InstanceName,Portnumber)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment