• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

How to set permissions on SQL Server Epress for access to DB

I have an application that employs IIS and a database running on SQL Server Express.
I have installed the application and created the database. IIS is up and running.
However, when I try to open the hope page, I get a page error.
I have a feeling this is beacuse I don't have permissions set on the SQL server.
I am using NT authentication.
Can anyone tell me what other permissions I need to set in SQL server so a user can connect to this DB?
Thanks.
0
ainselyb
Asked:
ainselyb
  • 3
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>However, when I try to open the hope page, I get a page error.
what error?

>Can anyone tell me what other permissions
other the what? ie what permissions did you put already?
0
 
ainselybAuthor Commented:
I am using SQL server Express.
The application has a text file which you configure with a username and password.
I created a domain user (user only) and added the credential to the text file.
I think went into SQL and added the user under security, login.

I also added the user grant permissions in the DB security itself.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
looks fine so far...
so: what error?
0
 
ainselybAuthor Commented:
It is just not loading the login.asp page which I am assuming is a DB security issue.

Is there a log I can look at to see if this is the case?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
then you need to add error handling to the login.asp page, to know the error message.
otherwise, no way to solve the problem.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now