after reinstalling sql server 2005, sql express, visual studio etc, my
development PC, I can access fully an mdf file only as an administrator,
but not as a power user developer ID I usually use. even when I was using
the administrator, I noticed, the connection was not as user instance.
I think I must have messed up somewhere in teh re-install.
Please enlighten me as to what is required to get the developer ID to full
access as user instance?
the present connection string is
Data Source=.\SQLEXPRESS;AttachDbFilename=D:\data\Strin g.mdf;Integrated
Security=True;Connect Timeout=30;User Instance=True
when I tried to test connection using the above string using the power user
developer ID, I get
---------------------------
Microsoft Visual Basic 2005 Express Edition
---------------------------
Failed to generate a user instance of SQL Server due to a failure in
starting the process for the user instance. The connection will be closed.
---------------------------
OK
---------------------------
when user instance is set to true
If I set the user instance to false, I get instead:
---------------------------
Microsoft Visual Basic 2005 Express Edition
---------------------------
CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file d:\data\StringTmp.mdf
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.
---------------------------
OK
---------------------------
I have checked that the ID does have full access to the mdf
How do I setup an sure instance?