We had to reinstall SQL on our Dev box. We kept the datafiles and re-attached them to the new installed sql. Problem is that the Logins are not there, and it will not let you recreate them and attach them to the Databases because it thinks they are already there. HELP!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What file or Database stores the User login information
- Thread starter Cranger
- Start date
tlbroadbent
MIS
Logins are stored in master..syslogins. The related user information is stored in sysusers in each database. It sounds like you have some broken users/logins. Check the following link for information about fixing broken logins and users.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
