New data source connection failure

Hi,
Windows 2003 Server Std. Edition - SQL Server 200 Std. Edition
I'm able to create a new data source in the ODBC panel on the SQL
server which points to a db on the same SQL server but not creating
that same new data source in the SQL Server Enterprise Manager or
Analysis Manager. I tried creating a new cube, a new DTS and so on but
I won't get past the new data source failure.
Error: [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not
exist or access is denied.
I tried using local admin account, sa account which both belong to the
sysadmin serve role.
Thank you.
Steve"Steve" <steve@.500mg.be> wrote in message
news:6b781b0f.0410300430.775b6306@.posting.google.com...

> Windows 2003 Server Std. Edition - SQL Server 200 Std. Edition
> I'm able to create a new data source in the ODBC panel on the SQL
> server which points to a db on the same SQL server but not creating
> that same new data source in the SQL Server Enterprise Manager or
> Analysis Manager. I tried creating a new cube, a new DTS and so on but
> I won't get past the new data source failure.
> Error: [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not
> exist or access is denied.
> I tried using local admin account, sa account which both belong to the
> sysadmin serve role.
It sounds like your SQL Server 2000 is running in "windows only"
authentication mode, which means the 'sa' account would not be recognized.
Try either a windows account (preferred technique) local admin should work
if you have not changed the basic security install, or change the
authentication mode to "sql server and windows", stop and restart SQL
Server.
Steve