Re: Enterprise Manager gone?
On 2/27/07, Dinner [EMAIL PROTECTED] wrote: I'll do a diff of the two and see if I can narrow it down any further. Probably just a config var or something. For Posterity! :d Crazy as it sounds, the Enterprise Manager was located in a folder called entman-- far out stuff, I tell you what! Copying it to the instance you want it in seems to be all that's needed to get it back. Chalk another one up to quick fingers, slow mind! |] ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Enterprise Manager gone?
Turns out the enterprise manager is stored in CFIDE. Don't know why, perhaps it's because I started with an external webserver vs. the built-in one- but somewhere along the line the CFIDE dir I used got the Ent Man whacked outta it (I had shared the one CFIDE dir). Copying the CFIDE from another server that still had the Ent Man put it back. I'll do a diff of the two and see if I can narrow it down any further. Probably just a config var or something. For Posterity! :d On 2/27/07, Dinner [EMAIL PROTECTED] wrote: Howdy! I tried setting up instances using the CF Admin, and I think I must have done something funky to the web connector or something, because the Enterprise Manager of the original cfusion instance isn't there anymore. I left it pristine y todo, IIRC (I set up one instance, besides the original, and hadn't gone back since). If anything, I might have shut off the built in webserver in the jrun.xml file. Could I have done something else? Anyone know why my Enterprise Manager would disappear from my original, multi-server j2ee installed instance, after letting me set up one other instance prior? I can do it the old skool way, via JRun admin, or by hand, but I was wondering what it was I did to knock it out. Thanks for any guesses, etc.! PS- using Apache and vhosts- both instances work fine (I'd had the cfusion instance turned off) there's just no Enterprise Manager where once there was one. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Enterprise Manager in a shared hosting situation
Is it a security risk to allow site owners to access their databases in a shared hosting arrangement by using Enterprise Manager? (Obviously I'm talking a windows box and MS Sqlserver2000+) I would have thought it was no more of a risk than allowing users to access their databases with other tools, no?? I'm looking at a new hosting company and they're terrific in many respects, but they dont allow access to SQLServer databases except by the on line browser-based SQLManager and/or ColdFusion. To that's going to mean writing export routines to export data to CSV files or something, ftp it to the site, then run an app on the site to import the data to the SQL that way. It's a security risk to allow direct connections to a remote database over a public network. Using Enterprise Manager itself is no more of an inherent risk than any other tool that does this, but the hosting company in question doesn't allow you to access your databases over the network at all, apparently. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231419 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Enterprise Manager in a shared hosting situation
I think the issue is not just Enterprise Manager, but opening up ports 1433 and 1434 to the internet. I have hosted situations which allow that access, and to be honest, it bothers me a little...the slammer worm made a lot of people more wary of having those ports open. Microsoft recommends that they not be open http://www.microsoft.com/sql/prodinfo/previousversions/securingsqlserver.mspx On 2/6/06, Mike Kear [EMAIL PROTECTED] wrote: Is it a security risk to allow site owners to access their databases in a shared hosting arrangement by using Enterprise Manager? (Obviously I'm talking a windows box and MS Sqlserver2000+) I would have thought it was no more of a risk than allowing users to access their databases with other tools, no?? I'm looking at a new hosting company and they're terrific in many respects, but they dont allow access to SQLServer databases except by the on line browser-based SQLManager and/or ColdFusion To that's going to mean writing export routines to export data to CSV files or something, ftp it to the site, then run an app on the site to import the data to the SQL that way. It's a pain because it's very convenient to use a DTS package to upload a whole bunch of data automatically I wouldnt be able to do this with this hosting company. -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231421 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Enterprise Manager in a shared hosting situation
Thanks Dave, No they dont allow direct access to the databases ... over the network. Is this normal? I know we all want to have our databases safe from hacking as far as it's possible, but this sems like it's unworkable.How do other people upload data and copy data down from sites under this kind of situation?Or does everyone just do everything on line? Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month It's a security risk to allow direct connections to a remote database over a public network. Using Enterprise Manager itself is no more of an inherent risk than any other tool that does this, but the hosting company in question doesn't allow you to access your databases over the network at all, apparently. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231422 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Enterprise Manager in a shared hosting situation
They could get round this by using some other port couldnt they? I know allowing any access from outside opens a risk, but we have to have some kind of access to do our work, upload and download data, dont we? Or am i being blinkered by the fact that using DTS and EntMgr is so convenient and I just dont want to do anything the hard way? Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com On 2/7/06, Jim Wright [EMAIL PROTECTED] wrote: I think the issue is not just Enterprise Manager, but opening up ports 1433 and 1434 to the internet. I have hosted situations which allow that access, and to be honest, it bothers me a little...the slammer worm made a lot of people more wary of having those ports open. Microsoft recommends that they not be open http://www.microsoft.com/sql/prodinfo/previousversions/securingsqlserver.mspx ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231424 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Enterprise Manager in a shared hosting situation
They could get round this by using some other port couldnt they? No. I know allowing any access from outside opens a risk, but we have to have some kind of access to do our work, upload and download data, dont we? Yes, and we all have to decide how to balance security against convenience. You may well decide to choose another, less security-conscious vendor. I probably would, myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231427 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Enterprise Manager in a shared hosting situation
No, you're not blinkered, the shared hosting I have allows access with EM and I'd hate not to have it! Ade -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 06 February 2006 15:06 To: CF-Talk Subject: Re: Enterprise Manager in a shared hosting situation They could get round this by using some other port couldnt they? I know allowing any access from outside opens a risk, but we have to have some kind of access to do our work, upload and download data, dont we? Or am i being blinkered by the fact that using DTS and EntMgr is so convenient and I just dont want to do anything the hard way? Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com On 2/7/06, Jim Wright [EMAIL PROTECTED] wrote: I think the issue is not just Enterprise Manager, but opening up ports 1433 and 1434 to the internet. I have hosted situations which allow that access, and to be honest, it bothers me a little...the slammer worm made a lot of people more wary of having those ports open. Microsoft recommends that they not be open http://www.microsoft.com/sql/prodinfo/previousversions/securingsqlserver.msp x ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231429 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Enterprise Manager in a shared hosting situation
Well they could change the port, it would at least mean that automated attacks don't find the right port. No? Ade -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 06 February 2006 15:14 To: CF-Talk Subject: RE: Enterprise Manager in a shared hosting situation They could get round this by using some other port couldnt they? No. I know allowing any access from outside opens a risk, but we have to have some kind of access to do our work, upload and download data, dont we? Yes, and we all have to decide how to balance security against convenience. You may well decide to choose another, less security-conscious vendor. I probably would, myself. Dave Watts, CTO, Fig Leaf Software ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231431 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
RE: Enterprise Manager in a shared hosting situation
Is this normal? I know we all want to have our databases safe from hacking as far as it's possible, but this sems like it's unworkable. How do other people upload data and copy data down from sites under this kind of situation? Or does everyone just do everything on line? I have very little experience with shared hosting environments. Typically, to access our clients' database servers, we either (a) go onsite, or (b) connect via VPN, or (c) connect to the web server (using RDP or VNC through SSH or something along those lines) then use tools installed on the web server console to connect to the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231433 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Enterprise Manager in a shared hosting situation
Well they could change the port, it would at least mean that automated attacks don't find the right port. No? Yes, since automated attacks have (so far) only used the default SQL Server ports. That's fine if your only concern is automated attacks, I guess. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231442 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
RE: Enterprise Manager in a shared hosting situation
No, you're not blinkered, the shared hosting I have allows access with EM and I'd hate not to have it! We've had this discussion before on this list, and it always comes down to customer service vs. security. Hosts that are more concerned about security won't allow it. Other hosts will allow it, and tell the customer they must use strong passwords. If there is a problem, only one customer loses their data and it's their fault, right? This assumes the DB vendor has a bug free product, which nobody has. Liability is always a problem. We all know there are idiots out there that would sue a glass maker when they brake their hand from punching a window. --- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231445 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
Re: Enterprise Manager in a shared hosting situation
Our ISP allows Ent Mngr on shared hosting (we've never had a security issue)they lock down connections by IP (a bit of a pain at timesbut better than most ISPs). So you get DTS, which as you said is dang handy ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 06, 2006 6:40 AM Subject: Enterprise Manager in a shared hosting situation Is it a security risk to allow site owners to access their databases in a shared hosting arrangement by using Enterprise Manager? (Obviously I'm talking a windows box and MS Sqlserver2000+) I would have thought it was no more of a risk than allowing users to access their databases with other tools, no?? I'm looking at a new hosting company and they're terrific in many respects, but they dont allow access to SQLServer databases except by the on line browser-based SQLManager and/or ColdFusion To that's going to mean writing export routines to export data to CSV files or something, ftp it to the site, then run an app on the site to import the data to the SQL that way. It's a pain because it's very convenient to use a DTS package to upload a whole bunch of data automatically I wouldnt be able to do this with this hosting company. -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231447 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
Re: Enterprise Manager in a shared hosting situation
So Bryan does that mean for practical purposes you really have to have a static IP where you're connecting from so it can be in the table of allowed ips? All isps in Australia dump your connection every so often so you can't keep the same ip for an extended period, unless you pay extra for a static ip. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com On 2/7/06, Bryan Stevenson [EMAIL PROTECTED] wrote: Our ISP allows Ent Mngr on shared hosting (we've never had a security issue)they lock down connections by IP (a bit of a pain at timesbut better than most ISPs). So you get DTS, which as you said is dang handy ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231450 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
Re: Enterprise Manager in a shared hosting situation
So Bryan does that mean for practical purposes you really have to have a static IP where you're connecting from so it can be in the table of allowed ips? All isps in Australia dump your connection every so often so you can't keep the same ip for an extended period, unless you pay extra for a static ip. Yep...that's exactly the case. We have 2 IPs stored with themour office IP (static) and my home IP (not static, but my router is always on and tends to keep the same IP when the 4 day lease expires and is renewed). I alos forgot to mention that they dropped port 1433 for another port (not perfectbut not as aobvious as leaving 1433 open) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231451 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
Re: Enterprise Manager in a shared hosting situation
So Bryan does that mean for practical purposes you really have to have a static IP where you're connecting from so it can be in the table of allowed ips? All isps in Australia dump your connection every so often so you can't keep the same ip for an extended period, unless you pay extra for a static ip. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com On 2/7/06, Bryan Stevenson [EMAIL PROTECTED] wrote: Our ISP allows Ent Mngr on shared hosting (we've never had a security issue)they lock down connections by IP (a bit of a pain at timesbut better than most ISPs). So you get DTS, which as you said is dang handy ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231452 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
Re: Enterprise Manager in a shared hosting situation
Mike Kear wrote: Is this normal? I know we all want to have our databases safe from hacking as far as it's possible, but this sems like it's unworkable.How do other people upload data and copy data down from sites under this kind of situation? Tunnel the connection over SSH or VPN. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231477 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
Re: Enterprise Manager in a shared hosting situation
In addition to the automated attacks, you need to think about the attacks from within...I'm not sure if any recent SQL2000 SPs have fixed this, or if it is true in SQL2005, but in the past a user in enterprise manager could see the names all of the other databases that are on the box, even if they don't have rights to them. At that point an attacker (who is another user on the box...do you trust those 100+ strangers who are on their with you?) has the database name, and most likely the username (since many hosts have the habit of naming the database and the database user the same thing). With that, they can start a dictionary attack on your database...if the host isn't logging failed logins, or isn't paying attention to the logs, that may be successful. So, if you are using a host that allows direct access to a shared SQL box, I would also recommend: 1. Ask for the database username to be something different from the database name 2. Make sure you have a very secure password -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231492 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Enterprise Manager in a shared hosting situation
I'm with Mike on this one (same provider) and have been using Enterprise Manager for years with no issues and a full understanding of the security implications. EM can be slow but the new EM for SQL 2005 seems to be a bit better - not that I will need to use it apart from local db's it seems. One thing I do not like about EM is you get a full list of databases on the server and not just your own so that could be a security weakness if people do not have strong passwords. Mind you the provider has Northwind installed on a live server. Even on my dev boxes I remove it. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231539 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Enterprise Manager in a shared hosting situation
Holy Cow!, I've experienced the complete opposite with SQL 2005. The EM takes forever to do anything. Also, I was trying to debug why some of my queries went from 20ms to ~20s to run. Come to find out, if the table was open in data or design view in EM, it was slowing down access to that table. I'm really crossing my fingers for some better performance soon. On 2/6/06, Peter Tilbrook [EMAIL PROTECTED] wrote: I'm with Mike on this one (same provider) and have been using Enterprise Manager for years with no issues and a full understanding of the security implications. EM can be slow but the new EM for SQL 2005 seems to be a bit better - not that I will need to use it apart from local db's it seems. One thing I do not like about EM is you get a full list of databases on the server and not just your own so that could be a security weakness if people do not have strong passwords. Mind you the provider has Northwind installed on a live server. Even on my dev boxes I remove it. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231545 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
RE: Enterprise manager
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
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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226874 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
RE: Enterprise manager
I think what you need to do is create another alias to the same server using the Client Network Utility and add the alias to Enterprise Manager, rather than the actual server. Then you can have multiple aliases with different login details pointing to the same server. Bye! -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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226875 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
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: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
Re: Enterprise manager
Mikenot sure if this will workbut perhaps setup a new SQL Server Group and register the duplicate named server in there?? Perhaps if it's in another group then the name conflict will go away. HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226882 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Enterprise manager
I will give that a try bryan. mike -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 12:29 p.m. To: CF-Talk Subject: Re: Enterprise manager Mikenot sure if this will workbut perhaps setup a new SQL Server Group and register the duplicate named server in there?? Perhaps if it's in another group then the name conflict will go away. HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226886 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
RE: Enterprise manager
Hmmm... Same error occurring - server name already exists. mike -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 12:29 p.m. To: CF-Talk Subject: Re: Enterprise manager Mikenot sure if this will workbut perhaps setup a new SQL Server Group and register the duplicate named server in there?? Perhaps if it's in another group then the name conflict will go away. HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226887 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
RE: Enterprise manager
Did you try creating another alias in the Client network Utility? Ade -Original Message- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: 12 December 2005 23:48 To: CF-Talk Subject: RE: Enterprise manager Hmmm... Same error occurring - server name already exists. mike -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 12:29 p.m. To: CF-Talk Subject: Re: Enterprise manager Mikenot sure if this will workbut perhaps setup a new SQL Server Group and register the duplicate named server in there?? Perhaps if it's in another group then the name conflict will go away. HTH Cheers Bryan Stevenson B.Comm. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226890 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
Re: Enterprise manager
Why can't they permission it so your single login can access both db's? You would be granted access to both db's from the one E-Mgr login. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| 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:226891 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
RE: Enterprise manager
Thanks guys - this worked a treat !!! mike -Original Message- From: Ryan Sabir [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 1:11 p.m. To: CF-Talk Subject: RE: Enterprise manager I think what you need to do is create another alias to the same server using the Client Network Utility and add the alias to Enterprise Manager, rather than the actual server. Then you can have multiple aliases with different login details pointing to the same server. Bye! -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:226893 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
RE: Enterprise Manager or Query Analyzer like tool for Oracle
Aquadata studio (http://aquafold.com/) is a pretty nice little tool that allows you to have connection to several different types of DBs. Doesn't have quite as much as TOAD, but is handy if you have several projects spread over several DBS and are like me and need to swap between them at a moments notice. -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 4:59 PM To: CF-Talk Subject: Enterpise Manager or Query Analyzer like tool for Oracle Does anyone know if Oracle or some 3rd party has tools like Enterprise Manager or SQL Query Analyzer? We are trying to port some of our tools to Oracle from MS SQL and are currently using SQL*Plus (command line thingy) and some built in web interface, both of which are horrible. jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214103 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
RE: Enterprise Manager / SQL Server
Just install sql without the server, it's under the custom install option. Good luck, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]] |Sent: Monday, November 19, 2001 4:34 PM |To: CF-Talk |Subject: OT: Enterprise Manager / SQL Server | | |Hi - | |I'm wondering if Enterprise Manager for SQL Server is |available from Microsoft as a free or low cost download. If |anyone has details or suggestions, please let me know. | |Thanks, | | ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager / SQL Server
Icks That's what I was afraid of you saying. People don't react well when I tell them they need to download a 300MB+ installer to install just a small subset of the files they actually download. Oh well :-(. Thanks for the info anyhow. -Jay -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 4:34 PM To: CF-Talk Subject: RE: Enterprise Manager / SQL Server Just install sql without the server, it's under the custom install option. Good luck, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]] |Sent: Monday, November 19, 2001 4:34 PM |To: CF-Talk |Subject: OT: Enterprise Manager / SQL Server | | |Hi - | |I'm wondering if Enterprise Manager for SQL Server is |available from Microsoft as a free or low cost download. If |anyone has details or suggestions, please let me know. | |Thanks, | | ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager connection to SQL Server
To check the port in the client network utility, on the General Tab, make sure TCP/IP is an enabled protocol and click the properties button. The only option there is port number. Also, for each connection in the client network utility, You're mapping a server alias to the server's address. Under the alias tab, make sure Dynamically determine port is unchecked and you should be able to change the port if need be. Hope this helps =) -Original Message- From: JoshMEagle [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 5:12 AM To: CF-Talk Subject: RE: Enterprise Manager connection to SQL Server I had a similar issue recently ... trying to connect to our SQL Servers from a remote location. I was using the IP Address of the servers to connect, but this wouldn't work, I had to use the actual name (such as SQL.MYSITE.COM) instead of the IP ... then it connected flawlessly. I suppose it should work with the IP Address and I'm no expert in this field, so it may just be an anomaly here, but I'd give it a whirl if I were you. I'm sure the SQL experts will have a much more thorough answer for you, however. Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 2:14 PM To: CF-Talk Subject: Enterprise Manager connection to SQL Server Newcomer to SQL Server... I'm attempting to use Enterprise Manager to connect via an ISP to a SQL Server 2000 db on a shared host. I was successful in doing that on Friday, but after installing MSDE on my Win98 dev laptop, the connection always failed (Server does not exist or access denied). I've uninstalled MSDE and reinstalled Enterprise Mgr, still to no avail. I CAN successfully ping the db, and I've confirmed that the Client Network Utility is set up to use TCP/IP as the protocol. My hosting service says I should confirm that I can use Port 1433, but I'm unsure how to do that or how to further diagnose what's happening. Any help appreciated! Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager connection to SQL Server
I had a similar issue recently ... trying to connect to our SQL Servers from a remote location. I was using the IP Address of the servers to connect, but this wouldn't work, I had to use the actual name (such as SQL.MYSITE.COM) instead of the IP ... then it connected flawlessly. I suppose it should work with the IP Address and I'm no expert in this field, so it may just be an anomaly here, but I'd give it a whirl if I were you. I'm sure the SQL experts will have a much more thorough answer for you, however. Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 2:14 PM To: CF-Talk Subject: Enterprise Manager connection to SQL Server Newcomer to SQL Server... I'm attempting to use Enterprise Manager to connect via an ISP to a SQL Server 2000 db on a shared host. I was successful in doing that on Friday, but after installing MSDE on my Win98 dev laptop, the connection always failed (Server does not exist or access denied). I've uninstalled MSDE and reinstalled Enterprise Mgr, still to no avail. I CAN successfully ping the db, and I've confirmed that the Client Network Utility is set up to use TCP/IP as the protocol. My hosting service says I should confirm that I can use Port 1433, but I'm unsure how to do that or how to further diagnose what's happening. Any help appreciated! Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager connection to SQL Server
The SQL Enterprise Manager will default to port 1433, so unless you changed it, I wouldn't worry about that. Try re-establishing the connection with the Client Network Utility. Also, try using a different authentication routine. For example, login to Win98 as the username/password combo you would use to connect to the SQL server and then try using trusted connection instead of SQL authentication. If all else fails, call the ISP and have them walk you through it. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 11:14 AM To: CF-Talk Subject: Enterprise Manager connection to SQL Server Newcomer to SQL Server... I'm attempting to use Enterprise Manager to connect via an ISP to a SQL Server 2000 db on a shared host. I was successful in doing that on Friday, but after installing MSDE on my Win98 dev laptop, the connection always failed (Server does not exist or access denied). I've uninstalled MSDE and reinstalled Enterprise Mgr, still to no avail. I CAN successfully ping the db, and I've confirmed that the Client Network Utility is set up to use TCP/IP as the protocol. My hosting service says I should confirm that I can use Port 1433, but I'm unsure how to do that or how to further diagnose what's happening. Any help appreciated! Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager
Kinley, You may be having a problem . that your client is trying to use "named pipes" to connect to the SQL Server ...since you said by IP address you probably want to use TCP/IP to connect to the server. Take a look at the "Client Network Utility" to make sure that you can use TCP IP to connect. And your Not being able to select the connection protocol when I'm registering a server just seems silly. It's one of the annoyances I've had with SQL server for a while now. To get the Register Server wizard Click on the root SQL group (named "SQL Server Group") then choose Tools from the menu bar --- Wizards... (again silly way to have to do things) -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: Kinley Pon [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 04, 2001 2:47 PM To: CF-Talk Subject: OT: Enterprise Manager I have been frustated out of my brains...I foolishly selected to have the wizard for registering a new SQL Server turned off. So from that point on, each time I right-click a server and then click "New SQL Server Registration", I get the "Registered SQL Server Properties" dialog box instead. Within the dialog, the dropdown list does not have anything available to select from except "(local)", so I enter the IP address of the server I wish to register. This is not working for me. I get a timeout when attempting to connect. I have used the wizard and that works beautifully. But how do I re-set my Enterprise Manager so that I can have access to the wizard again? I have tried uninstalling and installing Enterprise Manager several times but it is storing the original setup somewhere on my workstation. Really frustrated... Can anyone help...please? - Kinley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager
i'm not sure if i fully understand the problem...but if you're trying to connect to a remote server, have you tried setting it up using the client network utility? -Original Message- From: Kinley Pon [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 04, 2001 11:47 AM To: CF-Talk Subject: OT: Enterprise Manager I have been frustated out of my brains...I foolishly selected to have the wizard for registering a new SQL Server turned off. So from that point on, each time I right-click a server and then click "New SQL Server Registration", I get the "Registered SQL Server Properties" dialog box instead. Within the dialog, the dropdown list does not have anything available to select from except "(local)", so I enter the IP address of the server I wish to register. This is not working for me. I get a timeout when attempting to connect. I have used the wizard and that works beautifully. But how do I re-set my Enterprise Manager so that I can have access to the wizard again? I have tried uninstalling and installing Enterprise Manager several times but it is storing the original setup somewhere on my workstation. Really frustrated... Can anyone help...please? - Kinley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager (SQL 7.0) For SQL 2000
You can install just the Enterprise Manager using the SQL Server Install CD. I believe you choose 'install server', then 'install only server tools' or something to that effect. As I understand it, if you have CALs for SQL Server, then you are allowed to install Enterprise Manager on those machines. I'm certainly no licensing lawyer, so if anyone knows otherwise, let me know :) I still had trouble connecting to a SQL 2000 server from a remote machine; however. I'm going to try some of the suggestions. Norman Elton Information Technology College of William Mary -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 16, 2000 1:20 AM To: CF-Talk Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 Guys, I don't know what to say. I am using TCP IP and this isn't the issue its a version issue that I Don't even know if it can be resolved. I don't know if the server has a setting which says let lower version clients connect. I don't know where to allow people to download SQL 2k Enterprise manager. Any ideas?! Thanks, Neil - Original Message - From: "Chris Meier" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:35 PM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager (SQL 7.0) For SQL 2000
I need to find a website or a page on Microsoft's site where customers can download the client for their use. With SQL 7 you would download the trial and then you would have the client. As for licensing its based on per a processor. Thanks, Neil - Original Message - From: "Norman Elton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 16, 2000 7:32 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 You can install just the Enterprise Manager using the SQL Server Install CD. I believe you choose 'install server', then 'install only server tools' or something to that effect. As I understand it, if you have CALs for SQL Server, then you are allowed to install Enterprise Manager on those machines. I'm certainly no licensing lawyer, so if anyone knows otherwise, let me know :) I still had trouble connecting to a SQL 2000 server from a remote machine; however. I'm going to try some of the suggestions. Norman Elton Information Technology College of William Mary -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 16, 2000 1:20 AM To: CF-Talk Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 Guys, I don't know what to say. I am using TCP IP and this isn't the issue its a version issue that I Don't even know if it can be resolved. I don't know if the server has a setting which says let lower version clients connect. I don't know where to allow people to download SQL 2k Enterprise manager. Any ideas?! Thanks, Neil - Original Message - From: "Chris Meier" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:35 PM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager (SQL 7.0) For SQL 2000
Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager (SQL 7.0) For SQL 2000
The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager (SQL 7.0) For SQL 2000
Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager (SQL 7.0) For SQL 2000
Guys, I don't know what to say. I am using TCP IP and this isn't the issue its a version issue that I Don't even know if it can be resolved. I don't know if the server has a setting which says let lower version clients connect. I don't know where to allow people to download SQL 2k Enterprise manager. Any ideas?! Thanks, Neil - Original Message - From: "Chris Meier" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:35 PM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager Win 2000
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Claude, It's probably that you don't have the right Client Network settings to connect to SQL server. Try this... Start -- Programs -- Microsoft SQL Server -- Client Network Utility Make sure your default Network Library is TCP/IP and not named pipes. Aaron Johnson, MCSE, MCP+I MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] ___ "Never forget that only dead fish swim with the stream." -- Malcolm Muggeridge ___ - -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 13, 1997 5:21 PM To: CF-Talk Subject: Enterprise Manager Win 2000 Has anyone experienced problems connecting to their server host using enterprise manager I was able to connect to my host sql server space without any problems under win 98 but since I have upgraded to win 2000 I am not able to connect successfully it generates error saying that it is unable to create file or else the server is not running etc etc any suggestions would as always be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager Win 2000
Claude: Are you using a devlopment SQL Server on the same machine that you upgraded or are you connecting to a server? If you have the server on your machine, make sure that the MSSQLSERVER is started in the services. Also, I would recommmend backing up your data, reformatting, splitting your computer into a data and a program/os partition and do a fresh install of 2000. I never trust upgrades. If you are connecting to a remote SQL Server through enterprise manager, try to delete the connection and then re create it. That works a lot for me. Greg - Original Message - From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 13, 1997 5:21 PM Subject: Enterprise Manager Win 2000 Has anyone experienced problems connecting to their server host using enterprise manager I was able to connect to my host sql server space without any problems under win 98 but since I have upgraded to win 2000 I am not able to connect successfully it generates error saying that it is unable to create file or else the server is not running etc etc any suggestions would as always be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager Win 2000
I am running win2k and using enterprise manger to connect to a sql box on nt4.0. and a sqlbox on advancedwin2k server. I have been doing this for sometime with no problems. Thanks [EMAIL PROTECTED] 12/14/00 09:46AM Claude: Are you using a devlopment SQL Server on the same machine that you upgraded or are you connecting to a server? If you have the server on your machine, make sure that the MSSQLSERVER is started in the services. Also, I would recommmend backing up your data, reformatting, splitting your computer into a data and a program/os partition and do a fresh install of 2000. I never trust upgrades. If you are connecting to a remote SQL Server through enterprise manager, try to delete the connection and then re create it. That works a lot for me. Greg - Original Message - From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 13, 1997 5:21 PM Subject: Enterprise Manager Win 2000 Has anyone experienced problems connecting to their server host using enterprise manager I was able to connect to my host sql server space without any problems under win 98 but since I have upgraded to win 2000 I am not able to connect successfully it generates error saying that it is unable to create file or else the server is not running etc etc any suggestions would as always be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager Win 2000
yep. increase the timeout. -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 13, 1997 2:21 PM To: CF-Talk Subject: Enterprise Manager Win 2000 Has anyone experienced problems connecting to their server host using enterprise manager I was able to connect to my host sql server space without any problems under win 98 but since I have upgraded to win 2000 I am not able to connect successfully it generates error saying that it is unable to create file or else the server is not running etc etc any suggestions would as always be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists