November 7, 2003 at 12:29 pm
I am a little green when it comes to SQL server administration and need some advice.
I created an instance of sql server last year using just a Local account (administrator) as I was doing everything locally on that machine.
I now have the task of doing some sql jobs that will DTS between this machine, say 001 and another say 002.
I have created a domain account called flex_sql on 001 and login to machine under this account. flex_sql is an administrator on 001.
The job works but not when scheduled. I am pretty sure I need to do these to things:
1) Change to Start Up Service Account to start up under flex_sql. It is currently starting up under .\Administrator.
2) Change SQL Server Agent to Start up also under flex_sql.
* I am nervous to change these start up services accounts as I do not remember off hand setting up a password for .\Administrator. I am worried I could get locked out of the system.
+ Am I going down the right road with my actions?
+ Could I possibly get locked out of my machine?
Much thanks in advance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply