WEB Matrix/MSDE "SQL Server dose not exist or access denied?

[dajinghu]

I am learning ASP.net and working on a database application by following ASP.net Tutorials. I have following on my System: Windows2000 (pro), ASP Web Matrix 1.0 and MSDE (SQL) 2000.

After Install MSDE I tried to create System DSN with DataSources (ODBC) and successfully to connect with it.

However when I create a New Database with Web Matrix DATA Windows in the web application, I got "SQL Server does not exist or access denied ConectionOpen(Connect())"

What's wrong with it? How to solve the problem.

Thx for your help.

[dajinghu]

More Information and correction:

I have DSL/Broadband Router on my PC.
Web Matrix should be version 1.1.

[naijacoder]

Hi..
if u get:- access denied ConectionOpen(Connect())"
Then u are not able to access ur MSSQL server!!!That means u are not using the right PARAMETERS to log in such as Username and password.
Are u logging in as an Admin or just a user?
I guess its something btw ur OS and ur SQL Server(LOGINS)
check whether ur using ur OS logins or the SQL Server(LOGINS) to access ur DB

[dajinghu]

Hi.

You are right. I did get "access denied ConectionOpen(Connect())"

I do believe that I was not able to access ur MSSQL server.
I do have Administrator right to log on the PC and run MSDE 2000 build (I passed SAPWD as admin password which was exactly as same as I log on when I run the install).

By the way do you know now can I check and sync the OS login and SQL Server login?

Thanks for your help.