In SQL Server 2005 there is no native auto logon to automatically logon however you can create a taskbar or desktop shortcut and pass the trusted connection command line switch as well as the SQL server name and database name which will accomplish the same thing as an auto logon would.
1. Create a new shortcut and add the following to the text box asking you to “Type the location of the item:” and then select “Next”:
SqlWb -E -S ServerName -d DatabaseName
Example:
SqlWb -E -S MySqlServer -d SMS_XXX
2. At the Select a Title for the Program dialog box in the text box asking you to “Type a name for this shortcut enter your SQL Server name or the Database name and select “Finish”
Tip: To change the default icon for the shortcut right mouse click on the icon and from the context menu select “Properties”. Then at the bottom of the dialog box select “Change Icon” and browse for a new icon using the default SqlWb.exe or browse to the %SystemRoot%\system32\SHELL32.dll and select one.
No Comments