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 SSMS and SSDT now GA

Posted: June 1, 2016 | Author: | Filed under: Microsoft SQL Server Data Tools, Microsoft SQL Server Management Studio, Uncategorized | Tags: , | Leave a comment

SQL Server

SSMS now generally available

https://msdn.microsoft.com/en-us/library/mt238290.aspx

SQL Server Data Tools (SSDT) for Visual Studio 2015 is now generally available.

https://msdn.microsoft.com/en-us/library/mt204009.aspx

 

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.