We are moving our SQL Server 2000 databse to a new server. After I
installed it and copied the data over, I found that SQL Server Agent will
not start. I get an Access is denied... message.
The only difference that I know of is that the new server is running Windows
2003 Advanced server and the old serve is not.
Any suggestions?
TIA
MikeIf you are using a system account to log in the service,
change it to a local or domain account that you know the
password for. If you are using a local or domain account,
set the service to system account (stop and restart the
service) and then re-enter your domain/local account with
the correct password. >--Original Message--
>We are moving our SQL Server 2000 databse to a new
server. After I
>installed it and copied the data over, I found that SQL
Server Agent will
>not start. I get an Access is denied... message.
>The only difference that I know of is that the new server
is running Windows
>2003 Advanced server and the old serve is not.
>Any suggestions?
>TIA
>Mike
>
>.
>|||Was this a brand new install? Pls check your sqlagent.out located in the
LOG folder of your SQL Server installation directory for more information
on the error mesg? the sQL Error logs will help as well.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment