November 4, 2002 at 9:25 am
We have just upgraded a server and reinstalled the SQL Server (version 7). After the upgrade, one strange probelm is found. In order to run the stored procesure 'sp_databases', the user has to be added to all the databases. Otherwise, the following error occurs:
Server: Msg 916, Level 14, State 1, Line 1
Server user 'carl' is not a valid user in database 'model'.
We had used this stored procedure without problem for several years.
Does anyone know the cause?
Thanks.
Carl
November 4, 2002 at 9:30 am
When you say you reinstalled SQL Server, did you restore MASTER? Have you run "sp_change_users_login 'report'" on each database to see if there are any orphan users?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 4, 2002 at 9:42 am
quote:
When you say you reinstalled SQL Server, did you restore MASTER? Have you run "sp_change_users_login 'report'" on each database to see if there are any orphan users?
Hi, Greg
I used a block of script from MSDN Library to recreate all the users. All the applications are running well after the reinstallation.
I have run the sp_change_users_login 'report' for each database and haven't got any orphan users.
SP_Databases can be run by any public useres. Why is it checking the users in the databases? I could successfully run the same statement in several other SQL Servers. They all have the same version.
Thanks for your quick reply.
Carl
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply