Wrox Programmer Forums
All Other Wrox Books Do you have a question about a Wrox book that isn't listed anywhere on p2p.wrox.com or where the forum is locked? Here's a forum to post questions about any other Wrox book so that other readers or one of the authors can help you with your questions. IF YOU ARE LOOKING FOR CODE DO NOT ASK "Where can I find the code for this book?" That question is answered here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the All Other Wrox Books 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
  #1 (permalink)  
Old February 26th, 2004, 01:57 PM
Authorized User
Join Date: Oct 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sql server connection failed

ok ive been having problems first it said it wasnt a trusted conection so looking through here i found u had 2 download enterprise manager and now i get this error

Login failed for user 'sa'.
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 'sa'.

Source Error:

Line 10:
Line 11: 'Opens conection
Line 12: connection.Open()
Line 13:
Line 14: 'returns sqldatareader to the calling function

Source File: c:\inetpub\wwwroot\SpeedyFreaks\BusinessObjects\Ca talog.vb Line: 12

Stack Trace:

[SqlException: Login failed for user 'sa'.]
   System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   SpeedyFreaks.Catalog.GetDepartments() in c:\inetpub\wwwroot\SpeedyFreaks\BusinessObjects\Ca talog.vb:12
   SpeedyFreaks.DepartmentList.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\SpeedyFreaks\UserControls\Depar tmentList.ascx.vb:45
   System.Web.UI.Control.OnLoad(EventArgs e)

any help would be much appreciated (its in vb)

thx very much

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL server registration failed cuy .NET Framework 2.0 1 June 14th, 2006 01:07 AM
Failed to copy objects from SQL server to SQL Serv monfu SQL Server 2000 4 December 4th, 2005 05:54 PM
Sql Server Login Failed error a42 ASP.NET 1.0 and 1.1 Basics 3 December 14th, 2004 05:19 PM
sql server login failed rizp SQL Server 2000 10 September 11th, 2004 03:01 AM

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