dbTalk Databases Forums  

How can you connect to SQL 2005 with Windows authentication, but different credentials than your current login?

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss How can you connect to SQL 2005 with Windows authentication, but different credentials than your current login? in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Paul Shapiro
 
Posts: n/a

Default How can you connect to SQL 2005 with Windows authentication, but different credentials than your current login? - 02-24-2008 , 04:35 PM






Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?


Reply With Quote
  #2  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM






One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #3  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #4  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #5  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #6  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #7  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #8  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #9  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
  #10  
Old   
Linchi Shea
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 02-24-2008 , 09:46 PM



One way is to establish an authenticated session first by using net use. Am
example follows:

cmd>net use \\aDomainMachineName\$ipc /useromainName\DomainAccount Password

Once this is established, you can then use Windows authentication in the
security context of the above domain account.

Linchi

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.