Viewing 15 posts - 76 through 90 (of 6,354 total)
OK, then you cannot use that script to do what you need to do. Reason is all the SIDs will be different in the new domain, you're going to end...
March 25, 2024 at 10:52 am
That doesn't answer the question.
What is happening to the old domain once you have migrated?
Not your old SQL AG cluster setup, the WHOLE domain?
Maybe you're domain sysadmins may shine more...
March 25, 2024 at 10:36 am
Is there going to be a trust between the two domains? Or are you going to be destroying the old domain upon migration?
If there is no trust, then are all...
March 25, 2024 at 10:20 am
If you go into your profile, there will be a Topic's Started page where you can see the forum topics which you created and not ones you replied to.
Or if...
March 22, 2024 at 11:45 am
And as for the latency, the distance between two datacenters is few miles nothing too big. So latency was never an issue. As for Availability groups, we would need Synchronous...
March 21, 2024 at 3:47 pm
1 - So you're shared storage isn't actually shared in your current setup then, you'll have 1 SAN in the Primary site, and 1 SAN in the DR site and...
March 21, 2024 at 10:41 am
1, if you set @Execute = 'N', it will print out the actions it will do in the order it will do it.
2, there is no progress indicator, you could...
March 19, 2024 at 8:44 am
Sharing the deadlock graph / XML will help people to see what went on, otherwise people will be shooting blind without the actual information.
March 18, 2024 at 8:16 am
You don't need to remove them, if you have setup the cluster and AG right it should allow some form of failover, either automatic or manual to the secondary.
You need...
March 18, 2024 at 8:12 am
SQL on Azure could be more secure depends again how its all setup, if you're just going to again put it on a public IP address then it wont be...
March 14, 2024 at 4:31 pm
No just put 1433 there.
Make sure 1433 is also not in the same place in the MSSQLSERVER2012 settings too.
Then in visual studio/SSMS whatever you use to connect put
TCP:myip,1433
March 14, 2024 at 4:30 pm
Use
TCP:myipaddress,1433
then as the connection string.
If that dont work then you'll need to work with you network admins to find out what NSG's are stopping the traffic.
Also as I say, don't...
March 14, 2024 at 3:59 pm
OK, and in TCP/IP and you scroll all the way to the bottom in IPAll, what is set for TCP Dynamic Ports / TCP Port?
Also the same for the other...
March 14, 2024 at 3:56 pm
Does it say TCP/IP is enabled here, or disabled
(Yours will say Protocols for SQLExpress)
March 14, 2024 at 3:52 pm
You need a , and not a : for the port split character.
The error tells me that you probably haven't enabled TCP/IP as a protocol, or there is a firewall...
March 14, 2024 at 3:39 pm
Viewing 15 posts - 76 through 90 (of 6,354 total)