Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Fix tempdb
Message
From
11/01/2002 13:57:17
 
 
To
11/01/2002 13:18:25
Christopher Pinnock
United General Insurance Company
Kingston, Jamaica
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00603166
Message ID:
00603658
Views:
18
Check out MSKB Q239759

"The Microsoft Windows NT account under which the MSSQLServer service starts does not have Full Control permissions on the directory in which you are trying to create the database. "

If this is accurate, your server is configured incorrectly. The account that the MSSQLSERVER service uses is supposed to be a member of the local Administrators group.

-Mike

>Encountered an unexpected error while checking the sector size for file 'E:\MSSQL7\DATA\TEMPDB.MDF'.
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform