Setting up MSDE problems

B

bri189a

Senior Contributor
Joined
Sep 11, 2003
Messages
1,004
Location
VA
I knew there was reason I always use MS Access db's.... grrrrr...

So I have C# 2003 and decided for my own sadistic reasons that I'd start using MSDE instead of Access... so I went and downloaded the package, up-packed it, quickly skimmed through the file to get the command line parameter to install it and apparently it installed since the service is now running. Going to 'Server Explorer' I type in my computer (and tried localhost for the fun of it) and tried using 'trusted connection' and entering SA with the password I created when installing MSDE and everything comes back with Access denied. MSDE is very user unfriendly apparently and Microsoft spared no expense at putting out a wonderful 6000 line text file that doesn't tell you anything useful... well maybe it does, but whose going to read a 6000 line document?

Any ideas?
 
When you select trusted connection you don't have to type a password. A trusted connection implies that the application will use your Windows login to connect (mapping itself to a role in Microsoft SQL Server). Granted that is unlikely to be the problem but I believe it's worth noting.
 
Appreciate it guys... I'm just really head strong on good documentations coming with a product and I expect more from Microsoft than some README.TXT file... I know Access is severly limited, but it's what I'm accostomed too, but I know I need to transfer my knowledge to the SQL side if I'm ever going to do anything large scale. I'll read up on that link and get back with you if I have any more questions.... thanks, and Derek, trusted connection failed (this is the same account I used to install it with)... probably since I didn't read the install doc fully I skipped something important and will have to re-install it, but we'll see... serves me right for being in a rush. :/
 
Back
Top