Hi guys,<BR><BR>I've just downloaded the evaluation copy of SQL Server 2000 and I've got it up and running fine but I can't connect to a database with a DSN. I'm getting the following error:<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'LIZARD-JOHNIUSR_LIZARD-JOHN'.<BR>/thezone/index.asp, line 5<BR><BR>LIZARD-JOHN is the network name of the computer I'm running since SQL Server 2000 is installed locally. I've specified a ui and pwd in the DSN connection string but I'm still having no luck.<BR><BR>I set up the DSN to use Windows NT authentication and after testing the DSN, it said that the test had been successful.<BR><BR>I've already read the article on the MSDN site concerning the error code I received but this isn't really helping.<BR><BR>Sorry to post this but I'm really struggling. It's been a rather steep jump from Access. Any ideas?<BR><BR>Thanks in advance,<BR><BR>hellz.