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.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-05-23 : 13:13:45
|
| Is there a way to use Linked Server and have the user be NT.For Remote login.I have a NT Group which has user1, user2 in here. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-23 : 13:19:00
|
| I've never been able to get Windows authentication to work over a linked server. I always have to use SQL authentication.Here's the error I get with Windows authentication:Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-23 : 14:34:00
|
| It works with windows also but security account delegation has to be established between servers.We also use SQL login which is easy to setup. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-23 : 14:39:50
|
| sodeep, how do you setup "security account delegation"? Is it done at the Active Directory level or in SQL Server?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-23 : 15:02:35
|
| Yes, with Active Directory Level and not really secure way to do it.For info:http://msdn.microsoft.com/en-us/library/ms189580.aspx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-23 : 15:11:30
|
Thank you! I have no access to Active Directory and the people who admin it I'm sure would not make these changes for me.  I'll stick with SQL authentication.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-05-23 : 15:57:53
|
| I have the NT accounts set up on both servers Example in ad have GROUP called ADGROUP and user TRACEY comes in they will be DOMAIN\TRACEY - is there a way to use the NTGROUP within SQL as the linked settings otherwise i have to set up all the users within SQL which i did not want to do just the one GROUP |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-23 : 22:56:42
|
| I never get windows account work in linked server either. Why do you try it and let ue know the result? |
|
|
|
|
|
|
Linked server with NT