SQL SERVER 2014 & VS2013 instance issues

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 SERVER 2014 & VS2013 instance issues

Author

Topic

neoprabhakar
Starting Member

3 Posts

Posted - 2014-09-16 : 01:05:28

I've been developing web forms on VS2013. Today when I jumped to work on winforms, I was not able to connect to sql server 2014 for database connectivity. I even downloaded and installed the SSDT update, then too I've been thrown with ERROR 26 Error Locating SERVER/Instance specified. I did rechecked the instance name but even though no LUCK. the only way I can connect is via SERVER EXPLORER. I want to add the database file(.mdf) in the solution explorer. Please suggest.

Config:
Windows 8.1
Visual Studio 2013 Ultimate
SQL Server Management Studio with Tools 2014

H2O

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-16 : 12:39:44

Can you connect in Management Studio? If so, then attach the database using SSMS GUI or CREATE DATABASE FOR ATTACH command.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

neoprabhakar
Starting Member

3 Posts

Posted - 2014-09-17 : 14:55:21

Yes I can connect via management studio. I did created and designed it in Management studio. But I am bit curious why it didn't worked as vs2012 did with sql server 2012

H2O

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-17 : 15:01:57

I wouldn't rely on visual studio to do the SQL tasks. Use SSMS for that. VS is designed to do some things but not all.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

neoprabhakar
Starting Member

3 Posts

Posted - 2014-09-18 : 14:07:18

Got it. SSMS for SQL Data, VS only to code apps.

H2O

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources