Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 10832

Dedicated Admin Console (DAC) a reserved connection on SQL Server that grants special access to system tables and can help diagnose problems

10 votes
Accepted

Static DAC ports for named instances

Taken from the Microsoft Support site: To configure a static port for the specialized Dedicated Administrator Connection (DAC), you must update the registry key that corresponds to your instance. … I use this script to configure the Remote DAC port: /* Reads the instance's registry settings (via xp_instance_regread as opposed to xp_regread), to determine if the Dedicated Aministrator …
Hannah Vernon's user avatar
  • 70.5k
0 votes

"the maximum number of '1' dedicated administrator connections already exists" message in er...

Adding a System.Data.SqlClient.SqlConnectionStringBuilder object to your script, and using it to generate the connection string, would avoid this issue from the outset. PS C:\> $SqlConnectionStringBui …
Hannah Vernon's user avatar
  • 70.5k