change email link in subscription

how can i change the link from http://servername/... to http://ipaddress/...
in the subscription email? Right now I don't have dns setup yet so I would
like to you ip address instead but the email sent out with the
http://servername/... link. Please adviceYou could try changing the urlroot element in RSReportServer.config.
Mike G.
"John R" <JohnR@.hotmail.com> wrote in message
news:%238SXzDLFFHA.2052@.TK2MSFTNGP09.phx.gbl...
> how can i change the link from http://servername/... to
> http://ipaddress/... in the subscription email? Right now I don't have dns
> setup yet so I would like to you ip address instead but the email sent out
> with the http://servername/... link. Please advice
>

change @@SERVERNAME 2005 - Urgent please help !!!

Hi There

I have changed the servername of a sql server 2005 instance. Using sp_dropserver and sp_addserver as per BOL.

However, after changing the servername i still see that :

EWX-JDGSQLSRV1\SQLServer2005SQLAgentUser$EWX-JDGSQLSRV1$MSSQLSERVER

EWX-JDGSQLSRV1\SQLServer2005MSSQLUser$EWX-JDGSQLSRV1$MSSQLSERVER

EWX-JDGSQLSRV1\SQLServer2005MSFTEUser$EWX-JDGSQLSRV1$MSSQLSERVER

built in logins still have the old server name.

My big concern is that these will no longer work?

Also i am changing not only servernames but doamins, i cannot find anythign on chaning domains and all that must be done.

Are the built in sql server logins still ok after i change the servername ? Even though they do not reflect the change?

Wjat else must i do before moving the server to a new domain (i will change the servcie accounts to use new domain accounts in the configuration manager?)

Thanx

Dietz:

Did you include the "local" tag when you called the sp_addserver stored procedure?

Dave

|||

Yes i did, i found the prblem though. Has nothing to do with that when i checked the sql log it could not execute sp_startup_agent, becuase agent XP's were not enabled, i could not enable agent XP's because lock pages in memory priviledges were not granted to the new sqlservice account.

So i granted the priviledges and enabled agent XP's and all was well.

Cdosys

I am trying to send job status information using smtp via cdosys. I have it emailing but I want to pass the servername and jobname in the email. Can anyone assist?

***oops, here is the SP and the command ran from the job steps;;;

************************************************** *****

CREATE PROCEDURE [dbo].[sp_send_cdosysmail]
@.From varchar(100) ,
@.To varchar(100) ,
@.Subject varchar(100)=" ",
@.Body varchar(4000) =" "
/************************************************** *******************

This stored procedure takes the parameters and sends an e-mail.
All the mail configurations are hard-coded in the stored procedure.
Comments are added to the stored procedure where necessary.
References to the CDOSYS objects are at the following MSDN Web site:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/_cdosys_messaging.asp

************************************************** *********************/
AS
Declare @.iMsg int
Declare @.hr int
Declare @.source varchar(255)
Declare @.description varchar(500)
Declare @.output varchar(1000)

--************* Create the CDO.Message Object ************************
EXEC @.hr = sp_OACreate 'CDO.Message', @.iMsg OUT

--***************Configuring the Message Object ******************
-- This is to configure a remote SMTP server.
-- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/_cdosys_schema_configuration_sendusing.asp
EXEC @.hr = sp_OASetProperty @.iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2'

-- This is to configure the Server Name or IP address.
-- Replace MailServerName by the name or IP of your SMTP Server.
EXEC @.hr = sp_OASetProperty @.iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', 'smtpserver'

-- Save the configurations to the message object.
EXEC @.hr = sp_OAMethod @.iMsg, 'Configuration.Fields.Update', null

-- Set the e-mail parameters.
EXEC @.hr = sp_OASetProperty @.iMsg, 'To', @.To
EXEC @.hr = sp_OASetProperty @.iMsg, 'From', @.From
EXEC @.hr = sp_OASetProperty @.iMsg, 'Subject', @.Subject

-- If you are using HTML e-mail, use 'HTMLBody' instead of 'TextBody'.
EXEC @.hr = sp_OASetProperty @.iMsg, 'TextBody', @.Body
EXEC @.hr = sp_OAMethod @.iMsg, 'Send', NULL

-- Sample error handling.
IF @.hr <>0
select @.hr
BEGIN
EXEC @.hr = sp_OAGetErrorInfo NULL, @.source OUT, @.description OUT
IF @.hr = 0
BEGIN
SELECT @.output = ' Source: ' + @.source
PRINT @.output
SELECT @.output = ' Description: ' + @.description
PRINT @.output
END
ELSE
BEGIN
PRINT ' sp_OAGetErrorInfo failed.'
RETURN
END
END

-- Do some error handling after each step if you have to.
-- Clean up the objects created.
EXEC @.hr = sp_OADestroy @.iMsg
GO
************************************************** ****

declare @.Body varchar(4000)
select @.Body = 'Job Succeeded'
exec sp_send_cdosysmail 'me@.you.com','you@.me.com','servername Jobname',@.Body

ThanksAnyone? Bueller?