Link to home
Start Free TrialLog in
Avatar of nectarios777
nectarios777Flag for United Kingdom of Great Britain and Northern Ireland

asked on

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?
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

check what MSSQL... services do you have? - see Win services..
Are you sure that your database(s) created in 2005?
see
http://www.dotnetnuke.com/About/Documentation/FrequentlyAskedQuestions/tabid/546/Default.aspx

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.
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial