August 3, 2010 at 11:14 pm
I have recently installed SQL Server 2008 R2 (10.50.1600)
When i clicked to create new DB Maintenance Plan, SSMT threw the following error message
TITLE: Microsoft SQL Server Management Studio
------------------------------
The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.
(MaintenancePlan)
------------------------------
ADDITIONAL INFORMATION:
The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.
(MaintenancePlan)
------------------------------
BUTTONS:
OK
------------------------------
It doesn't allow me to create the maintenance plan. i can query the databases restored on this server in SSMT. I haven't seen this error message before.
Any help is appreciated.
August 3, 2010 at 11:32 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic963233-1550-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply