Is it possible to change a named instance of Sql Server 2005 to the default
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric Hall
No, I believe you would need to reinstall SQL Server for that type of
change.
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
sql
Showing posts with label sp_dropserver. Show all posts
Showing posts with label sp_dropserver. Show all posts
Monday, March 26, 2012
Rename named instance to default instance?
Is it possible to change a named instance of Sql Server 2005 to the default
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
--
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
--
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
Rename named instance to default instance?
Is it possible to change a named instance of Sql Server 2005 to the default
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the defaul
t
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the defaul
t
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
Monday, February 20, 2012
Removing a server
I am trying to remove a server name from SQL Server 7.0
server by using the,
sp_dropserver 'SERVER2'
but keep getting the error of
'There are still remote logins for the server 'SERVER2'
SERVER2 no longer exists. How can I remove this server
from the Current SQL Server and/or how can I find
the 'remote logins' that belong to this server ?
Thanks.Try sp_droplinkedsrvlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>I am trying to remove a server name from SQL Server 7.0
> server by using the,
> sp_dropserver 'SERVER2'
> but keep getting the error of
> 'There are still remote logins for the server 'SERVER2'
> SERVER2 no longer exists. How can I remove this server
> from the Current SQL Server and/or how can I find
> the 'remote logins' that belong to this server ?
> Thanks.|||That did it......Thanks.......
>--Original Message--
>Try sp_droplinkedsrvlogin.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>
>.
>
server by using the,
sp_dropserver 'SERVER2'
but keep getting the error of
'There are still remote logins for the server 'SERVER2'
SERVER2 no longer exists. How can I remove this server
from the Current SQL Server and/or how can I find
the 'remote logins' that belong to this server ?
Thanks.Try sp_droplinkedsrvlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>I am trying to remove a server name from SQL Server 7.0
> server by using the,
> sp_dropserver 'SERVER2'
> but keep getting the error of
> 'There are still remote logins for the server 'SERVER2'
> SERVER2 no longer exists. How can I remove this server
> from the Current SQL Server and/or how can I find
> the 'remote logins' that belong to this server ?
> Thanks.|||That did it......Thanks.......
>--Original Message--
>Try sp_droplinkedsrvlogin.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>
>.
>
Removing a server
I am trying to remove a server name from SQL Server 7.0
server by using the,
sp_dropserver 'SERVER2'
but keep getting the error of
'There are still remote logins for the server 'SERVER2'
SERVER2 no longer exists. How can I remove this server
from the Current SQL Server and/or how can I find
the 'remote logins' that belong to this server ?
Thanks.Try sp_droplinkedsrvlogin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>I am trying to remove a server name from SQL Server 7.0
> server by using the,
> sp_dropserver 'SERVER2'
> but keep getting the error of
> 'There are still remote logins for the server 'SERVER2'
> SERVER2 no longer exists. How can I remove this server
> from the Current SQL Server and/or how can I find
> the 'remote logins' that belong to this server ?
> Thanks.|||That did it......Thanks.......
>--Original Message--
>Try sp_droplinkedsrvlogin.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>>I am trying to remove a server name from SQL Server 7.0
>> server by using the,
>> sp_dropserver 'SERVER2'
>> but keep getting the error of
>> 'There are still remote logins for the server 'SERVER2'
>> SERVER2 no longer exists. How can I remove this server
>> from the Current SQL Server and/or how can I find
>> the 'remote logins' that belong to this server ?
>> Thanks.
>
>.
>
server by using the,
sp_dropserver 'SERVER2'
but keep getting the error of
'There are still remote logins for the server 'SERVER2'
SERVER2 no longer exists. How can I remove this server
from the Current SQL Server and/or how can I find
the 'remote logins' that belong to this server ?
Thanks.Try sp_droplinkedsrvlogin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>I am trying to remove a server name from SQL Server 7.0
> server by using the,
> sp_dropserver 'SERVER2'
> but keep getting the error of
> 'There are still remote logins for the server 'SERVER2'
> SERVER2 no longer exists. How can I remove this server
> from the Current SQL Server and/or how can I find
> the 'remote logins' that belong to this server ?
> Thanks.|||That did it......Thanks.......
>--Original Message--
>Try sp_droplinkedsrvlogin.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>>I am trying to remove a server name from SQL Server 7.0
>> server by using the,
>> sp_dropserver 'SERVER2'
>> but keep getting the error of
>> 'There are still remote logins for the server 'SERVER2'
>> SERVER2 no longer exists. How can I remove this server
>> from the Current SQL Server and/or how can I find
>> the 'remote logins' that belong to this server ?
>> Thanks.
>
>.
>
Removing a server
I am trying to remove a server name from SQL Server 7.0
server by using the,
sp_dropserver 'SERVER2'
but keep getting the error of
'There are still remote logins for the server 'SERVER2'
SERVER2 no longer exists. How can I remove this server
from the Current SQL Server and/or how can I find
the 'remote logins' that belong to this server ?
Thanks.
Try sp_droplinkedsrvlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>I am trying to remove a server name from SQL Server 7.0
> server by using the,
> sp_dropserver 'SERVER2'
> but keep getting the error of
> 'There are still remote logins for the server 'SERVER2'
> SERVER2 no longer exists. How can I remove this server
> from the Current SQL Server and/or how can I find
> the 'remote logins' that belong to this server ?
> Thanks.
|||That did it......Thanks.......
>--Original Message--
>Try sp_droplinkedsrvlogin.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>
>.
>
server by using the,
sp_dropserver 'SERVER2'
but keep getting the error of
'There are still remote logins for the server 'SERVER2'
SERVER2 no longer exists. How can I remove this server
from the Current SQL Server and/or how can I find
the 'remote logins' that belong to this server ?
Thanks.
Try sp_droplinkedsrvlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>I am trying to remove a server name from SQL Server 7.0
> server by using the,
> sp_dropserver 'SERVER2'
> but keep getting the error of
> 'There are still remote logins for the server 'SERVER2'
> SERVER2 no longer exists. How can I remove this server
> from the Current SQL Server and/or how can I find
> the 'remote logins' that belong to this server ?
> Thanks.
|||That did it......Thanks.......
>--Original Message--
>Try sp_droplinkedsrvlogin.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>
>.
>
Subscribe to:
Posts (Atom)