connection does not open from SSMS

Question

connection does not open from SSMS

Arsh

SSCertifiable

Points: 6367
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 9 (of 9 total)

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

Phil Parkin SSC Guru Points: 247180 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?

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: 3512 More actions · Answer 3

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

Arsh SSCertifiable Points: 6367 More actions · Answer 4

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

Arsh SSCertifiable Points: 6367 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: 247180 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?

rothj Hall of Fame Points: 3512 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: 430 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