Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

DAC issue Expand / Collapse
Author
Message
Posted Saturday, July 4, 2009 1:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 6,732, Visits: 8,484
With clustering stuff, many thing must be managed using cluster administrator!

What are you looking for ? (With regards to instance management)


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #747172
Posted Saturday, July 4, 2009 6:13 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
ALZDBA (7/4/2009)
With clustering stuff, many thing must be managed using cluster administrator!

What are you looking for ? (With regards to instance management)



i want enable the DAC remote acces from SAC
Post #747195
Posted Sunday, July 5, 2009 3:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 6,732, Visits: 8,484
did you try this in SSMS:

EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #747318
Posted Sunday, July 5, 2009 3:24 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
ALZDBA (7/5/2009)
did you try this in SSMS:

EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO


Yes .. i have enabled that by executiing that query already ..but issue is i could not able to modify the anything by using the sac wizard in sql server clustering setup.
Post #747322
Posted Sunday, July 5, 2009 11:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 6,732, Visits: 8,484
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.


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #747514
Posted Monday, July 6, 2009 2:02 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
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 .
Post #747551
Posted Monday, July 6, 2009 2:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 6,732, Visits: 8,484
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


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #747570
Posted Monday, July 6, 2009 4:16 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
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 ....
Post #747591
Posted Monday, July 6, 2009 4:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 6,732, Visits: 8,484
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)

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

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


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #747603
Posted Monday, July 6, 2009 6:34 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
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)

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 ?

Post #747657
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse