• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

ms sql 2008 error 916

i try to expand databases in a remote server witj my laptop which has ms sql 2008 installed (the remote computer  has server 2005) it never made problems and now i get  error 916

enyone know what is it?

tnx
0
Avner_Lehavi
Asked:
Avner_Lehavi
  • 2
  • 2
1 Solution
 
blandyukCommented:
What user are you using to connect to your SQL 2005 database?

Server user id %d is not a valid user in database '%.*s'

Explanation

When a user tries to open a database, SQL Server performs the following checks to determine the validity of the user:

   1. Looks for the suid (SQL Server user ID, copied from syslogins) of the process in sysusers to find the corresponding uid (user ID, unique in this database) and gid (group ID to which this user belongs).
   2. Looks for a "guest" row in sysusers (the suid for "guest" is -1).
   3. Looks for the user ID in sysalternates.
   4. In SQL Server release 10.0 and later, checks sysusers to determine whether the user has "sso" role if the user does have an suid in the database. This check is related to SQL Server auditing.

Error 916 occurs when a user tries to open a database and SQL Server finds that the user ID is not valid.
0
 
Brad HoweDevOps ManagerCommented:
This is a bug in SSMS 2008.

"Server user id %d is not a valid user in database '%.*s'"

Give this a shot.

http://blog.cpugeni.com/archive/2008/09/22/microsoft-sql-server-management-studio-2008-error-916.aspx

Fix:
In Object Explorer, click Databases
Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”
Right click the column headers and deselect “collation”
Refresh Databases, and hopefully bingo!

Cheers,
Hades666
0
 
Brad HoweDevOps ManagerCommented:
@blandyuk - Correct :)
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now