How to recover SA password on Microsoft SQL Server 2008 R2

http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/ create a new user. Enter following commands CREATE LOGIN recovery WITH PASSWORD = ‘TopSecret 1′ Go grant the user a SYSADMIN roles using the same SQLCMD window. sp_addsrvrolemember ‘recovery’, ‘sysadmin’ go

SQL Error 924 Database Single User mode change to Multi Users mode

exec sp_lock --- find the spid by dbid with lockType X Kill spid ----- kill the Spid exec sp_who --- find the Spid Kill spid ----- kill the Spid again ALTER DATABASE EmailXtender Set MULTI_USER

Check and Change isolation level of SQL Database

ALTER DATABASE EFORMSDEV_LC SET READ_COMMITTED_SNAPSHOT ON GO ALTER DATABASE EFORMSDEV_LC_PM SET READ_COMMITTED_SNAPSHOT ON GO SELECT name, snapshot_isolation_state_desc, is_read_committed_snapshot_on FROM sys.databases

open firewall ports on Windows 2008 R2 for SQL Server 2008 R2

@echo ========= SQL Server Ports =================== @echo Enabling SQLServer default instance port 1433 netsh firewall set portopening TCP 1433 "SQLServer" @echo Enabling Dedicated Admin Connection port 1434 netsh firewall set portopening TCP 1434 "SQL Admin Connection" @echo Enabling conventional SQL Server Service Broker port 4022 netsh firewall set portopening TCP 4022 "SQL Service Broker" @echo Enabling Transact-SQL Debugger/RPC port 135 netsh firewall set portopening TCP 135 "SQL Debugger/RPC" @echo ========= Analysis Services Ports ============== @echo Enabling SSAS Default Instance port 2383 netsh firewall set portopening TCP 2383 "Analysis Services" @echo Enabling SQL Server Browser Service port 2382 netsh firewall set portopening TCP 2382 "SQL Browser" @echo ========= Misc Applications ============== @echo Enabling HTTP port 80 netsh firewall set portopening TCP 80 "HTTP" @echo Enabling SSL port 443 netsh firewall set portopening TCP 443 "SSL" @echo Enabling port for SQL Server Browser Service's 'Browse' Button netsh firewall set portopening UDP 1434 "SQL Browser" @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK) netsh firewall set multicastbroadcastresponse ENABLE

Update existing user mapping after restoring database

EXEC sp_change_users_login 'update_one', 'abc', 'abc'

SQL Server 2008 R2 version with Sp

SQL Server 2008 R2 : 10.50.1600.1 With SP1: 10.50.2500.0

Windows Service Error

0x1395 The cluster group could not be found.