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+00:00 November 22nd, 2016|Configuration Manager (SCCM), SQL|0 Comments

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: http://blog.ctglobalservices.com/kea/win-pe-peer-caching-in-configmgr-current-branch/ Client install failing on management point: http://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+00:00 May 17th, 2016|Configuration Manager (SCCM), Events, SQL|0 Comments

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 [...]

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+00:00 May 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+00:00 February 27th, 2009|SQL|Comments Off on 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+00:00 February 10th, 2009|SQL|0 Comments