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 |
|
stonebreaker
Yak Posting Veteran
92 Posts |
 Posted - 2009-11-24 : 09:41:22
|
| I want to create a maintenance plan on a server. When I remote desktop in to the server and run Management Studio, I can create the maintenance plan just fine. But when I try to create the maintenance plan using Management Studio on my desktop, it gives me an error saying it "failed to connect to <server name>. Verify that server is configured to allow remote connections." I log on either box using the same windows domain id, it's a member of the windows admin user group.I ran sp_configure and remote access is set to 1. However, remote admin connections is set to 0, and so is remote proc trans. Does anyone know which setting needs to be changed to allow remote creation of maintenance plans? |
|
|
|
|
|
server settings for remote admin of maint plans