Monday, February 9, 2015

Clearing remembered / default login for SQL Server Management Studio


Removing the remembered login and password list in SQL Management Studio

SQL Server Management Studio 2014 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin

SQL Server Management Studio 2012 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

SQL Server Management Studio 2008 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Or find SqlStudio.bin at C using window explorer and delete the file.

Replace SQL Server Profiler with ExpressProfiler (aka SqlExpress Profiler)

Download at https://expressprofiler.codeplex.com/

ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project.

Can be used with both Express and non-Express editions of SQL Server 2005/2008/2008r2/2012/2014 (including LocalDB)
Distribution package contains both standalone version of ExpressProfiler (can be used without installation) and installation package.


Make sure to grant the "Alter trace" permission to the selected user.