Changing SQL Server Name

Greetings,
I have an application that runs on SQL Server XXXX. I want to change the
name of the server to YYYY.
Other than changing references within the application, is there anything
else I need to do because of the Server name change?
Platform: Win 2000 Server/SQL Server 2000
Thanks in advance,
Don
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
After renaming a server, you also need to update the system table
references to the server name - something like:
sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName','local'
After executing the stored procedures, restart SQL Server.
-Sue
On Thu, 09 Sep 2004 09:33:34 -0700, don larry <donlarry17@.hotmail.com>
wrote:

>Greetings,
>I have an application that runs on SQL Server XXXX. I want to change the
>name of the server to YYYY.
>Other than changing references within the application, is there anything
>else I need to do because of the Server name change?
>Platform: Win 2000 Server/SQL Server 2000
>Thanks in advance,
>Don
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!
|||Oh and the jobs. You can script out your jobs and then go through the
script and change the server name and replace the jobs with the new
jobs you have just scripted.
The sysjobs table has the originating_server column which has the
server name value stored in it. It will be referencing the old server
name when you rename the server.
-Sue
On Thu, 09 Sep 2004 09:33:34 -0700, don larry <donlarry17@.hotmail.com>
wrote:

>Greetings,
>I have an application that runs on SQL Server XXXX. I want to change the
>name of the server to YYYY.
>Other than changing references within the application, is there anything
>else I need to do because of the Server name change?
>Platform: Win 2000 Server/SQL Server 2000
>Thanks in advance,
>Don
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!
|||I've written an article on this particular topic:
http://www.karaszi.com/SQLServer/inf...rver_name.asp.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"don larry" <donlarry17@.hotmail.com> wrote in message
news:%23w$LBrolEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Greetings,
> I have an application that runs on SQL Server XXXX. I want to change the
> name of the server to YYYY.
> Other than changing references within the application, is there anything
> else I need to do because of the Server name change?
> Platform: Win 2000 Server/SQL Server 2000
> Thanks in advance,
> Don
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thank you so much guys, i will implement all these steps.
Big Appreciation!
Don
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sql

Changing SQL Server Name

Greetings,
I have an application that runs on SQL Server XXXX. I want to change the
name of the server to YYYY.
Other than changing references within the application, is there anything
else I need to do because of the Server name change?
Platform: Win 2000 Server/SQL Server 2000
Thanks in advance,
Don
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!After renaming a server, you also need to update the system table
references to the server name - something like:
sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName','local'
After executing the stored procedures, restart SQL Server.
-Sue
On Thu, 09 Sep 2004 09:33:34 -0700, don larry <donlarry17@.hotmail.com>
wrote:
>Greetings,
>I have an application that runs on SQL Server XXXX. I want to change the
>name of the server to YYYY.
>Other than changing references within the application, is there anything
>else I need to do because of the Server name change?
>Platform: Win 2000 Server/SQL Server 2000
>Thanks in advance,
>Don
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!|||Oh and the jobs. You can script out your jobs and then go through the
script and change the server name and replace the jobs with the new
jobs you have just scripted.
The sysjobs table has the originating_server column which has the
server name value stored in it. It will be referencing the old server
name when you rename the server.
-Sue
On Thu, 09 Sep 2004 09:33:34 -0700, don larry <donlarry17@.hotmail.com>
wrote:
>Greetings,
>I have an application that runs on SQL Server XXXX. I want to change the
>name of the server to YYYY.
>Other than changing references within the application, is there anything
>else I need to do because of the Server name change?
>Platform: Win 2000 Server/SQL Server 2000
>Thanks in advance,
>Don
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!|||I've written an article on this particular topic:
http://www.karaszi.com/SQLServer/info_change_server_name.asp.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"don larry" <donlarry17@.hotmail.com> wrote in message
news:%23w$LBrolEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Greetings,
> I have an application that runs on SQL Server XXXX. I want to change the
> name of the server to YYYY.
> Other than changing references within the application, is there anything
> else I need to do because of the Server name change?
> Platform: Win 2000 Server/SQL Server 2000
> Thanks in advance,
> Don
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thank you so much guys, i will implement all these steps.
Big Appreciation!
Don
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Changing Service Account

