SQL Server 2000 can not start on XP OS with NTFS format?

[honghue]

I installed SQL Server 2000 on Window XP operation system that was formatted by NTFS type.SQL Server 2000 can not start.But when i insttalled SQL Server on Window XP operation system that was formatted by FAT type SQL Server can start and run normal. Thanks for any help.

 

[stravis]

NTFS and FAT have nothing to do with your SQL Server not running. If this is a new PC, perhaps you installed SQL Server and then changed your PCs name, which would cause SQL Server to fail to start. In any case, try reinstalling SQL Server on your Windows XP machine to solve this issue.

 

[honghue]

Thak your response, Stravis.
I formatted my XP OS with FAT and installed SQL Server 2000 that ran very well.But I formatted my XP OS with NTFS, SQL Server can not start(I have not changed my computer'name).

 

[stravis]

More than likely you have one of two problems.

1. The user account the SQL Server Services are using do not have the proper file permissions. To determine if this is the issue quickly, you can make the user account for your services a member of the local Administrators Group.

2. You are using NTFS compression to reduce the amount of space taken up by your databases. SQL Server will fail to start if you are using NTFS file compression. If you are in fact using file compression, uncompress all SQL Server related content, and attempt to start the SQL Server Service.

Hope this helps

 

[honghue]

Thank your responses very much,Stravis.
I found problem that when i installed SQL at first time it was not success,to success installing,i must uninstall SQL and delete the folder of SQL.
Once again, i thank your help,