dbTalk Databases Forums  

Error source:Microsoft OLE DB Provider for SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error source:Microsoft OLE DB Provider for SQL Server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
guido
 
Posts: n/a

Default Error source:Microsoft OLE DB Provider for SQL Server - 03-14-2006 , 10:15 AM






Hi to all, does anyone know if MS SQL Server 2000 Personal Edition has some
limitation on DTS usage o connections?

I've this problem:

when i create a DTS with a Data Driven Query task and two connection
"Microsoft OLE DB Provider for SQL Server" as source and target, i get the
error below.

Error source:Microsoft OLE DB Provider for SQL Server.
Error description: Cannot open DB registred in login <DB_NAME>. Login failed.

If I create the same DTS on a Developer Edition I do not have any problem !!

WHY THIS ???

Thanks
Guido

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.