MSSQL2K and WIN2K3 SP1

We have a Windows Server 2003 Standard with SQL Server 2000 Standard
edition serving as a development server. There are several DTS packages
hosted on the server and they connect to an entry from the local hosts
table. The reason for this is that each of the DEV, QA and PROD
servers in this group have an entry with the same name (ex. SVR_DBNAME)
but each of which point to their own IP address, allowing us to copy
the packages between servers without going back and changing all the
server name references.
Recently, WIN2K3 SP1 was installed on the machine and immediately, the
DTS packages - which use WIndows Authentication - failed with a message
indicating that the system could not authenticate against the local
Windows user:
Login failed for user '(null)'
Once SP1 was removed, the packages resumed working. What setting does
the service pack change that is causing this?
thanks
markHi
A couple of questions
Does the server/s have Mixed authentication mode or windows only?
Did you try ( If I understood correctly) to add an owner of DTS Packages to
the group of Admin of WIN2K3?
<markfcook@.gmail.com> wrote in message
news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> edition serving as a development server. There are several DTS packages
> hosted on the server and they connect to an entry from the local hosts
> table. The reason for this is that each of the DEV, QA and PROD
> servers in this group have an entry with the same name (ex. SVR_DBNAME)
> but each of which point to their own IP address, allowing us to copy
> the packages between servers without going back and changing all the
> server name references.
> Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> DTS packages - which use WIndows Authentication - failed with a message
> indicating that the system could not authenticate against the local
> Windows user:
> Login failed for user '(null)'
> Once SP1 was removed, the packages resumed working. What setting does
> the service pack change that is causing this?
> thanks
> mark
>|||Q1) mixed mode authentication is used
Q2) the windows account is a member of the local administrators group
Uri Dimant wrote:
> Hi
> A couple of questions
> Does the server/s have Mixed authentication mode or windows only?
> Did you try ( If I understood correctly) to add an owner of DTS Packages to
> the group of Admin of WIN2K3?
>
>
>
> <markfcook@.gmail.com> wrote in message
> news:1161054855.189750.67760@.m73g2000cwd.googlegroups.com...
> > We have a Windows Server 2003 Standard with SQL Server 2000 Standard
> > edition serving as a development server. There are several DTS packages
> > hosted on the server and they connect to an entry from the local hosts
> > table. The reason for this is that each of the DEV, QA and PROD
> > servers in this group have an entry with the same name (ex. SVR_DBNAME)
> > but each of which point to their own IP address, allowing us to copy
> > the packages between servers without going back and changing all the
> > server name references.
> >
> > Recently, WIN2K3 SP1 was installed on the machine and immediately, the
> > DTS packages - which use WIndows Authentication - failed with a message
> > indicating that the system could not authenticate against the local
> > Windows user:
> >
> > Login failed for user '(null)'
> >
> > Once SP1 was removed, the packages resumed working. What setting does
> > the service pack change that is causing this?
> >
> > thanks
> >
> > mark
> >