473,686 Members | 2,773 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ASP.NET Web Site + SQL Server Connectivity Problems!

Can somebody help me with the following problem I have?

Configuration:

1 x Microsoft Windows Server 2003 Web Edition + IIS 6.0 + ASP.NET

1 x Microsoft Windows Server 2003 Standard Edition + SQL Server 2000 Service
Pack 3

Both PC's are installed on a separate switch so that they can talk to each
other and they are isolated from the rest of our internal network. The web
server is publically accessible on the internet. Both PC's are in a
WORKGROUP and NOT in a domain.

I have an ASP.NET web application running on the web server that has a login
page with is served over SSL. The login code creates a SQL server connection
to the database server in order to process the login.

The connection string on the web server is in the registry and contains:
server=<servern ame>; database=<Datab asename>; integrated security = SSPI;

The SQL Server is set to Windows Integrated security. I have created a local
user account on the database PC with GUEST access rights. I have added this
user to the SQL server security logins and given the account appropriate
access to the required stored procedures in the relevant database.

On the web server I have created a local user account with GUEST access
rights. Same name and same password as the account on the SQL server box.
In IIS 6.0 I am setting the web site username for anonymous logins to be
this user account.

In the asp.net web.config file I have set <identity impersonate="tr ue" />.

When I attempt to login to the database I get the following error message:

System.Data.Sql Client.SqlExcep tion: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection. at
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean& isInTransaction )
at
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction ) at
System.Data.Sql Client.SqlConne ction.Open() at
SpringFin.Login .VerifyPassword (String suppliedUserNam e, String
suppliedPasswor d)

I tried setting the web.config to this...

<identity impersonate="tr ue" userName="<user name>" password="passw ord" />

....but that only caused a server error and the web page would not start at
all.

I am a little lost at this point and I would appreciated some guidance if
anyone can help.

Kind regards,
Gareth
Nov 17 '05 #1
0 1077

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

Similar topics

0
4123
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed : 500 Mhz RAM : 192 MB Hard Disk : 6 GB
14
2951
by: diskoduro | last post by:
Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after that every user had his own mde linked to the main mdb. Year by year, progressively the number of records has been growing and the speed of the application has decreased strongly, because of the grrrreat number of records stored.
6
1304
by: John | last post by:
Hi Is there an asp.net sample site with access backend that I could use to learn good asp.net development practices? Thanks Regards
7
1583
by: Jon Davis | last post by:
OK I have a web app that I built that makes MANY calls to the DB in each request. The app wasn't tuned for scalability so this wasn't a problem, but time is too short to redesign how the database is accessed because the data that's being stored is time relevant and the web app will be thrown out in a few months. Since I try to separate the OleDb stuff from the business logic, I just create new database connections and trust that those...
1
1363
by: Bruce Hodge | last post by:
Hi, We have multiple copies of an application running on 2003 server hosted on the Internet. Each has it's own SQL database, each has it's own Website and URL. So in processing terms they are all isolated. You'd think they would all run at the same speed if they have the same number of users accessing them, but they don't, here's the problem. One client (6 users) has his own copy of the application and is connecting to the...
2
5222
by: Rico | last post by:
Hello, I have a Win2K3 Server with SS2005 developers edition. I am working on a Windows XP Pro workstation which has SQL Server 2000 installed as well as the SQL Native Client. I'm using an MS Access ADP to connect to the server and for some reason it's extremely slow, even to the point of throwing time out errors and "can't generate SSPI context" messages. I've hit the MS website and found info on the SSPI error, but none of the...
3
1601
by: rmgalante | last post by:
I have a pretty large web site with about 400 files after I precompile it. When I use the VS2005 Publish tool and publish to an FTP site, which is running IIS, most of the attempts hang after about 10 minutes. Sometimes it works; sometimes it doesn't. Most times it doesn't. What is really aggravating is that I get no error message from VS2005 when the publish utility stops. It just stops. The only way I can tell that something is wrong...
3
2204
by: tatata9999 | last post by:
Just talked to someone, he said he couldn't access my site (I was 'shocked'), could you people give it a try? I'm sorry it's off topic but I'm speaking of the truth, http://www.mytata.net/ and post feedback like your location. Many thanks. Once again, my apologies if some of you feel bad about this.
2
1314
by: Cindy | last post by:
Hi. I have a site that stores files on SQL Server tables (possibility of a large database) and uses Full-Text Search to search through all these files. I was wondering, since traffic might be quite large, what companies normally do in such scenarios. I am fairly good with programming but machine configuration is not my strong suit. First, is there a way to host this ourselves? What kind of equipment would we need for a dedicated...
0
8584
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
8516
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8778
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
7599
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
6440
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
4532
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2945
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
2205
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1934
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.