Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Enter Windows Authentication on connect?

Author  Topic 

jakobt
Starting Member

5 Posts

Posted - 2007-11-30 : 04:07:20
I'm trying to connect to a database using my virtual machine, where I´m logged in as another user than the one that's granted acccess to the database. Can I enter the windows username and password used to connect to my SQL 2005 database, in Windows Authentication Mode?

Jakob

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-30 : 04:13:44
No, but when you launch SQL Management Console, you can do a run as..
Go to Top of Page

jakobt
Starting Member

5 Posts

Posted - 2007-11-30 : 04:32:48
How do I do that? Can't seem to find it...
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-30 : 04:55:55
Right click on Management Studio icon in windows, second option down is run as.
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-11-30 : 08:04:50
also in 2005 you can use EXECUTE AS to execute scripts as a different login as long as your current login has rights to EXECUTE AS.

http://msdn2.microsoft.com/en-us/library/ms181362.aspx


elsasoft.org
Go to Top of Page
   

- Advertisement -