I set my Win 2000 Server to run as a stand-alone server by defining a workgroup (not running a domain). Then, I install SQL Server 2000 Enterprise by using processor license and windows authentication method.<BR><BR>There are 3 accounts in the security section of Enterprise Manager ...<BR>- BUILTINAdministrators<BR>- MYSERVERmyname<BR>- sa<BR><BR>Then, I create a simple database in SQL Server and try to inititate it with the following string:<BR><BR>Conn.Open "PROVIDER=SQLOLEDB; DATA SOURCE=MYSERVER; INITIAL CATALOG=crmINVY; USER ID=sa; PASSWORD=;"<BR><BR>Unfortunately, there is an error message:<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for SQL Server (0x80004005)<BR>Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.<BR><BR>What's wrong with the string? Do I need to fine-tune SQL Server? And how?<BR><BR>p.s. When I change DATA SOURCE to MYSERVERmyname, the system takes a while to process the page and returns the following error:<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for SQL Server (0x80004005)<BR>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.<BR><BR>Thank you so much.