Luis Cazares (8/2/2012)

---

emmanuel.constant (8/1/2012)

---

Luis Cazares (7/31/2012)

---

In the part where it asks

Which SQL Server do you want to connect to?

Server:

Just put the IP Address and port. Example:

192.168.0.1,1433

If it works, that...

Luis Cazares (7/31/2012)

---

In the part where it asks

Which SQL Server do you want to connect to?

Server:

Just put the IP Address and port. Example:

192.168.0.1,1433

If it works, that might be some...

Luis Cazares (7/31/2012)

---

Why are you trying to create an ODBC connection?

Are you trying to connect to SQL Server Management Studio?

Are you using a prompt window like this?

Or are you trying...

I use that to create an ODBC connection and log into the SQL studio?

How would I do that?

I am sure.

I have it as this:

DOMDEV\DOMDEVDBSERVER

Where

serverName = DOMDEV

instanceName = DOMDEVDBSERVER

In parentheses I have the right instance name and for the server name I have the right host name as well.

I have it as this:

Winser2008hostname\sqlServer2008instanceName

Where

serverName = Winser2008hostname

instanceName =...

I'm typing the it as "Winser2008hostname\SQLSERVER01"

I don't understand the question "Also, just to be a stickler, are you positive that the instance is not named?"

Yes that has been confirmed as well.

I first it wasn't; then discovered that WinServer 2008 installs with ping replies disabled;

therefore, I enabled it using this "netsh firewall set...

So then it's seems that I've covered all bases for this to work but it doesn't.

Is there any other reason why I'm receiving these messages.

No windows authentication.

I'm using SQL Server Authentication.

Thanks Jared.

Well then that has been addressed also. I made sure that was enabled as well.

I did discover that I have the Win2008 server which host the SQL Server...

Thanks Jitendra.

1. TCP\IP Services seems to be disabled. Which is not allowing you to handshake with remote server.

Where would I go to enable the TCP\IP service?

2. Please type correct Server\instance...

I've attached the error messages sorry about that.

The inbound firewall rules were added already.

All service running has also been confirmed.

Same results.