Results 1 to 3 of 3

Thread: SQL Server error 18456

  1. Apr 4th, 2001, 05:12 AM #1
    Parasu Raman
    Parasu Raman is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2001
    Location
    Chennai, India
    Posts
    219

    Cool

    Hi all,
    In SQL Server 7, when Im trying to open a table (in enterprise manager) for which the user has previledges, it says that SQL Server error 18456 - Login failed. and it asks to login again. When I login again, it connects correctly.
    Why is this so? The user has all the rights to view the table. Is there anybody to guide me out??

    Cheers and thanx in advance

    Parasu Raman
    Om Nama Sivaya!!!
    Reply With Quote Reply With Quote
  2. Apr 4th, 2001, 06:02 PM #2
    Chris Byrom
    Chris Byrom is offline
    Lively Member
    Join Date
    Oct 2000
    Location
    Texas
    Posts
    111

    silly guess

    Do you have a connection set up to the server automatically. I did this myself the other day. I had the wrong name and password specified, and when I tried to access something it would not let me. I just changed the login name and pword for the server by right clicking on the server in EM, and selecting 'Edit SQL Server Registration Properties'. As the subject says this is just a guess.

    Reply With Quote Reply With Quote
  3. Apr 4th, 2001, 11:04 PM #3
    Parasu Raman
    Parasu Raman is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2001
    Location
    Chennai, India
    Posts
    219
    Hi Chris,
    Thanx for that. The login and password which I use is a valid one. Im working on the server only.
    I'm able to access the tables when Im going in as the sa but other users, though they have previledge, the login failed error comes.
    Cheers

    Parasuraman
    Om Nama Sivaya!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width