CirquedeSQLeil (4/1/2010)

---

rainleta (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

In that article I gave it discusses how the Browser Service is used for Named Instances. If you specify a different than default port for the...

Nicholas Cain (4/1/2010)

---

So on the Protocol tab you have

-Enabled Yes

-Keep Alive 30000 (example value)

-Listen All Yes

Have you changed the values under IPAll and set

-TCP Dynamic Ports to nothing (leave...

CirquedeSQLeil (4/1/2010)

---

In that article I gave it discusses how the Browser Service is used for Named Instances. If you specify a different than default port for the default instance...

BTW, I am using default instance. You can see it from the connection dialog.

Yes. All the IPs are disabled. I only have IPALL.

Before I tried the dynamic port, I used 1533 and changed all the IPs to 1533. But it still doesn't work...

From netstat on the server,...

Here you go.

I turn off/on the name pipes,...

CirquedeSQLeil (4/1/2010)

---

rainleta (4/1/2010)

---

CirquedeSQLeil (3/31/2010)

---

rainleta (3/31/2010)

---

Another finding:

I enabled the dynamic port on the server, restart the SS and SQL Browser Service, I cannot make connection from client. I have to find...

I think there is no problem with my client. If I specify connection as server,port I...

Yes. From netstat command, I...

CirquedeSQLeil (3/31/2010)

---

rainleta (3/31/2010)

---

Another finding:

I enabled the dynamic port on the server, restart the SS and SQL Browser Service, I cannot make connection from client. I have to find and use...

Another finding:

I enabled the dynamic port on the server, restart the SS and SQL Browser Service, I cannot make connection from client. I have to find and use the port...

I think 1533 is a valid or correct port number

:crying:

I only have one default instance on the server. And before I specified the 1533 port, I double-checked it is not occupied by other applications.

What do you mean by...