"Kevin3NF" wrote:

> Have you verified from the SQL Server error log that the SQL Server is
> listening on tcp? You say it is active and working but you don't mention
> how you checked.
>
> Also verify that the aspstate user has rights to the SQL Server and to its
> default database.
>
> Did you try QA with that user/pwd?
>
> --
> Kevin Hill
> President
> 3NF Consulting
>
> www.3nf-inc.com/NewsGroups.htm
>
>
> "J Duff" <JDuff@discussions.microsoft.com> wrote in message
> news:6BCF27D6-5C21-4C86-9FB2-04BDD89CA467@microsoft.com...
> >I have a Windows 2003 svpk 1 server running SQL Ser 2000 svpk 3. Trying to
> > access a asp.net application on the same server and get the following:
> >
> > System.Data.SqlClient.SqlException: SQL Server does not exist or access
> > denied
> >
> > Here is my connection string:
> > sqlConnectionString="data source=127.0.0.1;user id=aspstate;
> > password=aspstate" cookieless="false" timeout="90" />
> >
> > I have also tried the data source as server name and ip address. I have
> > also tried the sa account and password but it did not work. TCP port is
> > active and working. I can log into the database with the query
> > application
> > and everything works just fine.
>
>