We had some serious server problems and ultimately had to reinstall
SQL Server 2000 on a Windows 2000 Server box.

Initially, we installed SQL server under a domain account named
srmsql. Under this installation we created everything, (DBs tables,
DTS pkgs, jobs, etc.)

Before we did our second or reinstallation, we saved what we needed
(.mdf/.bak, etc.) did the install and put everything back. This time
however, we did the install under a domain account called srmoper.
Almost everything works pretty well. I am having trouble with a few
jobs that execute DTS packages. When I open the package itself, and
run each step of the package individually, it runs fine. When I just
try to run the package as a package though, it gives me the following:

Package Error

Error Source: Microsoft OLE DB Provider for SQL Server

[DBNETLIB][ConnectionOpen(Connect()).]
SQL Server does not exist or access is denied.

So I guess I really want to know is what do I need to do when I do a
reinstall of SQL Server under a different domain account than DTS was
created? Thanks.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/DTS-reinstal...ict196024.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=663968

You probably need to change the name of the server for each connection
inside of each package.
Check your logins and permissions... make sure you have all user accounts in
the new server.
Also make sure you dont have orphans users.
JFB

"mwmiller78" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote