Home > database >  Strange questions, the SQL server client have a few computer suddenly unable to connect, part of the
Strange questions, the SQL server client have a few computer suddenly unable to connect, part of the

Time:05-22

Suddenly beginning Friday afternoon, inside the company have a few computer unable to connect to SQL server, but ping tong, other computer can connect normal! The key is also not to upgrade

CodePudding user response:

Firewalls have done anything Settings, Telnet server port 1433 to succeed

CodePudding user response:

Setting wall didn't do it

CodePudding user response:

Telnet test port is normal, if not, change the basic is a network strategy,

CodePudding user response:

The key is not only a few units, and a few other station can be

CodePudding user response:

Look at the maximum number of connections set, 0 for unlimited
 
The SELECT value_in_use FROM sys. Configurations WHERE name='user connections'

Is not zero has again see even how many
 
SELECT COUNT (1) the FROM sys. Sysprocesses

CodePudding user response:

First off on the client 360, under test
  • Related