Sometime you may get the below error while connecting to SQL Server.
A Connection was successfully established with the server, but than an error occurred during the login process, (Provider: Shared Memory Provider, error: 0 - No process is on the other end end of pipe.)
(Microsoft SQL Server Error: 233)
The above error clearly states that maximum value for user connection is already reached so you can't login to SQL Server. If you are the system administrator than you can increase the maximum value by using the SP sp_configure.
Use the below steps to increase the value.
Open the SQL Server Management Studio.
Write down the below queries:
sp_configure 'show advanced options', 1
Go
reconfigure
Go
sp_configure 'user connections', 0
Go
reconfigure
Go
A Connection was successfully established with the server, but than an error occurred during the login process, (Provider: Shared Memory Provider, error: 0 - No process is on the other end end of pipe.)
(Microsoft SQL Server Error: 233)
The above error clearly states that maximum value for user connection is already reached so you can't login to SQL Server. If you are the system administrator than you can increase the maximum value by using the SP sp_configure.
Use the below steps to increase the value.
Open the SQL Server Management Studio.
Write down the below queries:
sp_configure 'show advanced options', 1
Go
reconfigure
Go
sp_configure 'user connections', 0
Go
reconfigure
Go
how can we apply query on offline server...... when clicked on new query it shows connect to server dialog.
ReplyDeleteHere Server is not offline. Maximum connection to the server is reached.
DeleteYou can connect to Management Studio.