You can always set up an alias for the 2nd instance of the server and then register the alias in EM.
On 8/15/07, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Who can recommend a SQL Management utility other than Enterprise Manager > to manage multiple Microsoft SQL Databases and not having multiple > pieces installed like EMS SQL Management Studio for SQL Server ( > http://www.sqlmanager.net/en/products/studio/mssql ). > > Don't get me wrong they have a nice utility but I can not afford > spending $500+ on a utility to manage databases on a shared hosting > provider. > They have everything is various applications so unless you buy the > studio, you would need SQL Manager, Data Export, Data Import, SQL Query, > and others just to have a complete package like MS SQL Servers > Enterprise Manager. > > Only reason I am looking else where is that I want to be able to > register more than one database with the same host. > > ex: > host: sql.somehost.com > username: Client_A_Name > password: Client_A_Pass > database: clientA > > host: sql.somehost.com > username: Client_B_Name > password: Client_B_Pass > database: clientB > > Notice the same host... EM will not allow you to register more than one > host. Since the databases are unique to the client, I want to keep them > separated. > > I also looked at Aqua Data Fold, which isn't bad either. There is alot > to that program and well running at $400 per user still up there is > cost. > > I am sure there is something a bit cheaper. > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
