+ Post New Thread
Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 49
Enterprise Software Thread, Whos using SCCM? in Technical; I have heard whispers that it's going to be launched at the MMS 2012 , if ture during April....
  1. #31
    djwingfield's Avatar
    Join Date
    Mar 2010
    Posts
    33
    Thank Post
    7
    Thanked 10 Times in 10 Posts
    Rep Power
    10
    I have heard whispers that it's going to be launched at the MMS 2012, if ture during April.

  2. #32

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    does sccm need the sql server on the same box? im wondering if the install problems im having are due to me trying to use a seperate sql server ?

  3. #33

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    @RabbieBurns - No the SQL Server can be on any box, just make sure that the remote SQL Server is configured to allow remote connections as this is what usually causes people the most headache's...

  4. Thanks to Gatt from:

    RabbieBurns (25th March 2012)

  5. #34
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,128
    Thank Post
    543
    Thanked 152 Times in 138 Posts
    Blog Entries
    78
    Rep Power
    79
    SQL can be hosted anywhere - Ive been running it against a cluster since install. On the 2012 front, can also substantiate the rumourings about MMS... there is lots and lots of talk about it.

  6. Thanks to TheScarfedOne from:

    RabbieBurns (25th March 2012)

  7. #35

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    Ok then I guess I am stuffing something up with my SQL install

    Are you using SQL 2008R2 or 2008?

    Are there any changes I need to make to the SQL install process that differ from the default?

  8. #36

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    Not sure if it works with 2008 R2, if using 2008 it needs to be at least SP2 and I think it needs a specific CU..
    No change to the default install AFAIK, but as I said, you need to run the SQL Configuration tool or whatever its called to allow remote access from the SCCM Server

  9. Thanks to Gatt from:

    RabbieBurns (25th March 2012)

  10. #37

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    Quote Originally Posted by Gatt View Post
    Not sure if it works with 2008 R2, if using 2008 it needs to be at least SP2 and I think it needs a specific CU..
    No change to the default install AFAIK, but as I said, you need to run the SQL Configuration tool or whatever its called to allow remote access from the SCCM Server
    yeh the RC says it works with R2. So its not just a case of opening the ports? What do i need to do within the configuration tool please?

  11. #38

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    This might help -> How to enable remote connections in SQL Server 2008? - <dw:daniel_walzenbach runat="server" /> - Site Home - MSDN Blogs

    (Sory I've been saying Remote Access, but its Remote Connections!)

  12. #39

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    thanks ill check it out. But thinking about it I was able to use the same SQL server to install SCVMM to wouldnt that require remote connections ?

  13. #40

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    yup as I thought, it was already enabled

  14. #41

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    What errors you getting?
    Are all the relevant firewall ports are opened?

    Also found this - How to Install Configuration Manager Using a Remote SQL Server

    It's for SQL 2005, but it may still be useful for 2008 upwards.

  15. #42

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    Ive just created a new SQL instance on the SQL server using the default instance this time, and it seems to be letting me continue. Previously I was using a named instance.

    Ill let you know how it goes tomorrow. Cheers.

  16. #43

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    OK, install is going fine against the default instance I created. I hadnt read anywhere that it wouldnt work with a named instance but Im guessing that was my problems all along.

    Also, with the default install the collation was wrong I had to use this command to fix it:

    Code:
    Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer /SQLSYSADMINACCOUNTS=rabbieburns /SAPWD=supersecretpass /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

  17. #44

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    Is this for SCCM 2007 or 2012? I know SCCM 2012 is very picky about the SQL collation type, but didn't think 2007 was?

  18. #45

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,841
    Thank Post
    569
    Thanked 994 Times in 766 Posts
    Blog Entries
    15
    Rep Power
    460
    That's the fix you need to apply (or set it during installation) to get SQL 2008 R2 working with SCCM 2012. Shouldn't have any issue further from that.

SHARE:
+ Post New Thread
Page 3 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. Sooo... who's using SCCM 2012
    By gshaw in forum Enterprise Software
    Replies: 14
    Last Post: 18th January 2012, 04:13 PM
  2. [MS Office - 2010] Deploying Office 2010 using SCCM
    By 10101010 in forum Office Software
    Replies: 1
    Last Post: 12th January 2011, 12:18 PM
  3. Whos using what broadband?
    By stevef1 in forum Internet Related/Filtering/Firewall
    Replies: 1
    Last Post: 26th November 2010, 09:41 AM
  4. Anyone who uses EMBC notice issues with google images not showing up correctly?
    By Sam_Brown in forum Internet Related/Filtering/Firewall
    Replies: 15
    Last Post: 19th October 2010, 02:20 PM
  5. [SCCM 2007] Do you use SCCM to deploy Windows 7?
    By Ric_ in forum O/S Deployment
    Replies: 11
    Last Post: 23rd March 2010, 02:18 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •