Jump to content

Search the Community

Showing results for tags 'sql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • 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


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







  1. Hi All, I was wondering if someone could give me some pointers to a HowTo Guide for SQL 2016 Always-On. I've been using a guide from sqlrx.com which has brought me to a point but it's not complete idiot proof obviously as I'm stuck.. I've created the AG - Availability Group and I've both servers in but I can't figure out what the Availability Group Listener is for I assume I need it.. Current status is the Always on AG is up I have a primary server green but my secondary as a red Arrow and my Availability Databases is green. I don't expect the solution to be handed to
  2. Following along in the documentation, I get to where I want to install the Reporting Services Point Role. Figure no big deal. In walking through the steps of role setup everything is great until I go to dropdown the selection for the Reporting Server Instance. It does not see the reporting server instance. In looking at the SQL server, I don't see reporting services listed in the Start Menu and I selected Reporting Services on the original install. I've even gone back into SQL setup to look and SQL setup shows it is installed. Anyone have an idea?
  3. Hello, We are just starting down the path of SCCM and building out a DEV environment. Will install 1702 then upgrade to 1710 and then possibly 1802. Looking at the Hardware and Server requirements wondering if anyone could shed any light into their builds. There are a number of posts out there talking about the (2) different install scenarios. Do more people install SQL locally on the Primary site server or do they install it on a remote server - which could be beneficially if you're looking at clustering your SQL environment. We're currently an Oracle shop which really doesn't help us ou
  4. Hi All, I hope you are well, Currently I have an issue I have unsuccessfully been battling with for a few days now. The original plan was to have the sccm db running on a sql high availability always on group setup. 1 x primary server 1 x sup server 1 x dp server 2 x sql servers when I tried to install SCCM initially, on the clustered sql, I was getting issues with listener admin rights / ports Excerpt from sccm install log --------------- CWmiRegistry::GetStr: Failed to get string value MSSQLSERVER Configuration Manager Setup 06/03/201
  5. I am in the process of upgrading our SCCM infrastructure from Svr2008R2 and SQL2008R2 to 2012R2 so I can upgrade to current branch. We are doing in-place upgrades, to 2012R2 on our Primary Site and also our separate DB server. Our DBA is going to start by upgrading our SQL version to 2014 on the box and they have asked the question where do these facets attached to the database come from and how are they generated, as the DBA plans on detaching backing up and re attaching the DB, they said these facets will not be carried over. Are these facets generated by SCCM and will they continue to ex
  6. Just a tip or something to be aware of. One of my admins pointed out they were running low on disk space on the drive where the SQL server was installed. Turns out that by default the ReportServer DB log file is set to grow to 2TB by default! Went into SSMS and changed the ReportServer DB to "simple" and then ran the "shrink" command on the log file of that DB. File went from 500+GB to 6MB. Changed to the maximum file size afterwards too so it doesn't happen again. Thought some of you might find this useful.
  7. Error with Database replication link after expanding primary standalone to CAS with primary. Replicator link analyzer says the sql server boker login is missing.
  8. I am trying to add a CAS to a stand along primary server and I get to the point where it is asking for the Path to the SQL Server data file and the Path to the SQL Server Log file, but doesn't proceed any further. If the SQL server is remote, does it still use a local C:\... path, and would it be the path on the remote server or local...SQL is installed as a default instance on another server called xwz. Won't go past screen shot below.
  9. Hi All. Long time lurker here but now is the first time I have been moved to create an account and ask for some advice. I’m looking for a bit of direction on how to proceed as I’m a bit stuck, I’d like to fix this without breaking anything else in SCCM. I’m running SCCM build 1606 – Last week we upgraded the SQL instance hosting all out SCCM databases from SQL 2008 SP3 to SQL 2014 (this because we plan to upgrade to SCCM 1702). The SQL upgrade wizard reported that it upgraded all components successfully to SQL 2014 but when I opened the SCCM console all the reports are missi
  10. Hello all, I've ran into a few issues with SCCM 2012 R2 SP1, I have a remote 2 node SQL cluster, essentially one of the nodes failed a few months ago so it's been online for a while, during this time the SCCM DB was moved to this cluster, today the 2nd node is now online so I was expecting that SCCM was install what it needed on this server, I am however running into issues with SCCM thinking that a drive of E:\ exists in the sitecomp.log however this drive does not exist on the node, is there anyway of changing the path? or will I need to reset my SQL configuration again from the setup?
  11. Hello, I'm new to SQL and I need help understanding the best approach to our current problem. I need to build a custom parameter-based report in Microsoft SQL Report Builder 3.0 where you select two or more collections as parameters. The report should then cross reference which computers exist in all selected collections and output their name it to the report. I have built a static query I can run against the SQL server directly, but we need to be able to dynamically select a collection for easier reporting purposes. This is the query I use: SELECT v_GS_SYSTEM.Name0 FROM v_GS_SYSTEM WHE
  12. As part of our companies SCCM 2012 design process, I'm tasked with attaining some network traffic modelling for a CAS design and a single Primary Site design. Scenario: 10,000 managed devices spread in over 22 locations globally 1x CAS 2x Primary Sites (5,000 devices per site) What would the estimated size of the databases be and the amount of network traffic (Primary "A" <-> CAS <-> Primary "B"). I've tried Googling for this information and couldn't find definitive numbers or even ball park numbers to do calculations. Any assistance is much appreciated.
  13. Hi all, I've my lab setup running under two servers (SCCM server and SQL server). I did this to keep the environment as equal as other environments where I work with. However, I need more space (hdd) and maybe this will also help me to gain some performance. I want to install the a new instance of SQL in the SCCM Server. Is this as simply as it should or it's a big challenge?! Steps that I think are necessary: - install same SQL version in SCCM server, same collation, reporting services; - remove reporting services roles - follow all these steps https://blogs.technet.micro
  14. Hi guys, Planning to upgrade our configmgr to 2012r2SP1 but first wanted to check with you what's the minimum supported SQL version, currently running 2008 R2 SP1 CU9, any help please? thanks, MW
  15. Hey everyone, especially Niall, thank you so much for this community. It's been a great help! I am standing up a new SCCM 2012 R2 server and am setting it up with the plan to deploy SUS updates from SCCM (currently using a standalone WSUS server in our environment). We are running the SQL server DB for SCCM on its own server, using the default instance. I have not installed the SUS role yet on the new SCCM server. My DBA is asking me if it's OK for the SCCM and WSUS databases to share the same instance. My instinct tells me I shouldn't, but the DBA says it that if it were possible, it wo
  16. Hello, I am trying to move the database from a SQL 2008 R2 cluster to SQL 2014 cluster. Our current set up is: Windows 2008 r2, SCCM 2012 (cu2 only, planing to upgrade to 2012 R2 as soon as DB is working), SQL 2008 r2 SP3. I took a backup of the DB on the old cluster, restored in the new one without any issues. I left the compatibility mode on 2008 - Schema 100. I run USE master; GO ALTER DATABASE CM_PR1 SET ENABLE_BROKER GO USE master; GO ALTER DATABASE CM_PR1 SET TRUSTWORTHY ON GO USE master; GO ALTER DATABASE CM_PR1 SET HONOR_BROKER_PRIORITY ON; GO Now, run the fo
  17. I am attempting to write a powershell script for our 2012 SP1 environment that well ask for the input of a package ID and it will prestage its dependencies all in separate pkgx files so it is easier to tell what has already been pre-staged. Each dependency will be named by package ID. I have the logic to get the dependencies, however I noticed something. If I go to prestage a file and check the box to include dependencies, it will list the superseded packages as well. If I try to distribute content, it will only list the dependencies. While researching superscedence and content
  18. Trying to connect Config Manager CAS Console to its SQL database and getting error (Screenshot 1). Also SMS_EXECUTIVE and other SMS Services could not Start (Screenshot 2). Getting one of the event error as - License Activation (slui.exe) failed with the following error code: hr=0x800705B4 I can connect to other Primary Site database from CAS Console. Domain Admins and Local Administrator have all the rights in DCOM permissions. I checked the forum and tried with other options but it didn't helped. Any suggestions please? SCCM Error 1.txt SCCM Error 2.txt SCCM Error 3.txt
  19. Hi Forum, Please help! Here's the story. When we had our SCCM installed it seems that some bright spark decided to put a trial version of SQL on the server its installed on. Last week the trial ran out and reporting stopped and then no one could connect via the consoles. Our apps team fixed this and we can now log into SCCM 2012 but we cannot build any machines via PXE. Any suggestions? I've checked the SMSPXE.log and see errors: Loaded D:\Program Files (x86)\Windows Kits\8.1\Assessment and Deployment Kit\Deployment Tools\amd64\DISM\wimgapi.dll SMSPXE 24/03/2015 10:36:17 8428
  20. Hello All, I'm looking for a query or report that will return the network information for all systems or all machines in a collection. Our environment unfortunately still uses wins and I need to see how many machines out in the wild might be missing their secondary wins server address. Google has proven fruitless. Thanks, Mike
  21. Hi All, environment: SCCM 2012R2 / SQL 2008R2 Could someone please advise re solving the problem? Just followed all the steps to apply CU4 for ConfigManager/SQL but when it comes to updating SQL i’m getting following errors: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure ‘k’. Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 41 Invalid column name ‘TransportType’. Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 46 Invalid column name ‘TransportType’. Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 4
  22. Hi All, I am currently managing a production SCCM R2 CU2 server with an SQL 2012 site database server and reporting services point and I have the Site System status for the SQL component server role listed as critical under System Status\Site Status. I suspect its a bug but I just want to get some confirmation. There are no errors or warnings going back weeks when view the "Messages" associated with it. I've also checked the sitestat and statesys logs and the ONLY errors I have are listed below: sitestat.log ---->: Unable to get the file system information for: \\DP1\E$\; error =
  23. I am looking for a query that finds all computers joined to the domain since XX date. I tried using the query below which looks back over the last week for new computers but this also discovers any computers that have been modified in the last 7 days. Does anyone have a query that is based on date created? select SMS_R_System.Name, SMS_R_System.CreationDate FROM SMS_R_System WHERE DateDiff(dd,SMS_R_System.CreationDate, GetDate ()) <= 7
  24. I installed the Reporting Services Point role on my sql2012 site system server. sccm is installed on my sccm primary site server. I set my network username under the reporting services point properties. My account is a full administrator on both servers. When I click on reports under reporting on the monitoring tab it waits for a while and comes back with no reports. I checked the smsadminui.log and get the following. [7, PID:4532][11/21/2014 08:23:44] :[ReportProxy] - User-specified default Reporting Point [sCCM.legislature.intranet] could not be found, [sql2014-SCCM.legislature.int
  25. Hi guys We have on our primary site a SCCM Server, which is installed on a Windows Server 2012 R2. On this server is Microsoft SQL Server 2012 with SP1 installed. We have also an secondary site. Which has installed the Microsoft SQL Express 2012 on it (without any Service Pack). When I want to upgrade the SQL Express on the secondary site to Service Pack 1, what should i pay attetion. What I already did is - I have downloaded the SQLEXPR_x64_ENU.exe on following url: http://www.microsoft.com/en-US/download/details.aspx?id=35579 My question is: How can I upgrade the SQL Express on t
  • Create New...