Red Gate is not an option: it gives me error that my current privilege is not enough to even compare data using Red Gate SQL Data Compare:

EXECUTE permission denied on...

Jeff Moden (2/16/2012)

---

Grant Fritchey (2/16/2012)

---

I'd cheat.

Get a copy of Red Gate SQL Compare and just capture the data that exists in one database, but not the other. Very easy that...

I used this command to dump the current firewall settings:

netsh firewall show config

Domain profile configuration (current):

-------------------------------------------------------------------

Operational mode ...

Lowell (2/10/2012)

---

going back to the questions on the first page...we never got a definitive answer.

did you disable windows firewall and attempt to connect?

what was the results or specific error when...

unfortunately it is still not working.

Up

Thanks.

I don't see two SQL instances on that server, where did you see it?

I changed the port number to 14330, it still gives me the same error.

I am sorry I am confused here, isn't...

I think I did, as you can see from the attached screenshot.

Issue persists, no more clue?:crying:

when I telnet the server with port 1433, it gives me a blank screen other than a blinking cursor, is that normal?

The event says I can't put 1433 on both entries, so I made the changes and now it is exactly the same as another server that I have no issue...

You are right, I opened Configuration Manager, and checked protocol for TCP/IP there, it says it is configured as using dynamic port and the port option is empty, so I...

SKYBVI (2/7/2012)

---

halifaxdal (2/7/2012)

---

SKYBVI (2/7/2012)

---

Can...

SKYBVI (2/7/2012)

---

Can you do...