Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 23rd, 2004, 04:37 PM
Registered User
 
Join Date: Mar 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to pdr1165 Send a message via AIM to pdr1165 Send a message via MSN to pdr1165 Send a message via Yahoo to pdr1165
Default sa login fail...can't find where to fix it

Error

--------------------------------------------------------------------------------
An unexpected error has occurred on this page.The system administrators have been notified.

The error occurred in:
http://localhost/thephileVB/Default.aspx

Error Message:
Cannot open database requested in login 'ThePhile'. Login fails.
Login failed for user 'sa'.

Error Stack:
System.Data.SqlClient.SqlException: Cannot open database requested in login 'ThePhile'. Login fails.
Login failed for user 'sa'.
   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 C:\wrox\ThePhileVB\WebModules\Core\DBObject.vb:lin e 53
   at Wrox.WebModules.Polls.Data.Questions.GetCurrentId( ) in C:\wrox\ThePhileVB\WebModules\Polls\Polls.Data\Que stions.vb:line 158
   at Wrox.WebModules.Polls.Business.Question.GetCurrent Id() in C:\wrox\ThePhileVB\WebModules\Polls\Polls.Business \Question.vb:line 227
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\wrox\ThePhileVB\WebModules\Polls\Poll.ascx.vb:l ine 260
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\wrox\ThePhileVB\WebModules\Polls\Poll.ascx.vb:l ine 62
   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've verified my sa password and checked the .config files in the config folder and the web.config file. Any ideas?
 
Old March 23rd, 2004, 05:55 PM
Registered User
 
Join Date: Mar 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to pdr1165 Send a message via AIM to pdr1165 Send a message via MSN to pdr1165 Send a message via Yahoo to pdr1165
Default

I have also tried two different accounts other than sa and obtained the same results (same results for each unique login that is). I tried one with a password and one without. Stumped!
 
Old March 24th, 2004, 01:36 PM
Registered User
 
Join Date: Mar 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can you use sa in query analyzer and open ThePhile?

Is your SQL Server setup to use SQL Server and Windows authentication or Windows authentication only
 
Old March 24th, 2004, 04:14 PM
Registered User
 
Join Date: Mar 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to pdr1165 Send a message via AIM to pdr1165 Send a message via MSN to pdr1165 Send a message via Yahoo to pdr1165
Default

Figured it out...I had the database names thePhile instead of ThePhile. Blasted case sensitivity! Thanks for the reply.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Login failed for user 'sa' scarlisle BOOK: ASP.NET Website Programming Problem-Design-Solution 3 November 29th, 2009 09:51 AM
Login Failed for User sa r_taduri Crystal Reports 1 November 29th, 2009 09:50 AM
Login failed for user 'sa'. ernestlambert BOOK: ASP.NET Website Programming Problem-Design-Solution 2 March 7th, 2005 12:26 PM
'sa' can not login caojun SQL Language 2 January 11th, 2005 09:08 PM
login fail by user 'sa' in .net framework 1.1 sara_1981 BOOK: Beginning ASP 3.0 3 August 2nd, 2004 07:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.