• Register
0 votes
41 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 4 views
4 views
Problem: We are currently migrating servers (2005 to 2008) and our host backed up the SQL database and transferred it to the new server. I have transferred the website files and changed the IP address in the connection string and the global.asa file. ... the new server, but when I try to launch a page that connects to the SQL I get the following error. SQL_Server_does_not_exist_or_access_denied.
asked Apr 26 Yeamin 21.4k points
0 votes
1 answer 4 views
4 views
Problem: We are currently migrating servers (2005 to 2008) and our host backed up the SQL database and transferred it to the new server. I have transferred the website files and changed the IP address in the connection string and the global.asa file. ... the new server, but when I try to launch a page that connects to the SQL I get the following error. SQL_Server_does_not_exist_or_access_denied.
asked Apr 26 anika11 32k points
0 votes
1 answer 2 views
2 views
Problem: technically speaking we have a mirror image on the new server, but when I try to launch a page that connects to the SQL I get the following error. SQL_Server_does_not_exist_or_access_denied.
asked Mar 23 ummesalma 29.2k points
0 votes
1 answer 4 views
4 views
Problem: Please help me fix this dilemma: dbnetlib connectionopen (connect()). sql server inexistente ou acesso negado. :
asked Apr 6 tuhin1 48.9k points
0 votes
1 answer 3 views
3 views
Problem: I am trying to create a temporal table in my SQL Server database. Is anyone familiar with this error in SQL Server: Msg 2760, Level 16, State 1, Line 5 The specified schema name "items" either does not exist or you do not have permission ... ( [itemsID] ASC ), PERIOD FOR SYSTEM_TIME(ValidFrom, ValidTo) ) WITH(SYSTEM_VERSIONING = ON (HISTORY_TABLE = [items].[items_Temporal_History]));
asked Apr 25 sumaiya simi 43.9k points
0 votes
1 answer 5 views
5 views
Problem: How to connect my database to my VS C# project ?
asked Mar 1 Raj Tyagi 14.4k points
1 vote
1 answer 5 views
5 views
Problem: Can some one tell me the differnce between: Sql server uses an extended version of sql called t-sql or transact-sql.
asked 3 days ago PkGuy 23.5k points
0 votes
1 answer 8 views
8 views
Problem: I was trying to create a table, t has given an error saying, Cannot convert varchar to datetime
asked Apr 24 ummeshani 8.8k points
1 vote
1 answer 9 views
9 views
Problem: Whenever I try to configure the database in my SQL Server gridview I get this error : Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. ... : 1326) I don’t know how to cope up with this problem . I use Visual Studio 2010 . Any help will be appreciated
asked Apr 21 Raj Tyagi 14.4k points
0 votes
1 answer 31 views
31 views
Problem: Hello! I developed a website on Blazor technology for my school project about a month ago. I did not touch my website again until today. I had to show my website to a client of mine. But when I run the website, it shows the above-mentioned error. I am ... done any changes anywhere in the project, except that I updated the version of SQL Server on my PC. Please help me to fix this problem!
asked Apr 21 Code Learner 9.8k points