connection error

hi,

I installed sql server 2005 ,when i try to connect to sql server management studio iam getting this 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

I searched internet and found this :under sql server surface area configuration

So I followed the following steps to change the setting from local connection to local and remote connection:

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration. 2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections. 3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:

Changes to Connection Settings will not take effect until you restart the Database Engine service.

4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

But there is no DATABASE ENGINE It contain ANALYSIS SERVICES.

Then How Get rid from the above error.

Thanks in advance.

hi,

I installed sql server 2005 ,when i try to connect to sql server management studio iam getting this 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

I searched internet and found this :under sql server surface area configuration

So I followed the following steps to change the setting from local connection to local and remote connection:

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration. 2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections. 3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:

Changes to Connection Settings will not take effect until you restart the Database Engine service.

4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

But there is no DATABASE ENGINE It contain ANALYSIS SERVICES.

Then How Get rid from the above error.

Thanks in advance.

|||

Look in the SCM (service Control manager of Windows) There you will find the SQL Server Service "SQL Server (MSSQLSERVER)" (or probably and instance name in the parenth.) Restart this service and you′ll be fine.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de