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.
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)
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
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.
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.
Member
222 Points
210 Posts
Visual Web Developer Express 2010 and Microsoft SQL Server 2008 Management Studio Express.
Jan 06, 2014 07:47 AM|SeeDosRun|LINK
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
Lucky > Good
All-Star
32817 Points
3815 Posts
Re: Visual Web Developer Express 2010 and Microsoft SQL Server 2008 Management Studio Express.
Jan 07, 2014 02:17 AM|Angie xu - MSFT|LINK
HI SeeDosRun
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
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
222 Points
210 Posts
Re: Visual Web Developer Express 2010 and Microsoft SQL Server 2008 Management Studio Express.
Jan 08, 2014 09:36 AM|SeeDosRun|LINK
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
Lucky > Good