login fails for linked server to text file

Question

Post reply

login fails for linked server to text file

Amrita bhatia

Right there with Babe

Points: 718
More actions
August 22, 2005 at 3:57 am

#90783

hi

following is the query for creating a linked server to text file

EXEC sp_addlinkedserver txtsrv1, 'Jet 4.0',

   'Microsoft.Jet.OLEDB.4.0',

   'C:\CSV',

   NULL,

   'Text'

GO

login is created as

EXEC sp_addlinkedsrvlogin txtsrv1, FALSE,'admin', NULL

above line fails ,

'admin' is not a local user. Remote login denied.

any idea why is it failing

above statement works if we give sql server login is given

thanks

Amrita

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Max Mulawa SSC Enthusiast Points: 174 More actions · Answer 1

Max Mulawa

SSC Enthusiast

Points: 174

August 22, 2005 at 5:14 am

#583852

if u check sp_addlinkedsrvlogin syntax then u will see that your parameter 'admin' should be a SQL Server login or a Windows NT user and Windows NT user must have been granted access to SQL Server.

Amrita bhatia Right there with Babe Points: 718 More actions · Answer 2

Amrita bhatia

Right there with Babe

Points: 718

August 22, 2005 at 5:23 am

#583855

this statement is working

EXEC sp_addlinkedsrvlogin txtsrv1, FALSE,null,'admin', NULL

but can anybody point me to the difference between them ??

AndrewMurphy SSCertifiable Points: 5586 More actions · Answer 3

I'm being obvious here ()....but the "EXEC sp_addlinkedsrvlogin txtsrv1, FALSE,null,'admin', NULL" statement has 1 extra 'null' after the false.

If you read the sp_addlinkedsrvlogin stored procedure, and follow the logic of the IF conditions contained therein, the latter statement must go down a different execution path from the former.