Hello,

I just finished installing ThePhile.com web app. Each time I try to start the web app. I get Login failed for user COMPUTERNAME\IUSR_SERVERNAME

Stack Trace:
System.Data.SqlClient.SqlException: Login failed for user COMPUTERNAME\IUSR_SERVERNAME . at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at Wrox.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, Int32& rowsAffected) in H:\wrox\ThePhile\Modules\Core\DbObject.cs:line 104 at Wrox.WebModules.Polls.Data.Questions.GetCurrentID( ) in H:\wrox\ThePhile\Modules\Polls2\Polls.Data\Questio ns.cs:line 94 at Wrox.WebModules.Polls.Business.Question.GetCurrent ID() in H:\wrox\ThePhile\Modules\Polls2\Polls.Business\Que stion.cs:line 129 at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in H:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 123 at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in H:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 114 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain()

I changed connectionString to server=(local) in the config files

Any help would be much appreciated.

Thanks

Karl

It seems COMPUTERNAME\IUSR_SERVERNAME isn't added as a user to the database, is that correct?

Brian

Hi

Brian, thanks for the reply and yes you are right. I added the user to the database and everything is working fine.

Regards

Karl

I have face this problem
try to find the sentence you use to connect the database
delete the mode you connect the database
if you use win2000 try instead the one you delete to username=sa password=
I am a learn and English is not my native language
so if this is of no help
do not blam me