locked
Adding Service-Based Database not working after system updates

    问题

  • 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

    2012年1月3日 6:15

答案

  • 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

    2012年1月4日 21:02

全部回复

  • 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.
    2012年1月3日 6:30
  • Everyone is afraid to help the n00bie.....This doesn't bode well !!!   Dive in folks, take the plunge !!     Please??  :)
    2012年1月3日 21:12
  • 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
    2012年1月4日 3:49
    版主
  • 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

    2012年1月4日 21:02
  • Where do you get the instance name?

    I tried using SQLEXPRESS2K8R2 and still get the error.

    2012年3月29日 16:26
  • I was with this same problem and your tip solved my problem.

     I left the name blank for the default instance.


    Thank you!!

    2012年4月27日 20:03