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

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.
0
nectarios777
Asked:
nectarios777
  • 3
  • 3
1 Solution
 
arbertCommented:
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...
0
 
nectarios777Author Commented:
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?
0
 
arbertCommented:
when you install, it asks for the server name--use the server\instance name.....

0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
arbertCommented:
0
 
nectarios777Author Commented:
Thanks a lot arbert
0
 
nectarios777Author Commented:
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?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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