OK I presume you have a different login for each database then and thus can only access one at a time. You can connect to same servers with different names by using aliases.
To use an alias run the "client network utility" form your sql server folder. Add a new alias Select TCP/IP Type a name for the alias, and eneter the REAL server IP or FQDN in the Server field. You can now add a new SQL server connection to Enterprise manager using this alias. Russ -----Original Message----- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: 12 December 2005 23:26 To: CF-Talk Subject: RE: Enterprise manager Ok, the physical server is hosted at my webhost. For that server, I now have 2 databases setup - one which I connect to online using enterprise manager. I wish to be able to connect to the second db also - so need to add a new server registration to the webhost server group. The error occurs because I cannot have 2 server registrations with the same name. Hope this helps a little. mike -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 12:04 p.m. To: CF-Talk Subject: RE: Enterprise manager I'm not really sure what your trying to say. Are you referring to physical server, or instances of SQL server. Neither of these can be created via enterprise manager. A new server requires hardware and an actual machine. A new instance requires you install sql server again and choose to deploy a new instance. Russ -----Original Message----- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: 12 December 2005 22:46 To: CF-Talk Subject: Enterprise manager Hi guys, I use sql enterprise manager to connect to my hosts sql database. Currently I have one database per server. I now need to add a new database to an existing server, but get the error message that the server name already exists. I am not sure how I can get round this as I need the server name to stay consistent for both databases? Any help would be appreciated. mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226908 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54