SQL
-
Backup Software
Nakivo Backup and Replication 7.2 Beta Announced New Features
Yet again exciting news from Nakivo today as they made an announcement concerning the Beta release of Nakivo Backup & Replication 7.2. It looks to include many new and highly anticipated features that have been eagerly anticipated in the product.…
-
SQL
SQL Cluster computer account could not be configured
In working on an older Microsoft SQL Cluster server configuration recently, I ran into an issue with a lab copy of the SQL Cluster not bringing the SQL resources online as expected. After rejoining the domain and sychronizing everything with…
-
SQL
Troubleshooting general SQL connectivity issues
There are quite a few things that an administrator may need to check when it comes to making sure connectivity to SQL is happy and healthy in your respective environments. ย As of late, I have put together a checklist of…
-
SQL
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
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…
-
Servers
SQL Server Firewall and performance tweaks
Everyone, I wanted to pass along a few Windows firewall tweaks that I have found useful with building a SQL server on Windows 2008 server or higher. ย The following simple tweaks can really help with issues you may see involving…
-
SQL
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]…