CODEWITHSUNDEEP
sql-server
KellyM
KellyM

Reputation: 2532

Remotely Connecting to SQL Server Express Instance

I receive the following error when trying to connect to a remote SQL Express instance:

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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

I initially tried accessing the server with SQL Server credentials. No success.

I have:

  1. Ensured remote connections are enabled
  2. Ensured TCP Protocol is enabled
  3. Ensured SQL Server Browser is started

Then I tried the "Run As" command to run ssms.exe as another user with appropriate credentials. I still receive the same error. What might the issue be?

A couple of specific questions:

Thanks for any help. The remote instance is SQL Server 2008 R2.

Upvotes: 2

Views: 2704

Answers (1)

Neo
Neo

Reputation: 3399

Dynamic port entry has to be given along with the SQLExpress login

SERVERNAME\SQLEXPRESS,45490

`Data Source=127.2.3.4\SQLEXPRESS,1433;Network Library=DBMSSOCN;Initial Catalog=dbase;User ID=sa;Password=password`

Upvotes: 2

Related Questions