Denied access to SQL Express database files

[=?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

 

[Steve Cochran]

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

 

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

How do I take ownership of the files?

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

 

[Steve Cochran]

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

steve

 

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

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

Stig

 

[Erik Funkenbusch]

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

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