SQL
-
Windows Server 2012 Failover Cluster SQL 2012 SSL configuration
A project recently had me working on Windows Server 2012 Failover Cluster SQL 2012 SSL configuration for an international company who had recently provisioned this new Windows cluster to replace an aging cluster already in place. There are a lot of…
-
SQL Server local SQL authentication error logged in locally
Guys, so I have run into a really weird situation with a development SQL Server local SQL authentication error logged in locally. Local SQL authentication succeeds if you login remotely via SQL Server Management Studio. However, using SSMS, the login…
-
SQL 2014 Setup there was an error generating XML document
A couple of days ago, a fellow colleague was setting up a VM with SQL and then Microsoft Dynamics or that was the plan. The VM was relatively clean with only Windows updates installed, AV, and a couple of small…
-
SQL Windows Authentication can’t login to SSMS locally
Recently, a client was experiencing a really weird issue where they could connect to a recently built SQL server using SQL Server Management Studio loaded on remote workstations, however, they could not login to the console of the server or…
-
How to find the SSRS Job Name with the Report Name SQL
In order to check the status of the SSRS report subscription jobs, status, and the last run time, run the following SQL script against the MASTER DB. It will list: report id report name last status SELECT c .Name AS ReportName , rs . ScheduleID AS JOB_NAME , s . [Description]…
