This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello everyone,
I can't connect to SQL Server inside Visual Studio 2019.
The Microsoft SQL by itself is connecting, its only inside visual studio.
I get error 40. I followed the steps and restart SQL in "Services" but that didn't help.
What can I do to solve this ?
Thanks in advanced.
Error: 40- could not open a connection to SQL Server - in visual studio 2019
See the following which provides diagnostic steps to follow
It's too old, nothing is like that in windows today.
its very different and I cant go through those steps, sorry.
Not solving my problem.
Perhaps running the following PowerShell script might help
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = 'SELECT @@SERVERNAME AS ServerName'
$SqlCmd.Connection = $SqlConnection
$SqlConnection.Open()
$rdr = $SqlCmd.ExecuteReader()
while($rdr.Read())
{
$rdr["ServerName"].ToString()
}
$SqlConnection.Close()
Hi Karen,
I ran all the commands in the PowerShell but the same problem.
I I don't understand what this code for
and why
$SqlConnection.Close()
is closed it at the end ?
The error usually indicates an error entering the server\instance; (localdb)\MSSQLLocalDB. If you are trying to connect to the local db then a dot or (local) will work.
VS 2019 has a feature named "SQL Serer Object Explorer" (under the View menu) which enumerates the SQL instance found on the local machine.
Select the instance you are trying to connect and configure the authentication according to your configuration.
My SQL Server's database is shown there, but I still can't connect it with Server Explorer - same error as before.
Yes it closes the connection.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
That error is a generic "could not connect to server" message and does not help in any way diagnose the actual problem.
What exactly did you enter for the server name? Try "./sqlexpress", since your screen shot appears you have installed an instance named "sqlexpress".
I suggest you start here:
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15#testing-a-local-connection
Thank you, you helped me.
I needed to add my server name, I thought it need to be added automatically.
Forgot about that, silly me.
Elad