Viewing 15 posts - 1,966 through 1,980 (of 9,241 total)
you typically harden the server after the applications have been installed not before hand.
What level of permission did the user have running the installation?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 3:31 am
Database admin(DBA) (6/29/2015)
how many log files needs to be created
You only need 1 transaction log, size it appropriately for your system
Database admin(DBA) (6/29/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 1:35 am
Please clarify the following
Ozzmodiar (6/29/2015)
I have 3 node HA set up
Each node has a standalone install of sql server?
You're implementing an alwayson availability group?
Ozzmodiar (6/29/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 1:10 am
alan.spillert (6/29/2015)
Be sure to set SQL Server Memory Option appropriately (don't leave it at the 2TB default).
Sql server 2012 std will not use more than 64gb ram, it is a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 12:51 am
g.britton (6/29/2015)
You can't.
This is incorrect, you can. It's just not good practice.
You need to grant the computer account access to the share.
Chitown (6/29/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 12:45 am
Joy Smith San (6/29/2015)
Howe to ensure the SPN we registered manually is working fine and SQL Server is using the same ?How can we confirm this ?
Thanks again,
San.
Connect...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 12:34 am
Standard edition of sql server 2012 only supports 64GB RAM, for 128GB you'll need Enterprise or install SQL Server 2014 Standard edition
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 9:18 am
Check the SPN documentation from MS, this kb has details on SETSPN, this has details on SQL Server SPNs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 9:06 am
can you provide a screenshot of the error in the cmd window?
are you copying and pasting the command into the command window?
When connecting to the instance use
SQLCMD –S Server_Name\Instance_Name -E...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 8:09 am
My first questions would be
did you manage to start the instance using
[Code="other"]
SQLServr.Exe –m[/code]
if you didn't manage to start the instance what error did you get for the login...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 7:30 am
the service accounts will need to be changed in the initial phase, this should be done via sql server configuration manager.
Once the instances are online you may start to script...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 7:16 am
editied
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 6:54 am
ramana3327 (6/25/2015)
Hi Perry,Is the passwords are same as the original passwords?
Yes, as I said above if you're moving between instances that sql server 2008 or lower your passwords are retained...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 5:48 am
the account sql server runs under will attempt to register and deregister the SPN each time it starts and stops. If the account hasn't been provided with the necessary AD...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 5:28 am
All AGs on the instance will use the same mirror endpoint but then the same is true if all the dbs are in the same group, they'll still use the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 5:25 am
Viewing 15 posts - 1,966 through 1,980 (of 9,241 total)