Enterprise Manager confusion

Ok i know that the main reason for the error that contains

System.Data.OleDb.OleDbException: Login failed for user 'BEDROOM\ASPNET'.
is because i do not have the ASPNET registered.
From what i have been told i need Enterprise Manager.
I HAVE NO CLUE WHERE TO GET IT OR HOW TO CONFIGURE IT OR ANYTHING OF IT
sorry for the caps.
I have search on here and google and nothing
any help
thanks
It is not a stand alone product, it is part of SQL Server 2000, try the link below to test drive the full version of SQL Server. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx|||

base836ball wrote:

Ok i know that the main reason for the error that contains

System.Data.OleDb.OleDbException: Login failed for user 'BEDROOM\ASPNET'.
is because i do not have the ASPNET registered.
From what i have been told i need Enterprise Manager.
I HAVE NO CLUE WHERE TO GET IT OR HOW TO CONFIGURE IT OR ANYTHING OF IT
sorry for the caps.
I have search on here and google and nothing
any help
thanks

Inthis previous threadyou said you already had Enterprise Manager. Sorry I didn'tfollow up with your question there, the open source part of yourresponse confused me and I forgot to respond.
You do notneed Enterprise Manager. You can perform the needed commands from the command line using the osql utility.
You might findHow To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility to be helpful. In an osql session you will need to execute these commands:

EXEC sp_grantlogin 'BEDROOM\ASPNET'
GO
USE yourDatabase
GO
EXEC sp_grantdbaccess 'BEDROOM\ASPNET', 'ASPNET'
GO

Seethis post andthis post for more step-by-step instructions that I've given in the past.
|||BEAUTIFUL!!!!!
Thanks. Everything is up and operational