March 7, 2009 at 7:39 am
:)Dear all Sql server is installed but it is accessible only as administrator
i am not able to access as user so please
can any body help me to make it accessible to the user
regards
phil
March 7, 2009 at 8:27 am
Hi
Did you add the windows user account to the server logins and the database users (e.g. with roles db_datareader, db_datawriter)?
Greets
Flo
March 9, 2009 at 6:51 am
Thanks for the reply
1)When ever the server two thousand five is installed
it is accessible to only admin
2)If it is accessible by the user (i.e by the student they are not able to access the adventure Works)
3) Now could I get the solution for this
4) may be some where we are going wrong while installation
could any body revert
regards
phil:)
March 9, 2009 at 10:01 am
The Administrator needs to add a Windows account (preferable) or SQL account and give it permissions, as Florian mentioned.
March 10, 2009 at 3:56 am
If you want to give access to SQL Server for a group of users, the best way is to get the users added to a Windows group and then give the group login rights to SQL Server.
This way you can grant database rights to the group in SQL Server, and everyone in the group gets those rights. It is far easierto manage than granting rights to individual users.
It is also best practice in security to separate the functions of a) allowing access by an individual to a resource from b) controlling the rights someone has within a resource. Using Windows groups goes a long way towards this, as typically Windows admin people add/remove people to groups and DBAs set up rights in SQL Server.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply