Change default windows login in Integrated Security

19 Feb 2007 1:22 PM

Nemo

Hi everybody!
I've a connection to a database using integrated security in order to
connect my app. with this db. but I want to use not the default
Windows Login, I want use another login (an Active Directory validated
login).

Do you know how change the default login for other in Integrated
Security connection in Sql Server 2000 - 2005??

Thanks in advance.

19 Feb 2007 6:10 PM

William (Bill) Vaughn

I discuss how to use "Run As" to impersonate another registered user in my
book. Basically, you create a shortcut that sets the run-as credentials.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"Nemo" <jorge.maga***@gmail.com> wrote in message
news:1171891379.378475.24250@m58g2000cwm.googlegroups.com...
> Hi everybody!
> I've a connection to a database using integrated security in order to
> connect my app. with this db. but I want to use not the default
> Windows Login, I want use another login (an Active Directory validated
> login).
>
> Do you know how change the default login for other in Integrated
> Security connection in Sql Server 2000 - 2005??
>
> Thanks in advance.
>

21 Feb 2007 7:32 AM

Nemo

I solved the problem and the aswer is "IMPERSONATION" the connection
with the user login in the app.