If you want to permsnently change it then only one thing has to be done. Just make sure all your stored procedures use ANSI syntax.

http://www.aquesthosting.com/HowTo/Sql2005/Providers.aspx

Is the correct network port open in the new webserver to connect to the database?

I already did that. It is not locked.

Thanks,

 I did that, but I'm gettign the follwoing error now. When I tried to open it with that account it is not giving any error. But when I try to run...