• Register
0 votes
28 views

Problem :

We are currently migrating our servers (2005 to 2008) and our host backed up our SQL database and transferred it to our new server.

I have transferred our website files and changed our IP address in our connection string and also in our global.asa file.

So technically speaking we have the mirror image on our new server, but when I want to launch a page that connects to our SQL I get the below error :

SQL_Server_does_not_exist_or_access_denied.

6 5 3
7,540 points

1 Answer

0 votes

Solution :

The error message in your case is may be correct. First, try to verify that your network path from you to your new server works or not and you can connect with your specified userid/pwd.

1) Open Management Studio and try to connect to your SQL Server instance by the  ip address. By this way, you will likely need to use your SQL Server userid/pwd if you dont have already as you are on the Internet host and there are very likely no AD context for the Windows auth.)

2) If you can try to connect to your instance and your database by using the Management Studio then you must have missed the connection string somewhere. So please try to maintain only one location for the said connection string generally in the config file.

I hope it solves your problem.

9 7 4
38,600 points

Related questions

0 votes
1 answer 6 views
6 views
Advantages and disadvantages of views in SQL Server I need to know more about the advantages and disadvantages of views in SQL Server. Thanks!
asked Nov 18 miki 1.6k points
0 votes
1 answer 11 views
11 views
For loop in SQL Server stored procedure I want to know more about the for loop in SQL server stored procedure. Thanks!
asked Nov 17 miki 1.6k points
0 votes
1 answer 7 views