You must Sign In to post a response.

07 Sep 2016 01:01

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	4

How to Converting SQL Server named instance to default instance

Hi

How to Converting SQL Server named instance to default instance.

I have install in Sql Server for this instance
ADMIN-PC\SQLEXPRESS

but now i need no instance name after instance how to convert SQL Server named instance to default instance.

I need my sql instance this
ADMIN-PC

no need SQLEXPRESS in SQLSERVER connection

I searched google but no luck.

any one guide me.

#767790

09 Sep 2016 03:14

Joined:	05/05/2016
Level:	Bronze
Points:	8

Points:	2

Could you please try on below step:
1. Login to Sql Server with another instance (not default one)
2. Try below query

sp_dropserver ADMIN-PC\SQLEXPRESS ;
GO
sp_addserver ADMIN-PC, local;
GO

3. restart the SQL instance

Submit New Thread

Return to Return to Discussion Forum

How to Converting SQL Server named instance to default instance

About dotnetspider.com

Quick Links

General

Services