October 19, 2022 at 9:16 am
Hi,
I got SQL server (2019) installed on my workstation but the issue is when I check with USER_NAME(), the return is "guest"?
Due to being guest, I can't make or restore databases in SQL server as my permissions are limited.
What should I do to contact my IT department? I am only going to be running SQL server on localhost, so don't know why I would need to run as admin.
Note: I can't run as admin because of corporate user policies.
Background: previously I was using Access to store data but wanted to gain practical experience with SQL server instead.
October 19, 2022 at 1:53 pm
Whoever did the install needs to add your login to the admin role on the instance. And yeah, you need to be admin on the SQL Server instance to actually control it. It shouldn't violate any corporate policies since it's purely a developer tool locally. Or, you need to get a SQL login from whoever installed (if they installed using mixed security) that has more privileges.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 14, 2022 at 3:20 pm
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply