Post reply

new SQL server registration problem

  • May 17, 2004 at 10:25 am

    #85571

    Sorry... newbie question here.  Am trying to create a new SQL server registration.  All goes well until the an attempt to actually connect is made at which time I recceive the "SQL Server does not exist or access denied...".  This ONLY happens on one machine though (mine.. of course).  I can connect on virtually any onther machine in my office except my own.  My NT Admin and I have been at work on this for a few days.  We've removed and re-added the machine from the domain, tried a different domain ID, etc...  Using SQL 7, any ideas ?

    Thanks!

  • May 17, 2004 at 11:37 am

    #506683

    Have you tried creating an alias through Client Network Utility? 

  • May 17, 2004 at 1:47 pm

    #506699

    Yes.  Sorry for the delay.  We did try creating an alias, no luck.

  • May 18, 2004 at 8:54 am

    #506800

    Can you access SQL Server from osql command line?

  • May 18, 2004 at 8:55 am

    #506801

    Or in this case, ISQL?

  • May 18, 2004 at 9:34 am

    #506810

    good idea... no, cannot connect.  Here is the message:

    Msg 18456, Level 14, State 1:

    Login failed for user '****'

    DB-Library: Login incorrect.

  • May 18, 2004 at 9:38 am

    #506811

    Did you try using your login? Try using SA and the proper password.

  • May 18, 2004 at 10:32 am

    #506821

    Tried 2 seperate accounts (both good), neither could get in.

  • May 19, 2004 at 7:09 am

    #506937

    Is this SQL Server running on your work station? If so, is it running under your user accounts? If so, have you changed your password lately? If nothing else works, maybe you need to re-install, if at feasible.

  • May 19, 2004 at 7:25 am

    #506939

    Client only running on my machine, very recetnly changed password, have tried reinstalling (SQL7) mltiple times.   I'm fearing a full machine reload.

Viewing 10 posts - 1 through 9 (of 9 total)

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