Chris
Chris

Reputation: 641

Managing SQL Server connected to existing DotNetNuke website

Sorry if this question isn't "programmery" enough. Before my time at the company they paid for a very expensive website written in asp.net and dotnetnuke. Absolutely terrible but there's very little that can be done about that now. They won't give us access to the SQL Server for some bizarre reason but they've given us FTP access.

Is there some way I can install a database manager (like phpMyAdmin) using FTP? I think I've found the username and password but I'm not familiar with asp so it's quite a confusing system.

Help would be greatly appreciated.

Upvotes: 1

Views: 390

Answers (2)

Ian Robinson
Ian Robinson

Reputation: 16944

If you have the host credentials for the DotNetNuke website, you can log in and query the database through the built in SQL window in the DNN site. It doesn't give you much help (no browsing, no intellisense) but it does let you read and write to the database (assuming the application user has permissions - which typically it does or the DNN site doesn't really function all that well). This may be helpful depending on what you need to do (which wasn't really clear from your post).

Upvotes: 0

AUSteve
AUSteve

Reputation: 3248

If know the connection string for the SQL Server you don't need to install anything on the server. MS SQL Server Management Studio (and many other database management tools) can open remote databases so you can run them on your own PC. The fact that a DNN website runs from the SQL Server is not relevant.

Upvotes: 1

Related Questions