about create plan in SQlServer2008 r2

• zsafakhah

  SSC-Addicted

  Points: 441

  More actions

  April 11, 2012 at 1:28 am

  #267156

  Helo Dear,

  I Loged in with sa user in SQlServer2008 r2 and wanted to Created Plan but I got Below error :

  "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."

  but when logged in with windows authentication mode in SQlServer in Could Create Plan but My jobs Fail because of My job wanted to ran by Servername\Username and can not khnowledge my User.

  what i should do?

  Please help.............

• Ashok Teotia

  SSCrazy

  Points: 2407

  More actions

  April 11, 2012 at 1:55 am

  #1471704

  Hi,

  Remove quotes around any components in connection string in data source of the job's step, Will resolve your problem.

  Regards

  Ashok

• zsafakhah

  SSC-Addicted

  Points: 441

  More actions

  April 11, 2012 at 3:31 am

  #1471732

  I Fixed it.

  1- My sa password had ; charecter . i change it.

  2- register dts.dll in C:\Program Files\Microsoft SQL Server\100\DTS\binn. I register it by regsrv32 Syntax.

  and now every thing is ok:-D