May 17, 2013 at 2:58 am
we have .net application. we have to connect to Database through this application.
i have tried below...
1) SQL Login with SysAdmin role (its working, but it is not accepted as security reasons)
2) SQL Login with dbo_owner role (it is opened application, but when click on buttons in the application which is giving error)
3) Created application role and assinged dbo_owner. (it is not opening application)
Note: we are giving user name and password in connection string of application.
So, what is the better way and which type of user need to create to connect this database only through the application ?
May 17, 2013 at 8:09 am
What error you are getting?
Also even using DB_Owner role is not security best practice. I would suggest using db_datareader & db_datawriter
role. But if you post the error message that will help us identify, why application is not able to access DB.
Also, are you able to connect to SQL Server via the SQL Login with dbo_owner role and access your DB?
May 20, 2013 at 5:10 am
SQL Login with dbo_owner role (it is opened application, but when click on buttons in the application which is giving below error)
"The server can't fulfill your request, perhaps the session is timed out.
Please close the browser and start a new session.
We're sorry for the inconvenience. "
and what about Application roles ? could we use Application roles to connect database through Application ?
May 20, 2013 at 6:51 am
It looks like some custom message generated via application.
Look at the error logs for actual error. Also, have you tried the user (your application user to connect directly to database), and run queries.
When I say application role, I meant that you can create your own roles (custom) in the database and name it as application role.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply