Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL database connection didn't work

Author  Topic 

ria87
Starting Member

3 Posts

Posted - 2013-08-22 : 20:49:34
Hi,

I'm using visual studio 2008. My friend created a project and the database using SQL. RIght now i try to open that database that has been created using Visual studio 2012 however it's failed.
it show error message = 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 connection(error 26: error locating server/instance specified.)

Can you tell me what wrong with that database?

My friend try to open it using ms visual studio 2012 and it's can be opened.

Ria

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-08-23 : 00:15:41
May that is the problem with connection string....
Can you post the connection string which was written for DB connection....
Make sure that the DB name, Server Name, User name & password are correct

--
Chandu
Go to Top of Page

ria87
Starting Member

3 Posts

Posted - 2013-08-27 : 02:44:10
i use the local server: (LocalDB)\v11.0.



Ria
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-08-27 : 08:05:20
Do you have LocalDB installed? Assuming you do, try creating a new project and connecting to localdb. It may be that there are some settings in your colleague's installation of VS2012 that do not match yours.
Go to Top of Page

ria87
Starting Member

3 Posts

Posted - 2013-09-02 : 22:20:25
seems like the ms visual studio 2008 with .NET version 3.5 didnt support local db. http://blogs.msdn.com/b/sqlexpress/archive/2011/11/28/using-localdb-in-visual-studio-2010.aspx

Ria
Go to Top of Page
   

- Advertisement -