WEB Matrix/MSDE "SQL Server dose not exist or access denied?
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.
More Information and correction:
I have DSL/Broadband Router on my PC.
Web Matrix should be version 1.1.
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
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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL