nectarios777
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?
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?
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="SqlDataPr ovider" > ) 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.
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="SqlDataPr
Then browse to localhost/DotNetNuke in your web browser. The application will automatically execute the necessary database scripts.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.