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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
What user are you using to connect to your SQL 2005 database?

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


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.
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.

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!

Brad HoweDevOps ManagerCommented:
@blandyuk - Correct :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.