Questions tagged [logins]
For questions about login credentials and accounts used to access a database resource, typically at the server or instance level.
335
questions
0
votes
2
answers
62
views
Creating an Active Directory login with specified SID
I have restored (FULL) a database using SSMS to a new server. When I did this we received errors indicating the account was unable to login, likely due to bad SID as we confirmed the account did ...
1
vote
2
answers
182
views
Unable to drop user due to assigned privileges?
How do you drop a user with read-only permission to PostgreSQL?
I created a user, with read-only access to all tables, on an RDS Postgres database with:
CREATE ROLE myuser WITH LOGIN PASSWORD '...
- 1,314
0
votes
0
answers
173
views
Error in Login securables - SQL Server
I am using SQL Server 2017 and the latest SSMS version. When I click securables of login in SSMS, I see this error:
Object reference not set to an instance of an object. (SqlMgmt)
Program Location:
...
0
votes
2
answers
74
views
On update: Login failed for SQL Server authenticated sysadm
I run into a weird bug?
User complained to me that he cannot anymore update certain tables in database. He had owner rights in database and the login was window login (ad-login). I tried elevating him ...
- 101
0
votes
1
answer
73
views
Using at sign "@" in password Oracle Database/Forms
We have an application running in Oracle Forms which connects to an Oracle database (12c). We've always had issues with using the "@" sign in passwords so we always instructed our users not ...
- 1
0
votes
2
answers
142
views
What's the issue with keeping a SQL Server login's default database as 'master'
I've read recommendations to switch non-sysadmins login's default database to something other than master. Tempdb is often recommended.
If a login/user has no permissions by default for their default ...
- 47
1
vote
0
answers
28
views
SSRS not using MSA or gMSA account on Domain [duplicate]
I am trying to install SSRS on a new server to report on our new database server and want to use a MSA account on our domain (server is on our domain) but I keep getting errors when trying to start ...
- 11
0
votes
2
answers
74
views
Find if AD group login is in use or not
Is there a way to find out if AD group login is in use or not? Basically I am trying to find out which logins are used and decommission ones not in use. Note that it isn't possible to decomm them by ...
- 1,908
-3
votes
1
answer
52
views
How can I add a new SQL Server in SQL-Server? [closed]
As you can see in the title, SQL-server is not very clear when it comes down to naming their objects.
My situation is: I have two logins, "SQLExpress" and "SQLExpress01", and I ...
- 523
0
votes
0
answers
199
views
SQL Audit - Security Audit Log - Login Failures -
need some guidance please.
Encountering below message in a SQL Server (2016 & 2019) - Audit - Security Audit Log - Login Failure. The SQL Server Error Log does not show any Login Failures.
The ...
- 1
1
vote
0
answers
30
views
SA disabled and no other user has access to master db [duplicate]
I have inherited an old SQL Server 2008 R2 where SA login is disabled. No other logins gives access to master db, so I cannot really gain access to administrative stuff (create new logins, change ...
- 111
3
votes
1
answer
1k
views
Not Able to Enable sa Account in SQL Server 2019 Express after Login with Windows Authentication Mode
I have installed SQL Server Express 2019 on my machine and after installation, I am able to login into server using the Windows Authentication method like
And as you can see the sa account has been ...
- 131
0
votes
1
answer
1k
views
Why SQL Server Job fails with "EXECUTE AS LOGIN failed for the requested login"?
I created a SQL Server job, in which:
My user is set as the owner of the job
No user is specified for run as at any step.
The job failed with the error:
'EXECUTE AS LOGIN' failed for the requested ...
- 437
0
votes
0
answers
25
views
Syncronizing logins between postgres and ms sql server
We have a setup where we have a "master" MS SQL Server database server which holds lots of (spatial) data. We are a windows shop, so we have Active Directory and it's user/group system.
For ...
- 587
0
votes
1
answer
379
views
What is login token and user token in SQL Server?
I came across these two SQL Server catalog views today: sys.login_token and sys.user_token. The document states that they:
Returns one row for every server principal that is part of the login token.
...
- 1,157
0
votes
1
answer
78
views
MySQL Not Resolving % in Host
Running MySql server 8.0.31 on an Amazon EC2 instance (52.99.189.74) in Ubuntu 22.04. When I log in to the mysql prompt with sudo, this is how the user and host columns of the mysql.user table look ...
- 73
0
votes
1
answer
151
views
Unable to remove local login for linked server
I have added a linked server that was working fine. After this I added a local login to within properties > security on the linked server. After doing this I get an error when trying to run a query ...
0
votes
1
answer
1k
views
How to allow remote MSSQL user to bulk insert my local txt file?
I have a txt file on my local PC. I run localy Java app which connects to remote MSSQL. Now I need to bulk insert from that text file into my database table.
However, SQL login can't read my file. I ...
- 133
1
vote
2
answers
7k
views
SQL Server login failed for user and all user accounts seem to be disabled
When I tray to login to SQL Server, all users are disabled and fail with error 18470. Even Windows Authentication.
Login failed for user 'NT Service\SSISScaleOutMaster150'. Reason:
Could not find a ...
- 11
0
votes
2
answers
1k
views
db2 - how to get list of all of the Db2 instances on computer
I have several Linux servers and on them may be one or more Db2 instances. Db2 instances can be from different Db2 versions.
For security audit I need to write some simple bash script to check for ...
- 325
2
votes
1
answer
3k
views
How do I change the default database owner for new databases in SQL Server?
I had cause to change my computer name (it’s running in a virtual machine). I have an existing SQLExpress instance which was installed prior to the rename.
There are some features which fail because ...
- 2,759
2
votes
0
answers
435
views
How to create logins in sql server based on the Azure Active Directory?
In my Azure environment
I have many resources, and I have a virtual machine that contains my sql server database
This is my virtual machine:
What I would like to achieve is to
create logins inside my ...
- 15.8k
3
votes
2
answers
2k
views
INSERT denied on tables. but login has permission for it
I'm running a procedure from database X to database Y.
On database Y there should be an insert from the user.
In this picture , the first column is the Login, the second one is the role that have all ...
- 7,374
0
votes
0
answers
285
views
Error 18456 Login failed for User
We are observing these below errors in our logs frequently and it gets fixed automatically -
Error: 18456, Severity: 14, State: 46. Login failed for user 'sqllogin'. Reason: Failed to open the ...
- 43
1
vote
0
answers
59
views
Default logins after installating SQL Server 2019 [duplicate]
I migrated my old logins from a SQL Server 2017 instance to a newly installed SQL Server 2019 instance, by following Microsoft's guidelines:
https://learn.microsoft.com/en-us/troubleshoot/sql/security/...
1
vote
1
answer
269
views
Connect to local instance after leaving domain account [duplicate]
Yesterday, I switched from a domain user account to a local user account in Windows. Before the change, I could connect to my local database instance, but after leaving the domain, I cannot connect ...
- 11
0
votes
1
answer
556
views
What does this statement mean: SELECT ... COLLATE SQL_Latin1_General_CP1_CI_AS AS [-- Logins To Be Created --]
What does this statement mean?
SELECT ... COLLATE SQL_Latin1_General_CP1_CI_AS AS [-- Logins To Be Created --]
It is part of a script I'm trying to adapt for listing out the SQL Server logins in an ...
- 303
-1
votes
1
answer
233
views
script to drop logins in a SQL Server instance throwing errors [closed]
Please can anyone see what's wrong in my code? I'm getting error:
Msg 3903, Level 16, State 1, Line 25
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
I've checked the syntax ...
- 303
0
votes
0
answers
287
views
Database users are lost after restore - how to fix
We had many facilities that operate in areas where there is poor/no internet connection; the facility staff sent us monthly a backup of the facility database for us to restore it on our data center.
...
- 101
5
votes
3
answers
785
views
SQL Server Logon Trigger Implications - are there any side effects possible in my scenario?
Some of developers on my team know passwords from SQL accounts that have extended permissions
We would like to track and be alerted whenever any of developers are using any of those SQL accounts to ...
- 5,462
4
votes
3
answers
26k
views
How can I fix "Login failed for user sa" error in SQL Server?
I can access my databases through SQL Server Management Studio (SSMS) by using my Windows account no problem.
I have two issues though:
I want to enable sa and then try to log in using sa and the ...
- 189
0
votes
0
answers
199
views
MySQL Error 1251 on 5.7.33 - Can't log in
ERROR 1251 (08004): Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have recently imported a backup into a test environment so I can review some ...
- 37
7
votes
2
answers
14k
views
Why and how and where to use user without login
I've been trying to find why, how and where to use Users Without Login and I didn't find my exact question or anything that gets closer.
Where I did my research (I also read other posts, saw Youtube ...
0
votes
0
answers
440
views
Linked server anonymous login error
I am trying to access a database in my UAT server through a windows login credential. When I try to access the database, I get the error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This ...
- 83
3
votes
2
answers
1k
views
How can I check if one specific login has any database users mapped on it?
I've create some logins and database users. So I would like to accomplish the following.
Drop user from database:
USE [dbname]
GO
IF EXISTS (SELECT 1 FROM sysusers WHERE NAME = 'username')
DROP ...
- 71
0
votes
3
answers
398
views
Allow user to create databases on server and to see only the databases that are created by him, without creating login first
I want to implement the following use case using C# application and MS SQL Server Express 2014. I have a centralized database server in which there are already created some database (which have the ...
- 71
1
vote
1
answer
37
views
What is VPS\example.com_web identity in SQL server?
I was facing connection failed for requested login in SQL server 2016 used for example.com domain on a VPS. I added the following logins to the database NT AUTHORITY\IUSR and NT AUTHORITY\NETWORK ...
- 231
0
votes
1
answer
380
views
SID for SA account
I want to change the SA password for the always on availability group servers. Since i wanted to keep the same password on all the replicas when I tried to transfer the login through Microsoft Stored ...
- 1,039
4
votes
2
answers
2k
views
Query to retrieve SQL Server login password length
I've been asked by corporate security to review our Azure SQL Databases and find out if there are any SQL Logins which have "short" passwords. I am not aware of a way to achieve this - I ...
- 3,841
1
vote
1
answer
944
views
Can we configure logins to only connect to read-only replicas in Azure SQL Database automatically?
For Read-Only routing, rather than explicitly using "ApplicationIntent=ReadOnly" into our application connection string or for individual users to specify it in additional properties, can ...
- 131
0
votes
1
answer
1k
views
Can a member of the SQL server 'sysadmin' role login to any database?
I've been researching and can't find a definitive answer. So I apologize if this question is more obvious than I suspect. All documentation I can find definitively says 'sysadmin' roles can do ...
- 304
1
vote
1
answer
322
views
Unable to login after db upgrade
I upgraded postgresql from 8.4.2 to 12.3. I created a dump of the db from the old version, and restored into the new version.
The port for the new version is 5532. The old one uses 5432. After I ...
- 19
0
votes
1
answer
168
views
MS SQL Server 2016 - Database Security - Login Permissions
I have an SQL Server 2016 database with Always On structure. I have a login that I called x. My x login's properties are:
Default database: abc
Server roles: public (ticked)
User mapping: Map (ticked)...
- 55
0
votes
2
answers
1k
views
ORA-01031: insufficient privileges, cannot login as any user
I ran below command and restarted docker container.
alter system set processes = 1 scope = spfile;
after this I am not able to login to DB at all.
root@30b2f9030f89:/u01/app/oracle/product/11.2.0/xe/...
- 1
2
votes
1
answer
1k
views
Do I need GRANT for INSERT to table If has EXECUTION GRANT for procedure?
I have five domain users and five roles in my database. GRANT EXECUTE adds to the appropriate roles. Roles are included in other roles, i.e. at most we have one role that has grants for two procedures,...
- 111
4
votes
1
answer
389
views
Active Directory Name Change
Our Active directory will change the accounts name for example John Doe [email protected] to [email protected].
My question is do I need to change all the SQL Logins individually or the person can login ...
- 1,039
0
votes
1
answer
109
views
Restrict use of tables
I am looking to restrict SELECT/INSERT for the 60-80 tables in the database.
The database has very complex security structure, and want to restrict INSERT/SELECT for all users (and except SysAdmin, no ...
1
vote
0
answers
493
views
SQL Login Denied yet Login is sysadmin
When I installed SQL Server 2017 Standard I installed it under my domain account and added it to the sysadmin role. I have then added the Domain Admins AD group to SQL and have deleted my domain ...
- 111
1
vote
1
answer
65
views
Should I revoke login from the default pgsql user?
I set up a localhost pgsql installation (os x catalina, homebrew, 12.*). I am developing a sql data warehouse and I’d like my dev environment to be as close to the production one as possible. Homebrew ...
- 183
0
votes
2
answers
48
views
New DB is not in the end user list
I created a user tom(SQL Login) in SQL Server 2019 Standard edition. Then I remove and reinstall the SQL Server 2019 standard edition(same version) and restored all the databases again with the same ...
- 99