This might be a 2003 question not a SQL one but I'm stuck and I fear it's because I'm missing something really stupid.
Here goes:
I added a 2003 R2 server SP1 (basic install with no additional apps) to my network with a ton of storage.
All I want to do is change the directory where the Sql2K backup goes from an old 2K server to this new one.
For the past 3 years this has worked beautifully and will still work on any shared folder on the domain: \\192.168.35.40\SQLbackup
I change it in the Maintenance Plan to the new server IP# \\192.168.35.41\SQLbackup (I made a folder on the new server the same name)
It can't connect: "The network path was not found"
I can map a drive from the SQL server to that shared folder, and create files and delete them.
I can ping that server from the SQL server.
The only thing that fails is the Maintenance plan.
I even deleted the Plan and tried to make a new one but it still fails.
Google and this site had no posts on this.
I have no clue where to go with this.
The directory on the new server has full permissions for everyone...
Any ideas?
Here goes:
I added a 2003 R2 server SP1 (basic install with no additional apps) to my network with a ton of storage.
All I want to do is change the directory where the Sql2K backup goes from an old 2K server to this new one.
For the past 3 years this has worked beautifully and will still work on any shared folder on the domain: \\192.168.35.40\SQLbackup
I change it in the Maintenance Plan to the new server IP# \\192.168.35.41\SQLbackup (I made a folder on the new server the same name)
It can't connect: "The network path was not found"
I can map a drive from the SQL server to that shared folder, and create files and delete them.
I can ping that server from the SQL server.
The only thing that fails is the Maintenance plan.
I even deleted the Plan and tried to make a new one but it still fails.
Google and this site had no posts on this.
I have no clue where to go with this.
The directory on the new server has full permissions for everyone...
Any ideas?