CODEWITHSUNDEEP
asp.netdatabasehostingconnection-string
denza
denza

Reputation: 1298

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

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

Upvotes: 0

Views: 606

Answers (2)

Philip Badilla
Philip Badilla

Reputation: 1058

\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

Upvotes: 2

Prabhavith
Prabhavith

Reputation: 486

Try to use SqlServer Authentication instead of windows authentication

Upvotes: 1

Related Questions