Stef Merlijn
asked on
Access SQL Server instance by NONE-admin Windows user
Hi,
My application installs SQL Server instance (2014 express). One customer did the installation using a NONE-admin Windows user with elevated rights during installation. SQL Server service does run for the instance, but now that same user does not have access to the server.
Is there some setting that must be adjusted in order to give that user access?
Maybe this is not enough information to analyse the issue, so please feel free to ask any additional info.
My application installs SQL Server instance (2014 express). One customer did the installation using a NONE-admin Windows user with elevated rights during installation. SQL Server service does run for the instance, but now that same user does not have access to the server.
Is there some setting that must be adjusted in order to give that user access?
Maybe this is not enough information to analyse the issue, so please feel free to ask any additional info.
ASKER
And when that same user become an Administrator Windows user?
Because the usee than still cant access the server.
Because the usee than still cant access the server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Windows authentication was enabled. Install was done with sa + password.
After install windows user that installed sql server was changed to admin.
After install windows user that installed sql server was changed to admin.
So that user should be able to logon that server and open the sql management studio either with his Windows login or with SA i would say or Maybe your problem is in login remotely?
ASKER
All is on local desktop.
So I should install mmss and give explicit acces to the user or??
So I should install mmss and give explicit acces to the user or??
Yes install SSMS and check valid logins. Then make the user sysadmin or DB owner.
The key is:
Then something went wrong with the installation.
SQL Server service does run for the instance [..]
Then something went wrong with the installation.
ASKER
Yes, the instance is running.
When an user installs a SQL Server instance it doesn't mean that he or she will have admin rights on the instance. For that he or she need to had himself during the installation process. Is that hasn't be done then you still have the chance to connect as 'sa' but seems like SQL Server has been configured to use Windows Authentication mode, meaning that 'sa' login won't work.
What account has been used to run the SQL Server service?
NOTE: If the SQL Server has no database the more easy thing to do is to reinstall the SQL Server instance but this time remember to add the necessary admin users during the setup.
What account has been used to run the SQL Server service?
NOTE: If the SQL Server has no database the more easy thing to do is to reinstall the SQL Server instance but this time remember to add the necessary admin users during the setup.
ASKER
Re-installation did it for me. Thank you all for the help.
Nice!!
Non admin users have no rights to open sql server.
So an admin or SA needs to login and allow that user to open SQL.