IIS7 - Database Manager

IIS Database Manager Install Instructions

domainscanners — Mon, 09 Nov 2009 15:03:23 GMT

Hi,

I have 2 x Win Server 2008 R2 installs.

Server 1 runs IIS 7.5

Server 2 runs SQL 2008.

I would like to install the IIS Database Manager but am not sure where to install it. I thought this would be on the IIS box (Server 1) but I get an error saying "Microsoft SQL Server 2008 Management Objects is a pre-requisit for installing IIS Database Maanager." and privides a link to the objects. I follow the link, run the x64 Management Objects install and get another error saying "Setup is missing an installation prerequisit: Microsoft SQL Server 2008 System CLR Types. This gives me another link to where I am presented with a download page full of setup files of which im not sure of which one I am suppose to install.

Are there any clear instructions I can follow somewhere?

IIS7 + UNC SHARE and WRONG SQL SERVER CONNECTION

fbi1970 — Tue, 27 Oct 2009 08:30:56 GMT

The scenario is:

- IIS7.5 running on server A, publishing a UNC share from server B (configurated with properly authentication for remote share)

- web site is using a connection string to a SQL Server database using the "." server (i.e. the machine itself)

The bad behaviour is that the connection is made to the SQL Server on server B. It should be made to the one on server A.

Why it happens? The web site should run on server A, so the "." alias should connect to databases on server A, not the ones on server B.

Thanks in advance

MySql DB Manager provider

ma_khan — Mon, 13 Apr 2009 07:18:46 GMT

We do not have built-in support for MySql but does anyone know of a provider for the DB Manager???

Edit: do we have a hotkey available for Execute! for an SQL query?

Database Manager does not work for remote management

knagis — Fri, 25 Sep 2009 06:59:06 GMT

I installed the Database Manager 1.0 extension on the server. It shows up in the IIS7 manager and displays the list of databases etc.

But when I connect to the server using remote IIS7 manager, it asks me to download the binary, installs it, but when opening the Database Manager node, it throws an error:

---------------------------
Database Manager
---------------------------
There was an error while performing this operation.
Details:
Filename:
Error: The configuration section 'system.webServer/management/dbManager' cannot be read because it is missing schema
---------------------------
OK
---------------------------

OK, I found the solution - the remote management service had to be restarted.

Ability to connect to networked database server

mysorian — Sun, 20 Sep 2009 02:22:00 GMT

" IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network."

My IIS Manager could not discover networked servers. Of course, I presume it assumes a wired network, mine was on a WIFI network.

LocalSqlServer on Database connections

clustermaster — Thu, 23 Apr 2009 09:49:06 GMT

Hi all,

I have install the latest database manager and is really cool.

I have one problem i want to delete the LocalSqlServer on Database connections.

Even when i deleted if i log-off and log-on this appears again. I greated a new connection that works try again to delete but appears again.

Thank you.

Database Manager RC does not work when shared confiugration is enabled

wadapao — Fri, 26 Jun 2009 16:28:01 GMT

so here is my problem:

Microsoft IIS 7 for hosters recommend using shared configuration for iis. Good idea so I am using it.

Now Microsoft says use Database Manager for hosters which allows managing database easy but when I am trying to install it, it says it does not work when shared configuration is enabled on IIS.

how are we supposed to use Database Manager if its not going to work when shared configuration is enabled. Clarify ASAP

Thanks

The IIS Database Manager RC is here...

SaadL — Fri, 10 Apr 2009 17:30:53 GMT

The IIS Database Manager RC has been released. Check it out at: http://www.iis.net/extensions/DatabaseManager.

Some of the features are:

Add, rename, drop, and edit tables
View and manage primary keys, indexes and foreign keys
Data editing
Establish connections to multiple databases
Create and execute queries
Create, alter and delete stored procedures
Create, alter and delete views
Manage stored procedures
Manage both local and remote database from your machine
IIS 7.0 Manager provides remote management capabilities with a clean firewall-friendly option for managing a remote SQL Server
Exposes a public extensibility platform that enables the development of providers to support other databases
Compatible with SQL 2008 and 2005

If you have any questions, comments, asks for new features, just post on this forum and let us know. DBMan is here to help :)!