Error 18456

Question

Error 18456

hjalplos

Grasshopper

Points: 13
More actions
July 14, 2004 at 11:56 am

#102112

I just refreshed a database and had a problem with one user who could no longer login to the application, rec'd error msg '15023 User or role already exists in db'.
I ran "sp_change_users_login 'auto_fix', 'Username'" to fix the ophaned SID's, and now the user can login to the app but gets the error msg "Connection failed SQL State '28000', SQL Server error 18456' Login failed for user 'Username' when entering their login and PW.
User clicked 'OK' and got the SQL Server login dialog box. When entering the Username and PW in this box the user can get into the app. This is only effecting one user, all other users get into the app by entering their Username and PW into the logon screen of the app. Any suggestions would be greatly appreciated. Thx

Viewing 6 posts - 1 through 6 (of 6 total)

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

Jim P. SSCrazy Eights Points: 8725 More actions · Answer 1

Check in the EM Security. By any chance does the workstation/client have a login in the server? Did you run a fix on that?

----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.

hjalplos Grasshopper Points: 13 More actions · Answer 2

I checked in EM Security and user is a member of the same groups with same perms as the users who don't have this problem. What fix do you mean? and where do I get it from? Also I don't know if this makes a difference but we are running two instances of SQL on the box, one for Prod'n and one for Test. I refreshed from Prod to Test. User is fine with Prod login but its the Test logins that cause the problem. Thx

Jim P. SSCrazy Eights Points: 8725 More actions · Answer 3

I was referring to :

Does the workstation/PC have a login in the SQL server?

If so did you do the autofix_login on that?

----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.

hjalplos Grasshopper Points: 13 More actions · Answer 4

Sorry I'm a little confused..do you mean do we use NT Authentication? We use SQL Authentication.

Also I'm brand new to to asking questions in forums.. how do I do a PM reply? I couldn't bring up the compose screen.

Peter Tillotson Hall of Fame Points: 3325 More actions · Answer 5

If the user can log on OK by entering the SQL Authentication User name and password, the error must be in the connection string your app is using to link to the test database. Check that it has the correct username and password.

Peter