Requirements Not Met ~ Program Rejected (wrong platform)…What Witchery is This?

Ran into a challenge yesterday that found me chasing apparitions into the SCCM DB and in the process, discovering some interesting insights into the fatal, Failed to download policy (Code 0x80004005) Task Sequence (TS) error. Besides being interesting as Hell, we also found a “clean” resolution that was not available through countless Goog searches.  As if all that was not enough, there is a quick lesson on using a SQL Search tool that I was completely unfamiliar with until good friend, Adam Gross (follow this cat on the Twit: @AdamGrossTX), hipped me to what all the cool kids were doing!  [...]

Error installing WSUS using a remote SQL and non-standard SQL port

Ran into this error earlier today while trying to install WSUS using a remote SQL 2014 SP2 server with non-standard SQL ports. 2016-11-22 20:30:13  Stopping service WSUSService 2016-11-22 20:30:13  Stopping service W3SVC 2016-11-22 20:30:13  Configuring database... 2016-11-22 20:30:13  Configuring the database... 2016-11-22 20:30:13  Establishing DB connection... 2016-11-22 20:31:14  System.Data.SqlClient.SqlException (0x80131904): 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 [...]

By |2017-08-22T10:29:40+01:00november 22nd, 2016|Configuration Manager (SCCM), SQL|Kommentarer lukket til Error installing WSUS using a remote SQL and non-standard SQL port

Links from our MMS ConfigMgr precon session

Thanks for all the questions and tweets during the opening session yesterday. Jason, Anne and I really enjoyed the afternoon. As promised here are the links from the session. Update 1605 for Configuration Manager Technical Preview: https://blogs.technet.microsoft.com/configmgrteam/2016/05/16/update-1605-for-configuration-manager-technical-preview-available-now/ winpe peer caching: https://blog.ctglobalservices.com/kea/win-pe-peer-caching-in-configmgr-current-branch/ Client install failing on management point: https://blog.ctglobalservices.com/kea/configmgr-client-failing-to-install-on-management-point/ Startup script: http://blog.configmgrftw.com/configmgr-client-startup-script/ SQL XL sheet: https://t.co/XUXuUfxuaq Cache management example: https://blogs.msdn.microsoft.com/helaw/2014/01/07/configuration-manager-cache-management/ SQL best practice: https://stevethompsonmvp.wordpress.com/2016/02/05/proper-tempdb-creation-for-configuration-manager/ & https://stevethompsonmvp.wordpress.com/2014/05/19/powershell-sql-audit-script/  

By |2017-08-22T10:28:42+01:00maj 17th, 2016|Configuration Manager (SCCM), Events, SQL|Kommentarer lukket til Links from our MMS ConfigMgr precon session

How to: Create custom SQL- based Reports in System Center 2012 R2: Configuration Manager

A customer asked me  for a “how-to” on how to Create reports in SCCM 2012, so why not share with everyone. This post is not intended to show how to write or design queries, but show you have to create  a report based on a SQL query you might already have. Even-though we are skipping how to write SQL Queries for know, this post is still going to be a bit long. Time for that cup of coffee! First some requirements: You need to have an SQL Server instance for SCCM with SQL Reporting Services running You need to have [...]

Troubleshooter note: SQL Installation fails with exitcode 0x84BB0001 on a ReFS formatted partition.

So I tried to install SQL the other day for a new ConfigMgr environment, but I kept getting an error during the first seconds of the installation with 0x84BB0001 as the exit code. With some quick investigation into the log files I found this%Temp%\SqlSetup_Local.log:C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt: Shows that the installation has difficulties installing on a ReFS formatted partitionDisk Manager Shows that D:\ is formatted with ReFS (I blame my PowerShell Script :)): Now the quick and easy way of fixing this is to reformat the partition to NTFS. And this is what I did in this case. But [...]

By |2015-10-11T19:05:00+01:00oktober 11th, 2015|Configuration Manager (SCCM), Scripting & Development, SQL|Kommentarer lukket til Troubleshooter note: SQL Installation fails with exitcode 0x84BB0001 on a ReFS formatted partition.

SCOM 2012 R2 and SQL Server 2014

**** This is not supported by Microsoft and should only be done in a Test Environment **** *** Not even in the staging environment – Please *** Some customers have asked me about the gain for using SQL 2014 in the SCOM environment – And I did some fast tests – In my test envronment (7 servers, NLB, 2 MS, 2 Web/Report) which shows that out-of-the-box it will actually be faster just to upgrade to SQL 2014. And both an Upgrade and New Install does work with SCOM 2012 R2. Configuration: Virtual Machine: 4 gb memory VHD on SSD drive [...]

By |2014-05-15T15:54:26+01:00maj 15th, 2014|Operations Manager (SCOM), SQL|2 Comments

Report Server Course

Links: http://msdn.microsoft.com/en-us/library/ms153561.aspx http://msdn.microsoft.com/en-us/library/ms156500.aspx http://www.developer.com/db/article.php/10920_3727626_2 http://msdn.microsoft.com/en-us/library/ms157406(sql.90).aspx http://blogs.msdn.com/bwelcker/archive/tags/Reporting+Services/default.aspx http://www.sql-server-performance.com/articles/reporting/index.aspx http://lyon-smith.org/blogs/code-o-rama/archive/2007/03/22/visual-studio-column-guides-redux.aspx http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en http://visualstudiomagazine.com/columns/article.aspx?editorialsid=1900 Husk Report Builder 2.0 Og her er koden i forbindelse med Report server kurset d 25. - 27 feb: Private Sub LoadInformation()   'load information into list view lstView.Items.Clear()  Dim myCatalogItems As CatalogItem()myCatalogItems = rs.ListChildren("/", True)  For Each cItem As CatalogItem In myCatalogItems  Dim strValues(3) As String strValues(0) = cItem.Name strValues(1) = cItem.Path strValues(2) = cItem.Type.ToString()strValues(3) = cItem.CreatedBy lstView.Items.Add(New ListViewItem(strValues))  Next End Sub Private Sub DisplayCurrentInfo()  Me.Cursor = Cursors.WaitCursor  'display item information in messagebox Dim item As ListViewItem = lstView.SelectedItems(0)  Dim strName As String = item.SubItems(0).Text  Dim strPath As String = [...]

By |2009-02-27T14:44:04+01:00februar 27th, 2009|SQL|Kommentarer lukket til Report Server Course

SQL 2005 Course

Samples, Utils and Links from MOC 2780 SQL 2005 Course. Check All Databases with undocumented stored procedure: EXEC SP_MSForEachDB @command1="Print '?' DBCC CHECKDB ('?')" Another track to the same station. Declare @db VarChar(100),  @dbid int,  @hidb int Select @hidb = Max(dbid ), @dbid = 0 from master..sysdatabases While @dbid < @hidb Begin    Set @db = null    Select @db = name    From sysdatabases    Where dbid = @dbid    if @db is not null       DBCC CheckDB( @db )    Set @dbid = @dbid + 1 End Reindex all tables in a database: EXEC sp_MSforeachtable @command1=“print ’?' DBCC DBREINDEX [...]

By |2009-02-10T10:01:21+01:00februar 10th, 2009|SQL|Kommentarer lukket til SQL 2005 Course