connection does not open from SSMS

Question

connection does not open from SSMS

Arsh

SSCertifiable

Points: 6354
More actions
July 5, 2024 at 9:17 am

#4433525

Dear Friends,
Would be grateful if anybody can advise why one of my servers, doesnt allow a connection anymore from SSMS on my terminal. The IP address is the unchanged. SQL server port was changed I remember, that i am anyways providing in with the IP as IP:portnumber..Thanks in advace.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246944 More actions · Answer 1

Arsh wrote:

Dear Friends,
Would be grateful if anybody can advise why one of my servers, doesnt allow a connection anymore from SSMS on my terminal. The IP address is the unchanged. SQL server port was changed I remember, that i am anyways providing in with the IP as IP:portnumber..Thanks in advace.

What is the text of the error message you receive?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

kparshotam18007 Newbie Points: 1 More actions · Answer 2

Since it looks like some amendments were done to port number, did you check firewall settings for this port on server?

rothj Hall of Fame Points: 3402 More actions · Answer 3

Shouldn't it be IP, port (comma not colon) ?

Arsh SSCertifiable Points: 6354 More actions · Answer 4

Its working with IP and comma. thanks. but still it fails with servername and comma ? any comments

Arsh SSCertifiable Points: 6354 More actions · Answer 5

thanks everyone for the suggestions

Its working with IP and comma. thanks. but still it fails with servername and comma ? any comments .Its a default instance and the only on that server.thank u.

Phil Parkin SSC Guru Points: 246944 More actions · Answer 6

Arsh wrote:

thanks everyone for the suggestions
Its working with IP and comma. thanks. but still it fails with servername and comma ? any comments .Its a default instance and the only on that server.thank u.

If you ping the server name, does it come back with the correct IP address?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

rothj Hall of Fame Points: 3402 More actions · Answer 7

If the issue isn't DNS it's probably a Kerberos\SPN issue:

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/features/service-principal-name-spn-support-in-client-connections?view=sql-server-ver15

You can use the MS Kerberos tool to check it:

https://www.microsoft.com/en-us/download/details.aspx?id=39046

Also, is the SQL Browser Service running?

cyrusbaratt SSC-Addicted Points: 417 More actions · Answer 8

What is the instant name which may include the port number? Yes, verify/your firewall your firewall rules. Configure the default port 1433 in your firewall to get around your issue possibly. Verify your SQL server configuration TCP/IP settings is correct.

DBASupport