SQL Server access denied or does not exists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I lunched my Web Application and use the SQL Server, I keep getting an
error" SQL Server access denied or does not exists", I followed all the
resources(kind of) from Microsoft web site and I still cannot get it to work.
I do not have Microsoft Enterprice installed in my Windows XP professional,
but according to Microsoft I do not have to have it since Windows XP and
Framework .NET installs a virtual directory (DB Server) for me.
I confirmed it but I just cannot give permission to ASPNET account to access
the SQL server, and the SQL server is running. What I am doing wrong or not
setting something? Please help.

Thank you.
 
Are you using integrated security? If you are you will *have* to give the ASPNET account access to the database or change the credentials that ASP.NET runs under (via the processModel element in machine.config).Changing these credentials, however, will change them for *all* ASP.NET applications (at lease on IIS5 it will IIS6 uses another more flexible mechanism to set teh credentials for the woorker process).

The alternative is to use SQL Server authentication and have a logon that has access to only those data objects that your web application needs. of course you'll have to store the password somewhere that the ASP.NET application has access to.

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft.com/microsoft.public.dotnet.framework/<[email protected]>

When I lunched my Web Application and use the SQL Server, I keep getting an
error" SQL Server access denied or does not exists", I followed all the
resources(kind of) from Microsoft web site and I still cannot get it to work.
I do not have Microsoft Enterprice installed in my Windows XP professional,
but according to Microsoft I do not have to have it since Windows XP and
Framework .NET installs a virtual directory (DB Server) for me.
I confirmed it but I just cannot give permission to ASPNET account to access
the SQL server, and the SQL server is running. What I am doing wrong or not
setting something? Please help.

Thank you.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.770 / Virus Database: 517 - Release Date: 27/09/2004



[microsoft.public.dotnet.framework]
 
Hello Richard;
Do you know where can I find the instructions to change the credentials in
the machine.config file or for the SQL Server authetincation?, since I am
training myself for a certification, I know a little bit about the enviroment.

Thank you.
Joe
 
For chenging the ASP.NET worker process credentials:

http://msdn.microsoft.com/library/d...us/cpgenref/html/gngrfProcessmodelSection.asp

For using SQL Server authentication:

http://msdn.microsoft.com/library/d...ntSqlConnectionClassConnectionStringTopic.asp

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft.com/microsoft.public.dotnet.framework/<[email protected]>

Hello Richard;
Do you know where can I find the instructions to change the credentials in
the machine.config file or for the SQL Server authetincation?, since I am
training myself for a certification, I know a little bit about the enviroment.

Thank you.
Joe

Richard Blewett said:
Are you using integrated security? If you are you will *have* to give the ASPNET account access to the database or change the credentials that ASP.NET runs under (via the processModel element in machine.config).Changing these credentials, however, will change them for *all* ASP.NET applications (at lease on IIS5 it will IIS6 uses another more flexible mechanism to set teh credentials for the woorker process).

The alternative is to use SQL Server authentication and have a logon that has access to only those data objects that your web application needs. of course you'll have to store the password somewhere that the ASP.NET application has access to.

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft.com/microsoft.public.dotnet.framework/<[email protected]>

When I lunched my Web Application and use the SQL Server, I keep getting an
error" SQL Server access denied or does not exists", I followed all the
resources(kind of) from Microsoft web site and I still cannot get it to work.
I do not have Microsoft Enterprice installed in my Windows XP professional,
but according to Microsoft I do not have to have it since Windows XP and
Framework .NET installs a virtual directory (DB Server) for me.
I confirmed it but I just cannot give permission to ASPNET account to access
the SQL server, and the SQL server is running. What I am doing wrong or not
setting something? Please help.

Thank you.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.770 / Virus Database: 517 - Release Date: 27/09/2004



[microsoft.public.dotnet.framework]
Click to expand...

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.770 / Virus Database: 517 - Release Date: 27/09/2004



[microsoft.public.dotnet.framework]
 
Great, I will try that and let you know the outcome.

Thank you for your help.

Joe

Richard Blewett said:
For chenging the ASP.NET worker process credentials:

http://msdn.microsoft.com/library/d...us/cpgenref/html/gngrfProcessmodelSection.asp

For using SQL Server authentication:

http://msdn.microsoft.com/library/d...ntSqlConnectionClassConnectionStringTopic.asp

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft.com/microsoft.public.dotnet.framework/<[email protected]>

Hello Richard;
Do you know where can I find the instructions to change the credentials in
the machine.config file or for the SQL Server authetincation?, since I am
training myself for a certification, I know a little bit about the enviroment.

Thank you.
Joe

Richard Blewett said:
Are you using integrated security? If you are you will *have* to give the ASPNET account access to the database or change the credentials that ASP.NET runs under (via the processModel element in machine.config).Changing these credentials, however, will change them for *all* ASP.NET applications (at lease on IIS5 it will IIS6 uses another more flexible mechanism to set teh credentials for the woorker process).

The alternative is to use SQL Server authentication and have a logon that has access to only those data objects that your web application needs. of course you'll have to store the password somewhere that the ASP.NET application has access to.

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft.com/microsoft.public.dotnet.framework/<[email protected]>

When I lunched my Web Application and use the SQL Server, I keep getting an
error" SQL Server access denied or does not exists", I followed all the
resources(kind of) from Microsoft web site and I still cannot get it to work.
I do not have Microsoft Enterprice installed in my Windows XP professional,
but according to Microsoft I do not have to have it since Windows XP and
Framework .NET installs a virtual directory (DB Server) for me.
I confirmed it but I just cannot give permission to ASPNET account to access
the SQL server, and the SQL server is running. What I am doing wrong or not
setting something? Please help.

Thank you.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.770 / Virus Database: 517 - Release Date: 27/09/2004



[microsoft.public.dotnet.framework]
Click to expand...

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.770 / Virus Database: 517 - Release Date: 27/09/2004



[microsoft.public.dotnet.framework]
Click to expand...
 
Back
Top