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
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