Viewing 14 posts - 76 through 89 (of 89 total)
How do I check the cliconfg?
I ran both queries these queries:
SELECT * FROM msdb.dbo.sysjobservers
SELECT * FROM msdb.dbo.sysjobs
Both the originating_server_id and the server_id are 0.
March 4, 2009 at 2:59 pm
The correct computer name \ instance name. This is different than what I'm seeing in the Maintenance Plan >> Manage Connections >> Local Area Connection. The server...
March 4, 2009 at 2:36 pm
I have tried recreating the plans, but the local area connection still points to the old server. It is grayed out and I can not change it. I...
March 4, 2009 at 2:23 pm
The connection is to the old server. I didn't do a full restore of the msdb database, but I did do a compare on it to make sure that...
March 4, 2009 at 2:08 pm
Whoops sorry, I must have gotten distracted...I'm creating the maintenance plans through SSMS.
March 4, 2009 at 1:20 pm
I ran it, but I'm not really sure what I need to be looking for.
March 4, 2009 at 1:07 pm
Yeah, I've actually already run the ipconfig commands already...didn't help the situation. Maybe I'll try dropping and re-adding the server after business hours tonight, because at this point I'm...
March 4, 2009 at 12:58 pm
I'm not seeing anything weird in the error logs, just some mail errors that don't really have to do with this.
Is it possible for my sql agent to be running...
March 4, 2009 at 12:46 pm
The instance names are the same, but the virtual server names are different than those of my 2005 Cluster.
And no, the server name was not changed along with the dns...
March 4, 2009 at 12:41 pm
Well, our developers use servername\instance name to connect to sql via their connection strings. And to not affect their work, we went ahead and created a new sql...
March 4, 2009 at 12:22 pm
The DNS changed. Is there anyway I can get things working without having to do a reinstall?
March 4, 2009 at 11:24 am
I checked and the account does seem to have appropriate permissions. I think it has something to do the the local area connection - the local area connection isn't...
March 4, 2009 at 9:58 am
That worked like a charm. Thanks for your help!
February 4, 2009 at 8:59 am
Viewing 14 posts - 76 through 89 (of 89 total)