DAC issue

  • ALZDBA (7/5/2009)


    Did you change the SAC connection from localhost to the logical server name of your sqlserver instance ?

    e.g. mysqlserver\myinstance you should connect to mysqlserver.

    Yes ...After that only its allowing me to open the SAC wizard but while doing the some modification like enable or disable the dac remote access on the wizard its giving the error message .

  • What service pack is your sqlinstance on ?

    Select Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS

    , Serverproperty( 'Edition' ) as Edition

    , Serverproperty( 'InstanceName' ) as InstanceName

    , Serverproperty( 'IsClustered' ) as IsClustered

    , Serverproperty( 'MachineName' ) as MachineName

    , Serverproperty( 'ProductVersion' ) as ProductVersion

    , Serverproperty( 'ProductLevel' ) as ProductLevel

    , Serverproperty( 'ResourceLastUpdateDateTime' ) as ResourceLastUpdateDateTime

    , Serverproperty( 'ResourceVersion' ) as ResourceVersion

    , Serverproperty( 'ServerName' ) as ServerName

    , USER_ID() AS [USER_ID]

    , USER_NAME() AS [USER_NAME]

    , SUSER_ID() AS [SUSER_ID]

    , SUSER_SNAME() AS [SUSER_SNAME]

    , IS_SRVROLEMEMBER ('sysadmin') AS [Is_ServerAdmin_Sysadmin]

    , ORIGINAL_LOGIN() AS [ORIGINAL_LOGIN]

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

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

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • ALZDBA (7/6/2009)


    What service pack is your sqlinstance on ?

    Select Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS

    , Serverproperty( 'Edition' ) as Edition

    , Serverproperty( 'InstanceName' ) as InstanceName

    , Serverproperty( 'IsClustered' ) as IsClustered

    , Serverproperty( 'MachineName' ) as MachineName

    , Serverproperty( 'ProductVersion' ) as ProductVersion

    , Serverproperty( 'ProductLevel' ) as ProductLevel

    , Serverproperty( 'ResourceLastUpdateDateTime' ) as ResourceLastUpdateDateTime

    , Serverproperty( 'ResourceVersion' ) as ResourceVersion

    , Serverproperty( 'ServerName' ) as ServerName

    , USER_ID() AS [USER_ID]

    , USER_NAME() AS [USER_NAME]

    , SUSER_ID() AS [SUSER_ID]

    , SUSER_SNAME() AS [SUSER_SNAME]

    , IS_SRVROLEMEMBER ('sysadmin') AS [Is_ServerAdmin_Sysadmin]

    , ORIGINAL_LOGIN() AS [ORIGINAL_LOGIN]

    i have not applied any service pack after installing sql server 2005 cluster standard edition ....

  • Oh, you should !

    Why ?

    - bugs have been cleaned up

    - new features have been added (SSB, logon triggers,..)

    - performance optimisations

    - SSMS menu items have been shifted around (SP2) :sick:

    The current is SP3 and they did release some cumulative updates for that too.

    http://support.microsoft.com/kb/913089

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

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

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • ALZDBA (7/6/2009)


    Oh, you should !

    Why ?

    - bugs have been cleaned up

    - new features have been added (SSB, logon triggers,..)

    - performance optimisations

    - SSMS menu items have been shifted around (SP2) :sick:

    The current is SP3 and they did release some cumulative updates for that too.

    http://support.microsoft.com/kb/913089

    ya ..i should apply the service pack soon...i have to apply the service pack in sql server clustering environment ..could you explain me what are rules & steps should i follow at the time of service pack apply in cluster environment ?

    are u sure that this problem will be resolved after applying this sp3 ?

  • Just another thought: You are at the console, or are using a remote desktop solution to run SAC, right ?

    We now only have SP3 instances with sql2005 and are not experiencing the problem you state.

    How To apply SP3:

    www.sqlservercentral.com/articles/Installation/66128/

    Play it safe: start with a full backup of your instance(s)

    fyi:

    We didn't encounter problems when upgrading from sp2 cu2 to SP3 on our 2-node sql-cluster (multiple instances).

    We do pay attention for the cluster resource to reside on the same node as the sql instance to be upgraded.

    We even upgraded multiple instances in a single run. We moved all instances to the same node before starting the upgrade.

    Off course it will not hurt to have a spare/backup set of resource db files !

    We take a copy of them after every upgrade (because at that moment is planned downtime).

    One thing we did observer is the needed reboot after the first instance + the client software have been upgraded.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

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

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • ALZDBA (7/6/2009)


    Just another thought: You are at the console, or are using a remote desktop solution to run SAC, right ?

    We now only have SP3 instances with sql2005 and are not experiencing the problem you state.

    How To apply SP3:

    www.sqlservercentral.com/articles/Installation/66128/

    Play it safe: start with a full backup of your instance(s)

    fyi:

    We didn't encounter problems when upgrading from sp2 cu2 to SP3 on our 2-node sql-cluster (multiple instances).

    We do pay attention for the cluster resource to reside on the same node as the sql instance to be upgraded.

    We even upgraded multiple instances in a single run. We moved all instances to the same node before starting the upgrade.

    Off course it will not hurt to have a spare/backup set of resource db files !

    We take a copy of them after every upgrade (because at that moment is planned downtime).

    One thing we did observer is the needed reboot after the first instance + the client software have been upgraded.

    Yes .. i have took the virutal machine by mstsc console and trying to modify the SAC ...

    thks for your information ....

  • Im facing the same issue and we are SQL 2012 Enterprise, one thing is that one person on the team is able to connect but none of the rest of the team is able to we get the message as if it can connect mentioned in the beginning of this post.

    Any solution Thanks in advance

  • Also with SQL2012, only a single active DAC is allowed !

    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.

    ref Diagnostic Connection for Database Administrators

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

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

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Thanks for the reply

    We have went through just about everything only one DBA is able to connect using DAC we know there is only one connection allowed.

    Is there any changes need to be done in configuration manager or settings some where?

    I didnt beleive so but just curious

  • Keep in mind you cannot connect Object Browser using and admin:server\instance connection.

    You must use a Query panel ( New Query ) and then connect using admin:server\instance .

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

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

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 11 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply