Title pretty much says it all - I am running Windows Vista, and I have two Windows user accounts (one has Administrator rights, one does not). I am new to SQL Server, but not at all to database technology. For those who don't want the background
information, my question is, how can I attach and (more importantly) access databases in MS SQL Server 2008 R2 Express using a NON-ADMIN Windows user account?
Here's my scenario...
I always log on to the machine with the non-administrator account for general day-to-day use - then, when necessary, I either select "Run As..." or otherwise provide the Administrator's user id / password as required.
I installed SQL Server 2008 R2 Express successfully, followed by SQL Server Management Studio (which, for some reason, was NOT installed as part of the SQL Server installation). In both cases, Windows admin user credentials were required and supplied,
no problem.
Next, I started ...
Go to the complete details ...