Eric Barro
ebarro at afsweb.com
Wed Jun 9 11:35:59 CDT 2004
This is what worked for me whenever I could not get SQL server to register a server...
In your HOSTS file add an entry for the SQL server with its IP address like so...
192.168.1.254 mySQLServer
Of course if the IP address of the sql server changes you will have to make manual adjustments. In my experience SQL server boxes rarely have their IP addresses changed. This approach also assumes that the SQL server has a static IP address.
---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Charlotte Foust
Sent: Wednesday, June 09, 2004 9:00 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Can't Register Server - FINALLY
Well, after 3 uninstalls and reinstalls, SQL Server finally allowed me
to register a server! That pounding you heard last night was my head
beating on the wall. :-{ I could get EM up and I could even get QA up,
although of course neither of them really worked since they couldn't
connect to an active server, but I couldn't register a server until that
last install. Nothing changed in between except my frustration level
and the name of the server, but suddenly there it was.
Charlotte Foust
-----Original Message-----
From: Charlotte Foust
Sent: Tuesday, June 08, 2004 2:20 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Can't Register Server
MDAC is 2.7 and has been since 2.7 came out. I've kept it upgraded
until 2.7. I won't put 2.8 on until I install the VB.Net stuff. It
comes up as NEWBOOK.
Charlotte Foust
-----Original Message-----
From: Francisco H Tapia [mailto:my.lists at verizon.net]
Sent: Tuesday, June 08, 2004 12:46 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Can't Register Server
Charlotte,
Please humor me for a bit, what MDAC is currently isntalled on your
system? you can download the component checker from MS, then just run it
and it'll tell you you're running either 2.5 - 2.8
I have found that MDAC 2.6 SP1 is generally the best combo of all,
although 2.7 is good too.
also you probably have a server icon in your system tray, what name does
it say for your local server?
Charlotte Foust wrote On 6/8/2004 1:00 PM:
>No, that's the problem. I can't register the server because it errors
>saying the connection is open.
>
>Charlotte Foust
>
--
-Francisco
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 6/6/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 6/6/2004