Error while Connecting from QueryAnalyzer

  • I have a Server abc.which is connecting from ping utility.But giving error from

    query analyzer.I have added tcp/ip,namedpipes,multiprotocal in client networkutility.

    But is telling that Specified Sqlserver Not Found.

    Anu Suggestion for solving the error.

    UmaShankar


    UmaShankar

  • What is the error that you are getting.

    If you are trying to connect using sa account under the security option set the authentication mode to both sql server and windows.

    Pay Respect to People on your way up. For you will meet the same People on your way down.


    He who knows others is learned but the wise one is one who knows himself.

  • Error is Unable to connect to Server1

    [Microsoft][SqlserverDriverError][dbnetlib]Invalid Connection

    Iam using Windows Authentication only to connect.

    UmaShankar


    UmaShankar

  • Are you trying to connect through a machine other than the one on which sql server is installed. What Login Name are you using, since you have mentioned that you are using windows authentication make sure that the username you are using while connecting has appropriate rights on the sql server.

    By the way are you able to connect using sa as login.

    Pay Respect to People on your way up. For you will meet the same People on your way down.


    He who knows others is learned but the wise one is one who knows himself.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply