+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
Enterprise Software Thread, SCCM 2012 failing pre-req check (SQL Perms) in Technical; Im trying to have a play with SCCM 2012 and I cant seem to get past the pre requesite check ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199

    SCCM 2012 failing pre-req check (SQL Perms)

    Im trying to have a play with SCCM 2012 and I cant seem to get past the pre requesite check (see attached)

    Ive added the sccm2012 machine account to the administrators group on the SQL server, Ive disabled all firewalls to make sure its not a port thing, cant really find any other info on what I should be doing..

    sqlfail.PNG

  2. #2


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    8,914
    Thank Post
    226
    Thanked 2,676 Times in 1,973 Posts
    Rep Power
    787

  3. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    Nope, using SQL Server 2008 R2 SP1 with CU4

    Supported Configurations for Configuration Manager

  4. #4


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    8,914
    Thank Post
    226
    Thanked 2,676 Times in 1,973 Posts
    Rep Power
    787
    I thought you might be using the latest version of SQL but wasn't sure.

    Are there any things listed in this guide which you may have missed?

  5. #5

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    Thats the guide I followed actually. I'm pretty sure I followed it precisely but Ill double check, one thing though I'm not sure about the bit that says about SQL_Latin1_General_CP1_CI_AS collation.

    The SQL Collation is one of the checks that fails. How do I check the SQL server is using SQL_Latin1_General_CP1_CI_AS collation ?

  6. #6

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    Also my SQL is on a separate server not sure if that makes a difference?

  7. #7


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    8,914
    Thank Post
    226
    Thanked 2,676 Times in 1,973 Posts
    Rep Power
    787
    Quote Originally Posted by RabbieBurns View Post
    How do I check the SQL server is using SQL_Latin1_General_CP1_CI_AS collation?
    One way to check the collation would be to use this PowerShell script. To change it, try the script shown here (I haven't tried it myself though).

  8. Thanks to Arthur from:

    RabbieBurns (28th February 2012)

  9. #8

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    the script to change it only seems to change an existing db not the actual server.

    Ive also tried the method here Setting and Changing the Server Collation

    This is the output of the check script, is this the wrong one? collatio.PNG

    I might have to uninstall and reinstall SQL I guess. Where abouts is the collation stuff in the setup steps I dont seem to remember it.

  10. #9

    Join Date
    Dec 2007
    Posts
    867
    Thank Post
    90
    Thanked 165 Times in 140 Posts
    Rep Power
    49
    Apologies in advance if this is duff information, but i thought that I had come across SQL_Latin1_General_CP1_CI_AS before.

    Just looked through my book Migrating to Windows 7 using MDT 2010 Lite Touch and WDS and it's mentioned in relation to the MAPS Database installation for MDT.

    Within SQL Server Installation Centre, select Service Accounts Tab

    {numerous steps for new setting up new database, and after you've completed the Instance Root Directory and Disk Space Requirements} sections

    On the Collation Tab; Make sure that the Database Engine is set to SQL_Latin1_General_CP1_CI_AS

    Hope this helps is some way (still learning it myself! MDT 2010 that is)
    Last edited by MYK-IT; 28th February 2012 at 08:34 AM.

  11. Thanks to MYK-IT from:

    RabbieBurns (28th February 2012)

  12. #10

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    Thanks.. I guess Ill just blow away this SQL server and re-install.

  13. #11

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    although Im assuming this will only fix the Collation error in my first post, I guess I should try to fix the other 2 as well before I go reinstalling.

  14. #12

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    right reinstalled SQl with the correct collation but it still fails the pre-req check (i think the pre-req check is looking for SQL on the local server)

    So Im trying to install it anyway and specify the remote server, but its failling when trying to connect to the SQL DB:

    Code:
     Exception message: [A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)], Exception details: [System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

  15. #13

    Join Date
    Apr 2006
    Posts
    389
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    Worth taking the setup app out of the equation? Try setting up an ODBC alias to the SQL Server using the credentials you're plugging into the setup, show you whether you can connect to the database server in the first place.

  16. #14

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    I used the same SQL server to install SCVMM 2012 and SCOM 2012 no problem so the database and the credntials seem to be working OK..

  17. #15

    Join Date
    Feb 2013
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I have the semilar problem with the one with i reinstall SQL 2008 R2 just to change collation from "Latin1_general_CI_AS" to "SQL_Latin1_general_CP1_CI_AS" and after reinstall is still have that error that i dont have "SQL_Latin1_general_CP1_CI_AS" here are two pic one of is from SQL and one from SCCM install

    my question if my SQL is SQL_Latin1_general_CP1_CI_AS how come is error under installation of SCCM 2012 ?-)

    SCCM error.PNGSQL now.PNG

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. SCCM 2012
    By synaesthesia in forum Network and Classroom Management
    Replies: 12
    Last Post: 9th July 2012, 02:09 PM
  2. SCCM 2012 RC
    By synaesthesia in forum Network and Classroom Management
    Replies: 6
    Last Post: 26th January 2012, 06:52 PM
  3. sccm 2012
    By irsprint84 in forum Enterprise Software
    Replies: 11
    Last Post: 13th June 2011, 01:37 PM
  4. Anyone got an idea of the release date for SCCM 2012?
    By pete in forum Enterprise Software
    Replies: 1
    Last Post: 7th June 2011, 01:17 PM
  5. Replies: 2
    Last Post: 6th June 2007, 10:46 AM

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
  •