Category Archives: SQL Server Configuration

Availability Group Listeners Creation Issue

I must admit, that I was facing this issue since a while. I was trying to setup a lab to have a hands on with AlwaysOn feature; however the Availability Group Listeners creation was failing. As I started looking into … Continue reading

Posted in AlwaysOn, How To, Just Learned, Setup LAB, SQL Server, SQL Server Configuration, SQL Server HA, SQL2012, TestLab | Tagged , , , , , , | Leave a comment

Unable to start SQL Server after relocating TempDB

After I modified the file size of tempdb database yesterday on my SQL Express instance, SQL Server was failed to start. When I checked the SQL Server error log, following entries were recorded. 2012-11-07 11:25:34.99 spid10s Error: 17053, Severity: 16, … Continue reading

Posted in How To, Just Learned, SQL Server, SQL Server Configuration, SQLCMD | Tagged , , , | 7 Comments

How to enable FILESTREAM features after installing SQL Server 2008?

It is possible to enable FILESTREAM after the SQL Server 2008 installation. Open the SQL Server Configuration Manager and select SQL Server Services. Right-click on the SQL Server Service, SQL Server (MSSQLSERVER), and select Properties from the available drop-down menu. … Continue reading

Posted in SQL Server Configuration | 1 Comment