You are welcome..

Just to get a clear picture, what is that you are trying to do from Maintenance Plan?

You can set the flow of a maintenance plan in such a way...

Yes, I too would assume there is an issue due to port number. Try changing it to a newer value and restart the SQLExpress instance.

No, it will not have any multiple occurrences. It will execute the next time it is supposed to execute (after the current execution is completed)..

Let's say the execution started at...

As mentioned by previous user, did you disable firewall and test..

Are you connecting from SSMS?

SSIS is not instance specific, so try connecting to the SSIS Instance without the \Instance name, just give the server name and try..

It is recommended to have a Clustered Index on all tables (except where there are very few rows)..

So I would not want to drop those clustered indexes.. If you have...

I would recommend that idea, just to make...

What about named pipes? have you enabled that?

Alternately have you tried logging to that instance using IPAddress\Instance name..

Read one of my articles here .. http://learnsqlwithbru.com/2010/03/07/scripting-database-objects-in-sql-server-2008/%5B/url%5D

Just filter only that table(s) you would want..

From the OP's message, what I see is the data from the client machines needs to be updated on the server, which would be possible using Merge Replication (necessary care...

Without SQL Agent, your only option is to execute the SSIS packages manually, which will be fine to do it once or twice, but that would most likely not how...

If I am not wrong, LiteSpeed has an option to restore a single object from a backup, though SQL...

I am sure with LiteSpeed or Other backup compression tools, you can backup to tape (to go with your current choice of tape backups) and at the same time you...

Look in SQL Server Surface Area Configuration. Connect by Instance and see the property for Remote connections. see if the option is set to Local and remote connections?

I am not...