Viewing 15 posts - 3,601 through 3,615 (of 9,244 total)
go into add\remove programs and uninstall the sql native client then re run the installer
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2014 at 5:23 am
N.D (2/4/2014)
ah cheers, so it's the OS that's the dependency & that answers my question very nicely 🙂
On Windows 2008 you'll still get the option of AD groups but you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2014 at 4:44 am
Moving the user and system database files to different locations can be done. It depends on your amount of experience with SQL Server. The fact that the mounted volumes are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2014 at 4:22 am
what version ESX\VSphere you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2014 at 3:57 am
The requirement to use group auth is based on the OS you are installing SQL server onto. If you're using a legacy OS such as Windows 2003 you'll need to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2014 at 3:56 am
michael.mcloughlin (2/3/2014)
OK im getting mixed messages on whether a heartbeat network is needed, Microsoft recommend you dont use one for 2008 onwards as it can have adverse effects.
A lot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2014 at 7:44 am
Jeff Moden (2/2/2014)
Me too! That way, I can just turn them off and call it a day. 😀
Whatever floats your boat 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2014 at 7:24 am
Terminal services in admin mode only allows 2 seeisons at a time. You'll need to reconfigure TS to allow multi user connections, you'll need to add the new role via...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2014 at 6:16 am
ah ok, i was incorrectly assuming you were using Windows 2012, that PS command is incorrect. Check the cluster events to ensure that there are no errors. I'll need to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2014 at 4:29 am
The reason it says not recommended is because the node votes are unavailable. What OS are you using?
Can you post the results of the following query run on the cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2014 at 6:18 am
michael.mcloughlin (1/31/2014)
From what i read when looking into this it is suggested that a heartbeat isn't required any more from SQL 2008 onwards?
Yes but when running the cluster validation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2014 at 10:40 am
HowardW (1/31/2014)
michael.mcloughlin (1/31/2014)
I have upped the session time-out to 15 seconds, i assume this is just a standard ping?Will see how it goes over the weekend.
Careful with that, it really...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2014 at 6:22 am
Mani-584606 (1/30/2014)
Instance one on Node1:
Instance Name: AlwaysOnAG1\INS1
E:\SQLData\INS1
F:\SQLLogs\INS1
Instance two on node2:
Instance Name: AlwaysOnAG2\INS2
E:\SQLData\INS2
F:\SQLLogs\INS2
If we wanted to use Always on Availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2014 at 4:05 am
the reader role allows multi server job access over the user role, do they need this?
The users will only be able to edit jobs\schedules that they own, what is it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2014 at 3:59 am
DBANoobie (1/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2014 at 7:40 pm
Viewing 15 posts - 3,601 through 3,615 (of 9,244 total)