Hello!

This means that the SQL server has been set up in NT-Only mode. You need to use a trusted connection and belong to a group that has been assigned privilages on the server and database you're after (eg by default, If you're a member of the SQL Server's local machine's administrators group (which usually includes all domain admins), you'll have dbo access to the SQL server)

To do this:

right-click on the server in the Enterprise Manager and choose properties

Select the Use Windows Authentication

Click OK

Right-click on the server and choose connect

HTH

Andrew

>Hello!
>
>Since VFP have more crowds than any other UT Forum, I decided to re-post my question here.
>
>I am just new in SQL Server 2000. How to register properly a SQL Server using enterprise manager in my PC? The wizard tells me this "Login failed for user "sa". Reason: Not associated with a trusted SQL Server connection."
>
>TIA

---

If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?

---

From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."

---

All my FoxTalk and other articles are available on my web site.

---

Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.