I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.
I am connecting to a SQL Database from VS 2005, Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security
= True. I am using Windows Authentication mode in SQL Server Express.
The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL
Server 2005 it works fine only if User Instance = False.
I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server
Express, Nothing is working.
I am already added to the Administrator Group locally on my Laptop. Still same problem.
Checked this article:
http://msdn.microsoft.com/en-us/library/ms254504.aspx, same problem.
I enabled User Instances and also tried to Disable User Instances. When I disable user instances, and then try to connect from VS, I get a different error, which is asking to enable user instances.
View Complete Post