Prev: SQLView joining two fields
Next: ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!
From: John on 13 Jul 2010 08:08
hi,

I am having 2 logins from my domain. one is normal user and another one is
domain admin. domain admin is in ITAdmins group, which have SQL Connection as
sa to connect the SQL Instances.

I need to log in to my laptop always with normal user only (security
policy). I am using DOMAIN\Myname accout to connect to the SQL Instances.

please help me to where can I setup my account in my laptop, to store the
domain account connections and password with in it in secured locations, and
automatically connect to SQL Instances.

Thanks in advance.
From: Steen Schl�ter Persson on 14 Jul 2010 03:02
Hi,

You can run SSMS using RunAs. In this way you can define which account you
want it to run under.

The following shortcut will run a SQL2008 Management Studio -

C:\WINDOWS\system32\runas.exe /user:YourDomain\YourAccount "C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"


--
Regards
Steen Schl�ter Persson (DK)

"John" <John(a)discussions.microsoft.com> wrote in message
news:728A0C4E-3FF9-4261-8471-485122D131D9(a)microsoft.com...
> hi,
>
> I am having 2 logins from my domain. one is normal user and another one is
> domain admin. domain admin is in ITAdmins group, which have SQL Connection
> as
> sa to connect the SQL Instances.
>
> I need to log in to my laptop always with normal user only (security
> policy). I am using DOMAIN\Myname accout to connect to the SQL Instances.
>
> please help me to where can I setup my account in my laptop, to store the
> domain account connections and password with in it in secured locations,
> and
> automatically connect to SQL Instances.
>
> Thanks in advance.


 | 
Pages: 1
Prev: SQLView joining two fields
Next: ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!