one database is having so many table and have user called digi
he is created so many SP and some tables., when i restore the db it
restored without any problem.,
after restoring application is not working
how to ensure that restored DB is having same security as the original
for that user .
when i tried to run the script of that db over that restored DB
it was showing user digi does not exist. but i have creted user digi
where can i get the useful information about this
/sreeni
--
srin
Posted via http://dbforums.comUytkownik "sreenivasa" <member32738@.dbforums.com> napisa w wiadomoci
news:3084542.1057641115@.dbforums.com...
> i wanted to restore user DB from one sql server to another sql server ,
<cut>
It's probably your answer - another sql so it means another master database.
You have user account in database wich was restored, but you do not have
user login (in master database - sysusers table) wich is connected to
database account.
You must drop database user and create new login - not recomended, or use
sp_change_users_login with Auto_Fix option.
regards
Marcin D
No comments:
Post a Comment