CODEWITHSUNDEEP
visual-studio-2012database-connection
user1809104
user1809104

Reputation: 717

How to connect to SQL database from Visual Studio/ open .mdf file

If I copy an .mdf file created by SQL server management studio and put it in the app_data folder I get this error:

"This database file is not compatible with the current instance of SQL Server.

To resolve this issue, you must upgrade the database file by creating a new data connection, or you must modify the existing connection to this database file.

For more information, see http://go.microsoft.com/fwlink/?LinkId=235986"

And if I attempt to Add connection using the visual studio wizard, choosing the Microsoft SQL server database file and select the file I get this error:

" Unable to open physical file "path" {access is denied) an attempt to attach an auto named for file "path" a database with the same name exists, or specified file cannot be opened, or it is located on UNC share"

And if I attempt to add a connection choosing the "Microsoft SQL server" option in the choose data source window:

"a network related or instance specific error occurred while establishing a connection to SQL server. the server was not found or was not accessible. Verify the the instance name is correct and that the SQL is configured to allow remote connections..."

The only reason I want to connect visual studio to the database is because VS doesn't allow me to import text files. I have imported a text file into a DB from SQL server management studio and I want to connect it to VS. I've turned off UAC in windows 7 and I have file permissions to the mdf file.

Upvotes: 2

Views: 6979

Answers (1)

longestwayround
longestwayround

Reputation: 1019

Old question, but just to provide an answer for visitors from Google, the problem is not related to file system access (although Administrator accounts should have full privileges to the folder containing the mdf and log files). The solution is that SQL Management Studio needs to be opened using "Run As Administrator". The elevated permissions will allow SQL Server (or SQLExpress) to attach the older mdf file and update it. Once the db is attached, you can access it in Visual Studio by adding a database connection through the Add New Item->Data->ADO.NET Entity Data Model wizard.

Upvotes: 1

Related Questions