Set up
MS SQL 2005 on laptop (not express)
Connection string btw Asp.net and my database, that been working fine...
<add name="RTT_OPS_con" connectionString="Data Source=.;Initial Catalog=RTT_OPS;Integrated Security=True;MultipleActiveResultSets=true;" providerName="System.Data.SqlClient"/>
So I thought I would have a go with a general user on my database, I created a user name "RTTuser", and gace it reader/writer db roles. I setup if for my asp.net project database only.
The new connection string in my webconfig is...
<add name="RTT_OPS_con" connectionString="Data Source=.;Initial Catalog=RTT_OPS; User Id=RTTUser; Password=xxxxxxxxx63; MultipleActiveResultSets=true;Trusted_Connection=False;" providerName="System.Data.SqlClient"/>
BUT I get there error RTTUser is not a fails under a trusted connection.
I also tu ...
Go to the complete details ...