Connection to management studio | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Connection to management studio

Hi, I am getting this error message, while connecting to SQL server 2005. I was able to conenct to this beforwe without any hassles. I am able to RDP (Remote desktop connection) to this server and able to work in as myself, however i am not able to connect to server from my management studio, I am getting below mentioned error message, ANY IDEAS. Other user is able to connect from his computer and this server does allow remote connections… TITLE: Connect to Server
—————————— Cannot connect to proddwproddw. ——————————
ADDITIONAL INFORMATION: 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) (Microsoft SQL Server, Error: -1) For help, click:http://go.microsoft.com/fwlink?Prod…rver&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 ——————————
BUTTONS: OK
——————————
The error says it not configured for RemoteConnection …. Is this named Instance of SQL Server. is SQL Server Browser Running… Check firewall…. check again is it configrured for remote connection in Surface Area Configuration for Service and Connection…. "Other user is able to connect from his computer and this server does allow remote connections…" this is bit confusing…. "Other user is able to connect from his computer…. " are they connecting through RDP ? refer these links… http://support.microsoft.com/kb/914277
http://msdn2.microsoft.com/en-us/library/ms165724.aspx
you should enable sql server 2005 for remote connection using ‘SQL Server Surface Area Configuration’ its very well explained in the link that Madhu provided..http://support.microsoft.com/kb/914277
Deepak Kumar
MVP, MCDBA – SQL Server Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=154
http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=143 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Other user are able to connect through management studio, I am able to connect to other instances, but not to this one, not sure whats the issue, I have been able to connect to this instance a lot time before, I do have RDP access to server and can connect to sql instance on that server, but not from my machine, Any ideas why I am not able to connect this from my machine ??
Using RDP is nothing but connecting the instance locally…
Did you check the SAC remote configuration setting? as Deepak mentioned in his post? MohammedU.
Moderator
SQL-Server-Performance.com
]]>