Reseting MSDE Password

Posted on 2006-04-14
Last Modified: 2008-02-01
Small Business Server 2003
Thought I kept good track of my records but now I just realized that Sharepoint is actually installed on MSDE not my SQL server and I don't know the sa password :(  When I am logged into the server I can connect to //sun/sharepoint using windows authentication (thank goodness) but how can I use enterprise manager from my workstation to edit these values?  Can I reset the sa password?  It seems there are 2 msde database one for sbsmonitoring and one for sharepoint... and to my dismay the sa/password combo for one doesn't work for both.   Your advice is greatly appreciated.

Question #2
Is it worth the hassle to move the sharepoint and sbsmonitoring to the sql server - this is only used for 1-3 sites and only for testing purposes so the load is EXTREMELY light.
Question by:cboyda

    Author Comment

    Is there a default sa/password combo for sharepoint?
    LVL 33

    Accepted Solution

    The default pasword for SA is <blank>

    Maybe just hit enter for the password prompt...maybe yours is blank....;en-us;Q322336

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
    Learn about cloud computing and its benefits for small business owners.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video discusses moving either the default database or any database to a new volume.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now