title: ADODB connection don't connect to sqlserver Expresss
body: <p>I have installed an instance of MS SQL server Express on a new server. I have a web application with some old ASP.NET code written in VBScript, using another database (SQL Server) which works fine.</p>
  
  <p>every attempt to connect gives the same error:</p>
  
  <blockquote>
    <p>Microsoft OLE DB Provider for SQL Server error '80004005'
    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.</p>
  </blockquote>
  
  <p>The code is:</p>
  
  <pre class="lang-vb prettyprint-override"><code> Set udb = Server.CreateObject("ADODB.Connection")     
  'SQLEXPRESS ENVIRONMENT
   udb.Open("Provider=SQLOLEDB; Data Source=SEHAN5134AS1\SQLEXPRESS,1433; Initial Catalog=testDB; User ID=myUser; Password=sEcret;")
  'PRODUCTION ENVIRONMENT
  'udb.Open("Provider=SQLOLEDB; Data Source=manifolds-avalon.db.teliasonera.net,1433; Initial Catalog=smallworldweb_user-data; User ID=myUser; Password=sEcret;")
  </code></pre>
  
  <p>I have made an ODBC connection to verify that the the web server is able to connect to the server with the SQL-server and it works fine. I have tried to give the myUser any kinds of rights on the database. I can connect to the database with other programs (tcpip and named pipes are allowed, remote connections are etc.)</p>
  
  <p>I have tried to add </p>
  
  <pre class="lang-vb prettyprint-override"><code>"Server=SEHAN5134AS1.db.teliasonera.net; Network=DBMSSOCN;"
  </code></pre>
  
  <p>to the connection string. I have tried to use the full server name in the "Data Source" string. But now I have no ideas how to solve the problem. Any suggestions?</p>
  
  <p><strong>EDIT</strong>
  I have tried to make the connection via powershell as proposed by Dan Guzman and the result is shown below with the result of setting the ODBC connection. All results are from the same web server.
  <a href="https://i.stack.imgur.com/K2Aux.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K2Aux.png" alt="Results of using powershell and ODBC setup"></a></p>