How should i change connection string, for hosting asp.net site

Question

   connectionString=Data        Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True providerName=System.Data.SqlClient

// what should i change in my connection string so i can host my asp.net site on aspspider.info... //i get this errod

SqlException (0x80131904): User does not have permission to perform this action....and so on...

Please contact your hosting provider and I believe they will let you know the correct connection string. :) — user730420
– user730420, Commented Feb 21, 2012 at 14:55

Philip Badilla · Accepted Answer · 2012-02-21 13:54:56Z

2

\SQLEXPRESS;Initial Catalog=dubaicargo;
Persist Security Info=True;User ID=username;Password=password;pooling=false

change your connection don't use integrated security. the above connection is just a sample. there are many ways to connect to yourdatabase with more security see this for list connection strings

answered Feb 21, 2012 at 13:54

Philip Badilla

1,0581 gold badge10 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

denza Over a year ago

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;" providerName="System.Data.SqlClient"/> //i changed to this one and still doesn't change

Prabhavith · Accepted Answer · 2012-02-21 13:54:55Z

1

Try to use SqlServer Authentication instead of windows authentication

answered Feb 21, 2012 at 13:54

Prabhavith

5061 gold badge4 silver badges15 bronze badges

Collectives™ on Stack Overflow

How should i change connection string, for hosting asp.net site

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related