Re: Is it possible to logon to SQL Server as a different Windows user?

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 10/27/04 

Date: Tue, 26 Oct 2004 23:58:41 -0400

fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.

If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop. 

-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • Re: User ASPNET in SQL Server 2000
    ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: User ASPNET in SQL Server 2000
    ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON.
    ... >I got the following error when try to connect with a SQL Server in Windows ... I am accessing the database by using my PWS on my ... PWS must be using the NT AUTHORITY\ANONYMOUS LOGON account to get to ...
    (microsoft.public.sqlserver.security)
  • Is it possible to logon to SQL Server as a different Windows user?
    ... I'd like to stay logged on to windows as myself, a network user, but ... windows user who has an account on SQL Server with more privileges. ... I want to keep that open but logon to SQL Server as network user ...
    (microsoft.public.sqlserver.server)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
Quantcast