April 10, 2003 at 12:50 am
We have 20 databases on our SQL 2000 Server. Now a strange
problem has appeared on some of the databases. Example:
When a user 'X' with dbo permisssion right-click on a
table in the database 'AAA' and selects All tasks>Generate
SQL Script in Enterprise Manager he gets an error message.
Error 916: Server user 'X' is not a valid user in
database 'BBB'. If i give the user read-access in the
database 'BBB' it works fine. The same problem appears on
all tables and stored procdures in the database 'AAA'.
This problem also occurs on other databases and the error
always states that the user needs permission to the
database 'BBB'.
April 10, 2003 at 1:03 pm
quote:
When a user 'X' with dbo permisssion right-click on a table in the database 'AAA' and selects All tasks>Generate SQL Script in Enterprise Manager he gets an error message.Error 916: Server user 'X' is not a valid user in database 'BBB'. If i give the user read-access in the database 'BBB' it works fine.
Have you tried deleting and recreating the user's login? Does it happen with other users?
April 11, 2003 at 1:52 am
No, I have not deleted and recreated the user's login yet. I hope to find another solution. We have not noticed this problem with any other users.
/Stefan
April 24, 2003 at 7:00 am
Howzit ..
Make sure that the sql service account has full control permission on the drive or folder where the datafile resides .If you use the local system account make sure the system account \\pcname\system has full control on the drive or folder where the datafile resides . Just a thought ....
April 24, 2003 at 7:19 am
sql service account has full control.....
April 24, 2003 at 7:57 am
Have you recently applied SQL Server SP3 with 'allow cross-database ownship chaining' enabled?
April 24, 2003 at 8:19 am
I have recently applied SQL Server SP3 but with 'allow cross-database ownship chaining' disabled!
April 24, 2003 at 9:11 am
Did you ever have 'guest' user in database 'BBB' before?
Edited by - Allen_Cui on 04/24/2003 09:13:04 AM
April 24, 2003 at 11:47 pm
No!
But now since I have dropped the database and restored it from a backup it seems to work??? Strange......
April 28, 2003 at 7:22 am
What was the default database for that login? I've had odd errors before when the default database is not what it should be.
May 5, 2003 at 11:42 am
I had a question pertaining to orphaned logins. I am a DBA working on SQL 7. Whenever I restore a DB somewhere I manually fix the users by deleting the users from the sysusers table of that DB and then re-creating the login again. How does SQL 2000 handle this? Are the logins correctly mapped to the UIDS in SQL 2000 or would we need still need to fix them like in SQL 7
May 6, 2003 at 1:09 pm
Going to create another thread on this.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply