View Complete Post
Yesterday when I was trying to bind the port 1433 to the IP Address, the Bind didn't work. I ran 'Netstat -an' and noticed that there wasn't a port 1433 for listening. I found on MSDN how to manually uninstall a SQL Server Failover Cluster (msdn.microsoft.com/en-us/library/ms180973) . My question when I proceed is with the uninstall of SQL2 , will this affect our SQL1 Active Node?
Storage engineers are planning to Upgrade storage Drive and that storage using for SQL Server 2005 Active /Passive cluster.
as DBA what action I have to take.
I am planning
1.Backup all Databases.(Inluding system)
2.Takning all Databases OFFLINE(make sure no body using Databases)
3.Stopping Instance and Agent .
which is the best way.
any advise is helpful for me.
We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition.
Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster.
Because the cluster is a production server, I need to know exactly how I add a new node onto the current cluster without breaking anything. Also this is my first time to install a passive node, so it is difficult for me to understand how to install and configure it.
I have already added the physical node onto the cluster group so I can see the new node 'paused' from the Cluster Administrator. ÃÂ Now I need to install the SQL but I am too nervous to run the installation p
I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).
1.I have already have SQL Server 2000 SP4 Installation.
2.Can I start Installation(Side by Side) from Passive node ?
3.you want me give New SQL Server Netwrok name (Instance Configuration Screen)?.
4.you want me give New Instance ID name (Instance Configuration Screen)?
5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?
Thanks in advance
I have one cluster with two nodes. For reference, Node A = the normally active node, and Node B = the normally passive node.
When the cluster is running on Node B, scheduled jobs don't run. They work just fine when the cluster is running on Node A.
I have checked that on both nodes, all services are running under the same domain logins, and that both the jobs and the schedules within the jobs are enabled.
Everything else on the SQL seems to be working properly. I'd really like to get this working, but I don't know what else to look into.
In the past (SS 2005), I was able to apply patches to to the virtual cluster host and it automatically detected both nodes and applied the patch. This incurred downtime due to a reboot, but i did not care since this was a new cluster build.
Now, in 2008, the information I am finding implies that you should apply on passive node, perform a failover and then apply on other node.
I am curious if it is still possible to apply the patch like i did for SS 2005, where I just run the install a single time from the virtual cluster host, thereby letting the installer figure out it is a cluster and apply to both nodes?
Hi all experts,
I pretty new in SQL database along with WinServ clustering, so please mind my knowledge level in the overall process.
Base on the screenshot above, we have currently a single cluster created base in which that is controlling DB1 and DB2. Primarily DB1 would be our Active node whereas DB2 would be our Passive, both have it's own designated Public and Private IP. After a
small issue previously in which our cluster service failed, it seems that the failover has taken place in which at the moment is running on DB2, which bears the question now is would it be possible to have DB1 being the Active node without downtime? and what
is the process flow to change reactivate it back?
- Win2k3 Ent Application Server
- Win2k3 Ent DB1&2
- IBM DS5020 SAN Storage
On the disk management on each DB servers, we are not able to see the LUNs in DB1 (shown as Unreadable) whereas on DB2 it is shown as normal, in which we would assume that this is normal since DB2 is the active node.
Thanks for reading & most of my search base on this question ended up in this forum, which I would assume that this is the correct place to ask.
Can any one point me to a microsoft paper that cleary highlights the memory requirements of the passive node. I want to confirm that it needs to have the same memoery avaliable in the machine as the active node. I have been told that I doesn't.
The current active node has 16gb of ram with 4gb allocated to the os and the other split across 3 sql instances. The passive node currently only has 8gb of RAM, wouldn't it need 16gb if that is what has been allocated.
I've set in the web.config:
<!-- User Authentication -->
<forms loginUrl="~/Page/View/Content/Login.aspx" timeout="2880" requireSSL="true" />
This works fine. If there is no ssl connection, the login form doesn't continue. But I would like to check if ssl is active (in codebehind) and, if it's possible, to automatically the user to the https page if he's currently on http. (I could do this job by manually redirect with page.response("https://url.../login.aspx"); but this is not really generic. For example if the webapp is moved to another domain it doesn't work anymore... I'm looking for something like: FormsAuthentication.RedirectWithSSL(); or so... :D)
How to set SearchRoot Path in Active Directory in this
Functionality: We have scenario that
1<sup>st</sup> hit one LDAP server with some 'fixed user
name' &' fixed password ' and filter data
with specific User name(which given by user) getting 'User dn'.
After that we hit Next LDAP server based on the 'User
dn' getting from 1<sup>st</sup> server.
(So, in my case 1<sup>st</sup> LDAP
server works like as Load balancing server but functionalitywise it is
wi As System.Security.Principal.WindowsIdentity = _System.Security.Principal.WindowsIdentity.GetCurrent()
Dim a As String() = HttpContext.Current.User.
I am have requirement like displaying all the user information reporting to specific manager from Active Directory.
Please help me regarding this.