Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

login issue from application Expand / Collapse
Author
Message
Posted Thursday, August 28, 2008 3:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 27, 2011 2:40 PM
Points: 28, Visits: 104
Help,

one user could not log in from application, I checked if this user in that database users table. the user login/pwd is in the user table. In security login, there is not check mark in that db for this user.

I tried to put check market in that db for this user but it give me error message is:
Error 15665: All user IDs have been assigned.

I used this user login and pwd trying to login from application, it gave me Invalid user ID or password entered,

Any help?

Chen
Post #560872
Posted Wednesday, September 10, 2008 12:58 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:51 PM
Points: 4,065, Visits: 5,298
I believe the error number is really 15065. According to KB http://support.microsoft.com/?id=303879, you can create a maximum of 16,379 users in a SQL 2000 database. Do you really have that many users?

Greg
Post #567234
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse