SQL 2005

[Taggs]

Hi,

Does anybody know of a way of forcing the -E switch at startup of SQL Server Management tools? Or Opening the database component as default (rather than SQL query).

I'm trying to publish SQL client tools through citrix but I want to force the login to be the authenticated user. I have put the -E switch on the application startup but when I try to open the database it asks me to log on again. (Where I can switch the user to an sql user, which i dont want the users to be able to do)

I did find this to open the component but it didn't work

Cheers

Taggs

Edited January 29, 2008 by Taggs

[neo]

I have not tested myself...but You can try

Open Registry Editor

Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

Change to data of DWORD value LoginMode 2 to 1