Remotely Connecting to SQL Server Express Instance
<p>I receive the following error when trying to connect to a remote SQL Express instance:</p>

<pre><code>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&amp;EvtSrc=MSSQLServer&amp;EvtID=-1&amp;LinkId=20476
</code></pre>

<p>I initially tried accessing the server with SQL Server credentials. No success.</p>

<p>I have:</p>

<ol>
<li>Ensured remote connections are enabled</li>
<li>Ensured TCP Protocol is enabled</li>
<li>Ensured SQL Server Browser is started</li>
</ol>

<p>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?</p>

<p>A couple of specific questions:</p>

<ul>
<li><p>What is the "right" server name - I have been putting in the instance
name "NAME\NAME"?</p></li>
<li><p>When I am running as a different user, what is the appropriate
authentication mode: Windows, SQL Server, Active Directory Password,
or Active Directory Integrated?</p></li>
</ul>

<p>Thanks for any help. The remote instance is SQL Server 2008 R2.</p>