• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

sql server move problem

A

arvin

Guest
Hello everybody,

I move sql server databases from one server to another one both running msde sp3.

I do this with following steps:
1- backup db with EntMgr in sorce server.
2- copy BK files to desteniation server.
3- create new db with same creadential on new server by Plesk.
4- restore BK files on new server with EntMgr.


But when I set web.conf of my site to read from new da server, I get this error:

Login failed for user 'username'.

And when I create new db user by Plesk I get this error:

Could not find stored procedure ‘Example’

What I must to do to solve this?
Thanks in advance.
arvin
 
Back
Top