Connection to MSSQL server fails

Discussion in 'Databases' started by Zikdaman, May 25, 2014.

  1. Classic ASP site.
    My connection string (user and password edited out of course) is:
    "Provider=SQLOLEDB;Data Source=tcp:s07.Winhost.com;Initial Catalog=DB_75822_pictureshow;" _
    & "User ID=user;Password=password;" _
    & "Connect Timeout=15;Integrated Security=False;"

    It returns:
    Microsoft OLE DB Provider for SQL Server error '80004005'
    [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.

    I've tried it with and without the tcp prefix for the Source parameter. Same issue every time. Were have I gone wrong?
     
    Last edited by a moderator: Oct 14, 2015
  2. Elshadriel

    Elshadriel Winhost Staff

    Try removing the Provider name.
     
  3. Got the issue resolved by using the following example:

    Data Provider=SQLNCLI10;Data Source=myServerAddress;
    Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword
     
    ComputerMan and Elshadriel like this.
  4. Elshadriel

    Elshadriel Winhost Staff

    I'm glad you figured it out. :)
     

Share This Page