question

christiancharrier-7077 avatar image
0 Votes"
christiancharrier-7077 asked SeeyaXi-msft commented

windows 2016 can't connect sql server 2008 r2 installed on another server (w2008 R2)

Hello,
I have a sql server 2008 r2 (10.50.1617.0) installed on W2008 R2.
With SSMS 17 or 18 or other, some W2016 servers can connect but some others not.
Thanks for your help
Christian

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @christiancharrier-7077 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Hello Christian,

and which error message do they get? Is there a Firewall between blocking the access?

See MS Support
https://support.microsoft.com/en-us/sbs/topic/solving-connectivity-errors-to-sql-server-ae23c94b-b64b-5056-8b62-22e1694bb889?ui=en-US&rs=en-US&ad=US

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @christiancharrier-7077

Could you post your error message or a screenshot ? It will be helpful to solve the problem.

Best regards,
Seeya

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

christiancharrier-7077 avatar image
0 Votes"
christiancharrier-7077 answered

Hello,
Error attached.
Note that SSMS find the instance by "Server Search"123010-sqlerror1.png


Regards
CC


sqlerror1.png (11.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

christiancharrier-7077 avatar image
0 Votes"
christiancharrier-7077 answered

Adding : all prerequisites are okay.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

christiancharrier-7077 avatar image
0 Votes"
christiancharrier-7077 answered

Adding : this message after growing connection timeout
Une connexion a été établie avec le serveur, mais une erreur s'est ensuite produite pendant la négociation préalable à l'ouverture de session. (provider: TCP Provider, error: 0 - Le délai de temporisation de sémaphore a expiré.) (Microsoft SQL Server, Erreur : 121)
Regards

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I have a sql server 2008 r2 (10.50.1617.0)

That's SQL 2008 R2 RTM CU1 or so.

You should absolutely slap on the most last service pack for SQL 2008 R2 which is SP3. I would guess that you also need support for TLS 1.2. This did not come in SP3, but there was a later patch that provided this. I don't have the download link for this patch, sorry.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @christiancharrier-7077

Here is a link which you can refer to: https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.