SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How do I configure a named instance in SQL EXPRESS 2008 R2?


How do I configure a named instance in SQL EXPRESS 2008 R2?

Author
Message
Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2759 Visits: 2064
I've installed a SQL Server 2008 R2 Express onto a user's machine (he's stuck on the east coast, due to the aftermath of Hurricane Sandy), and we'll be putting this onto all of our users' machines. Anyway, after installing it I expected the installation routine to prompt me to define an instance of SQL Server 2008 R2 Express, either the default instance or a named instance. It didn't, so I closed the installer. Now when I bring up SSMSE, and it wants to connect to an instance, there isn't one on his machine. So, how do I create a named instance?

Kindest Regards,Rod
Connect with me on LinkedIn.
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23489 Visits: 9730
When it installs, there's an option for the instance name. The installer defaults to SQLEXPRESS or some variation on that (it's been a few months since I installed 2008). It very definitely is in the installation wizard.

I think it might skip that step if you pick a default option earlier in the wizard, but I wouldn't swear to that.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2759 Visits: 2064
Great, then I must have missed it. OK, so how do I now add a named instance?

Kindest Regards,Rod
Connect with me on LinkedIn.
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23489 Visits: 9730
Run the installer again. It'll ask if you want to add a new instance or modify an existing one, when you get to the right step.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2759 Visits: 2064
I've run the installer again. It gets to the Feature Selection page, and there I'm stopped.



As you can (I hope) see, the features are all selected, and disabled. When I try clicking on the Next button it complains because I've not selected anything. But it tells me that everything is selected. I'm confused; either it's all selected and installed and I can go on, but it won't let me.

Addendum: OK, I tried to put a link to a picture I captured of the dialog box, first on SkyDrive and then on Flickr, but in each case it fails. I don't know why, but it does. So, here's the URL, sorry, you'll have to copy-and-paste into your browser's address bar.

https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

Kindest Regards,Rod
Connect with me on LinkedIn.
paul.knibbs
paul.knibbs
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2541 Visits: 6232
That's only showing the client tools--there should be a section in there for the database engine as well. Are you sure this isn't just the Management Studio Express installer you're running, rather than the full database with advanced services installation? (I think the latter is a little over 700Mb, to give you an idea how big the installer should be).

(Full installer is available here, FYI: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=25174)
Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2759 Visits: 2064
Good question, Paul. I think I may have gotten the wrong download. I just checked and the name of the download is SQLManagementStudio_x86_ENU.exe, and it's about 156MB in size. I thought I was getting what I needed; I want the SQL Express engine and a management tool. The Advanced looked like it came with the SDK, which I thought wouldn't hurt. Perhaps I have gotten the wrong download, I'll take a look at the link you provided.

Kindest Regards,Rod
Connect with me on LinkedIn.
Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2759 Visits: 2064
Well, Paul, that was it. I had only downloaded and installed Management Studio Express. Man, I feel so stupid. I'm sorry everyone, my bad.

Kindest Regards,Rod
Connect with me on LinkedIn.
paul.knibbs
paul.knibbs
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2541 Visits: 6232
No problem.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search