Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DAC issue


DAC issue

Author
Message
SQL ORACLE
SQL ORACLE
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1487 Visits: 1314
I cannot connect an SQL instance using DAC from either a local machine or from a remote machine. The error I came across is as follow.

SQL Network Interfaces: An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.


I checked the following spots
DAC is enabled from the SQL Surface Area Configuration.
Remote Admin Connection is enabled from sp_configure.
SQL Server Browser is running.
I checked the port number 1434. It is open and is listening.

What did I miss here?
Any input will be greatly appreciated.
Chand00
Chand00
Mr or Mrs. 500
Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)

Group: General Forum Members
Points: 532 Visits: 1248
Hi,

Can you execute this sp_configure 'remote admin connections', 1;

And DAC port is assigned dynamically it trys to connect using TCP on port 1434 and it is failing it tries to check with other ports. I think you have to execute that and try and if that does not work try connecting with
sqlcmd –Stcp:

Thanks
Chandra Mohan N

Thanks
Chandra Mohan

ALZDBA
ALZDBA
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6966 Visits: 8839
Books online states these restrictions:

Restrictions
Because the DAC exists solely for diagnosing server problems in rare
circumstances, there are some restrictions on the connection:

To guarantee that there are resources available for the connection,
only one DAC is allowed per instance of SQL Server.
If a DAC connection is already active, any new request
to connect through the DAC is denied with error 17810.


To conserve resources, SQL Server 2005 Express Edition does
not listen on the DAC port unless started with a trace flag 7806.


The DAC initially attempts to connect to the default database
associated with the login. After it is successfully connected,
you can connect to the master database. If the default database
is offline or otherwise not available, the connection will return
error 4060. However, it will succeed if you override the default database
to connect to the master database instead using the following
command:

sqlcmd –A –d master

We recommend that you connect to the master database with
the DAC because master is guaranteed to be available if the
instance of the Database Engine is started.


SQL Server prohibits running parallel queries or commands with the DAC.
For example, error 3637 is generated if you execute either of the
following statements with the DAC:
RESTORE
BACKUP

Only limited resources are guaranteed to be available with the DAC.
Do not use the DAC to run resource-intensive queries (for example.
a complex join on large table) or queries that may block.
This helps prevent the DAC from compounding any existing server
problems. To avoid potential blocking scenarios, if you have to run
queries that may block, run the query under snapshot-based isolation
levels if possible; otherwise, set the transaction isolation level to
READ UNCOMMITTED and set the LOCK_TIMEOUT value to a short
value such as 2000 milliseconds, or both. This will prevent the DAC
session from getting blocked. However, depending on the state that
the SQL Server is in, the DAC session might get blocked on a latch.
You might be able to terminate the DAC session using CNTRL-C but
it is not guaranteed. In that case, your only option may be to restart SQL Server.



Do any of these match your case ?

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution" :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
SQL ORACLE
SQL ORACLE
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1487 Visits: 1314
Thank you so much for the input above. I have tried all you recommended. It still does not work now, however.
ALZDBA
ALZDBA
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6966 Visits: 8839
what software level are you on ?
select @@version



You are using a login that is member of the sqlserver administrators group, right ?

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution" :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
SQL ORACLE
SQL ORACLE
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1487 Visits: 1314
I used a sa account.
My SQL Server version is SQL 2005 enterprise edition with SP2.
MANU-J.
MANU-J.
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1710 Visits: 8766
Please look thru sql logs to find the port DAC is listening to and mention that port number wth the server name while taking DAC connection.

MJ
SQL ORACLE
SQL ORACLE
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1487 Visits: 1314
I did check. BOL states that DAC check default port first. If the default port does not exist, it will automatically check the open port for DAC.
John.Sansom
John.Sansom
SSC-Addicted
SSC-Addicted (431 reputation)SSC-Addicted (431 reputation)SSC-Addicted (431 reputation)SSC-Addicted (431 reputation)SSC-Addicted (431 reputation)SSC-Addicted (431 reputation)SSC-Addicted (431 reputation)SSC-Addicted (431 reputation)

Group: General Forum Members
Points: 431 Visits: 1558
Out if interest is your environment a clustered server configuration?


John Sansom (@sqlBrit) | www.johnsansom.com
sudhakara
sudhakara
SSChasing Mays
SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)

Group: General Forum Members
Points: 622 Visits: 1383
i am also facing the similar problem in my sql server clustering configuration . it was not allowing me to open the surface area configuration wizard after changing the remote machine name as virtual machine name its allowing to open the surface area window now but its not allowing to modify the settings in the surface area configuration wizard ...its giving the error message you cannot modify the surface area configuration for clustering services ...

Thnks in Advance.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search