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
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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

1
2 3 4 5
7