Search Results
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 dac
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 …
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 …