locked
Visual Web Developer Express 2010 and Microsoft SQL Server 2008 Management Studio Express. RRS feed

  • Question

  • User180268958 posted

    Hi all,

    I installed VWD Express 2010 a while ago which automatically installed SQL Server Express 2008 R2 Service Pack 2 - 10.50.4000.0

    I am trying to install Microsoft SQL Server 2008 Management Studio Express.

    One of the stages of installation asks if I want to perform a new installation of SQL Server 2008 or Add features to an existing instance of SQL Server 2008.

    I choose to Add features to an existing instance of SQL Server 2008 and "SQLEXPRESS" is displayed however when I try to continue I get an error

    "The Instance ID is required but it is missing."

    The only thing that jumps out at me is that when listing the SQLEXPRESS Server it has the version as 10.52.4000.0 - I don't know if that is relevant or not.

    Has anyone else had this problem?

    Thanks

    Monday, January 6, 2014 7:47 AM

Answers

  • User180268958 posted

    So it took me a while but I found a solution.

    The first problem was that I was trying to install SQL Server 2008 Management Studio Express (http://www.microsoft.com/en-IE/download/details.aspx?id=7593) when my server was SQL Server 2008 R2.

    So I looked for an R2 version of the SQL Server 2008 Management Studio Express. I found one and downloaded it (http://www.microsoft.com/en-us/download/details.aspx?id=22985) went through the installation and realised it was the same as what I had on my system already so that was no help.

    Then I found Microsoft SQL Server 2008 R2 RTM - Express with Management Tools (http://www.microsoft.com/en-us/download/confirmation.aspx?id=23650). I only installed the extras, not a new server as I already had one. I followed Beth Massi's guide - http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx (It's not specific to my situation but was close enough).

    That installed SSMS but when I opened the program I got an error that the package failed to load.  I spent an hour or two online looking for a solution, I ended up restarting my computer and then it worked. 

    Then I logged in to my instance of SQL server (in my case it was local and called .\SQLEXPRESS) - luckily I had written down my username and password when I installed that. I then tried to attach a database. Fail.

    So after going online for some more searching I found if I run SSMS AS ADMINISTRATOR and I turn all the permissions on for my .mdf and .ldf files I want they will attach.

    I don't know if this will help anyone else but I hope it saves someone some time.

    Thanks

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 8, 2014 9:36 AM

All replies

  • User-166373564 posted

    HI SeeDosRun

    "The Instance ID is required but it is missing."

    In our Installation and Setup forum, we discuss relevant questions about getting ASP.NET installed and running on your system.  For this issue, it's recommanded to get help from SQL Server forums forum, more SQL Server experts can help you there.

    In addition, during SQL Server Setup, an instance ID is generated for each server component. The server components in this SQL Server release are the Database Engine, Analysis Services, and Reporting Services.

    # How to: Add Features to an Instance of SQL Server 2008 R2 (Setup)

    http://msdn.microsoft.com/en-us/library/cc281940(v=sql.105).aspx 

    Best regards

    Angie

    Tuesday, January 7, 2014 2:17 AM
  • User180268958 posted

    So it took me a while but I found a solution.

    The first problem was that I was trying to install SQL Server 2008 Management Studio Express (http://www.microsoft.com/en-IE/download/details.aspx?id=7593) when my server was SQL Server 2008 R2.

    So I looked for an R2 version of the SQL Server 2008 Management Studio Express. I found one and downloaded it (http://www.microsoft.com/en-us/download/details.aspx?id=22985) went through the installation and realised it was the same as what I had on my system already so that was no help.

    Then I found Microsoft SQL Server 2008 R2 RTM - Express with Management Tools (http://www.microsoft.com/en-us/download/confirmation.aspx?id=23650). I only installed the extras, not a new server as I already had one. I followed Beth Massi's guide - http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx (It's not specific to my situation but was close enough).

    That installed SSMS but when I opened the program I got an error that the package failed to load.  I spent an hour or two online looking for a solution, I ended up restarting my computer and then it worked. 

    Then I logged in to my instance of SQL server (in my case it was local and called .\SQLEXPRESS) - luckily I had written down my username and password when I installed that. I then tried to attach a database. Fail.

    So after going online for some more searching I found if I run SSMS AS ADMINISTRATOR and I turn all the permissions on for my .mdf and .ldf files I want they will attach.

    I don't know if this will help anyone else but I hope it saves someone some time.

    Thanks

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 8, 2014 9:36 AM