Viewing 15 posts - 1,966 through 1,980 (of 9,253 total)
Please post the output of this powershell query, substitute VERSION.INSTID for your sql server version and instance name
Get-ChildItem "hklm:\software\microsoft\microsoft sql server\mssqlVERSION.INSTID\mssqlserver\supersocketnetlib\tcp\" | ForEach-Object {Get-ItemProperty $_.pspath}
so if you're using sql server...
June 30, 2015 at 8:35 am
is it a named instance or default instance?
what is it changing from and to?
June 30, 2015 at 7:29 am
😉
June 30, 2015 at 5:28 am
ItsDaveTime (6/30/2015)
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?
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)
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)
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...
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)
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...
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
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.
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...
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...
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...
June 29, 2015 at 7:16 am
Viewing 15 posts - 1,966 through 1,980 (of 9,253 total)