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:226878 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
