bri189a Posted November 10, 2003 Posted November 10, 2003 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? Quote
*Experts* Volte Posted November 10, 2003 *Experts* Posted November 10, 2003 Ugh... Access... Give me MSDE over Access any day. Anyway, have you looked here: http://www.microsoft.com/sql/msde/default.asp - there's gotta be something there. Also, try searching Google. Quote
*Gurus* Derek Stone Posted November 11, 2003 *Gurus* Posted November 11, 2003 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. Quote Posting Guidelines
bri189a Posted November 11, 2003 Author Posted November 11, 2003 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. :/ Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.