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

"Stig Kulvedrøsten" <stig@spire.as> wrote in message
news:FC21B8A0-BBE3-42B8-84D5-DB4F8A0C28AA@microsoft.com...[color=blue]
> 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
>[/color]

How do I take ownership of the files?

Stig

"Steve Cochran" <scochran@oehelp.com> wrote in message
news:E1C4C3E3-F855-41EB-949A-031269300CAE@microsoft.com...[color=blue]
> 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
>
> "Stig Kulvedrøsten" <stig@spire.as> wrote in message
> news:FC21B8A0-BBE3-42B8-84D5-DB4F8A0C28AA@microsoft.com...[color=green]
>> 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
>>[/color]
>[/color]

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

steve

"Stig Kulvedrøsten" <stig@spire.as> wrote in message
news:D2FD1119-FE20-44FE-812B-DD110572A1E5@microsoft.com...[color=blue]
> How do I take ownership of the files?
>
> Stig
>
> "Steve Cochran" <scochran@oehelp.com> wrote in message
> news:E1C4C3E3-F855-41EB-949A-031269300CAE@microsoft.com...[color=green]
>> 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
>>
>> "Stig Kulvedrøsten" <stig@spire.as> wrote in message
>> news:FC21B8A0-BBE3-42B8-84D5-DB4F8A0C28AA@microsoft.com...[color=darkred]
>>> 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
>>>[/color]
>>[/color]
>
>[/color]

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

Stig

"Steve Cochran" <scochran@oehelp.com> wrote in message
news:C819C69F-D937-4D9B-822F-EE8AF89B2941@microsoft.com...[color=blue]
> You have to right click on the files and Properties | Security and then
> fiddle there.
>
> steve
>
> "Stig Kulvedrøsten" <stig@spire.as> wrote in message
> news:D2FD1119-FE20-44FE-812B-DD110572A1E5@microsoft.com...[color=green]
>> How do I take ownership of the files?
>>
>> Stig
>>
>> "Steve Cochran" <scochran@oehelp.com> wrote in message
>> news:E1C4C3E3-F855-41EB-949A-031269300CAE@microsoft.com...[color=darkred]
>>> 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
>>>
>>> "Stig Kulvedrøsten" <stig@spire.as> wrote in message
>>> news:FC21B8A0-BBE3-42B8-84D5-DB4F8A0C28AA@microsoft.com...
>>>> 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
>>>>
>>>[/color]
>>
>>[/color]
>[/color]

On Tue, 16 Jan 2007 22:43:23 +0100, Stig Kulvedrøsten wrote:
[color=blue]
> 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[/color]

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