We need to change the account that the ReportServer service runs under. Is
it as simple as changing the account that the service logs on with, or is it
more involved?It is more involved because the RS symmetric key is encrypted and stored in
the RS database using the user that the RS Windows service is running under.
If you change the Windows service account RS won't be able to decrypt this
key unless you follow the procedure below.
1. Delete the references to the old key: rskeymgmt -r <installation id> (the
installation ID can be found in the rsreportserver.config file
2. Stop IIS and the Report Server windows service
3. Change the account service runs under to a domain account that can log in
to your reporting database.
4. Start IIS and the Report Server windows service
5. Reapply the encryption key: rskeymgmt -a -f <filename from step
1> -p<password from step 1>.
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"dachrist" <dachrist@.discussions.microsoft.com> wrote in message
news:45676F56-51C9-45D7-9067-D289DE2D91AF@.microsoft.com...
> We need to change the account that the ReportServer service runs under.
Is
> it as simple as changing the account that the service logs on with, or is
it
> more involved?

Changing domains and restoring db's

I have a 2000 server that also runs SQL 7.0.
This server is a PDC of domain "A". It also happens to be
the only server on the domain.
I am tasked to eliminate this domain and bring this server
into domain "B". I have been told that unfortunately, I
will have to FDISK this guy to scratch and reinstall OS,
SQL, everythng, to bring him into new domain.
Is this true?
Also, the SQL has some pretty big databases and of course
they are backed up nightly, but I was hoping not to have
to restore these db's from tape but instead, copy the
databases over to another server, then copy them back
after I have reinstalled the server and brought him into
domain "B".
Can I do this and what do I need to know how to go about
this?"Rick" <anonymous@.discussions.microsoft.com> wrote in message
news:00aa01c39991$10541780$a501280a@.phx.gbl...
> I have a 2000 server that also runs SQL 7.0.
> This server is a PDC of domain "A". It also happens to be
> the only server on the domain.
> I am tasked to eliminate this domain and bring this server
> into domain "B". I have been told that unfortunately, I
> will have to FDISK this guy to scratch and reinstall OS,
> SQL, everythng, to bring him into new domain.
> Is this true?
> Also, the SQL has some pretty big databases and of course
> they are backed up nightly, but I was hoping not to have
> to restore these db's from tape but instead, copy the
> databases over to another server, then copy them back
> after I have reinstalled the server and brought him into
> domain "B".
> Can I do this and what do I need to know how to go about
> this?
First make sure that the SQL services are not running under a domain
account. Go to the services applet and change the SQL services to use a
local system login (note: from this point SQL won't be able to use network
resources).
Then run dcpromo. Tell the wizard that this is the last domain controller
in the domain. This should turn it into a standalone server. Then you
should be able to join domain B and run the SQL services under a new domain
account.
To transfer databases from one SQL server to another use the DTS wizard from
Enterprise Manager. It has an option to transfer all objects from one SQL
database to another.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003|||So you're saying that I do not have to FDisk this server
and reinstall everything? I can just turn it into a
standalone server first and then bring it into a new
domain?
If that is the case, then I wouldn't have to do anything
to the SQL portion right? I'd just leave it as is?

Changing database connect to dynamic then the report fails.

Hi all. I've got a report in RS2005 where I am trying to be able to change the database it runs against based on a parameter. I started by making the report and having this as my connect string in the dataset:

="data source=MyServer; initial catalog=DataYear2005"

I was able to connect and preview the report with no problems. I checked the forum and found out that to make it dynamic, I should be able to just add a parameter to the above definition. I set up the parameter as a string with a default value of 2005 and then changed the connect string to be:

="data source=MyServer; initial catalog=DataYear"+Trim(Parameters!sSession.Value)

When I preview this, I get the error: "Error durring processing of the ConnectString expression of datasource MyDatasource."

I'm working in the VS.Net 2005 environment that gets installed with the SQL Server 2005 tools and running against a SQL Server 2000 server. Any help would be apprieciated.

Suggestion: change the connection string back so that the report is working again. Then add a textbox in the report that uses the same expression as your planned dynamic connection string expression. Make sure the expression works in that report textbox. I think there may be type conversion problems with the expression or the name of the report parameter is not correct (case-sensitive!). You may also want to try:

="data source=MyServer; initial catalog=DataYear" & Trim(CStr(Parameters!sSession.Value))

-- Robert

|||

Robert,

I tried your ideas and it is still not working. I set up the text box with the expression and I also made one with the connect string without the parameter. The data in both text boxes was identical. I then added the CStr function with no improvements. I also verified that the case was correct and it was. Any other ideas?

Thanks.

|||

Do you have any parameters that are query based and rely on this connection string?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.