I am an ASP.net newbie learning thru databasing now.
When setting up and connectiong to Database, i am prompted at SQL Server
Authentication for a user name and password
When I installed, thru the CMD under Start: Run in Windows 2000, i believe i
specified "sa" and "password" for user name and password. but now i get an
error, trying to input that.
"unable to connect to database.
Login failed for user "sa" Reason : not associated with a trusted SQL Server
connection"
What am i doing wrong? if i mistyped the password info when setting up,
where can i check it? or reset it?
Please someone help me
RaphaelSo are you using a ASP.Net script to connect to the DB?
The SQL connection should look like:
server=localhost;Trusted_Connection=true;database=theDB;user id=sa;password=password
Does that make sense to you?
Adrian|||um,
No not at first site, I am a newbie, remember!
I am trying to run from the web matrix project, and i simply cannot create a new msde database.
Do you have any further advice?
Thanks
Raphael
No comments:
Post a Comment