How to find a database in SQL Server 2005?

Posted on 2005-04-24
Last Modified: 2010-03-19
I have used an installer to create an SQL Server database and install DotNetNuke 3.0.13 portal to my IIS local server.
After I log on the  SQL Server Express Manager by entering .\SQLEXPRESS for the server instance with Windows Authentication,
I browse to the directory of the databases but I can't see the database created for the DotNetNuke portal.
The database has been created after I provided the 'sa' and strong password that were set during the installation of the SQL Server.

 What I want to do is to find this database and be able access visually the data like MS Access. I am using the free version of SQL Server 2005, thus I believe it doesn't have all the options. Do you know any other software that serves this?

Any ideas?
Question by:nectarios777
    LVL 42

    Expert Comment

    check what MSSQL... services do you have? - see Win services..
    LVL 42

    Expert Comment

    Are you sure that your database(s) created in 2005?

    Q.  What steps should I follow for a clean installation?
    A.  First, unzip the package into C:\DotNetNuke.  

    Second, create a Virtual Directory in IIS called DotNetNuke which points to the directory where the DotNetNuke.vbproj file exists.  Ensure that you have default.aspx specified as a Default Document for your Virtual Directory.  Depending on your choice of database you must have the necessary software installed on your server and you must create the database:

    ** MS Access ( default ) -- You need to ensure you have the latest Microsoft JET 4.0 Database Engine installed (browse to The database file ( DotNetNuke.mdb.resources ) will be created automatically.

    **SQL Server 2000 or MSDE 2000 (MSDE can be acquired from Then, manually create SQL Server database named DotNetNuke (using Enterprise Manager or your tool of choice.)  Specify the default data provider setting in web.config ( <data defaultProvider="SqlDataProvider" > )  Set the properties for the SqlDataProvider in web.config to match your server ( ie. connectionString )

    Then browse to localhost/DotNetNuke in your web browser. The application will automatically execute the necessary database scripts.
    LVL 42

    Accepted Solution

    there is free MYSQL that  very often is using with PHP

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    The steps for moving the system databases to a new location are documented in the following technical article: However sometimes after the moving process is finished, though SQL i…
    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    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