SSMS Running remotely

Posted: October 19, 2016 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server Management Studio, Uncategorized | Tags: , , | Leave a comment

To run SSMS remotely:

runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”

E.g.

runas /netonly /user:WIN-P9OQ9GF24HV\justdave “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”

Advertisement

SQL Server Clustering (FCI) setup using Cluster Shared Volumes with multipathed iSCSI disks

Posted: January 5, 2016 | Author: | Filed under: SQL Server FCI, SQL Server Management Studio, Uncategorized, Windows ACtive Directory, Windows Clustering, Windows Domain Controller Setup | Tags: , , , , | Leave a comment

Just finished an article on SQL Server Clustering (FCI) setup using

  • Windows Server 2016 Preview 4 cluster nodes
  • SQL Server 2016 CTP 3.2
  • Windows Server 2016 Preview 4 iSCSI storage using iSCSI targets as disks
  • Cluster Shared Volumes on top of the iSCSI disks
  • Multi-subnet setup
  • Domain Controller Setup
  • SSMS December 2015 release to test connections

http://smooth1.co.uk/installs/dbinstalls.html#3.1.14

SQL Server Clustering (FCI) setup using multipathed iSCSI disks

Posted: January 5, 2016 | Author: | Filed under: Microsoft SQL Server 2016, Microsoft SQL Server future, Microsoft SQL Server Management Studio, SQL Server FCI, Uncategorized, Windows ACtive Directory, Windows Clustering, Windows Domain Controller Setup | Tags: , , , , | Leave a comment

Just finished an article on SQL Server Clustering (FCI) setup using

  • Windows Server 2016 Preview 4 cluster nodes
  • SQL Server 2016 CTP 3.2
  • Windows Server 2016 Preview 4 iSCSI storage using iSCSI targets as disks
  • Multi-subnet setup
  • Domain Controller Setup
  • SSMS December 2015 release to test connections

http://smooth1.co.uk/installs/dbinstalls.html#3.1.13

NOTE: Only DB Engine and Analysis Services are supported as clustered.