Problem Creating Login ID

I restored a database called 'MyDatabase' from a backup file. It created a u
ser for me with the same name but no login with the same name. When I tried
to create a login id with the same name (MyDataBase), it does not let me the
same login id have privile
ges to access that database. I tried to do this under the 'Database Access'
tab. Please help.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Hi,
Execute "sp_change_users_login" procedure from the restored database. This
problem is because
the user inside the database will not have the appropriate Login master
database.
This link can be brought up by using the system procedure
sp_change_users_login .
See the details of sp_change_users_login procedure in books online.
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OdY4$OXXEHA.3596@.tk2msftngp13.phx.gbl...
> I restored a database called 'MyDatabase' from a backup file. It created a
user for me with the same name but no login with the same name. When I tried
to create a login id with the same name (MyDataBase), it does not let me the
same login id have privileges to access that database. I tried to do this
under the 'Database Access' tab. Please help.
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.