Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

DBI - SQL Server - DAC Connection

by roho (Monsignor)
on Aug 24, 2013 at 16:25 UTC ( #1050822=perlquestion: print w/ replies, xml ) Need Help??
roho has asked for the wisdom of the Perl Monks concerning the following question:

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.

UPDATE: Also posted to dbi-users@perl.org

"Its not how hard you work, its how much you get done."

Comment on DBI - SQL Server - DAC Connection

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1050822]
Approved by Jim
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (7)
As of 2014-07-12 20:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (241 votes), past polls