468,140 Members | 1,439 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,140 developers. It's quick & easy.

Connecting to SQLEXPRESS 2005 with an ASP web app


I have an ASP web app with an SQL back end. It's currently connecting to an
SQL Server 2000 database
using an ODBC DSN. I am currently migrating to a new Windows 2003 Server
machine and
SQL Server 2005 Express. As usual, the app doesn't connect right away, but
I've gone through all the new
Windows 2003 Server security issues and I'm able to get a normal ASP page to
display. I can also connect
to the SQLEXPRESS when I use visual studio or MS Access on a remote machine,
even using the same ODBC
DSN, but for some reason, I get an error when trying to access it though

The error is;

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT

I thought that sounded like the IUSR_MachineName user not being defined in
teh db, but when I got to add that user, there is
no IUSR_MachineName account available. Does anyone else have experience with


Jan 31 '06 #1
0 1335

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by BravesCharm | last post: by
3 posts views Thread by Ann Marinas | last post: by
2 posts views Thread by Patrick F | last post: by
6 posts views Thread by bill ramsay | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.