Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

SQL 2008 R2 Active-Active cluster

Posted: Jan/22/2011   By: nikhil   Points:15   Category: .NET  - ASP.Net    Views:175   Vote Up (0)   Vote Down (0)    

Hi, I am trying to set up a 2-node active-active SQL 2008 cluster. So it'll be something like:

Data 1, instance 1, node 1, node 2.

Data 2, instance 2, node 1, node 2.

In Failover Cluster Manager, under Services and applications, I have instance 1 with server name Data 1  and instance 2 with server name Data 2. I can do Move this service or application to another node by instnace 1 -> instance 2, or vice versa. No errors.

Now, I have an application with DB created on Data 2, instance 2. However, when testing the failover in Failover Cluster Manager it went fine and no erros reported, but the application stopped working.

I have a different app with DB created on Data 1, instance 1. This app works fine when testing the failover.

In short, I am puzzled. Where could I check to make sure this active-active cluster was installed and configured as planned?

I checked the summary log in Setup Bootstrap. Sorry about the format. Any suggestions would be greatly appreciated.

 

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Exit message:                  Passed
  Start time:                    2010-11-29 14:44:51
  End time:                      2010-11-29 15:02:39
  Requested action:              Install

Cluster properties:
  Machine name: FERRARI
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Enterprise Edition   10.50.1600.1    Yes      
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Enterprise Edition   10.50.1600.1    Yes      
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Enterprise Edition   10.50.1600.1    Yes      
  Sql Server 2008 R2   INSTANCE1            MSSQL10_50.INSTANCE1           Database Engine Services                 1033                 Enterprise Edition   10.50.1600.1    Yes      
  Sql Server 2008 R2   INSTANCE1            MSSQL10_50.INSTANCE1           SQL

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources

Visual Studio 2008 and Visual Web Developer 2010 Express launch ribbon menu item

  

My existing system has Visual Studio 2008 and Visual Web Developer 2010 Express. But Microsoft web installer for Webmatrix has made Wematrix Launch ribbon menu pointing to Visual Studio 2008. How could I make Webmatrix point to Visual Web Express 2010. To make use of IntelliSense and the debugger, I have to manually launch Visual Web Developer 2010 Express.

Any help to resolve this would be helpful Or is this a known issue at this time!




Enterprise Library and Express 2008

  

What version of the Enterprise Library should be used with Visual Studio Developer Express 2008?

Looking at using the Data Access Application Block.

Currently using an earlier version in C# that doesn't seem to be closing connections properly.

Tim


Problems Installing AKS 1.1 on Windows Server 2008 x64bit

  
Hi all, 

I am trying to install AKS 1.1 (not 2 or 1.0 cuz thats the only release i was able to find on aks.hisoftware.com) on a windows server 2008 x64bit machine. 
 
the toolkit installs in this location: C:\Program Files (x86)\HiSoftware\AKS  .... but nothing in the 12\template\features folder.

the script install_AKSFEAT.bat refers to a feature name "AKS", but i cannot see the feature anywhere in the features folder, and i cannot see a WSP pacakge to deliver this feature to sharepoint!

i event tried to look for the feature manifest to reverse engineer the works of the feature but no luck finding this file in the AKS install folder.

what am i missing here? how can i get AKS 1.1 to install properly and the feature to activate? please HELP!!


- mutaz

User Profile Service Sync with Active Directory- Address, Telephone tabs

  

I was able to sync the users from AD to SharePoint, however, in AD, there are 2 tabs called Address and Telephones and the attributes in these tabs didn't get transfered to SP and so they weren't displayed in SP.  The attributes in the Address tab are Street, PO Box, City, State, etc....  The attributes in the Telephones tab are Home, Pager, Mobile, Fax, IP phone.  The stuff that got transfered over to SP are from the General tab which as First Name, Initials, Last Name, Display Name, Description, Office, Telephone number, Email, Web page.

Please help. Thanks!


Error while installing SQL 2008 R2 reporting services

  

Hi

I am having trouble installing Sharepoint 2010. Every prerequisite installs except the SQL 2008.

The tool was unable to install SQL 2008 R2 reporting services sharepoint 2010 add-in.

This is the log:

2010-12-14 12:56:39 - SQL 2008 R2 Reporting Services SharePoint 2010 Add-in
2010-12-14 12:56:39 - Reading the following string value/name...
2010-12-14 12:56:39 - Version
2010-12-14 12:56:39 - from the following registry location...
2010-12-14 12:56:39 - SOFTWARE\Microsoft\Microsoft SQL Server\Report Server SharePoint Addin\CurrentVersion
2010-12-14 12:59:04 - Opening log file
2010-12-14 12:59:04 - Opened action for user
2010-12-14 12:59:04 - C:\Users\HansV\AppData\Local\Temp\PrerequisiteInstaller.2010.12.14-12.47.58.log


