Viewing 15 posts - 106 through 120 (of 174 total)
What does the Failover Cluster Manager log say on one of the nodes, anything? It sounds like an issue with the shared storage. You may want to run...
September 13, 2016 at 10:40 am
Brent Ozar's articles on clustering are really good. Here is a link to one of them, you can also google his name + clustering to see others. They...
September 9, 2016 at 12:56 pm
Yeah, I am afraid you will have to remove the mirroring and rebuild it.
September 9, 2016 at 12:48 pm
I agree with you there. We always patched the passive node first, failed the databases over to it, then did the previous active, then failed them back to their...
September 8, 2016 at 11:05 am
Is it safe to say that SP3 was successfully applied to both nodes (active or passive) at one time or another?
September 8, 2016 at 10:34 am
What does the Failover Cluster Manager log say? Also, for the instance that won't fail over, is there anything related in the Sql Server error log for that instance?
September 8, 2016 at 6:33 am
I would simply follow the instructions in this link: https://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/
September 7, 2016 at 12:27 pm
Hi, can you script out the Linked Server definition on the existing 2012 instance and paste the results? From Mang Studio>ServerObjects>LinkedServers>Highlite Linked Server> rt click>ScriptLinkedServerAs.
September 7, 2016 at 12:02 pm
Since your query is a select, the account should only need db_datareader on the destination.
August 25, 2016 at 5:58 am
It sounds like there are not enough permissions for the account used in the linked server. Specifically, the account may not have correct permissions to the schema on the...
August 24, 2016 at 11:58 am
You should not have to. They should already be mapped.
August 18, 2016 at 1:09 pm
Do I have the create the same logins on the mirror server also?
Yes
Do I have to create them on the mirror database server too?
They should come over automatically when you...
August 18, 2016 at 12:43 pm
Hi, are there any messages in any of the logs (windows or sql) that say "volume shadow copy" or VSS by chance?
August 18, 2016 at 10:58 am
Try using the IP address of the virtual instance with a comma and the port number where the server name goes in SSMS on the inactive node. Also, you...
August 15, 2016 at 3:36 pm
Hi Igor,
Are you saying that you cannot connect to the instance from the node which is not active, only from the active node, whichever that one is?
August 15, 2016 at 2:53 pm
Viewing 15 posts - 106 through 120 (of 174 total)