473,725 Members | 2,248 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem when accessing SQL database in website

I am developing apps in VWD Express and SQL Svr 2005 Express. I currently
have a web server running Win2K3 SBS W/IIS V.6.0 & ASP.NET 2.0. I am
currently using a test site that is only availible on my intranet. I have no
problem accessing the site, but when a link is clicked or somthing happens
where data is required from the SQL database, I get a long, ugly error
message that says:

Server Error in '/' Application.
----------------------------------
Cannot open user default database. Login Failed.
Login failed for user "NT Authority\Netwo rk Service".

Then the error message continues forever. This is what I have tried to do to
correct the problem: I have change the permissions in the SQL Server
Management Studio Express program that I downloaded from the Microsoft
website to allow the "NT Authority\Netwo rk Service" account authorization to
the database. I am a beginner at developing web apps, so I don't know much
about Visual Basic, so I havn't really done much code to the web.config file.
I have read books, and searched google for about a week and I still can't
find anything. I hope that this question doesn't seem too stupid. Thank You
for your help, and your response. - Jake
Mar 13 '06 #1
1 2233
why not turn on SQL Authentication and specify a username/password in your
connection string?

So ur connection string would look like:
Data Source=Aron1;In itial Catalog=pubs;Us er Id=sa;Password= asdasd;"

instead of using Trusted_Connect ion or Integrated_Secu rity

Karl

--
http://www.openmymind.net/

"Jake Henderson" <Ja***********@ discussions.mic rosoft.com> wrote in message
news:19******** *************** ***********@mic rosoft.com...
I am developing apps in VWD Express and SQL Svr 2005 Express. I currently
have a web server running Win2K3 SBS W/IIS V.6.0 & ASP.NET 2.0. I am
currently using a test site that is only availible on my intranet. I have
no
problem accessing the site, but when a link is clicked or somthing happens
where data is required from the SQL database, I get a long, ugly error
message that says:

Server Error in '/' Application.
----------------------------------
Cannot open user default database. Login Failed.
Login failed for user "NT Authority\Netwo rk Service".

Then the error message continues forever. This is what I have tried to do
to
correct the problem: I have change the permissions in the SQL Server
Management Studio Express program that I downloaded from the Microsoft
website to allow the "NT Authority\Netwo rk Service" account authorization
to
the database. I am a beginner at developing web apps, so I don't know much
about Visual Basic, so I havn't really done much code to the web.config
file.
I have read books, and searched google for about a week and I still can't
find anything. I hope that this question doesn't seem too stupid. Thank
You
for your help, and your response. - Jake

Mar 14 '06 #2

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

Similar topics

8
3971
by: ndsoumah | last post by:
hello guys I'm trying to get access to variables I put in a session variable from another page and it fails... here's the exact situation main file page1.php
9
2409
by: Pacific Design Studios | last post by:
I'm running ASP on IIS 5. My users who are on the network can access our database. Any users from the internet "outside" the network can't access it. We don't have a firewall. Our Windows Server crashed and ever since then its been a problem. Any suggestions. I think it is a setting in IIS. Thanks. ERoessing@pacificdesignstudios.com
2
4637
by: WisTex | last post by:
I've come across a very weird problem. Virtual includes work on all my ASP pages on the entire website, including those in subdirectories, yet they won't work on a particular page I created, even though the virtual include statement is copy & pasted exactly as it appears on the working pages. What would cause virtual includes to work in one page on a website, but not on another? Error Message: Microsoft VBScript runtime error...
0
2132
by: Alex Brown | last post by:
Is it a problem to attach Non-static site map providers under one that inherits from StaticSiteMapProvider ? We are implementing a custom site map provider for a website that is being converted to ASP.NET 2.0. The conversion is going well because some of the features, like Master Pages and Site Maps, of ASP.NET 2.0 allow us to migrate away from a "top frame" style of navigation to a standard dynamic cascading top menu with minimal...
2
1088
by: jecha | last post by:
I don't know why I continue getting such errors .With this one I can't even locate where the problem is.Its a database class for accessing information from a website database. <? /** * Database.php */ include("constants.php"); include("db_conn.php"); class Users {
7
1763
by: manas312 | last post by:
Hey guys.... I'm facing an interesting problem ....and need some solution..... The problem goes like this. You r having one site like www.abc.com (for example). The website contains only one textbox....blank textbox. Now I have a database of names of people. I hv control over database. I hv another site containing only one 'button'. (for ex. www.xyz.com) It acts as an interface site.(not exactly interface...but kinda)
1
1201
by: manas312 | last post by:
Hey guys.... I'm facing an interesting problem ....and need some solution..... The problem goes like this. You r having one site like www.abc.com (for example). The website contains only one textbox....blank textbox. Now I have a database of names of people. I hv control over database. I hv another site containing only one 'button'. (for ex. www.xyz.com) It acts as an interface site.(not exactly interface...but kinda)
14
9499
by: Brad | last post by:
I have a .net 2.0 web application project that creates a pdf file, saves the pdf to disk (crystal reports does this part), and then my code reads the pdf file and writes it to the httpresponse The web app works great on win2003 and xp and the end result is a pdf file is displayed in the browser. When I run the same code on Vista, the browser displays the message "Internet Explorer cannot display the web page". If I open the same...
5
2674
by: =?Utf-8?B?bXVzb3NkZXY=?= | last post by:
Hi, I wonder if someone could shed some light on this one for me. I have developed a web app in VS2005 with the built in server. It uses an sql database, everytihng works. I need to test it across the network, so i've installed IIS7 on my Vista machine and created a new website, point at the website's directory. After I switched to the 'Classic .net' app pool, it shows up on the port.
0
8889
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
9401
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9179
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9116
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...
0
8099
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6702
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
4519
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...
2
2637
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2157
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.