Tuesday, 14 February 2012
Configuring SIS in a Cluster problem
instructions found at http://msdn2.microsoft.com/en-us/library/ms345193.aspx.
I have added the required dependancies to a new generic resource in
the Cluster Adminstration screen and it is now asking me for DHCP
Service Parameters such as Database Path; Audit File Path, Backup
Path. These are not discussed in the instructions in the instructions
and I can't find any info on this page. Can anyone advise what
information the wizard is looking for here?
My SysAdmin tells me we are getting DHCP from Novel, if that helps.
On Dec 10, 10:11 am, Fayven Wren <FayvenW...@.gmail.com> wrote:
> I am attempting to configure SIS in a clustered environment using the
> instructions found athttp://msdn2.microsoft.com/en-us/library/ms345193.aspx.
> I have added the required dependancies to a new generic resource in
> the Cluster Adminstration screen and it is now asking me for DHCP
> Service Parameters such as Database Path; Audit File Path, Backup
> Path. These are not discussed in the instructions in the instructions
> and I can't find any info on this page. Can anyone advise what
> information the wizard is looking for here?
> My SysAdmin tells me we are getting DHCP from Novel, if that helps.
My Bad. Misread the instructions and did not specify the Service Type
as "Generic Service".
Sunday, 12 February 2012
Configuring Environment for first time
Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".
I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.
Any suggestions on how to resolve?
mwharton - I have the same question. Did you find an answer anywhere?
Harold
Configuring Environment for first time
Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".
I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.
Any suggestions on how to resolve?
mwharton - I have the same question. Did you find an answer anywhere?
Harold
Friday, 10 February 2012
Configure SQL Express to utilize Windows clustering
We are planning to setup SQL Express on a windows os clustered environment and trying to shoot for a active-passive configuration. We know that SQL server 2005 has this ability and will be leveraging that for mission critial production applications, however there are several other apps that we intend to use internally and would like to leverage windows clustering. Has anyone done this?
- Should we share the INSTALLSQLDATADIR? If yes, then how to specify the SQL Express installtion on cluster node#2 that, "hey..utilized this dir as the data dir".
- Or Should we not worry about it, and only the databases that we create for our apps be on the quorum/clustered resource drive?
Any pointers?
SQL Express does not support Clustering.
Regards,
Mike Wachal
SQL Express team