SQL Stuff

Shrink log files

Reset sa password

From command prompt

osql -L

Copy full name of SQL Server and type:

OSQL -S <insert_servername_here> -E

Execute the following query:

sp_password NULL, '<insert_new_password_here>', 'sa'
GO

From SQL Management Studio

Using SQL Password Recovery Tool

When You Have SA Disabled

Set RAM limits to internal SBS database

Error: SQL Server does not exist or access denied.

What tripped me up was that I was working with a non-default instance (original one was disabled). Apparently, the non-default instance gets a random port generated for it. Also, the port doesn’t seem to show itself anywhere in the SQL management tools.

The port was found here:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQLServer\SuperSocketNetLib\Tcp\IPAll

categories · links · piano · posts · scripts · THEAARBS · home