I'm new to SQL server. I installed SQL server on windows
2003 server.

And I installed the client on my windows Xp workstation.

When I try to connect with the SQL server, it gives error
message:


LOgin failed for User(NUll) Reason: not associated with a
trusted SQL server connection.

Earlier, When I installed SQL server, I chose Windows
authentication. After installation I go to SQL-EM,
security Logins and set a password for sa.

Don't know why can't connect
Any suggestions will be appreciated

If you are using Windows Authentication then you can't use sa since that is
a SQL Login. You need to add your domain account as a Login in SQL Server.
But you need to ensure your workstation is on the same domain as the server.

--

Andrew J. Kelly
SQL Server MVP


"ann" <xiaowei.cao (AT) state (DOT) mn.us> wrote

Thank you.

Yes, I did try to use domain account, there wes the same
message. not trusted SQL server connection

Our web server where SQL server is on does not joined our
domain. our domain now is in netware system. So we plan
to use the windows 2003 web server as a standalone,
although it is in the same subnet with novell network.

So now I tried to connect the sql server in workstations,
I failed.
What is the best solution to our enviroment?

Thank you in advance for further assistance.

If your sql server is not in the domain then you can't use NT authentication
like that. I would suggest you switch to Mixed authentication and use SQL
Server logins instead.

--

Andrew J. Kelly
SQL Server MVP


"xiaowei" <xiaowei.cao (AT) state (DOT) mn.us> wrote