Connecting to a sql server database
From: Irishmaninusa (jdaly_at_structuctureinteractive.com.takemeoffifyouwantoemailme)
Date: 09/13/04
- Next message: bruce barker: "Re: Invoke C#-Function calls in aspx pages"
- Previous message: Andrew Faust: "Re: How Low Can They Stoop ?"
- Next in thread: Marina: "Re: Connecting to a sql server database"
- Reply: Marina: "Re: Connecting to a sql server database"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Sep 2004 12:33:32 -0400
I have a client who is trying to connect to a sql server database using
asp.net and this is the error message that they get, any ideas on what is
causing the error message and what the correction for this.
Code they are using
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<body>
<%
Dim Conn As SqlConnection = New SqlConnection()
Conn.ConnectionString = "Provider=SQLOLEDB;Data Source=blah;Initial
Catalog=blah;user id=blah;password=blah2;"
Conn.Open()
Dim cmdSelectSpecies as SqlCommand
Dim species_result as SqlDataReader
cmdSelectSpecies = New SqlCommand("SELECT SpeciesName FROM Species",Conn)
species_result = cmdSelectSpecies.ExecuteReader()
While species_result.Read()
Response.Write( "<li>" )
Response.Write( species_result( "SpeciesName" ) )
end While
species_result.close()
Conn.close()
%>
</body>
</html>
Error MEssage
Server Error in '/' Application.
----------------------------------------------------------------------------
---- Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. 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 'NT AUTHORITY\NETWORK SERVICE'. Source Error: Line 11: "Initial Catalog=hekman_contract;" & _ Line 12: "Integrated Security=SSPI" Line 13: Conn.Open() Line 14: Line 15: Source File: c:\inetpub\wwwroot\hekman_contract\test.AW.aspx Line: 13 Stack Trace: [SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection (SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 ASP.test_AW_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in c:\inetpub\wwwroot\hekman_contract\test.AW.aspx:13 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27 System.Web.UI.Control.Render(HtmlTextWriter writer) +7 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243 System.Web.UI.Page.ProcessRequestMain() +1926 ---------------------------------------------------------------------------- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 -- J.Daly structure:interactive Ph: 616-364-7423 Fx: 616-364-6941 http://www.structureinteractive.com
- Next message: bruce barker: "Re: Invoke C#-Function calls in aspx pages"
- Previous message: Andrew Faust: "Re: How Low Can They Stoop ?"
- Next in thread: Marina: "Re: Connecting to a sql server database"
- Reply: Marina: "Re: Connecting to a sql server database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
