Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
sql server connetion error

Answered sql server connetion error

  • Monday, January 21, 2013 7:18 AM
     
     
    Sign In to Vote
    0

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

    Cannot connect to ..

    ------------------------------
    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: 2)

    Please Help me

     

All Replies

  • Monday, January 21, 2013 8:46 AM
     
     
    Sign In to Vote
    0

    1) Wrong typed server name \ instance name or not specified  a port 

    2) Blocked by Windows firewall

    3) TCP\IP port is disabled

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

     
  • Monday, January 21, 2013 1:02 PM
    Moderator
     
     Proposed
    Sign In to Vote
    1

    Hello,

    Please verify the SQL Server service is running using the following article or you are typing the correct name of the instance. Try to connect to the instance using “computername” or “computername\nameinstance”.

    http://technet.microsoft.com/en-us/library/ms190699(v=SQL.105).aspx

    Please enable Named Pipes and TCP/IP protocols.

    http://technet.microsoft.com/en-us/library/dd206997(v=SQL.105)

    For more information, please see the following post:

    http://blogs.msdn.com/b/sql_protocols/archive/2007/05/16/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error-xxx.aspx 
     

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Monday, January 21, 2013 2:03 PM
     
     
    Sign In to Vote
    0

    Hello Raj,

    1. Is SQL Server service that you are connecting to is online?
    2. Are you connecting to the server been on the same host? If yes then Local in Server name box?
    3. If you are trying to connect remotely then ask the system admin that "If he/she can see the SQL Server service running?
    4. Try using ip address & full connection string i.e. "192.126.152.32, 5544" in Server Name.
    5. Is firewall enabled? If yes then please check the exception.
    6. Are you able to telnet to the server? i.e. Command Prompt -> Telnet <server name/Ip address> <port number>?

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

     
  • Tuesday, January 22, 2013 8:16 PM
     
     Proposed
    Sign In to Vote
    1

    There are many reasons of SQL server connectivity issue. But I have setup an small checklist that helps me most of the time to find out the real cause of connectivity issue.

    1. Check SQL services are running

    2. Check SQL Browser service is running

    3. Check remote connections are enabled

    4. Network connectivity between database & application servers by TRACERT command

    5. Check TCP/IP protocol enabled at SQL server

    6. Check talent connectivity – telnet <IP address> <port no on SQL server running>

    7. Check UDP port 1434 is open or not on SQL Server

    8. Check firewall is running or not Check

    9. If firewall running, SQL Server & UDP port must be added in exception in firewall

    Refer Link : http://mssqlfun.com/2012/09/28/check-list-for-sql-server-connectivity-issue/

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

     
  • Tuesday, January 22, 2013 10:14 PM
     
     
    Sign In to Vote
    0

    Hi there,

    This is instance specific error. I guess your server may be running and you used incorrect server name in the connect to server window from SSMS.

    First thing make sure your service is running. "open sql server configuration manager and check servicess."

    from Connect to server

    server type: Database engine

    servername: you have following options

    1) (local)

    2)localhost

    3) .

    4) computername

    5)computername\instancename

    Authentication: windows Authentication

    Still you have issues post a screen shot of the error message.

    thanks

    kumar

     
  • Wednesday, January 23, 2013 6:56 AM
     
     
    Sign In to Vote
    0

    hey ,

    I'm trying to connect with default machine name or . using windows Authentication 

    Please Help me

     
  • Wednesday, January 23, 2013 10:41 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    The following post have some possible causes of the this error:

    http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx?PageIndex=21

    Have you done some of the suggestions provided above? Would you share with us a print screen of the Services section on SQL Server Configuration Manager?

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    • Marked As Answer by raj1904 Wednesday, January 23, 2013 1:07 PM
    •