RE: DBI - SQL Server - DAC Connection

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