Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

SQL 2000 SP2 HOTFIX Q315395

Hi there folks !

I got this error message when trying to restart my SQL 2000 after applying the HotFix Q315395 !

Event Viewer :

The MSSQLSERVER service failed to start due to the following error:

Access is denied.

___________

I review and comfirm the Service Account password, and the service configuration of MSSQLSERVER !

I did the following test on the box :

Try to start SQL with :

- SQLSERVR.EXE -> FROM HOTFIX

- SQLSORT.DLL -> FROM HOTFIX

- SQLSERVR.PDB -> FROM HOTFIX

-> Access is denied message !

Try to start SQL with :

- SQLSERVR.EXE -> FROM SP2

- SQLSORT.DLL -> FROM HOTFIX

- SQLSERVR.PDB -> FROM SP2

-> Server Hang on start-up !

Try to start SQL with :

- SQLSERVR.EXE -> FROM SP2

- SQLSORT.DLL -> FROM HOTFIX

- SQLSERVR.PDB -> FROM HOTFIX

-> Server Hang on start-up !

Try to start SQL with :

- SQLSERVR.EXE -> FROM SP2

- SQLSORT.DLL -> FROM SP2

- SQLSERVR.PDB -> FROM HOTFIX

-> Server Hang on start-up !

Try to start SQL with :

- SQLSERVR.EXE -> FROM HOTFIX

- SQLSORT.DLL -> FROM SP2

- SQLSERVR.PDB -> FROM SP2

-> ACCESS IS DENIED !

So, I review all right on the Executable, on the directory and the rigth of the "Service Account" to be sure that "Log on as a Service" right is set !

No result !

Any Idea folks ?

Thanks !

Martin Gagnon

TELUS

  • Other Collaboration Voice and Video Subjects
3 REPLIES
New Member

Re: SQL 2000 SP2 HOTFIX Q315395

Do not mix and match SP2 and Hotfix files like you've described. Check the services administrative tool to verify you have the proper password on the account MSSQLSERVER is using to run under. This is under the Log On tab for that service's properties.

adam

New Member

Re: SQL 2000 SP2 HOTFIX Q315395

Hi !

Thanks for your help ! I solve my problem by downloading the HotFix from MS Premium Support .

So, the file on my Unity 3.1.4 SP was corrupted, caused by downloading the ZIP file in ascii mode ? . I redownload the file in binary mode to be sure and, the file seem ok in this "new" downloaded package !

I will check the file on the CD that I burn yesterday, to confirm that the problem was cause by a bad "download" mode (Ascii / Binary) on your ftp site !

I will let you know the result !

Martin

New Member

Re: SQL 2000 SP2 HOTFIX Q315395

Hi !

My test result are that a problem occur when burning the CD1 !

(FTP CLient in Auto mode, select automaticly "Binary mode" for transfert, so it cannot be an issue)

Thanks for your time !

Martin

127
Views
0
Helpful
3
Replies
This widget could not be displayed.