1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Unable to register and connect to SQL SERVER

Discussion in 'Software Development' started by Muideen, Sep 23, 2008.

Thread Status:
Not open for further replies.
  1. Muideen

    Muideen Thread Starter

    Joined:
    Sep 3, 2008
    Messages:
    12
    I have been trying to connect an instance of SQL SERVER running on another computer on the same network with mine, but it gives this message
    "A connection could not be established to [COMPUTER NAME/SQL Server instance]
    Reason: SQL Server does not exist or access denied. ConnectionOpen(Connect()... Please verify SQL Server is running and check SQL server registration properties (by right clicking the [COMPUTER NAME/SQL Server instance] node and try again"
    .
    I keep getting this error even though I type the correct sa login credentials for the remote SQL SERVER instance. Every other computer on the network are able to successfully connect to that particular instance.

    I am able to register other instances and connect to them successfully, and the more painful part is that whenever I deploy a web app and try to reference that instance of SQL Server, the app crashes, with this error message.

    "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)"

    When i try to run the same app on other systems without changing the connection string, the app runs without crashing.

    This is really giving me serious concerns, as i have been on this for sometime now and i am running out of time.

    I am running on windows vista and SQL SERVER 2000

    I will really appreciate anyone's contribution.

    PLEASE HELP

     
  2. jdean

    jdean

    Joined:
    Jan 20, 2002
    Messages:
    433
  3. Muideen

    Muideen Thread Starter

    Joined:
    Sep 3, 2008
    Messages:
    12
    thanks, i am browsing the link now
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Unable register connect
  1. kammu
    Replies:
    1
    Views:
    218
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/752619

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice