Hi
We have a demo version of our SQL2000 application that uses MSDE. This has always worked sucessfully in the past.
However, at the most recent installation however there is a problem which I cannot seem to fix.
MDSE was installed on Windows 2000 using the Local Admin account.
When the user logs on to the PC, SQL will not start gives error message '5 Access Denied'.
I have given the local user read/write permission to the Data directory and mdf/ldf files that it contains.
I have tried starting SQL specifiying it to log on using the Local Admin account but it makes no difference.
Does anyone know what else can I do?
Thank you
Mark
SQL Server controls the permissions if a user has access to the (database) server and the appropiate databases. it has nothing to do with file permissions. You will have to create a new login and grant the login the appropiate permissions on the database.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Hi Jens, thank you for this, but I think the problem is more fundemental as at the moment SQL Server will not even start unless a local administrator is logged in.
Mark
|||
Which service account is the service running under ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||The service is set to logon using a specified account and we are specifying the local administrator account.
These settings work when the local administrator is logged-on to the PC, so it looks like we have entered both the Account and Password correctly.
Many thanks
Mark
No comments:
Post a Comment