简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Database> Mysql Tutorial> body text

sqlserver exchange instance name

WBOY
Release： 2016-06-07 15:09:50
Original
1264 people have browsed it

0 down vote I followed the procedure mentioned in http://sqldbpool.com/2008/09/03/how-to-change-sql-server-instance-name/like this For default instance sp_dropserver 'old_name'gosp_addserver 'new_name','local'go For named instance sp_drops

0down vote

I followed the procedure mentioned in http://sqldbpool.com/2008/09/03/how-to-change-sql-server-instance-name/like this

For default instance

sp_dropserver 'old_name' go sp_addserver 'new_name','local' go
Copy after login

For named instance

sp_dropserver 'Server Name\old_Instance_name' go sp_addserver 'ServerName\New Instance Name','local' go
Copy after login

down votefavorite

I installed VS2010 and it automatically installed SQL Server 2008 Express.

Now, the installed instance is called SQLEXPRESS, therefore to connect to it I have to use 'localhost\SQLEXPRESS' or '.\SQLEXPRESS' or something like that.

I want to rename the instance so I can connect using only my computer name or 'localhost'.

How do I do this?

I'm not sure of the express version of SQL Server bundled with VS 2010, but with the Standalone SQL Express 2008 (or R2), running the setup again will let you create a new instance.

enter image description here

Related labels：
exchange sqlserver
source：php.cn
Previous article：SQL Server 2005 中的分区表和索引 Next article：MySQL高可用解决方案(MySQL HA Solution)
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
XAMPP/SQLSRV: Unable to find Sqlsrv in PHPINFO(); - error from connection I'm trying to connect to my SQLServer database hosted on a LinuxVM. I'm running xampp on m...
From 2023-11-09 22:34:33
0
1
172
MySQL - Convert rows to columns I tried searching posts but only found solutions for SQLServer/Access. I need a solution i...
From 2023-10-13 11:50:31
0
1
232
Why is there only column name but no where equal to value in MySQL? It is not a syntax error Why is such a query not a syntax error? I have a SQLServer background and I'm really surpr...
From 2023-09-16 10:37:20
0
1
295
Experiment with sorting after query limit So this is my first question here, please forgive me if something is wrong. I'm trying to ...
From 2023-09-05 14:46:42
0
1
350
Background or font color in HTML is red I have the following code to send email notifications to recipients and it works great. Th...
From 2023-09-03 09:18:19
0
1
333
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！