"sqlapprentice" wrote:

> Hello,
>
> My SQL Server is set to "mixed mode".  I am using TCPIP.
> I can logon to the server physically, but I can't do it remotely on my
> laptop from my Enterprise Manager or Query Analyzer.  I am able to ping the
> server from my laptop.
> I don't have this problem with my other SQL Servers.
>
> When I use Query Analyzer with Windows Authentication, I get this error.
> login failed for user '(null)' not associated with a trusted SQL Server
> connection
>
> What is the problem?
>
> Thanks in advance.

"Enric" wrote:

> hi, your user domain must exists in that sql server.
> --
> Current location: Alicante (ES)
>
>
> "sqlapprentice" wrote:
>
> > Hello,
> >
> > My SQL Server is set to "mixed mode".  I am using TCPIP.
> > I can logon to the server physically, but I can't do it remotely on my
> > laptop from my Enterprise Manager or Query Analyzer.  I am able to ping the
> > server from my laptop.
> > I don't have this problem with my other SQL Servers.
> >
> > When I use Query Analyzer with Windows Authentication, I get this error.
> > login failed for user '(null)' not associated with a trusted SQL Server
> > connection
> >
> > What is the problem?
> >
> > Thanks in advance.

"sqlapprentice" wrote:

> Hi Enric,
>
> Yes, The user domain exists.
>
> I noticed that whoever install the SQL server did not install the compatible
> SQL SP4 for Windows 2003.
> It is running Windows 2003 with SQL 2000 SP3.
> I think you need at least SP3a to be compatible with Windows 2003.
>
> I will install the SP4 later this week...I think that may be the problem.
>
> Any suggestions?
>
> "Enric" wrote:
>
> > hi, your user domain must exists in that sql server.
> > --
> > Current location: Alicante (ES)
> >
> >
> > "sqlapprentice" wrote:
> >
> > > Hello,
> > >
> > > My SQL Server is set to "mixed mode".  I am using TCPIP.
> > > I can logon to the server physically, but I can't do it remotely on my
> > > laptop from my Enterprise Manager or Query Analyzer.  I am able to ping the
> > > server from my laptop.
> > > I don't have this problem with my other SQL Servers.
> > >
> > > When I use Query Analyzer with Windows Authentication, I get this error.
> > > login failed for user '(null)' not associated with a trusted SQL Server
> > > connection
> > >
> > > What is the problem?
> > >
> > > Thanks in advance.