472,352 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,352 software developers and data experts.

ASP.NET Web Site + SQL Server Connectivity Problems!

Can somebody help me with the following problem I have?


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=<servername>; database=<Databasename>; 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="true" />.

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

System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at
SpringFin.Login.VerifyPassword(String suppliedUserName, String

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

<identity impersonate="true" userName="<username>" password="password" />

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

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

Kind regards,
Nov 17 '05 #1
0 1033

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

Similar topics

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...
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...
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
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...
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...
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...
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...
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...
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...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

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.