Maintenance Plan Connection

[MasterRacker]

SQL 2005. I have a plan I'm having some trouble with. I'm trying to change the connection to use a domain service account instead of NT Integrated Security. In the connection properties I'm clicking to specify an id and password. I'm entering the id in the form <domain>\<username>. I am unable to connect.

In this particular dialog, am I being asked for a SQL ID instead of a domain ID? If so, Is there a way to specify a domain id instead of simply using integrated authentication?

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[mrdenny]

The package will run under the domain account of the SQL Agent. To change this you have to setup a proxy account for SSIS job types then change the job step to run under this proxy account (I think).

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog