Viewing 15 posts - 2,911 through 2,925 (of 9,241 total)
query the sys.configurations catalog on each server to compare the server level settings
Select name, value_in_use from sys.configurations
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:17 am
i would certainly start by resolving the VLF issue first, in fact when the VLF count gets over a 1000 sql server starts to alert in the error log that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:11 am
the fixed database and server roles are exactly that, so no you cant.
You may edit any server or database roles that you create
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:08 am
On the Principal drop the endpoint
--drop endpoint
DROP ENDPOINT PrincipalEndpointName
On the principal, create the windows login for the mirror instances svc account
--Create login
CREATE LOGIN [yourdomain\themirrorsvcuser] FROM WINDOWS
Create the endpoint
CREATE ENDPOINT PrincipalEndPoint
STATE=STARTED...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 4:10 am
oskargunn (9/26/2014)
results in the following error: Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
Should I use a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 3:56 am
Duran (9/25/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 8:51 am
No there isnt a default port but the endpoint is set to 5023 so why are you telnetting to a different port?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 8:47 am
SQLJocky (9/24/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 5:15 am
ok, the endpoint is using port 5023!!!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 5:12 am
oskargunn (9/25/2014)
I've also tried to telnet from primary site to mirror site, and that works.
on what ports?
It will also help if you can confirm whether or not there are any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:44 am
sandeepkumart (9/24/2014)
Is it possible to configure active/passive sql server cluster instance with the same ipaddress of msdtc?
No, the installer checks the IP address to ensure it is not in use....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:20 am
oskargunn (9/25/2014)
No, firewall is disabled on mirror site.
ok what about a secondary firewall, as previously suggested attempt a telnet to the port from the principal server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:14 am
do you have windows firewall enabled on the secondary server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:00 am
Duran (9/24/2014)
Lets say you have DB's log shipping from A to B in stand-by-mode so the DB are readable inbetween the apply log jobs. Is it possible to then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 2:54 am
certainly using SQL Server auth, using Windows auth will require assistance from a domain administrator
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 2:16 am
Viewing 15 posts - 2,911 through 2,925 (of 9,241 total)