This project has moved. For the latest updates, please go here.

Need to correct my Connection string.

May 8, 2012 at 5:30 AM
Edited May 8, 2012 at 5:55 AM

Hi all,

I created "TicketDesk" database in sql server. and I replaced connection as below:

Old one:

 add name="TicketDeskSecurityConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TicketDesk.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> add name="TicketDeskEntities" connectionString="metadata=res://*/Models.TicketDeskEntities.csdl|res://*/Models.TicketDeskEntities.ssdl|res://*/Models.TicketDeskEntities.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TicketDesk.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" /> add name="ElmahLog" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TicketDesk.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

 

Replaced with following :

 <add name="TicketDeskSecurityConnectionString" connectionString="Data Source=192.158.100.1;Initial Catalog=TicketDesk;Persist Security Info=True;User  ID=sa;Password=Tareta@123;Pooling=False"/>

add name="TicketDeskEntities" connectionString="metadata=res://*/Models.TicketDeskEntities.csdl|res://*/Models.TicketDeskEntities.ssdl|res://*/Models.TicketDeskEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=192.158.100.1;Initial Catalog=TicketDesk;Persist Security Info=True;User ID=sa;Password=Tareta@123;Pooling=False"/>

 

 

 

The second one "TicketDeskEntities" is I am not sure.

Please can any body correct this.. Or give any other suggestions.

 

 

 

<

 

<

add name="ElmahLog" connectionString="Data Source=192.158.100.1;Initial Catalog=TicketDesk;Persist Security Info=True;User ID=sa;Password=Tareta@123;Pooling=False"/>