Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Changing a name of SQL SERVER instance


Changing a name of SQL SERVER instance

Author
Message
jack.gargasz
jack.gargasz
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 7
Hi there!

Situation:

Old server named "TRANSIT" has been cloned in VMWare to a new server named "TRAFIC".
Server has been configured and has started up. Everything looks fine but:

SELECT @@SERVERNAME
> TRANSIT


We have searched MSDN and have found a document (http://msdn.microsoft.com/en-us/library/ms143799.aspx) which describes a procedure of changing a server name. The problem is - it does not work in our case:

sp_dropserver "TRANSIT"
GO
> Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 56
There are still remote logins or linked logins for the server 'TRANSIT'.


So we have tried:

sp_dropremotelogin old_name
GO
> Msg 15185, Level 16, State 1, Procedure sp_dropremotelogin, Line 68
There is no remote user '(null)' mapped to local user '(null)' from the remote server 'TRANSIT'.


or even

sp_dropremotelogin "TRANSIT\TRANSIT"
sp_dropremotelogin "local\TRANSIT"
GO


and any other combinations - same problem:
>Msg 15185, Level 16, State 1, Procedure sp_dropremotelogin, Line 68
There is no remote user '(null)' mapped to local user '(null)' from the remote server 'TRANSIT'.

>Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 56
There are still remote logins or linked logins for the server 'TRANSIT'.

Any idea how to change SQL SERVER 2008 instance name? Without this changed, we are unable to use Replication Services. Every time we try to edit, remove or even display properties of Replication -> Local Publications we get:

SQL Server is unable to complete the operation.

Additional information:
An error occurred connecting to Publisher 'TRAFIC'. (Subscription Properties)

SQL replication requires the actual server name to make a connection to the server.
Connection through a server alias, IP address, or any other alternative name are not supported.
Specify the actual server name, "TRANSIT".(Replication.Utilities)


and that is the dead end...

Anybody could help, please?
Elliott Whitlow
Elliott Whitlow
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6208 Visits: 5314
You can try:

http://msdn.microsoft.com/en-us/library/aa197071%28SQL.80%29.aspx

CEWII
jack.gargasz
jack.gargasz
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 7
That is exactly what we tried. The problems described in my post.

I have tried the approach they describe upon the website you gave me:

To disable replication using the SQL Server Enterprise Manager
Expand a server group, and then expand the Distributor (the server that contains the distribution database).

Right-click the Replication folder, and then click Disable Publishing.

Complete the steps in the Disable Publishing and Distribution Wizard.


But as soon an I do the part "Right-click the Replication folder, and then click Disable Publishing", I get:


SQL Server is unable to complete the operation.

Additional information:
An error occurred connecting to Publisher 'TRAFIC'. (Subscription Properties)

SQL replication requires the actual server name to make a connection to the server.
Connection through a server alias, IP address, or any other alternative name are not supported.
Specify the actual server name, "TRANSIT".(Replication.Utilities)


Any other suggestions? Help? Suicide booths locations?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search