March 13, 2014 at 7:27 am
We finally made the intermediate jump to SQL 2000 Enterprise from 7. Everything is running smothly with the exception of a server registration. While on 7, we had an instance of an offsite SQL Server 2000 server registered on our 7 server. We were running daily DTS packages to update data. Now that we are on 2000, we are not able to register this server (login failed for user null). We can register the server if we connect using sa, but cannot using Windows Authentication.
Appreciate any thoughts.
Brent
April 1, 2014 at 7:14 am
bshaw (3/13/2014)
We finally made the intermediate jump to SQL 2000 Enterprise from 7. Everything is running smothly with the exception of a server registration. While on 7, we had an instance of an offsite SQL Server 2000 server registered on our 7 server. We were running daily DTS packages to update data. Now that we are on 2000, we are not able to register this server (login failed for user null). We can register the server if we connect using sa, but cannot using Windows Authentication.Appreciate any thoughts.
Brent
Sorry, are you talking about linked servers or enterprise manager?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply