question

srikanth430 avatar image
srikanth430 asked

I have changed maximum number connection from 0 to 1. After restartin the instance am unable to connect the server. Can anyone help me how to resolve this..?

Unable to access the instance. Can anyone help me how to reset the maximum number connections from 1 to 0 ?
connection
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
Have you tried connecting to the instance using DAC? http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.