myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


           



Anybody know how to create a new SQL instance?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Anybody know how to create a new SQL instance? Page: [1]
Login
Message << Older Topic   Newer Topic >>
Anybody know how to create a new SQL instance? - 4/24/2008 3:39:36 AM   
iburnell


Posts: 239
Score: 1
Joined: 5/14/2003
From: London, UK
Status: offline 		The MS best practice states that if installing WSUS on the same server as SCCM its better to put it into a separate SQL instance. Not a great expert on SQL 2005 - just wondered if anybody has done this?. From a few googles looks like you have to go through the SQL setup all over again

Thanks

_____________________________

Ian Burnell
London UK
Post #: 1
RE: Anybody know how to create a new SQL instance? - 4/24/2008 9:02:33 AM   
aparrott

 

Posts: 23
Score: 3
Joined: 12/1/2005
Status: offline 		You are on target.  You need to re-run SQL setup and on the step where it asks you to select an Instance click the radio button for 'Named Instance'..

To connect to this instance (rather than default instance) you need to use [ServerName]\[InstanceName] in the SQL Mgmt Studio connection dialog. 

(in reply to iburnell)
Post #: 2
RE: Anybody know how to create a new SQL instance? - 4/24/2008 3:09:16 PM   
iburnell


Posts: 239
Score: 1
Joined: 5/14/2003
From: London, UK
Status: offline 		Thanks - I reran setup in VM ti test and created second instance. I was sort of hoping there might be a slightly shorter way but its no real big deal. So if setting up a brand new SQL 2005 install I presume I have to run setup twice - once for the default instance for SMS and then rerun to create new one

Thanks for tip about connecting to it in Mgmt studio - wasn't aware of that

_____________________________

Ian Burnell
London UK

(in reply to aparrott)
Post #: 3
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Anybody know how to create a new SQL instance? Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.203