Viewing 15 posts - 1,966 through 1,980 (of 9,244 total)
is it a named instance or default instance?
what is it changing from and to?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 7:29 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 5:28 am
ItsDaveTime (6/30/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 5:27 am
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
Viewing 15 posts - 1,966 through 1,980 (of 9,244 total)