Minimize Application When Active Window is minimized

  

I have an application used at work. I am trying to program it so that if the current window is minimized, all other open windows are also minimized.

I've tried searching around and couldn't find a way to do this, does anyone have any insight into this?


VS2008 .NET 3.5.1 Webservice Debugging Error on SQL 2008 first chance exception of type 'System.Security.SecurityException' occurred in System.Data.dll

  

I am new to this forum, and would like some help with what should be an easy task.    The goal is to create a simple web service that calls a stored procedure and returns some data.   I have  seen alot of artlicles on code access security adjustments relating to trust levels , but nothing relating to 3.5 (no .NET configuration tool.)    Being a noob at this stuff, I would like to get some simple examples working.  I run VS2008 locally on my PC but the code lives on a network share with the SQL2008 server.   Any help is most appreciated.    

Here is my code and exception output from debugging.

Immediate Window:

First-chance exception at 0x75b99617 in WebDev.WebServer.EXE: Microsoft C++ exception: [rethrow] at memory location 0x00000000..

A first chance exception of type 'System.Security.SecurityException' occurred in System.Data.dll

Webpage display after invoking ws:

System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
  at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
  at System.Security.PermissionSet.Demand()
  at System.Data.Common.DbConnectionOptions.DemandPermission()
  at System.Data.SqlClient.SqlConnection.PermissionDemand()
  at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  at System.Data.SqlClient.SqlConnection.Open()
  at BudAcct2WS.BudAcct2Service1.GetBudInfo(String strFundI, String strFctI, String strDptI, String strObj, String strSub)

VB.NET Code:

Imports System.Web.Services

Imports

 

System.Web.Services.Protocols

Imports

 

System.ComponentModel

Imports

 

System.Data

Imports

 

System.Data.SqlClient

Imports

 

System.Security

Imports

 

System.IO

Imports

 

System.Net

Imports

 

System.Reflection


Incorrect function during install of .Net 4.0 on Windows 2008 x64 SP2

  

I can not install the .Net framework 4.0 on a Windows 2008 x64 SP2 Server with all available updates installed.

I tried the windows update install, the web installer and the full distribution, all with the same result.
Next, I tried cleaning the temp folder (both %temp% and %systemroot%\temp), I checked the Windows installer service (runs on System, Manual), check the rights of System on the systemroot (full control), I runned SFC / Scannow, I used the .net cleanup utility to remove .Net 4.0, I restarted the server.

Nothing helps; I keep getting the error: Fatal error during installation.
The error in the html log is:

[12/6/2010, 22:0:50]Launching CreateProcess with command line = wusa.exe "E:\534e9c98d3cdbc4de4737aef\Windows6.0-KB956250-v6001-x64.msu" /quiet /norestart
[12/6/2010, 22:1:7]Exe (E:\534e9c98d3cdbc4de4737aef\Windows6.0-KB956250-v6001-x64.msu) failed with 0x1 - Incorrect function. .
[12/6/2010, 22:1:7]PerformOperation on exe returned exit code 1 (translates to HRESULT = 0x1)

You can download the log from http://www.vait.nl/Microsoft.NETFramework4Setup_20101206_220008128.html
And the MSI log from http://www.vait.nl/Microsoft.NET%20Framework4Setup_20101206_220008128-MSI_netfx_Core_x64.msi.txt

Please help!

Regards,

Theo

[edit]

The SFC log can be downloaded from http://www.vait.nl/CBS.txt

[/edit]


Connecting a database in Microsoft Access to an application using Visual Studio 2008 or 2010 on Windows 7 x64

  
I am a tech student who is currently finishing my first programming class. The class is online and the book instructed students to install Visual Studio 2008. I installed it from DreamSpark on my 2 systems that both have Windows 7 x64 bit. I installed Visual Studio Basic 2008 on one and Visual Studio Express edition on the other. I have used the Express edition on almost every assignment this semester. We also were instructed to download a file that contained the VB solutions that we would be modifying during the semester. The assignment this week was to connect a VB application to a Microsoft Access database using the Data Source Configuration Wizard. The database that was used came from the file that also contained the solutions for the semester. I followed every step in the book and everything matched until I tried to run the application. The BindingNavigator control was there and the column headers, there was one empty row under under the headers for data and nothing else. When I was modifying the application the connection test was ok and the table with all the data was there when I previewed the data. My instructor blamed this on Windows 7 not being compatible with VB 2008 so I installed 2010 and got the same result as I did with 2008. What am I doing wrong? When I first try to debug the program I recieve a windows error. It states that an error occured with a .dll file and that  windows corrected a problem and made the application compatible. 

Assign rights to the user group for particular OU in Active directory using C#

  

Hi,

I have one group of users say "TestGroup" and one OU say "TestOU". I want to assign rights to the Testgroup for TestOU using C# code. So i can cotrol read write access of that group by programmatically.

Please Help.


 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge