August 31, 2005 at 5:25 am
I have a problem, would appreciate some advice.
SQL 7 is on the server (let's call it Alpha).
SQL 2K development tools were installed on top of SQL 7 (by accident).
If I connect to Alpha with another machine through SQL 2K Enterprise manager, then I can view the DTS package contents and edit them as normal.
However, if I try and view the contents of the DTSs on Alpha itself, then I
cannot see anything when I attempt to view the package contents, nor can I create new DTSs.
Anyone have any ideas what I can do to fix this?
August 31, 2005 at 5:58 pm
Ajay,
This sounds like a permissions issue. Make sure your login has access to the msdb (at least to the DTS portions therein).
Good Luck,
Darrell
September 1, 2005 at 3:59 am
I don't think it is, I'm fairly sure I'm logged in as the sa user (although I'm not sure how to check this when I'm using EM).
A colleague mentioned that he encountered a similar problem some time ago and fixed the problem by replacing certain dlls with SQL Server 7.0 dlls.
Unfortunately, he's not here any more and I don't know which dlls I'd need to make DTSs work in SQL 7, despite trawling the internet looking for them.
Any suggestions?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply