Not able to log into SQL Mgmt Studio? Not a problem.

I stumbled on this handy tip here.

Sometimes passwords fail to get documented properly.

If that’s the case, you can reset the appropriate account password or create a new db_owner by running SQL Mgmt Studio as SYSTEM via PsExec.

Once you have PsExec run with options -s and -i with the path to you Ssms execuatable:

PsExec -s -i “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe”

Sql Mgmt Studio then launches, then click ‘Connect’ to login as NT AUTHORITY\SYSTEM.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

<span>%d</span> bloggers like this: