 | |
DTS and MSDE 2000
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: DTS and MSDE 2000 -
08-05-2008
, 06:14 PM
|
On Aug 4, 7:24 pm, jim <j... (AT) discussions (DOT) microsoft.com> wrote: hello, Hi jim, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Number: -2147467259 Have you checked that the NT user account used to load the package has right permissions to log into sqlserver and load the pkg? Is he the same user that created the package? And try also to execute it using DTSrun: DTSRUN /S[yourserver] /E / N"[PackageName]" MSDE 2000 is not multihomed, so I'm not certain as to why this error is occurring. As a backdrop, the dts pkg. was installed on the engine using LoadFromStorageFile and saved to msdb via SaveToSqlServer. The package is then loaded from sql server before execution. The package fails on the first step where an ActiveX script is called. So the DTS fails because the first step fails... I misunderstood. What does this ActiveX then do? Check this first step for ADO connections and check that all parameters such as server, user or password are correctly set. Here's the code used to load and execute the pkg. [...] Lastly, the Connection object(s) in the pkg. as set for SQL Server authentication. Then it's likely that the user that executes the dts with the proc that you posted (perhaps an external program, maybe Access, is being used to execute this package) hasn't right permissions to connect to the server, used in the activex script's connection. Assuming this server is up and operational, try, one more time  , to run the pkgwith dtsrun with an account for which you're sure that will complete with success. Any help is appreciated. HTH, Matteo |
#12
| |||
| |||
|
|
On Aug 4, 7:24 pm, jim <j... (AT) discussions (DOT) microsoft.com> wrote: hello, Hi jim, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Number: -2147467259 Have you checked that the NT user account used to load the package has right permissions to log into sqlserver and load the pkg? Is he the same user that created the package? And try also to execute it using DTSrun: DTSRUN /S[yourserver] /E / N"[PackageName]" MSDE 2000 is not multihomed, so I'm not certain as to why this error is occurring. As a backdrop, the dts pkg. was installed on the engine using LoadFromStorageFile and saved to msdb via SaveToSqlServer. The package is then loaded from sql server before execution. The package fails on the first step where an ActiveX script is called. So the DTS fails because the first step fails... I misunderstood. What does this ActiveX then do? Check this first step for ADO connections and check that all parameters such as server, user or password are correctly set. Here's the code used to load and execute the pkg. [...] Lastly, the Connection object(s) in the pkg. as set for SQL Server authentication. Then it's likely that the user that executes the dts with the proc that you posted (perhaps an external program, maybe Access, is being used to execute this package) hasn't right permissions to connect to the server, used in the activex script's connection. Assuming this server is up and operational, try, one more time , to run the pkgwith dtsrun with an account for which you're sure that will complete with success. Any help is appreciated. HTH, Matteo |
#13
| |||
| |||
|
|
On Aug 4, 7:24 pm, jim <j... (AT) discussions (DOT) microsoft.com> wrote: hello, Hi jim, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Number: -2147467259 Have you checked that the NT user account used to load the package has right permissions to log into sqlserver and load the pkg? Is he the same user that created the package? And try also to execute it using DTSrun: DTSRUN /S[yourserver] /E / N"[PackageName]" MSDE 2000 is not multihomed, so I'm not certain as to why this error is occurring. As a backdrop, the dts pkg. was installed on the engine using LoadFromStorageFile and saved to msdb via SaveToSqlServer. The package is then loaded from sql server before execution. The package fails on the first step where an ActiveX script is called. So the DTS fails because the first step fails... I misunderstood. What does this ActiveX then do? Check this first step for ADO connections and check that all parameters such as server, user or password are correctly set. Here's the code used to load and execute the pkg. [...] Lastly, the Connection object(s) in the pkg. as set for SQL Server authentication. Then it's likely that the user that executes the dts with the proc that you posted (perhaps an external program, maybe Access, is being used to execute this package) hasn't right permissions to connect to the server, used in the activex script's connection. Assuming this server is up and operational, try, one more time , to run the pkgwith dtsrun with an account for which you're sure that will complete with success. Any help is appreciated. HTH, Matteo |
#14
| |||
| |||
|
|
On Aug 4, 7:24 pm, jim <j... (AT) discussions (DOT) microsoft.com> wrote: hello, Hi jim, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Number: -2147467259 Have you checked that the NT user account used to load the package has right permissions to log into sqlserver and load the pkg? Is he the same user that created the package? And try also to execute it using DTSrun: DTSRUN /S[yourserver] /E / N"[PackageName]" MSDE 2000 is not multihomed, so I'm not certain as to why this error is occurring. As a backdrop, the dts pkg. was installed on the engine using LoadFromStorageFile and saved to msdb via SaveToSqlServer. The package is then loaded from sql server before execution. The package fails on the first step where an ActiveX script is called. So the DTS fails because the first step fails... I misunderstood. What does this ActiveX then do? Check this first step for ADO connections and check that all parameters such as server, user or password are correctly set. Here's the code used to load and execute the pkg. [...] Lastly, the Connection object(s) in the pkg. as set for SQL Server authentication. Then it's likely that the user that executes the dts with the proc that you posted (perhaps an external program, maybe Access, is being used to execute this package) hasn't right permissions to connect to the server, used in the activex script's connection. Assuming this server is up and operational, try, one more time , to run the pkgwith dtsrun with an account for which you're sure that will complete with success. Any help is appreciated. HTH, Matteo |
#15
| |||
| |||
|
|
On Aug 4, 7:24 pm, jim <j... (AT) discussions (DOT) microsoft.com> wrote: hello, Hi jim, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Number: -2147467259 Have you checked that the NT user account used to load the package has right permissions to log into sqlserver and load the pkg? Is he the same user that created the package? And try also to execute it using DTSrun: DTSRUN /S[yourserver] /E / N"[PackageName]" MSDE 2000 is not multihomed, so I'm not certain as to why this error is occurring. As a backdrop, the dts pkg. was installed on the engine using LoadFromStorageFile and saved to msdb via SaveToSqlServer. The package is then loaded from sql server before execution. The package fails on the first step where an ActiveX script is called. So the DTS fails because the first step fails... I misunderstood. What does this ActiveX then do? Check this first step for ADO connections and check that all parameters such as server, user or password are correctly set. Here's the code used to load and execute the pkg. [...] Lastly, the Connection object(s) in the pkg. as set for SQL Server authentication. Then it's likely that the user that executes the dts with the proc that you posted (perhaps an external program, maybe Access, is being used to execute this package) hasn't right permissions to connect to the server, used in the activex script's connection. Assuming this server is up and operational, try, one more time , to run the pkgwith dtsrun with an account for which you're sure that will complete with success. Any help is appreciated. HTH, Matteo |
#16
| |||
| |||
|
|
On Aug 4, 7:24 pm, jim <j... (AT) discussions (DOT) microsoft.com> wrote: hello, Hi jim, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Number: -2147467259 Have you checked that the NT user account used to load the package has right permissions to log into sqlserver and load the pkg? Is he the same user that created the package? And try also to execute it using DTSrun: DTSRUN /S[yourserver] /E / N"[PackageName]" MSDE 2000 is not multihomed, so I'm not certain as to why this error is occurring. As a backdrop, the dts pkg. was installed on the engine using LoadFromStorageFile and saved to msdb via SaveToSqlServer. The package is then loaded from sql server before execution. The package fails on the first step where an ActiveX script is called. So the DTS fails because the first step fails... I misunderstood. What does this ActiveX then do? Check this first step for ADO connections and check that all parameters such as server, user or password are correctly set. Here's the code used to load and execute the pkg. [...] Lastly, the Connection object(s) in the pkg. as set for SQL Server authentication. Then it's likely that the user that executes the dts with the proc that you posted (perhaps an external program, maybe Access, is being used to execute this package) hasn't right permissions to connect to the server, used in the activex script's connection. Assuming this server is up and operational, try, one more time , to run the pkgwith dtsrun with an account for which you're sure that will complete with success. Any help is appreciated. HTH, Matteo |
#17
| |||
| |||
|
|
On Aug 4, 7:24 pm, jim <j... (AT) discussions (DOT) microsoft.com> wrote: hello, Hi jim, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Number: -2147467259 Have you checked that the NT user account used to load the package has right permissions to log into sqlserver and load the pkg? Is he the same user that created the package? And try also to execute it using DTSrun: DTSRUN /S[yourserver] /E / N"[PackageName]" MSDE 2000 is not multihomed, so I'm not certain as to why this error is occurring. As a backdrop, the dts pkg. was installed on the engine using LoadFromStorageFile and saved to msdb via SaveToSqlServer. The package is then loaded from sql server before execution. The package fails on the first step where an ActiveX script is called. So the DTS fails because the first step fails... I misunderstood. What does this ActiveX then do? Check this first step for ADO connections and check that all parameters such as server, user or password are correctly set. Here's the code used to load and execute the pkg. [...] Lastly, the Connection object(s) in the pkg. as set for SQL Server authentication. Then it's likely that the user that executes the dts with the proc that you posted (perhaps an external program, maybe Access, is being used to execute this package) hasn't right permissions to connect to the server, used in the activex script's connection. Assuming this server is up and operational, try, one more time , to run the pkgwith dtsrun with an account for which you're sure that will complete with success. Any help is appreciated. HTH, Matteo |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.