[Discussion] Discuss the Release and idea here.

[iKasu]

It cannot happen, unless they physically Block port 1433 or configure the Default that I show in the video to something else.
This is what I keep referring to.
It is physically Impossible.


What I'm saying is. If they followed the video. They Did set it to 1433... that is the definite bottom line.
There is no physical way the Static can now be different Unless blocked by the Firewall on Purpose.

There is nothing further to say one way or the other.
Bottom line. Impossible.

I never said the Static Port will be changed.
Okay last try to explain it with an example:

1. Stop your SQL Server
2. Start a Server Program and change the Port to 1433
3. Start your SQL Server again.

Your SQL Server will run but NOT on Port 1433.
Use this Query:

USE master
Go
xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc'
GO

There you will see, that your SQL Server is running on Port 49166.

Why does this happen? Because with the 0 in the Dynamic Port you enabled Dynamic Ports.
If your SQL Server is unable to bind on Port 1433 it will then try to use a Dynamic Port
which you can change in the IPAll Section:

And now pls don't tell me i'm wrong....

 

[iKasu]

Sorry for this Offtopic now even if it has to do with the Thread...

Please read my Posts again. I !NEVER! said that they had to change it, they changed it nor did i changed it.
I said: IF another "Program" is using Port 1433 BEFORE SQL SERVER STARTS because idk why but it may happen - SQL Server will then
use the Dynamic Port.

It was just mentioned because it may happen for someone... Not yet, not in few Weeks but it will happen sooner or later...
So here again in short:
1. I never said they should change it
2. I never said: if they change it
3. I said: If another Program is blocking Port 1433 because it started before SQL Server then it will use a Dynamic Port

If you put a 0 in the Dynamic ones and the Static Port is for some reasons blocked, then it uses a Dynamic Port. END

We both now this wouldn't happen if they do everything right, but sooner or later there is a guy using a software which is configured
for Port 1433 and it may happen that this software blocks the Static Port because the SQL server got restarted or whatever.

If you leave it blank, then it wouldn't use a Dynamic port is the Static Port is blocked.

Forget everything we wrote and just answer this last Question:

Why did you enabled Dynamic Ports?
(Don't post anything else about that above, just answer the Question, please.)

 

[Iron21]

@iKasu










could provide these management tools

 

[zxc5588ss]

Re: [Release] "Dragona" officially named "Dragon Heart Legend"

dragona_multlang_1.0.20.499_0.4.95.exe Is it convenient to Google Divers?



[QUOTE = keyrita1; 8132166] @ DNC
好友可以解鎖.gfpk工具
Resource.gfpk

You must be registered to see links

更新---

Dragona_multlang_1.0.2.0
。客戶就是全部。gfpk 加密

---更新---

ftp: //ftp71.pfamily.com.tw/dragona_multlang_1.0.20.499_0.4.95.exe[/QUOTE ]

Is it convenient to Google Divers?