Post reply

DBNETLIB]SQL Server does not exist or access...

  • March 30, 2009 at 10:19 am

    #130158

    DBNETLIB]SQL Server does not exist or access...

    when I am trying to connect from window xp or window 2000 server for database install on windows 2003 from Query analyzer its giving error as

    server doesn't exist or access is denied

    Thanks in advance for support

  • March 30, 2009 at 10:35 am

    #968504

    Can you please cross check the following?

    1. Ping the server and check for connection

    2. Try connecting using Server IP Address

    3. Verify the Server Name used

    4. Check if the fireball is blocking the connection

    5. Check if sql server is listening on some other ports

    --Ramesh

  • March 30, 2009 at 10:45 am

    #968509

    thanks

    I did all and check the port and ip also

    Not able to add in Enterprise manager from other servers.

    When adding in ASP pages giving as Sa Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    db.inc line 6

    I have check in sql server authontication but also its not working

    I have created othere username too but it same

  • March 30, 2009 at 6:44 pm

    #968819

    Is sql authentication enabled on your sql server?

    http://msdn.microsoft.com/en-us/library/ms188670.aspx

    MJ

  • March 30, 2009 at 10:12 pm

    #968846

    Hi,

    Check if the TCP/IP protocol has been enabled & also if the SQL services are started & running fine.

    Thanks

    Have a nice day !!!

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • March 30, 2009 at 11:02 pm

    #968854

    hidayath (3/30/2009)

    thanks

    I did all and check the port and ip also

    Not able to add in Enterprise manager from other servers.

    When adding in ASP pages giving as Sa Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    db.inc line 6

    I have check in sql server authontication but also its not working

    I have created othere username too but it same

    Have you restarted the SQL Server after changing the authentication mode?

    --Ramesh

  • April 1, 2009 at 12:57 am

    #969647

    I did the change and Restarted the SQL SERVER even try to create the username and password and assing the priority by still is the same ..

    Is any way to ourcome with this problem as the Server is haveing two NETWORK CARD But i think it will not create any problem as we used to work with the same server with WIndows 2000 operating system but recently we updated to 2003 Windows then this problem is appearing

    And can even Add and open from query Analyzer and Enterprise manager of other server only the problem is when exectuing from IIS its giving this error

    Sa Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    db.inc line 6

  • April 1, 2009 at 4:22 am

    #969702

    Does this link helped you?

    --Ramesh

Viewing 8 posts - 1 through 7 (of 7 total)

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