Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: MSSQL DB conneciton problem

    We currently have 2 servers with 2 different hosting companies, lets say Host A and Host B. Now host A has our old server and also the MS SQL DB.

    We recently purchased a bigger server with HOST B. I moved some of the files over to that server and tried to see if the DB connected fine. But I got an error msg...

    Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    Now we have a local testing server and the connection string I use works fine. So it should work with HOST B. What might be the problem?

    The ASP connection string I use is below

    set objConn = Server.CreateObject("ADODB.Connection")

    objConn.ConnectionString = "Provider=SQLOLEDB.1; Network Library=dbmssocn;Password=pass;User ID=dbname;Initial Catalog=catname;Data Source=site URL"



  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Since network library is explicitly specified you need to check on the port assignments. 1433 is the default, but if your new hosting company has it blocked, or if your own firewall does not pass requests through it, - that will do it.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts