How to Recover the SA Password (Part 2)

February 2, 2016

Even though I have already published the article about the sa password recovery, this Part 2 adds some interesting stuff. This time everything is done via command line interface

Read the rest of this entry »


IIS-SQL application does not work on Windows 2008 R2

September 22, 2012

We have recently migrated one of our IIS applications with SQL database on background from Windows 2003 to Windows 2008 R2. And it stopped talking to database. Same ports opened, same ODBC connector created, but no data in any fields in web application

Read the rest of this entry »


How to Truncate a SQL DB Log File

July 9, 2011

Since I’m not a DBA, I do not remember it by heart

use master
go
dump transaction <database_name> with truncate_only
go
dbcc shrinkdatabase(<database_name>, 10)
go


“RequireKerberos” Error During the SQL 2008 Installation on Windows 2008 Cluster

October 28, 2010

During the SQL Server 2008 installation on Windows 2008 Cluster the following error occurs:

There was an error setting private property ‘RequireKerberos’ to value ‘1’ for resource ‘SQL Network Name (SQL-SERVER-NAME)’.  Error: Value does not fall within the expected range.

Read the rest of this entry »


How to Recover the SA Password

July 16, 2010

SQL Server 2000

  1. Login to Server using Local Administrator user
  2. Login to Query Analyzer using Windows Authentication.
  3. Use this procedure to change the SA password:sp_password null,’newpassword’,sa Read the rest of this entry »