I restored a DB to another server and then i used the stored procedures
exec sp_addlogin on the master DB and the exec sp_change_users_login on the DB that I have restored. When i try to run a sproc I am getting
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have used windows authentication to login to connect to the server using sql management studio
Am i missing something. Thankyou for the help
How do you call the stored procedure and what does the stored procedure do?
Thanks
Laurentiu
No comments:
Post a Comment