Colby, John
JColby at dispec.com
Mon Oct 11 13:55:06 CDT 2004
ooooohhhh cool. thanks John W. Colby The DIS Database Guy -----Original Message----- From: Eric Barro [mailto:ebarro at afsweb.com] Sent: Monday, October 11, 2004 2:32 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Problems registering database John, This trick might help. Put an entry in your HOSTS file (one each machine that runs SQL server) that corresponds to the SQL server's IP and name eg. 192.168.xxx.xxx Neo2 192.168.xxx.xxx Neo1 192.168.xxx.xxx Soltek1 192.168.xxx.xxx ColbyM6805 192.168.xxx.xxx MaryDesktop Everytime you register SQL server using EM it won't have difficulty finding the correct SQL server. I learned this trick a while back when all of a sudden I could not register the SQL server successfully. Prior to that I didn't have any issues. Something changed (possibly a SQL server service pack) and EM stopped recognizing SQL server registrations the "old way". I haven't had any issues with registering SQL server using EM once I added an entry for each SQL server machine I wanted to register in the HOSTS file. Eric -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Colby, John Sent: Monday, October 11, 2004 11:02 AM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer] Problems registering database Francisco, Thanks for that. I am not running the XP firewall (never will) but I am running a firewall. However I disabled all the firewalls for the purposes of testing this stuff and that didn't help. Having the port number is important though for setting up my firewalls so I appreciate that. The problem with using SQL Server authentication is that as soon as I get into that I have to set up users (none exist at this point) and that brings up what rights they need. There are a TON of them and I don't really understand that stuff. One of the reasons I specifically asked for "step by step". John W. Colby The DIS Database Guy -----Original Message----- From: Francisco Tapia [mailto:fhtapia at gmail.com] Sent: Monday, October 11, 2004 1:10 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Problems registering database Not only that, you are running XP SP2 IIRC from one of your ealier posts... please check that your software firewall is allowing sql server to get through it default listens on port 1433, so please make sure that at least this port is open. 2ndly make sure that the Sql Server is set up to listen in mixed mode so you can at your whim, choose between nt authentication and sql Server sercuity... to do this go to Neo2, and right click the server in EM, and choose the type of authentication allowed. when registering from other pc's you can elect to use the IP instead of the name, and thus make for less headaches.. ----------------------------------------- The information contained in this e-mail message and any file, document, previous e-mail message and/or attachment transmitted herewith is confidential and may be legally privileged. It is intended solely for the private use of the addressee and must not be disclosed to or used by anyone other than the addressee. If you receive this transmission by error, please immediately notify the sender by reply e-mail and destroy the original transmission and its attachments without reading or saving it in any manner. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender theref! ore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of email transmission. Users and employees of the e-mail system are expressly required not to make defamatory statements and not to infringe or authorize any infringement of copyright or any other legal right by email communications. Any such communication is contrary to company policy. The company will not accept any liability in respect of such communication. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com