Solved

How do I find the database in my FTP directory?

Posted on 2011-03-19
7
241 Views
Last Modified: 2012-05-11
Hi,

I've just taken over a web project from another web developer who's method of organizing the server had no rhyme or reason.   Everything's a mess, with groups of files in the last places you'd expect (I'm sure many of you have experience with this).

That said, how could I find the original database?  I have a copy of the source code, I'm running Visual Studio 2010, and have FTP access as well.  Would I run a search from a particular program?  

Any assistance would be greatly appreciated.

Thanks,
Dan
0
Comment
Question by:captainred
  • 3
  • 2
  • 2
7 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 35172851
The source code, maybe web.config, will have the connection string that should tell you where the database is.  Database are Not usually under the web root with the HTML files.
0
 
LVL 7

Expert Comment

by:Maverick_Cool
ID: 35173041
also Check in code for dataSource, if the code connects via a 'system data source' or 'user data source'.
In that case you should go to iis or system control panel to get details of connection string.
If it is directly in connection string, then use that url to locate your database.
0
 

Author Comment

by:captainred
ID: 35173250
Is there a way to search for files in the FTP with specific extensions, specifically MDF in this case?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Expert Comment

by:Maverick_Cool
ID: 35173269
use a ftp client like FileZilla, it has search functionality with recursive option
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 250 total points
ID: 35173294
There may be a way to search for it but it shouldn't be there with the rest of the files.  That would allow people to download your complete database.  No hosting company would support it being there.  Look first at 'web.config' and then at files that use the database to find the location.  Many hosting companies put the MS SQL and MySQL files elsewhere, often on a different server.  That would be a common if not standard practice.
0
 

Author Comment

by:captainred
ID: 35173356
I found the web.config file.  You're right - it's loaded with references to the database.  Many thanks!
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 35173467
You're welcome, thanks for the points.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now