Viewing 15 posts - 76 through 90 (of 625 total)
I have verified by query select * from sys.server_principals, and that windows logins already exists.
USE [master]
GO
CREATE LOGIN [servername\sqladmin] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english],
GO
ALTER SERVER ROLE [sysadmin] ADD MEMBER [servername\sqladmin]
GO
SID=0x010500000000000515000000017CF23F899DF198F4C91586E9030000
Pl. correct...
November 20, 2015 at 12:41 am
Thanks for reply...
I checked at Error log
Message
Login failed for user 'Servername\sqladmin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
Message
Error: 18456, Severity: 14, State: 5.
It means...
November 19, 2015 at 2:50 am
Thank you anthony.green..
AM I correct as following condition.
1. Two nodes cluster with AO setup - it should be require to configure file share to another server for reading cluster resource...
October 27, 2015 at 7:11 am
Thanks a lot Mr. Anthony.green..
Created file share to another file server and configured NodeFileMajority in cluster.
Performed Tested as below
- It is working smoothly..just shutdown Node1 and...
October 27, 2015 at 6:42 am
Yes.. I am loosing quorum resource between two nodes...at first time I did not configure File share features during AO setup.
Is it mandatory to add 3rd node or just enable...
October 27, 2015 at 5:06 am
Yes.
Total 2 Nodes and AO configured these two nodes. There is no shared disk only local VHD. also not configured File share witness option.
Simulated AO setup.
1. Just stop the...
October 27, 2015 at 4:33 am
Yes. It is two nodes cluster configured in AO. No shared disk.
OS: Windows 2008 R2
DB: SQL Server 2012
Get-ClusterQuorum details
PS C:\Windows\system32> Get-ClusterQuorum -Cluster ClusterName
Cluster ...
October 27, 2015 at 3:08 am
Simulated AO setup.
1. Just stop the SQL Services in Node1 and connect AO Listener at client. It got connect and succeed - OK.
2. started Node1 SQL services and stop...
October 23, 2015 at 4:37 am
I red your stairway series 6..
There are two node FCI configured as below
Server Instance Node 1
Role - Primary
Availability Mode - synchronize
Failover Mode - Automatic
Connection in Primary Role - Allow...
October 20, 2015 at 1:17 am
Hi Perry Thanks for reply..
I studied some document internet both IPs are not be same.
1. Cluster IP unique IP - 10.xx.xxx.22
2. AG Listener unique IP - 10.xx.xxx.23
I Configured above...
October 19, 2015 at 7:11 am
I want to know, does cluster IP and Listener IP both are same? or should be entered different IP on both side in alwayson AG configuration?
thanks
October 18, 2015 at 10:21 pm
Hello Mr. Perry..
What I am asking,
1. I should enter the unique IP address in access point administration portion while creating cluster group.
Application connection string which IP address to be...
October 8, 2015 at 1:18 am
Thanks for your replay..
I am not a developer. but I will try my best.
Could you give me any example for how will change existing nested cursor to set based...
October 7, 2015 at 3:36 am
Thanks Perrry for your replay...
Can always On setup by using standalone SQL instance with local HD, In this scenario, Does it require to meets pre -requisites on both the nodes?...
October 6, 2015 at 5:27 am
1. We are not using shared storage for current setup of always On availability group due to budgets constraints.. can be able to configure without SAN shard storage?
2. My requirement...
October 6, 2015 at 4:19 am
Viewing 15 posts - 76 through 90 (of 625 total)