none
cannot connect to server

    Question

  • I just installed ms sql server 2008 R2 on a development PC.  From the PC I installed sql server on I cannot connect to the server. Using MS Sql Server Management Studio:
      Server type : Database engine

      Server name : MSSQLSERVER
      Authentication : sql server authentication
      login : sa

    When I click connect, get the cannot connect to server error.  Named pipes, tcp/ip and shared memory are all enabled in sql server config manager.

    Why can I not connect to the server?  I see it from sql server config manager. 

    thanks,

     

     

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to MSSQLSERVER.

    ------------------------------
    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to 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

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Monday, January 09, 2012 5:54 PM

Answers

All replies