• Register
0 votes
36 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

Please log in or register to answer this question.

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 3 views
3 views
Problem: How to connect my database to my VS C# project ?
asked 4 days ago Ashty 1.8k points
1 vote
1 answer 2 views
2 views
Problem : I have a SQL query and I am New .When I execute this query, the error result is: The multi-part identifier "a.maxa" could not be bound. Why?
asked 1 day ago Shovo210 3.9k points
0 votes
2 answers 6 views
6 views asked Dec 30, 2020 miki 1.9k points
0 votes
1 answer 13 views
13 views
Problem: when i was trying to read data from Oracle database using the following code i was getting exception ResultSet res=stmt.executeQuery("select * from food"); But this table is actually exist in my database when i use this command directly in the command ... database this code is working fine ,but for other table names its not working properly.So someone please explain why this is happening.
asked Feb 21 Ali 6k points
0 votes
1 answer 15 views
15 views
Problem column name or number of supplied values does not match table definition
asked Feb 9 charles mathews 3.9k points
1 vote
1 answer 2 views
2 views
Problem : When I try to use the @RowFrom or @RowTo inside the @sqlstatement variable that is executed.. It gives me this error : "Must declare the scalar variable "@RowFrom"."Any ideas on what I need to do to fix this? Thank you in advance !
asked 1 day ago Shovo210 3.9k points
0 votes
1 answer 3 views
3 views
Problem : SQL Server Error : wait on the database engine recovery handle failed
asked 3 days ago Shovo210 3.9k points
0 votes
1 answer 12 views
12 views
Problem: What is the difference between the left join and the left outer join?
asked 6 days ago sasha 13.2k points
0 votes
1 answer 6 views
6 views
Problem: I have a database named foo and a database named bar. I have a table in foo called tblFoobar that I want to move data (and all) to the database from the database bar of foo. What is the sql statement to do this?
asked 6 days ago sasha 13.2k points
0 votes
1 answer 2 views
2 views
Problem: I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop (we are a training company, hence the need for multiple versions). I have installed SQL Server 2012 and have finally got SQL Server Data Tools to show, so that I can create SSRS reports ... I really don't want to uninstall Visual Studio, as this will bring you a number of other problems. How can I solve this problem?
asked 6 days ago sasha 13.2k points