login issue from application

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Security » login issue from application

Rate Topic

Display Mode

Topic Options

Author

Message

jchen-398834

Posted Thursday, August 28, 2008 3:47 PM

SSC 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

Greg Charles

Posted Wednesday, September 10, 2008 12:58 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:08 PM
Points: 4,006, Visits: 4,845

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 »

Permissions