Questions tagged [logins]
For questions about login credentials and accounts used to access a database resource, typically at the server or instance level.
330
questions
0
votes
2
answers
35
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,810
-3
votes
1
answer
48
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 ...
- 501
0
votes
0
answers
27
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
26
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
139
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
123
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 ...
- 425
0
votes
0
answers
23
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 ...
- 567
0
votes
1
answer
114
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.
...
- 897
0
votes
1
answer
29
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
73
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
0
answers
130
views
Login Failed for the user in one db but works in anther db (copy of dev)
I'll try to explain myself so we are using Azure SQL with one of our applications which is trying to write back to the database using python code. Now the problem is that we are creating a connection ...
0
votes
1
answer
624
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
3k
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
674
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 ...
- 173
2
votes
1
answer
1k
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,497
2
votes
0
answers
157
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.5k
2
votes
2
answers
920
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,248
0
votes
0
answers
229
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
129
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
335
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 ...
- 285
-1
votes
1
answer
136
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 ...
- 285
0
votes
0
answers
214
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
622
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,144
4
votes
3
answers
13k
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
118
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
10k
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
306
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 ...
- 73
3
votes
2
answers
557
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
235
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
34
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
253
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,019
4
votes
2
answers
1k
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,655
1
vote
1
answer
771
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
750
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 ...
- 294
1
vote
1
answer
184
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
137
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
950
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
918
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,...
- 101
4
votes
1
answer
223
views
Active Directory Name Change
Our Active directory will change the accounts name for example John Doe Jdoe@abcd.com to John.Doe@abcd.com.
My question is do I need to change all the SQL Logins individually or the person can login ...
- 1,019
0
votes
1
answer
67
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
358
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
34
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
46
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 ...
- 89
0
votes
1
answer
1k
views
SQL server Service Accounts permission
I will be changing the existing SQL Server Service accounts from the default to Domain accounts from the SSCM which i believe will set all the required permission. One thing I am not sure whether the ...
- 1,019
0
votes
0
answers
29
views
Why I cannot do this in SSMS directly? (assigning a LOGIN to a USER)
In SQL Server 2008 R2, I want to change the LOGIN for a USER in a database.
FROM THIS:
TO THIS:
Initially, the database has the [...] dots option to change this greyed-out (why?):
The only way to ...
- 294
1
vote
1
answer
220
views
Lost SQL credentials and unable to connect to SQL via SQLCMD
I have a machine running SQL 2014 but have neither the windows authentication or sa authentication details due to mismanagement of a previous support team.
Having tried logging in to SQL Management ...
- 13
0
votes
1
answer
105
views
Restrict server login by user AND machine (within or not within a domain): is it possible?
I'm trying to setup a SQL Server 2008 R2 instance, restricting access to my database so only specific users on specific machines can login there.
Let's say, we have 3 devs: John, Jill and Steve, with ...
- 103
0
votes
2
answers
42
views
Are AD Groups the exact same as individual windows logins with explicit permissions?
Does any application requires a windows/domain login to be explicitly added to a SQL Server instance or by replacing the login with an AD group that belongs to the server and has elevated permissions ...
- 195
1
vote
3
answers
2k
views
Cannot login as new user on MariaDB
When I create a new user in MariaDB, I cannot login as that user.
First I login to the database as root doing mariadb in a bash terminal.
I then run the following commands to create a database and ...
- 163