ASP.net application SQL Server Access Denied Help!

Hello all, first time posting here and I am running into a pickle of a
problem. Here is the scenario. I have a Windows 2000 server running
IIS and an ASP.net C# application. The application talks to a MS SQL
server on the same box. I have the connection string:

myConnection = New System.Data.SqlClient.SqlConnection("user
id=sa;password =sa;Initial Catalog=Maintenance;Data Source=WebServer")

This works just fine on the machine and all is well. I have installed
SQL MSDE, and all the other things on a Windows XP box and have changed
the data source name to comply with that system name and everything
works. Now here is where the problem is.

I have yet 2 more systems and when I try to install the same thing and
change the connection string I get "SQL Server does not exist or access
is denied" So to get test the "does not exist" part I wrote a small
VB.net app that opens the database using the same connection string and
this works. So it must be the ASP part. I have added both ASP and
IIUsr to the database user group and given them dbo permissions and full
rights to check that but I still get the same issue. I have sql
auditing enabled but it doesn't seem to give me what account is trying
to log in. I also have it set for mixed authentication. So with all
this info, is there anything glaringly obvious that would be why it
works on 2 but not another 2? Are there any group policies I can check
that limit IISusr or Aspnet user? Thanks in advance,

-Will

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.inetserver.iis)