Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mlevier
Starting Member
33 Posts |
 Posted - 2008-03-07 : 12:06:25
|
| I am trying to set up a maintenance plan is SQL Server. I set one up to query one of my very small tables for testing purposes. I made sure that I have the server entered in correctly and also verified that I needed to make sure that I have both TCP/IP and Named Pipes both enabled. However, everytime I set something up and try to execute it. The plans ends up failing. This isn't a hard process but something else isn't setup that needs to be. Does anyone have any ideas pertaining to this. Is there a special credential that needs to be setup for this?Any help on this would be great. Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-07 : 12:09:47
|
| Is your SQL Server agent Working fine? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-07 : 22:29:05
|
| How did you create maintenance plan step by step? |
|
|
|
mlevier
Starting Member
33 Posts |
Posted - 2008-03-10 : 14:20:26
|
| I actually tried it both ways just to make sure that I wasn't missing something. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-10 : 21:51:42
|
| Still don't know how did you do that. By the way, any useful message in plan's log file and job history? |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-26 : 23:00:43
|
| Check the sequence of the named pipe and TCP/IpManojMCP, MCTS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 23:06:14
|
| Not sure if it's related. By the way, why do you dig those old post out? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-26 : 23:08:20
|
Please stop mdubey. I think he is trying to increase his posts with meaningless answer. |
|
|
|
|
|
|
SQL Server Maintenance Plans