asked on

How to find a database in SQL Server 2005?

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.

arbert

You installed SQL Express, you should know the SA password that you created and should be able to logon to the instance....If you're having problems, force dotnetnuke to install on the other instance...

nectarios777

ASKER

Yes, I know the 'sa' password and I log on to the instance but the database is not visible. I believe what you suggest of forcing the DotNetNuke to install on the other instance might be the solution, but how can I do that?

arbert

when you install, it asks for the server name--use the server\instance name.....

ASKER CERTIFIED SOLUTION

arbert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nectarios777

ASKER

Thanks a lot arbert

nectarios777

ASKER

I have just gave it several tries but didn't make it work. The problem is how to enter the SQL Express instance name to the server textbox of the NUKEleus installer.
I entered "(local)/SQLExpress" and other formats but none of them seem to work. Do you know the correct string format?