Changing SQL Svr to run under domain account

From: Eric (Eric@noemail.com)
Date: 07/18/02 

From: "Eric" <Eric@noemail.com>
Date: Thu, 18 Jul 2002 11:06:43 -0700

I recently changed the SQL Server and the SQLAgent to run
under a domain account instead of the local system
account. Now since I've done this some of my jobs are
failing. Other servers are using this account to run the
services. I'm not sure what happened here. Any ideas?
Here is the error:

  Error: -2147467259 (80004005); Provider Error: 17
(11) Error string: [DBNETLIB][ConnectionOpen (Connect
()).]SQL Server does not exist or access denied.
Error source: Microsoft OLE DB Provider for SQL
Server Help file: Help context: 0. Process
Exit Code 1. The step failed.

Relevant Pages

  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
  • RE: MP Install issue
    ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)