SQL Server 2005 Remote Connection is not enabled
hi, i am able to connect to SQL Server from the same server that is the machine where it is installed using windows or sql authentication. but when try to connect from a remote machine i am getting the below error. A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) after going through some web sites i tried to enable the TCP/IP in the sql server configuration. when tried to enable TCP/IP it i got the below error. "Access is Denied" can anyone tell what is the problem. thanks, Srik
July 15th, 2008 1:16pm

go to sql server configuration manager and under client protocol make sure tcp ip ,named pipes and shared memeory ic enabled.Go to sql server surface area configuration and under databse-> remote connection choose both tcpip and named
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2008 7:11am

Hi, i tried the filrst one. tcp ip ,named pipes and shared memeory ic are enabled already. then i tried the second setting. after selecting both tcpip and named pipes option when i click ok, i got the below alert. i do not understand why it is saying "access denied". TITLE: Surface Area Configuration------------------------------ Alter failed. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+ServerProtocol&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: SetEnable failed for ServerProtocol 'Tcp'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&LinkId=20476 ------------------------------ Access denied (System.Management) ------------------------------BUTTONS: OK------------------------------ Thanks, Srik
July 18th, 2008 8:40am

Try this. 1. Go to server machine and log in to Sql Server Management Studio. 2. Right click on server -> select Properties 3. Click on connections -> Check whether 'Allow remote connections to this server'. 4. If this option is not checked then select the option and try to connect from other system. 5. Also check the Security tab -> Server authentication -> should be 'SQL Server and Windows Authentication mode' Pl let us know if these solves your issue. ____________ Senthil
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2008 12:40pm

Try this http://www.sql-articles.com/index.php?page=Scripts/remoteconn_dos.php
July 20th, 2008 9:20pm

I remember reading that you need to have the service "SQL Server Browser" started, not sure why though...
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2008 9:21pm

Hi Prasanna & Senthil, Thanks for the replies. but none of this is solving my problem. after selecting the local and remote connection and clicking ok it is giving me the same alert. that is "access denied". when i try to start the SQL Browser also i got the same error. Thanks, Srik
July 21st, 2008 11:35am

Hi Srik, I'm troubleshooting a similar problem and found your thread. Not sure if you've solved it yet, almost a month later, but I notice the error message refers to System.Management. Just an idea, but are you on corporate network on which the Network Admins might be using MS System Management Server (http://www.microsoft.com/SMServer/default.mspx) to control access to certain functionality like remote sql server connections?
Free Windows Admin Tool Kit Click here and download it now
August 19th, 2008 11:49pm

Hi Srik, Enable Via, TCP/IP, Named Pipes and Shared Memory in Protocols for <SQLInstance Name>. Then Change in SQL Server Surface Area Configuration.
August 20th, 2008 7:49am

Big Surprise - something as trivial as enabling access to a user/subnet/whateever has been made so confusing as to be unusable. I have just installed SQL server 2005 on a new Windows 2008 server installation. All updates have been applied. I can't log into the SQL server from a remote machine. In fact even when I'm logged in to the server machine under a local account with administrator priveledges, I can't change some setting. In depseration, I've turned off Windows firewall, and still can't connect. WTF ??? When is Microsoft going to stop crippling their software with idiotic configuration issues. I used to really like to use Microsoft products, now I hate them. BTW I've been working as a professional software developer for over twenty years, it's not like I don't know anything about computing.
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2008 7:01pm

Hi Srik, ******** Yankee, I also faced this problem in vista & windows server 2008. I tried to establish a remote connection to SQL server 2005 Express. I found the problem because of the security policies of vista & server. just go to SQL Configuration Manager->SQL server 2005 services-> open the sql server & browser properties select built-in-account as network service.(in vista & windows server 2008 this is default as local system) if u r using the express edition. u have to enable tcp/ip in configuration manager & windows firewall u have to add to expections from sqlservr & sqlbrowser. I hope it will solve ur problems.
November 27th, 2008 12:49pm

When you open the SQL Server Configuration, right click and select RUN AS ADMINISTRATOR if you are on Windows 7 before making the above mentioned changes.
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2010 5:11pm

It worked for me, Thanks a lot Deepak
November 23rd, 2010 7:20am

When you open the SQL Server Configuration, right click and select RUN AS ADMINISTRATOR if you are on Windows 7 before making the above mentioned changes. It Worked for me too Thanks.
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2011 6:42am

When you open the SQL Server Configuration, right click and select RUN AS ADMINISTRATOR if you are on Windows 7 before making the above mentioned changes. It Worked for me too Thanks.
January 29th, 2011 6:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics