SQL Server Performance Forum – Threads Archive
DTS Error
I wanted to run a DTS through Stored Procedure.<br /><br />EXEC master.dbo.xp_cmdshell ‘dtsrun /S FSDBMR /U sa /N Test'<br /><br />I get the following error….<br /><br /><br />DTSRun: Loading… <br /> <br />Error: -2147467259 (80004005); Provider Error: 17 (11) <br /> Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. <br /> Error source: Microsoft OLE DB Provider for SQL Server <br /> Help file: <br /> Help context: 0 <br /> <br />NULL<br /><br />Can some body help me abt this….<br /><br />Thanks<br />Rashmi[<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />!][V][xx(]<br />
well – is there a SQL server named FSDBMR ?
you are not passing the password .. /P try those Panic, Chaos, Disorder … my work here is done –unknown
Same error comes even when I provide those things…… there is a database called FSDBMR
A database or a server? Remember, the DTSRUN /S parametre specifies the SQL server (and instance), and not the database – that is incide you package. DTSRUN /S ServerNameInstanceName /U sa /P passwordforsa /N test CiaO Panic, Chaos, Disorder … my work here is done –unknown
Thanks …I was my mistake …I have not written the Server name( FSDBMR is not server it is database)
]]>