guest in sql2005 from restore database sql2000

Hi all.

I have restored a test database from SQL2000 into SQL2005 and then, since for the SQL2005 database guest is not a database user, when trying to modify its properties, I am getting the error messages : You must specify the logon username. (SqlManagerUI).

Thanks for youu help

[311 byte] By [AngelGonzález] at [2007-12-25]

«« ListView.CheckedItems.Count throws NullReferenceException
»» Rules work but are not displayed in the tree (VS2005)

# 1

Change the server principal which is mapped to the guest user to reestablish the link between the database principal and the server principal. The guest account e.g has to be treated carefully, because it allows access to your database e.g. in the case of db ownership chain.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

JensK.Suessmeyer at 2007-10-8 >