Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [logins]

For questions about login credentials and accounts used to access a database resource, typically at the server or instance level.

Filter by
Sorted by
Tagged with
0 votes
0 answers
22 views

Audit attempts to access the Database, only failed for some users and all attempts for the rest

I am needing help to be able to configure an audit mechanism that allows me to record in the audit_trail the login (or create session) attempts in my databases, the problem comes when I need to record ...
miguel ramires's user avatar
0 votes
0 answers
37 views

Need help to get a server to login to SQL Server database

I created a virtual machine (VM) on Azure to host Sparx Enterprise Architect cloud-based repositories using Pro Cloud Server (PCS) https://sparxsystems.com/products/procloudserver/30-min-tour/index....
sys_eng's user avatar
2 votes
1 answer
137 views

SSMS User Mapping Slow to Load, or Not Responding

I have been experiencing an issue in SSMS versions 14, 18, and 19, where loading the User Mapping of any given Login takes an age to load, sometimes up to an hour, or just never loads at all and hits ...
L.Moy's user avatar
  • 45
0 votes
0 answers
22 views

MySQL: Reconnect to Existing Database that I lost access to

Note I am not a programmer by trade. I have the most annoying problem ever while using MySQL 8.0, and all online resources I've seen provide zero solutions. I have one of those MySQL data directories ...
ZZ Top's user avatar
  • 1
0 votes
0 answers
81 views

CREATE LOGIN [$(USERDOMAIN)\MyWinADGroup] not working inside MS VS Project

I have 4 Windows AD Domains and the same AD Group within them: DEV\MyADGroup SIT\MyADGroup UAT\MyADGroup PROD\MyADGroup The domains are separated from each other and not trusted, so we can prevent ...
Oreo's user avatar
  • 1,528
2 votes
1 answer
102 views

Failed login attempts by an unknown user in SQL Server [closed]

I have an alert in SQL Server that notifies me when there are failed login attempts. This alert began to arrive during the early morning every about 3 minutes (see screenshot). This login attempt ...
Mariano G's user avatar
  • 355
0 votes
0 answers
158 views

How to get NTLM version authentication with select statement in SQL Server

From my using SSMS I connect to SQL Server 2019. I would like to know what authentication is my current session connection using. I executed SQL: select auth_scheme from sys....
folow's user avatar
  • 339
0 votes
2 answers
218 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 ...
rickandm00rty's user avatar
2 votes
2 answers
1k 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 '...
Cerin's user avatar
  • 1,355
0 votes
0 answers
309 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: ...
Farid Zahidov's user avatar
0 votes
2 answers
103 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 ...
user1054844's user avatar
0 votes
1 answer
164 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 ...
rkonings's user avatar
0 votes
2 answers
275 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 ...
Marcus's user avatar
  • 69
1 vote
0 answers
29 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 ...
Nik's user avatar
  • 11
0 votes
2 answers
129 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 ...
SQLPRODDBA's user avatar
  • 1,908
-3 votes
1 answer
55 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 ...
Dominique's user avatar
  • 521
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 ...
Werner's user avatar
  • 111
3 votes
1 answer
2k 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 ...
Behseini's user avatar
  • 131
0 votes
1 answer
2k 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 ...
HeyJude's user avatar
  • 447
0 votes
1 answer
626 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. ...
Fajela Tajkiya's user avatar
0 votes
1 answer
124 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 ...
Della's user avatar
  • 73
0 votes
1 answer
189 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 ...
chrispykill's user avatar
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 ...
Hrvoje T's user avatar
  • 163
1 vote
2 answers
9k 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 ...
Memo's user avatar
  • 11
0 votes
2 answers
2k 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 ...
folow's user avatar
  • 339
2 votes
1 answer
4k 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 ...
Manngo's user avatar
  • 2,819
2 votes
0 answers
579 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 ...
Marcello Miorelli's user avatar
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 ...
Racer SQL's user avatar
  • 7,386
0 votes
0 answers
318 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 ...
Mrigank's user avatar
  • 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/...
Vasilis Hadjiloucas's user avatar
1 vote
1 answer
333 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 ...
Leonard's user avatar
  • 11
0 votes
1 answer
661 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 ...
PTL_SQL's user avatar
  • 341
-1 votes
1 answer
272 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 ...
PTL_SQL's user avatar
  • 341
0 votes
0 answers
306 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. ...
Anas Tina's user avatar
  • 101
5 votes
3 answers
901 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 ...
Aleksey Vitsko's user avatar
6 votes
3 answers
32k 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 ...
asmgx's user avatar
  • 209
0 votes
0 answers
241 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 ...
vPilot's user avatar
  • 47
8 votes
2 answers
17k 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 ...
Belarmino Vicenzo's user avatar
0 votes
0 answers
497 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 ...
sqllover2020's user avatar
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 ...
Elena2020's user avatar
0 votes
3 answers
452 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 ...
Elena2020's user avatar
1 vote
1 answer
38 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 ...
Ali Sheikhpour's user avatar
0 votes
1 answer
447 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 ...
SQL_NoExpert's user avatar
  • 1,061
4 votes
2 answers
3k 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 ...
Stephen Morris - Mo64's user avatar
1 vote
1 answer
1k 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 ...
Venkat's user avatar
  • 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 ...
Appleoddity's user avatar
1 vote
1 answer
466 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 ...
anaigini's user avatar
0 votes
1 answer
186 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)...
jrdba's user avatar
  • 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/...
mukuna's user avatar
  • 1
2 votes
1 answer
2k 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,...
axdna's user avatar
  • 111

1
2 3 4 5
7