473,766 Members | 2,120 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem Connecting to SQL

I have been creating some pages that pull info from an SQL database
located on my computer. I have an identical DB located on the
production machine. The page runs fine on my PC (XP Pro), but when I
move everything over to the target machine (2003 Server) I get this
error:

Login failed for user 'NT AUTHORITY\NETWO RK 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.Sql Client.SqlExcep tion: Login failed for
user 'NT AUTHORITY\NETWO RK SERVICE'.

Source Error:

An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:
[SqlException: Login failed for user 'NT AUTHORITY\NETWO RK SERVICE'.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection
(SqlConnectionS tring options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
System.Web.Sess ionState.SqlSta teConnection..c tor(String
sqlconnectionst ring)

[HttpException (0x80004005): Unable to connect to SQL Server session
database.]
System.Web.Sess ionState.SqlSta teConnection..c tor(String
sqlconnectionst ring)
System.Web.Sess ionState.SqlSta teClientManager .GetConnection( Boolean&
usePooling)
System.Web.Sess ionState.SqlSta teClientManager .GetExclusive(S tring id)
System.Web.Sess ionState.StateC lientManager.Be ginGetExclusive Sync
(String id, AsyncCallback cb, Object state)

System.Web.Sess ionState.SqlSta teClientManager .System.Web.Ses sionState.IS
tateClientManag er.BeginGetExcl usive(String id, AsyncCallback cb, Object
state)
System.Web.Sess ionState.Sessio nStateModule.Ge tSessionStateIt em()
System.Web.Sess ionState.Sessio nStateModule.Be ginAcquireState (Object
source, EventArgs e, AsyncCallback cb, Object extraData)

System.Web.Asyn cEventExecution Step.System.Web .HttpApplicatio n+IExecution
Step.Execute()
System.Web.Http Application.Exe cuteStep(IExecu tionStep step, Boolean&
completedSynchr onously) +173
Can someone help me? I am obviously fairly new to this. I really can't
figure out what I am missing.

Thanks
--
-- Aaron
Nov 18 '05 #1
4 1536
Hi Aaron,

It seems that you are using integrated auth. try to change it to SQL auth.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Aaron Bellante" <no**@go.away.c om> wrote in message
news:MP******** *************** *@news.microsof t.com...
I have been creating some pages that pull info from an SQL database
located on my computer. I have an identical DB located on the
production machine. The page runs fine on my PC (XP Pro), but when I
move everything over to the target machine (2003 Server) I get this
error:

Login failed for user 'NT AUTHORITY\NETWO RK 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.Sql Client.SqlExcep tion: Login failed for
user 'NT AUTHORITY\NETWO RK SERVICE'.

Source Error:

An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:
[SqlException: Login failed for user 'NT AUTHORITY\NETWO RK SERVICE'.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection
(SqlConnectionS tring options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
System.Web.Sess ionState.SqlSta teConnection..c tor(String
sqlconnectionst ring)

[HttpException (0x80004005): Unable to connect to SQL Server session
database.]
System.Web.Sess ionState.SqlSta teConnection..c tor(String
sqlconnectionst ring)
System.Web.Sess ionState.SqlSta teClientManager .GetConnection( Boolean&
usePooling)
System.Web.Sess ionState.SqlSta teClientManager .GetExclusive(S tring id)
System.Web.Sess ionState.StateC lientManager.Be ginGetExclusive Sync
(String id, AsyncCallback cb, Object state)

System.Web.Sess ionState.SqlSta teClientManager .System.Web.Ses sionState.IS
tateClientManag er.BeginGetExcl usive(String id, AsyncCallback cb, Object
state)
System.Web.Sess ionState.Sessio nStateModule.Ge tSessionStateIt em()
System.Web.Sess ionState.Sessio nStateModule.Be ginAcquireState (Object
source, EventArgs e, AsyncCallback cb, Object extraData)

System.Web.Asyn cEventExecution Step.System.Web .HttpApplicatio n+IExecution
Step.Execute()
System.Web.Http Application.Exe cuteStep(IExecu tionStep step, Boolean&
completedSynchr onously) +173
Can someone help me? I am obviously fairly new to this. I really can't
figure out what I am missing.

Thanks
--
-- Aaron

Nov 18 '05 #2
In article <eT************ **@TK2MSFTNGP11 .phx.gbl>, "Ignacio Machin
\( .NET/ C# MVP \)" <ignacio.mach in AT dot.state.fl.us > says...
Hi Aaron,

It seems that you are using integrated auth. try to change it to SQL auth.

Cheers,

I am. Is it possible to use Integrated Authority. If not, why?
--
-- Aaron "The Relentless"
Nov 18 '05 #3
In article <MP************ ************@ne ws.microsoft.co m>,
no**@go.away.co m says...
I have been creating some pages that pull info from an SQL database
located on my computer. I have an identical DB located on the
production machine. The page runs fine on my PC (XP Pro), but when I
move everything over to the target machine (2003 Server) I get this
error:
<snip>


I found an answer to my problem. For anyone else who has this problem
go to:
http://www.microsoft.com/resources/d...rv/2003/standa
rd/proddocs/en-us/Default.asp?
url=/resources/documentation/WindowsServ/2003/standard/proddocs/en-
us/sec_acc_wpenabl e.asp

Thanks, Ignacio, for your response. It pushed me in the right
direction.

--
Aaron Bellante

-I Do not suffer from insanity. I rather quite enjoy it.
Nov 18 '05 #4
Hi,

Of course it's possible, in fact you are using it in your station, now what
you have to do is include the auth for the production machine.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Aaron Bellante" <no**@go.away.c om> wrote in message
news:MP******** *************** *@news.microsof t.com...
In article <eT************ **@TK2MSFTNGP11 .phx.gbl>, "Ignacio Machin
\( .NET/ C# MVP \)" <ignacio.mach in AT dot.state.fl.us > says...
Hi Aaron,

It seems that you are using integrated auth. try to change it to SQL auth.
Cheers,

I am. Is it possible to use Integrated Authority. If not, why?
--
-- Aaron "The Relentless"

Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2547
by: Ali | last post by:
I'm trying to write a really basic chat program that allows 2 client programs to send messages to each other via a server. I've managed to write the code so that both clients can connect to the server and send and recieve messages to/from the server but when I send a message from one client I can't get the message to appear in the second client. I think it's something to do with threads but I don't know what! I've been looking at the...
1
3795
by: Dmitry Akselrod | last post by:
Hello everyone, I have a vb.net application that wraps the TCPListener object in a class. The server connects to the local interface and establishes itself on port 9900. It then polls for pending connections every 500ms. I also have a vb6 application that uses the WinSock control at the other end of the communication tunel. I have to work with vb6 here because it uses less memory than .NET.
4
3574
by: Dave | last post by:
Hey guys, I have an ODBC problem that has me stumped. I wrote a VBA script to run in Microsoft Excel that pulls data out of an application using that application's ODBC driver and puts it into Excel. I am trying to translate the same program over to Microsoft Access and I ran into a problem. Access locks up if the data I am querying for is not present in the database. To retrieve data from the database of the application, my Excel...
3
5134
by: David | last post by:
Hi, Ive been trying to work this out for the past 2 days now and im not getting anywhere fast. The problem i have is that i am using Asynchronous sockets to create a Socket Client library. When i try to connect to a server that doesnt exist it raises a "Connection forcibly rejected by the resmote host" SocketException.
3
2351
by: W Akthar | last post by:
Hi I am trying to create a windows service which queries SQL Server on timed intervals and depending on the results send appointments to Outlook. The problem lies when I try to create an outlook application object.
2
3560
by: John | last post by:
Hi I was working fine with create user wizard and the default membership provider. I have now customised the membership provider as per attached web.config. The create user wizard picks up the custom membership provider fine and removes the security question/answer fields as designated in the custom provider. The problem is that when I try to create a new user in the create user wizard by entering the info and pressing the 'create...
4
19111
by: snowweb | last post by:
I am trying to implement a CSS hierarchical unfolding menu on a site. The thing is, it needs to be dynamically populated from the results of a database query. I previously had the menu working but then it was ‘hard coded’ and not built on the fly. Menu description: 2 top level items “Company” and “Products” (we will ignore “Company” since it is still hard coded and not causing a problem. Below “Products” we have hard coded “By...
0
2867
by: NoaGross | last post by:
Hi, I'm relly new in java and I have a problem. I'm using java applet. When using http all ok, but when trying to use https i get: Java Plug-in 1.5.0_10 Using JRE version 1.5.0_10 Java HotSpot(TM) Client VM User home directory = C:\Documents and Settings\noa ---------------------------------------------------- c: clear console window
1
4351
by: spatro | last post by:
Hi, I am trying to install DBD::mysql using the CPAN and I am facing the following error: cpan> install DBD::mysql CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Warning: Found only 0 objects in /root/.cpan/Metadata CPAN: LWP::UserAgent loaded ok
2
3045
by: orandov | last post by:
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error:
0
9571
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10009
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9838
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7381
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6651
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5279
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3929
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2806
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.