Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 17050 : initerrlog: Could not open error log file

Author  Topic 

beyonder422
Posting Yak Master

124 Posts

Posted - 2005-11-16 : 12:35:41
I was moving database files, following the steps laid out in:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

when I went to restart sql server and found that I could not start the sqlserveragent.

17050 :
initerrlog: Could not open error log file 'S:\SQL_Logs\ErrorLog'. Operating system error = 5(Access is denied.).

I was moving files from one drive to another, both located on a SAN.
Everything I've read says, "goto SEM and reset the server properties", the only problem is, I can see the server properties until sqlserveragent starts,

anyone tell me how to go in and manipulate server properties without using enter manger?

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2005-11-16 : 13:16:30
Well, before that, can you get to S:\SQL_Logs\Errorlog? Is there some funky permission on it? Also, if this is a network drive, does SQL Server run as a domain account, so it can get to the errorlog?
Go to Top of Page

beyonder422
Posting Yak Master

124 Posts

Posted - 2005-11-16 : 16:03:42
See "safe to move system database" post...
Go to Top of Page
   

- Advertisement -