So with the below:

I don't have to do a alter command for master this is taken care of by doing the

configration setting.

1.

....So i start by going to the configuration...

The thread seems rather confusing to me.........

Going to start with master first.

1.

....So i start by going to the configuration tool and set path from C: TO D:

-dD:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;

-eD:\Program...

I don't see your steps in the post ?

Yes i don't want to spend hours on it he he.....i got three instances of system db to move around to...

Hi i just need to move all system files from C to D

Is this Step 7

Is where i put master.mdf? insteald of myssqlsystemsource?

Where do you put D:\ PATH

ALTER DATABASE mssqlsystemresource

...

I passed the thread to my systems group for the SPN AD part.

Now if this works and i see Kerbos - i am assuming that now most of the other...

In sql 2000 you can't but sql 2005 you can by right click database, and click Files, for the owner

SQL1---SQL2

On SQL1 when i run my select * from linked...etc statement.

Im on the activity window and see the statement ID and see that this produces

I get

TCPTSQL19131924504FALSENTLM

(This is where...

Brackets go around like this

select * from [LinkedServer].DBNAME.SCHEMANAME.TABLENAME

I get the following:

OLE DB provider "SQLNCLI" for linked server "LinkedServer" returned message "Login timeout expired".

On linked server i have

...

Actually that makes sense you could have the owner be one user (sometimes app need this set).

Example Owner APPUSER owner

Then you could have dev/programmers who need db_owner to create...

I am aware of one owner and many users can be db_owner.

I wasn't sure if there are specific differences or why even do database owner and not just use

user...and set...

Yes i can get the linked sever to work using sql login just fine, but not with domain/tracey.

Lets hope someone else comes on here for some direction.

Did you get anything...

Oh i startup script to add linked tables in MS Access hmmm let me look around for that.

That is phase 2 of this hugh project but im getting there.

Thanks guys.

Found a great thread

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

select uses_self_credential as delegation

from sys.linked_logins as L, sys.servers as S

where S.server_id=L.server_id

and...

Yes i got everything nailed that you listed to the T.

Now i have some users who still use the good old Microsoft Access and use Linked Databases,

which would be pointing...

You still need to make sure your servers have SPN (This is ?)

setup correctly

AND on AD they are marked as "trust this account for delegation".

(On AD the...