Problem With SQL Server Job

Hi,
We have jobs successfully running on the server. Now we moved the server to a different IP address(still the same machine).
I modified the DTS which has been scheduled as a job. In the DTS I modified the server IP address. Now when I ran the job I am getting the error message as " DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
If I run the DTS itself it is working fine. But it is not working as a job.
But if I create a new job with the same DTS, the job runs fine without any error.
I have logged into the machine with my own user account.
Please some advise on this.

ThanksAre you trying to run the encrypted job that DTS created originally? If so, the GUID points to the previous version, not the one you modified. If you change the IP and let DTS create a new job, it should be OK. Or, manually create an uncrypted job with DTSRUN (details are in BOL).|||When you run it it runs under the context of your id, which has authority to right to the drives...

When it's scheduled it runs under the context of the sql server agents account, which does not have rights...

And because you made it an ip...it's leaving and coming back in to itself...and has to authenticate...

Grant the accounts the rights to the drive...|||Yes. I am running the encrypted job. But when I replaced this encrypted string with the new encrypted string (after I created the new job from the modified DTS), the job successfully ran.
If we use DTSRUN we need to provide the username and password in the code which will be seen by other users when they check the properties of the job.
So we are using the encrypted method.
If we want to user the encryption methodology, and if there are 100s of jobs, do we have to recreate each job from the DTS and replaced the encryption string or there is any easier method?
If we use DTSRUN method and if we provide username and password for sa in that string, will it be seen by otherusers when they try to open the job?

Thanks|||Is the SQLAgent a Windows user? If so, use the /E switch for a trusted connection.

Yes, you will have to create a new job for each encrypted string. Or script out one job, gather all the encrypted strings, and mass produce them.|||Does it have to be DTS?

Can't they be sprocs?

Or is it too late?sql

Problem with SQL Server 2005 dev edition

Hi
I have just installed SQL Server 2005 dev edition. I successfully have
created a new database and a table in that database. When I try to open the
table (right click on the table and choose Open Table) I get the error
"Unspecified error" and there is nothing shown. What is wrong and how can I
fix this?
Thanks!
Julia
Julia
Hmmm, strange. Have you try SELECT * FROM table from Query Builder?
Also take a look at ERRO.LOG to see some info
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:28B6CE1C-D855-4FC3-A138-73103C4CAC9C@.microsoft.com...
> Hi
> I have just installed SQL Server 2005 dev edition. I successfully have
> created a new database and a table in that database. When I try to open
> the
> table (right click on the table and choose Open Table) I get the error
> "Unspecified error" and there is nothing shown. What is wrong and how can
> I
> fix this?
> Thanks!
> Julia

Problem with SQL Server 2005 dev edition

Hi
I have just installed SQL Server 2005 dev edition. I successfully have
created a new database and a table in that database. When I try to open the
table (right click on the table and choose Open Table) I get the error
"Unspecified error" and there is nothing shown. What is wrong and how can I
fix this?
Thanks!
JuliaJulia
Hmmm, strange. Have you try SELECT * FROM table from Query Builder?
Also take a look at ERRO.LOG to see some info
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:28B6CE1C-D855-4FC3-A138-73103C4CAC9C@.microsoft.com...
> Hi
> I have just installed SQL Server 2005 dev edition. I successfully have
> created a new database and a table in that database. When I try to open
> the
> table (right click on the table and choose Open Table) I get the error
> "Unspecified error" and there is nothing shown. What is wrong and how can
> I
> fix this?
> Thanks!
> Julia

Problem with push subscription where subscriber identified by IP not name

I have set up six push subscriptions of the same publication on a wide area
network successfully, but am having a problem with the seventh one. I think
the problem is due to the fact that the subscription was set up using the
subscribing server's IP address rather than network name (there is currently
a problem on the network so the server's name can't be resolved)
The error seen in the merge agent for the subscription is:
The subscription to publication 'PersonNameAddrUpdate' is invalid.
(Source: Merge Replication Provider (Agent); Error number: -2147201019)
------
The remote server is not defined as a subscription server.
(Source: xxx.xxx.xxx.xx (Data source); Error number: 14010)
------
(xxx.xxx.xxx.xx is the subscribing server's IP address)
Is there anything that can be done while we have this problem with the
network?
Try using the client network utility to map the subscriber's IP address to
its netbios name and then register that in Enterprise Manager and as a
subscriber.
HTH,
Paul Ibison
"Laurence Neville" <laurenceneville@.hotmail.com> wrote in message
news:%237O3GIeTFHA.2812@.TK2MSFTNGP09.phx.gbl...
>I have set up six push subscriptions of the same publication on a wide area
>network successfully, but am having a problem with the seventh one. I think
>the problem is due to the fact that the subscription was set up using the
>subscribing server's IP address rather than network name (there is
>currently a problem on the network so the server's name can't be resolved)
> The error seen in the merge agent for the subscription is:
> The subscription to publication 'PersonNameAddrUpdate' is invalid.
> (Source: Merge Replication Provider (Agent); Error number: -2147201019)
> ------
> The remote server is not defined as a subscription server.
> (Source: xxx.xxx.xxx.xx (Data source); Error number: 14010)
> ------
> (xxx.xxx.xxx.xx is the subscribing server's IP address)
> Is there anything that can be done while we have this problem with the
> network?
>
|||I figured it out with help from this page:
http://www.adminlife.com/247referenc...36/184432.aspx
The answer was:
The error can also occur if the subscriber is registered using a TCP/IP
address instead of a Name.(see 321822). To work around, use the client
utilities to create an ALIAS name to the subscribers TCP/IP address and then
use that ALIAS name when registering the subscriber instead of the TCP/IP
address.
"Laurence Neville" <laurenceneville@.hotmail.com> wrote in message
news:%237O3GIeTFHA.2812@.TK2MSFTNGP09.phx.gbl...
>I have set up six push subscriptions of the same publication on a wide area
>network successfully, but am having a problem with the seventh one. I think
>the problem is due to the fact that the subscription was set up using the
>subscribing server's IP address rather than network name (there is
>currently a problem on the network so the server's name can't be resolved)
> The error seen in the merge agent for the subscription is:
> The subscription to publication 'PersonNameAddrUpdate' is invalid.
> (Source: Merge Replication Provider (Agent); Error number: -2147201019)
> ------
> The remote server is not defined as a subscription server.
> (Source: xxx.xxx.xxx.xx (Data source); Error number: 14010)
> ------
> (xxx.xxx.xxx.xx is the subscribing server's IP address)
> Is there anything that can be done while we have this problem with the
> network?
>