Adding Service-Based Database not working after system updates

Question

Hello,

I am a novice developer.  I recently installed SQL Server2008 R2 (Express with tools), and just a few days ago was able to add a Service-based database to my project as a new item and manipulate the database using VS tools with no problem. (Create tables, columns etc...)   However, after SP1 was installed ( at least I believe this to be the culprit, please don't take my word for it !! ) VS doesn't see my SQL server instance at all, if I'm reading this error message correctly.   Any ideas?

What I have tried:

1.  Disabled all firewalls

2.  Enabled all protocols within SQL Configuration settings

3.  Ensured that MSSQLSERVER service and browswer services were running.

Below is my About info from VS:

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

Installed Version: Premium

Microsoft Office Developer Tools   01021-532-2002102-70178
Microsoft Office Developer Tools

Microsoft Visual Basic 2010   01021-532-2002102-70178
Microsoft Visual Basic 2010

Microsoft Visual C# 2010   01021-532-2002102-70178
Microsoft Visual C# 2010

Microsoft Visual C++ 2010   01021-532-2002102-70178
Microsoft Visual C++ 2010

Microsoft Visual F# 2010   01021-532-2002102-70178
Microsoft Visual F# 2010

Microsoft Visual Studio 2010 Code Analysis Spell Checker   01021-532-2002102-70178
Microsoft Visual Studio 2010 Code Analysis Spell Checker

Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.

Microsoft Visual Studio 2010 Team Explorer   01021-532-2002102-70178
Microsoft Visual Studio 2010 Team Explorer

Microsoft Visual Web Developer 2010   01021-532-2002102-70178
Microsoft Visual Web Developer 2010

Crystal Reports Templates for Microsoft Visual Studio 2010  
Crystal Reports Templates for Microsoft Visual Studio 2010

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2522890)   KB2522890
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2522890.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2529927)   KB2529927
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2529927.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2548139)   KB2548139
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2548139.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2549864)   KB2549864
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2549864.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2565057)   KB2565057
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2565057.

Microsoft Visual Studio 2010 Premium - ENU Service Pack 1 (KB983509)   KB983509
This service pack is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.

Microsoft Visual Studio 2010 SharePoint Developer Tools   10.0.40219
Microsoft Visual Studio 2010 SharePoint Developer Tools

Answer 1

It should be noted that the Data Source Configuration wizard sees my SQL server instance fine and allows me to create a new dataset with no issues.  It is only when I try to add a new .mdf to a project (right click project>add>new item>Service-based Database) that I receive this message.

Answer 2

Everyone is afraid to help the n00bie.....This doesn't bode well !!!   Dive in folks, take the plunge !!     Please??  :)

Answer 3

Hello manyhat_itguy,

Thanks for your post. However, I do not think here is the appropriate forum for you to deal with your issue. Could you please offer me more information what kind of project are you creating? I would like to help you to move your case to the correct forum.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 4

I just resolved this issue moments ago.  Quite simply the problem was as follows:

1.  Create new project

2.  Right click project, add new item, add Service-based Database

I would receive error above.

I fixed this issue by going to Tools -> Options -> Database Tools -> Data Connections, and changing "SQL Server Instance Name to SQLEXPRESS2K8R2, which is the name of my locally installed SQL Server Express 2008R2 instance.  I was then able to create the .mdf file as needed. 

When I said novice, I wasn't kidding.  I am simply trying to follow an instructional video at LearnVisualStudio.net and couldn't continue :)

I think it was best for my "learning" to find the resolution myself anyways.

thanks

Answer 5

Where do you get the instance name?

I tried using SQLEXPRESS2K8R2 and still get the error.

Answer 6

I was with this same problem and your tip solved my problem.

 I left the name blank for the default instance.

Thank you!!