I have added Microsoft SQL Server 2005 - Express edition to my Plesk installation by using Add/Remove Programs --> Plesk --> Change.
It installed correctly.
Yet, SQL Server itself cannot access the databases becase the NTFS permissions DENY access to the Network Service account, and SQL runs under that 'account'. Therefore, SQL won't start.
If I check the NTFS permissions, I see that the account that has the proper permissions is called 'SQL2005USER$HOST$DOMAIN'. That user does not exist(?)
Should I change the credentials SQL is running under, or give the network service account the proper NTFS permissions? What are the *correct* defaults?
Tino
It installed correctly.
Yet, SQL Server itself cannot access the databases becase the NTFS permissions DENY access to the Network Service account, and SQL runs under that 'account'. Therefore, SQL won't start.
If I check the NTFS permissions, I see that the account that has the proper permissions is called 'SQL2005USER$HOST$DOMAIN'. That user does not exist(?)
Should I change the credentials SQL is running under, or give the network service account the proper NTFS permissions? What are the *correct* defaults?
Tino