Sign in
 
HomeLibraryLearnDownloadsSupportForums
Resources for IT Professionals > System Center Configuration Manager Forums > Configuration Manager General > SCCM 2007 No ODBC anymore?
Ask a questionAsk a question
Search Forums:
 

AnswerSCCM 2007 No ODBC anymore?

  • Thursday, October 29, 2009 2:48 PMalex.fischer Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi,

    please excuse this question: is there no ODBC configuration anymore on SCCM Site Server like it was in former versions? And if: how's the connectio to SQL DB handled with SCCM 2007?

    Thanks in advance for any reply.

    Alex
     

Answers

All Replies

  • Thursday, October 29, 2009 4:31 PMKent Agerlund Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi,

    No, you don't need to manually configure any ODBC connection when configuring SQL and ConfigMgr.
    Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products
     
  • Thursday, October 29, 2009 8:44 PMalex.fischer Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi Kent,

    so that means that there's no chance to change the SQL Server communication port if needed?

    Regards

    Alex
     
  • Friday, October 30, 2009 1:26 PMJason SandysMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    There is a system DSN set up for communication between the SMS Provider and the SQL Server; however, port numbers for SQL server are discoverable by SQL clients using the SQL browser service on the SQL server: http://msdn.microsoft.com/en-us/library/ms165724(SQL.90).aspx.
    Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
     
  • Monday, November 09, 2009 9:16 AMEric Zhang - MSFTMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’ as the previous steps should be helpful for many similar scenarios.

    If the issue still persists and you want to return to this question, please reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.

    In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.

    Thanks!