Hi,

I got the following error message

Msg 916, Level 14, State 1, Line 1

The server principal "UserName" is not able to access the database "DBName" under the current security context.

Msg 15247,...

Doesn't work...

The script runs but the user is till unable to connect to the database

Restore was not the problem...

The problem was that I was not able to connect to the database I resotred after I restored it.

Just to clarify - I'm working on SQL 2005 and not 2008

I have both dbcreator and securityadmin rights...

I tested your script on another database where I have dbowner rights and it worked. But that solution is weire - How can you...

I ran the user creation script with a user with security admin and I still got an error that I don't have permissions....

Sorry, I read again you answer and understood what you meant.

I will try it

Thanks

That is the problem, I do not have "admin" permission on the server. So what I need is a way to connect to the database after I restore it.

Thanks.

Checked that and it works

Shai

I have already tried that, it does not work...

What is the purpose of LocaleID anyway?

Shai