why restricted user


I am trying to convert navison 4.1 from SQL2000 to SQLserver 2005 …I did backup from SQL2000 …and then restore to a database in SQL 2005 …

then the restore susccefully done … but why i am getting beside the name of database ( restriced user) … and how can i unrestrict ?

thank you

In SQL Server Management Studio, right click on the DB and go to properties. Select ‘Options’ and scroll to the bottom. Change ‘Restrict Access’ under the State options to ‘Multi_User’.

Let us know how it goes.

Thanks Mark …It’s worked GREAT