December 17, 2009 at 10:35 pm
After making the Security changes for linked server , do we need to restart sql server or what?
i dont think so but 🙁
December 17, 2009 at 10:56 pm
If its working on SQL but not on windows authentication then Please check the following.
> Have you added the windows account to the other SQL Server?
If yes check the next thing below
> Check SPN Registration and delegation settings are done for your account.
Refer these links
http://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspx
Regards,
Raj
December 17, 2009 at 11:27 pm
What does SPN stands for and how it is related to Linked Server?
December 17, 2009 at 11:35 pm
mahesh,
my understanding says, your "csd\jason" user must have equal rights on both the server. (according to ur settings db_owner on both the servers)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 18, 2009 at 12:51 am
Read the links provided.
@Bhuvanesh:
Rights need not be in sync. Rights good enough to execute the query on the remote server would do.
Example:
Select * from server2.dbname.dbo.table1
If I am executing this query from Server1 using acct1, then acct1
should have select rights on the table table1 on server2. It doesnt matter whether acct1 is a Sysadmin/dbowner on Server1 or not.
Regards,
Raj
December 18, 2009 at 8:52 am
You need to setup delegation in order to the server be able to pass the user's credentials to the another SQL Server.
SPN stands for "Service Principal Name".
Check this article:
Regards,
Jose Santiago Oyervides.
December 18, 2009 at 9:46 am
mahesh.vsp (12/17/2009)
What does SPN stands for and
SPN Stands for Server Principal Name
You can get more information for this given below link
http://msdn.microsoft.com/en-us/library/ms677949(VS.85).aspx
how it is related to Linked Server?
When Linked server is configured to make use of Delegated account, in this case the entire authorization happens through Kerbros, to do that SPN has to be configured. Once this is implemented then only delgated account works and this configuration has to be done at ActiveDirectory also on the server where linked server is configured. This configuration can be done only by domain administrators.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply