I'm not an expert, but it sounds like the change has not replicated to the DC that the SQL Server is querying. I could be wrong though.

The default port is 1433. Otherwise if it is dynamic or changed to another port you'll need to look on the SQL Server for configuration.

To telnet open a command prompt and type in telnet [fqdn or IP] [port #]. If you connect it is accepting connections and your issue is elsewhere.

Something...

Yes, that code works, but it does loop which is going to be a bit slow. I prefer to not write generic triggers like that because, while they are...

Can you ping the remote server?

Can you connect using Telnet?

If you could connect before, what has changed since you successfully connected?

If you have the local server group selected in the Registered Servers tab and then do Open File it will connect to group.

Michal-469362 (9/14/2011)

---

I am brain dead this morning...

I have a table that I want to list distict phone #'s. I can do that with with:

SELECT DISTINCT PHONENBR FROM...

This is linked server, have you tried connecting directly without the linked server overhead?

ComputerFieldsInc (9/15/2011)

---

Great article, and great responses. I'm a developer on a team working on a redesign of a Visual FoxPro application. Initially the project scope will focus on migrating the...

Grant,

Defaulting all character columns to varchar or, even worse, nvarchar and then compounding it by using 255.

No statistics or index maintenance.

Then echoing just about everything else everyone else said.

Congratulations to Jeff, well-deserved, although don't you call yourself a developer, not a DBA?:-D

SQLRNNR (9/12/2011)

---

Jack Corbett (9/12/2011)

---

SQLRNNR (9/12/2011)

---

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>,...

SQLRNNR (9/12/2011)

---

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since the topic...

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since the topic they...

GilaMonster (9/9/2011)

---

Want to be really evil? (now we are getting into the mess that is nested transactions, named transactions and error handling)

How many rows does that select return? 0, 1,...