T-SQL筆記25_找出SQL Server instance name_增加其他別名的instance

 
在 MSSQL中

假若想要得知當前連接的資料庫 instance名稱

可以下如下指令

1 2 3 4 5

SELECT @@servername AS 'Server Name' -- The database server's machine name ,@@servicename AS 'Instance Name' -- e.g.: MSSQLSERVER ,DB_NAME() AS 'Database Name' ,HOST_NAME() AS 'Host Name' -- The database client's machine name

而預設在連線實體上也可以看到instance名稱

也可以透過

SQL Server Configuration Manager

在windows按鍵旁輸入框

輸入SQLServerManager15.msc 

(這邊我用的是SSMS18)

來查找開啟看後綴

補充

SQL Server 2005 版本

=> SQLServerManager.msc

SQL Server 2008 版本

=>SQLServerManager10.msc

SQL Server 2012 版本

=>SQLServerManager11.msc

SQL Server 2014 版本

=>SQLServerManager12.msc

SQL Server 2016 版本

=>SQLServerManager13.msc

SQL Server 2017 版本(SSMS17)

=> SQLServerManager14.msc

SQL Server 2019 版本(SSMS18)

=>SQLServerManager15.msc

假若我今天想新增一個別名

HostName\SQLEXPRESS

17-0535860-01\SQLEXPRESS

則要透過Installer來做額外安裝

然後接受合約並按下一步直到出現接下畫面

如此就能夠在本機同時有兩個instance了

Ref:

SQL Server 組態管理員

https://docs.microsoft.com/zh-tw/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver15

如何把 SQL Server 標準版當成 SQL Server Express 來用

https://blog.miniasp.com/post/2011/05/24/SQL-Server-Standard-as-SQL-Server-Express-using-Alias

SQL2008 - 安裝多 Instances 執行個體在同一台 Server

https://blog.xuite.net/tolarku/blog/31203264-SQL2008+-+%E5%AE%89%E8%A3%9D%E5%A4%9A+Instances+%E5%9F%B7%E8%A1%8C%E5%80%8B%E9%AB%94%E5%9C%A8%E5%90%8C%E4%B8%80%E5%8F%B0+Server+

How do I find the MS SQL instance name on my Windows system?

https://qualysguard.qualys.com/qwebhelp/fo_portal/authentication/ms_sql/ms_sql_server_instance_name.htm

[MSSQL] 快速開啟 SSMS & SQL Server Configuration Manager

https://dotblogs.com.tw/henryli/2015/05/20/151349

How to get current instance name from T-SQL

https://stackoverflow.com/questions/18070177/how-to-get-current-instance-name-from-t-sql

SQL Server - How to Create Multiple Instances on Single Server

http://www.sqlines.com/sql-server/create_multiple_instances

Create a new SQL Server Instance

https://manuals.gfi.com/en/SetupSQLInstanceGuide/content/administrator/topics/sql/createsqlserverinstance.htm

Create Microsoft SQL Server named instances

https://docs.microfocus.com/itom/Operations_Bridge_Manager:2019.11/SqlInstances

Steps to Connect to SQL Server When all System Administrators are Locked Out

https://www.mytechmantra.com/sql-server/steps-to-connect-to-sql-server-when-all-system-administrators-are-locked-out/

SQL Server Single User Mode Connection with SQL Server Management Studio

https://www.mssqltips.com/sqlservertip/6531/sql-server-single-user-mode-connection-with-sql-server-management-studio/

Login failed for user ‘xxx’. Reason: Server is in single user mode. Only one administrator can connect at this time.

https://learnsqlteam.com/2018/03/29/login-failed-for-user-xxx-reason-server-is-in-single-user-mode-only-one-administrator-can-connect-at-this-time/

Help: How to fix error – Reason: Server is in single user mode. Only one administrator can connect at this time

https://sqlserver-help.com/2013/12/06/help-how-to-fix-error-reason-server-is-in-single-user-mode-only-one-administrator-can-connect-at-this-time/