Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

How to find a database in SQL Server 2005?

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?
  • 3
1 Solution
Eugene ZCommented:
check what MSSQL... services do you have? - see Win services..
Eugene ZCommented:
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 http://support.microsoft.com/default.aspx?kbid=239114) The database file ( DotNetNuke.mdb.resources ) will be created automatically.

**SQL Server 2000 or MSDE 2000 (MSDE can be acquired from http://www.asp.net/Tools/redir.aspx?path=msde) 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.
Eugene ZCommented:
there is free MYSQL that  very often is using with PHP


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now