Not associated with a trusted SQL Server Connection

[striker73]

I am trying to set up SQL server on my Windows 2000 machine (AMY2000) so I can upsize my Access database to it. I have the SQL Server service running on the Windows 2000 machine, but when I go to access the database using Enterprise Manager, I can't register the SQL Server.

I have tried using SQL Server Authentication (login: sa password: blank) and Windows Authentication, but I keep getting the same error:

AMY2000 - Login failed for user '(null)'*. Reason: Not associated with a trusted SQL Server Connection.

*or 'sa'

Any ideas on how I can get this to work?

 

[tlbroadbent]

sa is a SQL login. Use SQL authentication rather than Windows authentication.

Also, it is extremely bad policy to leave the sa login withou a password. There are numerous viruses and hacks that take advantage of null sa passowrds. Once SQL Server is compromised, your server and perhaps the entire network is at risk depending on configuration.

See thread183-280043, a tip on "SQL Server Security."
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.