Error when opening app on different computer

0
votes

I have just finished an app that is using a database.mdf. Everything is working well, but when I open the app on a different computer, I'm getting the following error:

"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 that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "

Here is the database connection string:

Data Source=(LocalDB)\v11.0;AttachDbFilename=Z:\Items\ItemDatabase.mdf;Integrated Security=True;MultipleActiveResultSets=True;Connect Timeout=60

All computers have this network storage drive already mapped to the computer, but it only seems to work on my computer.

I have tried the double \\ but nothing worked. The names all match. What could it be?

Thanks

1
sql-serverdatabaselocaldbmdf
Should have to mapped drive Z: on every computer that you opening your application – PEO
Could also be permissions. IIRC the user needs full read + write permissions and this error will be thrown if they don't. – Simon Whitehead
are there other things that have it open at the same time? – Keith Nicholas
on other computers, is Z: drive mapped to the exact same share? If Z: is mapped in a logon screen, and program is running as different user, could it be that Z: exists, but is pointing to a different folder? – LB2
possible duplicate of Connect to Server :A network-related or instance-specific error and about 50 others located searching here for the first sentence in the quoted error message (and not to mention the 200K+ results that turned up with a Google search on the same sentence, many of which were here). – Ken White

1 Answers

1
votes

The computer which you are trying to run the application must have the LocalDB installed.

You can download it from this link: http://www.microsoft.com/en-us/download/details.aspx?id=29062