Posted by Erland Sommarskog on 03/01/07 22:13

(theintrepidfox@hotmail.com) writes:
> Found the Solution on Vista:
>
> - Go to Control Panel and Switch to Classic View
> - Click on User Accounts
> - Click on Turn User Account Control on or off
> - Uncheck use User Account Control (UAC) to help protect your
> computer.
> - OK
> - Restart System
>
> Try again to attach the DB. It should work now.
>
> Hope this helps anyone else having this problem.

Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
is that you should not run as Administrator all the time, only when you
need it. While running as Administrator is convenient, it makes it
easier for any infections your machines may catch to spread. I think
there is a context-menu option "Run As Administrator".

Personally, I have not had any encounter with Vista yet.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server Upgrade Wizard
• Prev in forum: Re: Newbie: Updating record with User information
• Thread view: Re: Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!

[Reply to this message]