I am using Visual Studio 2010/c#
and created an application where I am trying to access as a data source,a database which I created in SQLSERVER Express
(via management studio).
I have several instances from previous installs which I remove -
SQL COnfiguration manager just shows 1 instance SQLEXPRESS which got installed as a named instance "mymachine/sqlexpress".
Named pipes, TCP/IP and remote clients are all enabled.
I am running under windows 7 64 bit and both the dev environment and sql are in the same PC.
When I try and configure the connection I go to the physical path where the file resides, add it but the test connection button fails with the msg failed to generate a user instance of sql server, only an integrated connection can generate an user instance
The solutions I found don't seem to apply.
User Instance is already enabled (set to 1) and I could not find any path to remove "old instances" there is only 1 path leading to the currently installed Instance.
Help would be appreciated