Denied access to SQL Express database files

  • Thread starter Thread starter =?iso-8859-1?Q?Stig_Kulvedr=F8sten?=
  • Start date Start date
?

=?iso-8859-1?Q?Stig_Kulvedr=F8sten?=

I've installed Windows Vista Ultimate RTM. When trying to run/copy/and set
security attributes to certain sql server files I get access denied. Windows
displays my account as a admin account. When trying to run a website using
these sql server files I get the same message. No access. These worked great
with Windows XP a week ago.

Any suggestions?

Stig
 
You can try taking ownership of the files and then changing the permissions
on them. You might need to boot to Safe Mode and log on as Administrator.

steve
 
How do I take ownership of the files?

Stig

Steve Cochran said:
You can try taking ownership of the files and then changing the
permissions on them. You might need to boot to Safe Mode and log on as
Administrator.

steve
Click to expand...
 
You have to right click on the files and Properties | Security and then
fiddle there.

steve
 
I've done this and this doesnt change anything. It is only sql server
express db files that have this problem.

Stig
 
I've installed Windows Vista Ultimate RTM. When trying to run/copy/and set
security attributes to certain sql server files I get access denied. Windows
displays my account as a admin account. When trying to run a website using
these sql server files I get the same message. No access. These worked great
with Windows XP a week ago.

Any suggestions?

Stig
Click to expand...

There is a known compatibility issue with SQL Server Express SP1. You will
likely need to install the SP2 beta.
 
Back
Top