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
