A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

(0) Share

Report

Posted on by NissenB

Hello everyone,

I need your help. I have been struggling with this error since days and I don't seem to find the solution.

For a Devops mapping purpose, I had to rename my Virtual Machine (did it with SQL). I made sure the updates were made.
After since, Whenever I compile a model I get this error in Visual Studio 2019 (see below). On the other hand, Synchronize Database is not showing any erros.

When I open the Log file of the model result compilation, (file name : BuildModelResult) I noticed that it is calling the old name of the VM :

<Moniker>Initialization of cross reference database failed. Connection:Data Source=OLDNAME;Initial Catalog=master;Integrated Security=True;Connect Timeout=100;ConnectRetryCount=5;ConnectRetryInterval=10 failed with exception message:System.Data.SqlClient.SqlException (0x80131904)</Moniker>

I will be greatful for any thoughts to help me with this.

Thanks alot!

All responses (3)

Answers (1)

Suggested answer

San Artham 3,175 on at

Like (0)

Report

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

The file "AosService\PackagesLocalDirectory\bin\DynamicsDevConfig.xml" likely has entries pointing to other VM.

Check the file and update the entries as needed.
Prajakta 5 on at

Like (0)

Report

RE: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Hello, I am also facing same error. What was the solution to your problem ? I can see below link is marked as answer but there are a lot of things in that. Which specific was the solution to your problem. Appreciate you feedback. Thanks in advance !
Verified answer

huijij 19,811 on at

Like (0)

Report

RE: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Hi,

You can follow up the MS document to troubleshoot the errors:

docs.microsoft.com/.../network-related-or-instance-specific-error-occurred-while-establishing-connection

Community site session details

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates