TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Tauseef Kaldane
NA
22
13.3k
sql server grants access to specific login to database.
Aug 27 2014 12:24 AM
hello friends...
i have created website for intranet and hosted it on server. for that i needed to create login
"IIS APPPOOL\hi"
in sql server 2008 for my application to access my
"reportdb"
database.
"IIS APPPOOL\hi"
has sysadmin and public server roles in sql server 2008. And i had created another login
"sa"
same as
"IIS APPPOOL\hi"
. these are working correctly.
Now I want these two logins to access
"reportdb"
for all operations in database and remaining all logins should be denied to access
"reportdb"
. My Sql Server 2008 is having mixed mode (windows authentication and Sql authentication). plz help me
Reply
Answers (
0
)
What is Pivot Table in Sql Server and What is the use ?
i need to check username is unique or not?