Yes,

First i connected to Primary server , windows login and from there am connecting to the secondary and trying configure LS with wizard....

Yes it has access to that backup folder...

When i tried in same machine with two instances, it worked fine...

But, when i try using network machines the error raised....

Access given ;...

Refer this :

http://msdn.microsoft.com/en-us/library/ms190442.aspx

http://msdn.microsoft.com/en-us/library/aa933084(SQL.80).aspx

<<<>>>> while posting the topic

SORRY...!!

Post dropped 3 times....its not my mistake - i tried posting then it given application error - then again i tried to post the same for 3 times refreshing-

Finally...

Are you using SQL 2000? If so, I once created a SQL Agent job that does the trick, but I have not tested it on SQL 2005.

It is made up...

Yes,

I can see the DB user role in the secondary database... But cant create Login....

Ours is a mixed autheticated... SQL and WIN..

Any suggestions please...

Can't create a Login on the secondary server right ?

as the database will be in ReadOnly mode.... It will be like a dummy login, though its same in DB user...

Thanka for the post.

But cannot do the same as "SID is already in use" thisis the error am facing with the process...

Anyother help...

Thanks for quick reply,

Yes, its a Logshipped server (secondary database server)

I can see DB role and i need to have the same account for Login. With that account name we...

Sounds Good........ But dont write or respond in CAPS as its referred as shouting on others....

Any how have good times......

Rgds,

CH&HU@Win..

Exec sp_addlinkedsrvlogin

@useself='false', --//false means we are going to use remote login/password

...

Exec sp_addlinkedserver

@server='SERVERNAME/ IP', --//Logical name given to the linked server.

@srvproduct='', --//optional . Just for description

@provider='SQLServer', --//OLEDB Provider name, check BOL for...

A SQL Server login allows a user to connect to a server. A login is the base concept.

Database user is associated with a login to allow specific permissions on that...

Thanks Roshan..!!!!

It worked for me.... either it may be time being but... My JOB got succeeded...