Jump to content


Search the Community

Showing results for tags 'sql'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Cloud
    • Azure
    • Microsoft Intune
    • Office 365
  • General Stuff
    • General Chat
    • Events
    • Site News
    • Windows News
    • Suggestion box
    • Jobs
  • MDT, SMS, SCCM, Current Branch &Technical Preview
    • How do I ?
    • Microsoft Deployment Toolkit (MDT)
    • Official Forum Supporters
    • SMS 2003
    • Configuration Manager 2007
    • Configuration Manager 2012
    • System Center Configuration Manager (Current Branch)
    • Packaging
    • scripting
    • Endpoint Protection
  • Windows Client
    • how do I ?
    • Windows 10
    • Windows 8
    • Windows 7
    • Windows Vista
    • Windows XP
    • windows screenshots
  • Windows Server
    • Active Directory
    • Microsoft SQL Server
    • System Center Operations Manager
    • KMS
    • Windows Deployment Services
    • NAP
    • Failover Clustering
    • PKI
    • Windows Server 2008
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Hyper V
    • Exchange
    • IIS/apache/web server
    • System Center Data Protection Manager
    • System Center Service Manager
    • System Center App Controller
    • System Center Virtual Machine Manager
    • System Center Orchestrator
    • Lync
    • Application Virtualization
    • Sharepoint
    • WSUS

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 53 results

  1. Hello, I have a problem installing SCCM 2012 on the SQL 2008 R2 cluster. When it goes through the prerequisites, and I specify my SQL server, it connects fine, but when it comes to creating the database on the server it fails, saying that it can’t connect to the server. I tried a different approach and installed a local copy of SQL 2008 R2. SCCM installed fine. I moved the database to the SQL cluster, tried to re-point to use cluster and it failed again. Here is some log from the attempt to re-point to cluster: INFO: SQL Connection succeeded. Connection: clustername.domain MASTER, Type: Unsecure $$<Configuration Manager Setup><04-27-2012 10:32:34.107-60><thread=4056 (0xFD8)> INFO: SQL Server clustername.domain is clustered. $$<Configuration Manager Setup><04-27-2012 10:32:34.193-60><thread=4056 (0xFD8)> *** [08001][-2146893022][Microsoft] SSL Provider: The target principal name is incorrect.~~ $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)>*** [08001][-2146893022][Microsoft][sql Server Native Client 10.0]Client unable to establish connection $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)> *** Failed to connect to the SQL Server. $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)> INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)> I tried to connect using the ODBC connection, name resolution and it was ok. Then I tried to use IP address instead of the name and I also used domain admin account and the same result. I would appreciate your help.
  2. Hi there, WQL and SQL totally escapes me so I was wondering if someone could help. I'm after creating a report that will show users that have logged on to multiple machines and also list these machines... My Project manager asked spcifically for a report that displays users that have (in their possession) both a desktop and a laptop but I'm guessing my method would be easier. I believe you can also report on the primary user depending on the % of time a user has been logged on to a machine - maybe this could help narrow the results down further?? Hope someone can help - or at least understand my request ) Chris.
  3. I'm trying to plan for SCCM 2012 and I'm curious if anyone has a good idea what I can expect for SQL database growth? Or put another way, tools or other methods available to help me scale out the database server? I'm guessing around 4,000-5,000 clients will be reporting in to this system. Any help or direction would be greatly appreciated! Regards, Ben
×
×
  • Create New...