Server error

tlamazares · December 22nd, 2003, 03:22 PM

Hello!
I received the following message with I tried connecting to my database using my browser. Could someone please, give me some suggestions.
Thanks,
Anthony

Server Error in '/BegASPNETdb' Application.
--------------------------------------------------------------------------------

Login failed for user 'TOSHIBA-USER\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and where it originated in
the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'TOSHIBA-USER\ASPNET'.

Source Error:

Line 31: Dim objCommand As New SqlCommand(strSQL, objConnection)
Line 32:
Line 33: objConnection.Open()
Line 34:
Line 35: Response.Write("ServerVersion: " & objConnection.ServerVersion & _

Source File: C:\BegASPNETdb\webroot\ch03\SQLServer_connection.a spx Line: 33

Stack Trace:

[SqlException: Login failed for user 'TOSHIBA-USER\ASPNET'.]
   System.Data.SqlClient.SqlConnection.Open() +761
   ASP.SQLServer_connection_aspx.Page_Load(Object Source, EventArgs E) in C:\BegASPNETdb\webroot\ch03\SQLServer_connection.a spx:33
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +29
   System.Web.UI.Page.ProcessRequestMain() +724

pgtips · December 23rd, 2003, 04:51 AM

Sounds like the identity you're trying to connect with doesn't have access to the database. Try running this code in Query Analyser:

Code:

USE Master
GO
-- this line allows connection to the server
EXEC sp_grantlogin 'TOSHIBA-USER\ASPNET'
GO

-- This line grants access to a specific database
USE <<YourDbName,e.g.Northwind>> -- CHANGE THIS
GO
EXEC sp_grantdbaccess 'TOSHIBA-USER\ASPNET', 'ASPNET'
GO

dmitcha · September 4th, 2006, 01:07 PM

Phil, would you kindly take a look at my similar post? I'm not ready to run your code in the Query Analyzer because I'm not sure I'm using the right values for my connection string. Thank you. http://p2p.wrox.com/topic.asp?TOPIC_ID=49230