How to find a database in SQL Server 2005?
Posted on 2005-04-26
I have successfully installed the DNN 3.0.13 using SQL Server 2005. I used NUKEleus to install it for me. However, when I log on the SQL Express Manager I can't see the DotNetNuke database on the Tree Browser.
I believe that the DotNetNuke database has been created on the 'Default' instance of the SQL Server and not the SQLEXPRESS instance. However, I can't log on the 'Default' instance of the SQL Express Manager to run queries. I searched and found the DotNetNuke.mdf database under the:
C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data
When I log on the SQL Express Manager I can only see the
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Does anyone know how to log on the 'default' instance to access the DotNetNuke dataabase if that is the case?
Thank you in advance.