Thanks for your response, Steve. I started SQL Server with trace flag 7806. The
only difference I see in your connection string and mine is I specified port
number by appending it to server with a comma. I will try it with a separate
port parameter and see what happens.
From: [email protected]
To: [email protected]
Subject: DBI - SQL Server - DAC Connection
Date: Mon, 26 Aug 2013 09:56:32 -0400
Responding to Roy Fulbright's message as above:
After successfully setting up a connection to my DAC port in a manner similar
to yours I noted in the SQL Server 2008 R2 documentation under "Using a
Dedicated Administrator Connection" the following:
"SQL Server Express does not listen on the DAC port unless started
with a trace flag 7806."
Otherwise, my connection string looked like:
my $dbh = DBI->connect("dbi:ODBC:Driver={Sql Server native Client 10.0};"
. "Server=ims\\ims_test;"
. "port=50564;UID=$uid;PWD=$pwd",{
AutoCommit => 1,
RaiseError => 0,
PrintError => 0
})
Also, if you go to SQLServerCentral.com and put 'dbnetlib' and 'DAC' in the
search box, a number of threads with useful info come up.
Hope that helps Roy,
Steve Moreland
