Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Vista Newsgroups > Vista General

Vista - No access to sql serevr database files in Windows Vista

Reply
 
Old 01-17-2007   #1 (permalink)
Stig Kulvedrøsten


 
 

No access to sql serevr database files in Windows Vista

Using Windows Visat RTM, Visual Studio .Net 2005 SP1 and SQL Server Express
SP

When trying to run a website that uses a attachdb file in the
connectionstring I get this error:
An attempt to attach an auto-named database for file
e:\website\site1\app_data\site_db.mdf failed. A database with the same name
exists, or specified file cannot be opened, or it is located on UNC share.

I've tried giving it admin rights and taking ownership, but no difference.
I also get 'access denied' when trying to copy, delete and so on in Windows
Explorer.

Any suggestions?

Stig


My System SpecsSystem Spec
Old 01-24-2007   #2 (permalink)
LaRoux


 
 

Re: No access to sql serevr database files in Windows Vista

You don't mention if your SQL Server Express is at SP1 or not. It needs to
be at least SP1 to be Vista compatible.
Check here for information on running SQL Server on Vista (and Longhorn too)
http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

"Stig Kulvedrøsten" <stig@spire.as> wrote in message
news:303DE039-9A93-4FDD-8E39-270129DAFA20@microsoft.com...
> Using Windows Visat RTM, Visual Studio .Net 2005 SP1 and SQL Server
> Express SP
>
> When trying to run a website that uses a attachdb file in the
> connectionstring I get this error:
> An attempt to attach an auto-named database for file
> e:\website\site1\app_data\site_db.mdf failed. A database with the same
> name exists, or specified file cannot be opened, or it is located on UNC
> share.
>
> I've tried giving it admin rights and taking ownership, but no difference.
> I also get 'access denied' when trying to copy, delete and so on in
> Windows Explorer.
>
> Any suggestions?
>
> Stig
>



My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Re: Access Database on Vista Locking out everyone Vista General
Cannot open shared access database from vista Vista networking & sharing
Access Database networking and Windows Vista Vista networking & sharing
Synchronize Access 2003 database with Windows Mobile PDA? Vista General
Denied access to SQL Express database files Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46