Setting up MSDE problems

bri189a

bri189a

Well-known member
Joined
Sep 11, 2003
Messages
1,004
Location
VA
I knew there was reason I always use MS Access dbs.... grrrrr...

So I have C# 2003 and decided for my own sadistic reasons that Id 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 doesnt 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 dont 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 its worth noting.
 
Appreciate it guys... Im 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 its what Im accostomed too, but I know I need to transfer my knowledge to the SQL side if Im ever going to do anything large scale. Ill 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 didnt read the install doc fully I skipped something important and will have to re-install it, but well see... serves me right for being in a rush. :/
 
Back
Top