"paul gardiner" wrote:

> Brand new W2K3 server in a workgroup, no domain. Server
> name and IP address are pingable.
> Installed SQL Server 2000 with SP3a, no errors. Chose
> Windows authentication. SQL Server service and Agent
> service are running, Enterprise Manager on the server
> appears fine. No database created yet, trying to connect
> to the Northwind db.
>
> Don't know how to make a connection to the Northwind db.
> Do I have to create a share for the drive and/or folder
> that SQL is on? Do I have to adjust Local security on the
> server? On the server, when I try to add
> workgroup\computername to Allow Logon Locally, I can
> select it, but when I save, I get a message that says "an
> extended error has occurred. Failed to save Local Policy
> Database." Do I have to create a group on the server and
> within SQL that has all the necessary users?
>
> On a workstation,creating and testing an ODBC connection
> results in:
>
> Microsoft SQL Server ODBC Driver Version 03.85.1025
>
> Running connectivity tests...
>
> Attempting connection
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
> does not exist or access denied.
>
> TESTS FAILED!
>
> I'm obviously missing something. Any help would be
> greatly appreciated. Thanks.