Just another Perl shrine | |
PerlMonks |
DBI - SQL Server - DAC Connectionby roho (Bishop) |
on Aug 24, 2013 at 16:25 UTC ( [id://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:
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:
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?
UPDATE: Also posted to dbi-users@perl.org "Its not how hard you work, its how much you get done."
Back to
Seekers of Perl Wisdom
|
|