Jump to content

Can't Connect to SQL express server using Visual Studio Server Explorer

Go to solution Solved by dragonboy144,

Found the problem: you can't write IP/sqlexpress you need to just enter the IP

Hello, I cant connect to my Microsoft SQL express 2019 server using visual Studio(I am getting error 26), I can connect using Microsoft SQL Server Management studio just fine, what could be the problem?

 

Link to comment
Share on other sites

Link to post
Share on other sites

Error 26 is because it doesn't see the SQL instance running. Is your server running local or on a remote computer. If on a remote computer you need to open ports on your firewall and on the server firewall as well. If local then it mean you are using the wrong instance name or the instance is not running

Link to comment
Share on other sites

Link to post
Share on other sites

4 minutes ago, Franck said:

Error 26 is because it doesn't see the SQL instance running. Is your server running local or on a remote computer. If on a remote computer you need to open ports on your firewall and on the server firewall as well. If local then it mean you are using the wrong instance name or the instance is not running

It is on a remote pc, but I can connect from Microsoft SQl Manager, but not Visual Studio using the same Pc, User and Password 

Link to comment
Share on other sites

Link to post
Share on other sites

Found the problem: you can't write IP/sqlexpress you need to just enter the IP

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×