Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error Msg - DAC

Author  Topic 

Mishiago
Starting Member

1 Post

Posted - 2008-07-29 : 09:47:38
The error is:

Date 7/29/2008 4:37:29 PM
Log SQL Server (Current - 7/29/2008 4:37:00 PM)

Source Logon

Message
Could not connect because the maximum number of '1' dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by logging off or ending the process. [CLIENT: 127.0.0.1]

what i need to do for increasing the DAC connections?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-07-29 : 11:39:47
There is only one DAC, you cannot increase that number. It's intended as a last resort connection for administrators to use if the server is not accepting normal requests.

Why do you want to increase the number of connections allowed?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -