Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do I configure a named instance in SQL EXPRESS 2008 R2? Expand / Collapse
Author
Message
Posted Wednesday, October 31, 2012 11:39 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 20, 2014 8:23 AM
Points: 738, Visits: 1,305
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.
Post #1379466
Posted Wednesday, October 31, 2012 12:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1379483
Posted Wednesday, October 31, 2012 2:15 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 20, 2014 8:23 AM
Points: 738, Visits: 1,305
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.
Post #1379523
Posted Thursday, November 1, 2012 6:11 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1379769
Posted Thursday, November 1, 2012 10:06 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 20, 2014 8:23 AM
Points: 738, Visits: 1,305
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.

http://www.flickr.com/photos/26351522@N04/8145228213/


Kindest Regards,

Rod
Connect with me on LinkedIn.
Post #1379911
Posted Friday, November 2, 2012 5:40 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:12 AM
Points: 1,610, Visits: 5,482
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)
Post #1380292
Posted Friday, November 2, 2012 9:22 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 20, 2014 8:23 AM
Points: 738, Visits: 1,305
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.
Post #1380444
Posted Friday, November 2, 2012 10:30 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 20, 2014 8:23 AM
Points: 738, Visits: 1,305
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.
Post #1380499
Posted Friday, November 2, 2012 10:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:12 AM
Points: 1,610, Visits: 5,482
No problem.
Post #1380500
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse