Sunday, March 25, 2012

DTS error message

I am trying to DTS data from one db on server A to the same db on server B. Server B is my own local sql server registration. I get this error when trying to move data into a new db:

error description:[DBNETLIB][ConnectionOpen(Connect()).]SQLServer does not exist or access denied
Context: Error during initialization of the provider

any ideas?? Thanks a ton, in advance!! :rolleyes:I am trying to DTS data from one db on server A to the same db on server B. Server B is my own local sql server registration. I get this error when trying to move data into a new db:

error description:[DBNETLIB][ConnectionOpen(Connect()).]SQLServer does not exist or access denied
Context: Error during initialization of the provider

any ideas?? Thanks a ton, in advance!! :rolleyes:

hi,
this error may be is the server name, you use the (local) o the name of the server, in sql 2000 with instance name, is better write the name\instance.
test this and tell me.

No comments:

Post a Comment