DBI - SQL Server - DAC Connection

Roy Fulbright <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]>
I am running Activestate Perl 5.8.9 on Windows 7. I have been able to establish a connection to MS SQL Server using DBI for years. What I need now is to establish a Dedicated Administrator Connection (DAC) to SQL Server via DBI. I can establish a DAC connection to SQL Server using "sqlcmd" in a cmd window by prepending "ADMIN:" to the server name or by using the "-A" option, and this works fine.  When I prepend "ADMIN:" to the server name in my DBI connection string I get the following error message: 
DBI connect('Driver={SQL Server};Server=ADMIN:localhost\SQLEXPRESS;Database=pubs','sa',...) failed: MicrosoftODBC SQL Server DriverDBNETLIBSQL Server does not exist or access denied. (SQL-08001) state was 08001 now 01000  When I add the DAC listening port to the end of the server name in my DBI connection string I get the following error message: 
DBI connect('Driver={SQL Server};Server=localhost\SQLEXPRESS,60488;Database=pubs','sa',...) failed: MicrosoftODBC SQL Server DriverDBNETLIBInvalid connection. (SQL-08001) state was 08001 now 01000  
I have tried Super Search and Google, and have come up empty.
 
Does anyone know how to establish a DAC connection to SQL Server using DBI? 

Thanks,
Roy Fulbright
 
Also posted on Perlmonks at: http://perlmonks.org/?node_id=1050822
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.