Post reply

SQL Server does not exist or access denied.

  • July 21, 2010 at 8:04 am

    #387403

    We recently migrated our sql 2005 to sql 2005 due to hardware upgradation.

    after migration, I am receiving the following errors for some jobs that run during nights.

    All these failed jobs run some VBScript.

    Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server

    But if I rerun the same job again and again , it starts working..

    I have no clue of how to figure out this problem..... can some one help me on this.

    Does this have something to do with sql server settings....

    or what options do I need to check after installing a new sql server.

    Thanks in advance

  • July 21, 2010 at 8:49 am

    #1196213

    Check whether the job owner is same, as it was earlier. Also check the user rights for both the users.

  • July 21, 2010 at 9:05 am

    #1196229

    The owner has same permissions in both the servers. and he is sysadmin.

    but still I get the same error.

  • July 22, 2010 at 6:17 am

    #1196781

    Please check the open connections/performance of the Server to which the job points to. Most likely the server is busy when the job fails.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply