April 3, 2003 at 7:58 pm
I installed SQL Server client in my laptop and server in my server machine. Suddently I can't open all existing DTS packages from the Enterprise Manager in the server machine, but I can do that in my laptop. The error message I got is :
Error Source: MS Data Transformation Services (DTS) Package
Error Description: The specified module could not be found.
And I tried to create a new package, when I tried to create a new SQL connection using the "MS OLE DB Provider for SQL Server" under the "Connection", it gives me the same error. I think this is the cause of my unable to open packages which use SQL Server connections.
But I don't know why this does not happen in my laptop? What should I do?
April 4, 2003 at 5:40 am
did you install MDAC?, maybe you should install againt the client tools.
April 4, 2003 at 2:54 pm
What is MDAC? Where should I install it, client or server side?
April 6, 2003 at 3:31 am
Actually my problem now is narrow to the server machine only (pretty sure my laptop is not relative to this problem), and the problem now seems to be relative to the window login to the server machine.
When we installed the SQL Server, we choose the "Log on" as "This acount", and set the company domain administrator to "This acount". Now I found that only login to the server machine using this company domain administrator, the DTS works fine. Loging using other accounts which even belongs to the local administrator group, the DTS still has the "The specified module could not be found" problem. Anybody has any idea?
In additional, I am wandering what is the difference between setting up the "Log On" of the MSSQLSERVER service to be "Local System account" and to be "This account"? Which one is safer to use?
April 6, 2003 at 7:16 pm
April 7, 2003 at 1:14 am
JFB:
I actually looked at this article and did not find the solution for my case. Here are why:
1. I only have SQL Server 2000 installed, don't have a mix environment with SQL Server 7.0 and 2000
2. I did not install 2000 Analysis Services
3. I can open the DTS packages from the client tool in my laptop without a problem. And as I described in the previous reply, in the server machine, if I log in as the company administrator, I don't have problem either. Only when I login to the server machine as different users (but under the local administrator group), then I have this problem when I open the DTS packages from the Enterprise Manager.
Any idea?
April 7, 2003 at 1:37 pm
Hi,
Did you install sp2 in both pc's?
If not... install I thing this will fix you problem.
JFB
April 7, 2003 at 1:42 pm
I installed Service Pack 3 in both PCs and it does not solve my problem yet. 🙁
April 10, 2003 at 8:27 am
Were the DTS packages created on your pc? If so, you need to create them on the server. DTS uses settings from the computer that they were built on--which accounts for the module error.
Linda
April 10, 2003 at 10:15 am
Itz better run the SQL server services on the domain/admin a/c (this a/c).
Chk the pkg owner info,If it has the different than the domain/admin,Then chk the rights for the pkg owner.
Better create the pkg under domain/admin.
Edited by - spdhiva on 04/10/2003 10:16:31 AM
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply