Welcome to Sign in | Join | Help
in
Home Forums Photos Downloads

Can not connect to SQL 2005 through Management studio

Last post 10-24-2007, 9:50 by Ultima Mark. 6 replies.
Sort Posts: Previous Next
  •  09-24-2007, 10:01 PM 1132

    Can not connect to SQL 2005 through Management studio

    Please tell me I have something setup wrong.. I can't connect to my SQL server. I get this error:


    ------------------------------

    Cannot connect to 69.16.210.14.

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

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

     

     I've also tried connecting through the web based MyLittleAdmin and it will show me the system databases but when I try to expand the User Databases section ts says "URL requested does not exist".

     

    Please help..

  •  09-24-2007, 11:23 PM 1133 in reply to 1132

    Re: Can not connect to SQL 2005 through Management studio

    Try adding port# 937 to the IP like so:

    69.16.210.14,937

    If that doesn't work, submit a support ticket to support@ultimahosts.net


    William Eaton, MCSE
    iTech Computer Solutions, LLC
    www.itechcs.com
  •  10-24-2007, 9:17 1196 in reply to 1133

    Re: Can not connect to SQL 2005 through Management studio

    I have the exact same problem.

    Also cannot connect with sqlcmd or telnet. There are no firewalls blocking me as I can connect fine to another remote SQL server.

    Any ideas?

  •  10-24-2007, 9:21 1197 in reply to 1196

    Re: Can not connect to SQL 2005 through Management studio

    Did you try adding port# 937 to the Server/IP as mentioned in my previous post?  If that doesn't work, email support@ultimahosts.net
    William Eaton, MCSE
    iTech Computer Solutions, LLC
    www.itechcs.com
  •  10-24-2007, 9:39 1198 in reply to 1197

    Re: Can not connect to SQL 2005 through Management studio

    Yep, doing that throws a remote server actively refused connection (or similar). Keeping to the standard 1433 port it says server didn't respond in a timely matter.

    Opened a support ticket now, they're usually rather quick so :) Thanks though.

  •  10-24-2007, 9:47 1199 in reply to 1198

    Re: Can not connect to SQL 2005 through Management studio

    Yes, they are quick.  They probably need to enable SQL Management Studio access for your database/server.  They locked it down a while back.
    William Eaton, MCSE
    iTech Computer Solutions, LLC
    www.itechcs.com
  •  10-24-2007, 9:50 1200 in reply to 1199

    Re: Can not connect to SQL 2005 through Management studio

    Just use this for your server name in Management Studio [do not change your website settings]

    69.16.211.96,937

    as a replacement for

    69.16.210.14

    System Administrator
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems