Connecting to a sql server database

Irishmaninusa

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.Get PooledConnection
(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(HtmlTextWrite r 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

Jul 21 '05 #1

Subscribe Post Reply

1931

Marina

You are trying to use integrated security in your app (as is shown in the
line numbered code where the connection string is shown). This looks like
it's running on 2003 server, because asp.net runs under 'network service' by
default in this case. The 'network service' account doesn't have access to
sql server, hence integrated security fails.

The page source code you show is using a username/password to connect, but
clearly your client modifed the connection string to use integrated
security.

Don't write your code as asp.net script, since then your clients will start
modifying it in unpredictable ways, and you will have a support nightmare on
your hands. You should give them specific instructions on setting up a
username/password on their sql server and have them put this in web.config
or someplace like that, and have your app look there for connection
information. I also noticed you are using the old ASP method of writing out
all the HTML on your page - this is pretty antiquated. I would recommend you
take advantage of all the asp.net server controls now available to do this
sort of thing.
"Irishmaninusa"
<jd***@structuctureinteractive.com.takemeoffifyouw antoemailme> wrote in
message news:%2****************@TK2MSFTNGP15.phx.gbl...

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.Get PooledConnection
(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(HtmlTextWrite r 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

Jul 21 '05 #2

Irishmaninusa

Thanks.
"Marina" <so*****@nospam.com> wrote in message
news:Oh**************@TK2MSFTNGP14.phx.gbl...

You are trying to use integrated security in your app (as is shown in the
line numbered code where the connection string is shown). This looks like
it's running on 2003 server, because asp.net runs under 'network service' by default in this case. The 'network service' account doesn't have access to sql server, hence integrated security fails.

The page source code you show is using a username/password to connect, but
clearly your client modifed the connection string to use integrated
security.

Don't write your code as asp.net script, since then your clients will start modifying it in unpredictable ways, and you will have a support nightmare on your hands. You should give them specific instructions on setting up a
username/password on their sql server and have them put this in web.config
or someplace like that, and have your app look there for connection
information. I also noticed you are using the old ASP method of writing out all the HTML on your page - this is pretty antiquated. I would recommend you take advantage of all the asp.net server controls now available to do this
sort of thing.
"Irishmaninusa"
<jd***@structuctureinteractive.com.takemeoffifyouw antoemailme> wrote in
message news:%2****************@TK2MSFTNGP15.phx.gbl...

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.Get PooledConnection
(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(HtmlTextWrite r 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

Jul 21 '05 #3

by: John Morgan | last post by:

I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP...

Microsoft SQL Server

Connecting to SQL Server DB

by: John Spiegel | last post by:

Hi all, I'm missing something, probably stupid, on connecting to a SQL Server database from an aspx file. I haven't really done much w/ SQL Server and suspect that it's a problem on that side. ...

ASP.NET

Separate Webserver and SQL Server -- error when connecting asp.netapp to a database

by: Ann Marinas | last post by:

Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...

ASP.NET

Connecting to Server Problem

by: Suresh | last post by:

Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...

DB2 Database

Problem connecting to my database

by: Patrick F | last post by:

Hi, i have SQL Server 2005 and a database set that is called, myCompany the problem is that i cant connect from my page to it, here is from the web.config: ( i have got this connectionstring from...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Connecting to a sql server database

Similar topics