November 10, 2008 at 8:31 am
--I am having problems with a Link server.
--I have SQL 2005(sql02) with a link SQL server 2000 (sql01)
--The problem only occurs when a domain user BUT Non-admin runs the job.
--The user exist on both servers
--Environment SQL Server Standard Edition
--Both TCP/IP and Names pipes are enabled
--The user can execute the T-SQL script and a query but not when the job runs or it is schedule.
--This is the error I am getting:
--when using OPENQUERY or LINKSERVERNAME.DATABASENAME.SCHEMANAME.TABLENAME
Executed as user: DOMAINNAME\UName. Named Pipes Provider:
Could not open a connection to SQL Server [1450]. [SQLSTATE 42000] (Error 1450)
OLE DB provider "SQLNCLI" for linked server "MYSQL01" returned message
"Login timeout expired". [SQLSTATE 01000] (Error 7412)
OLE DB provider "SQLNCLI" for linked server "SQL01" returned message
"An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.".
[SQLSTATE 01000] (Error 7412). The step failed.
--Thank you very much!
November 14, 2008 at 7:18 am
Any ideas?:crying:
November 14, 2008 at 12:57 pm
hi,
Make that user the dbowner and then execute the job, hopefully it will work.
Good luck
November 14, 2008 at 1:49 pm
Aftabsatti,
Thank you for the idea, but the he is already a dbowner.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply