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
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 ...
rickandm00rty's user avatar
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 '...
Cerin's user avatar
  • 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: ...
Farid Zahidov's user avatar
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 ...
user1054844's user avatar
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 ...
rkonings's user avatar
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 ...
Marcus's user avatar
  • 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 ...
Nik's user avatar
  • 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 ...
SQLPRODDBA's user avatar
  • 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 ...
Dominique's user avatar
  • 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 ...
MCovi's user avatar
  • 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 ...
Werner's user avatar
  • 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 ...
Behseini's user avatar
  • 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 ...
HeyJude's user avatar
  • 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 ...
til_b's user avatar
  • 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. ...
Fajela Tajkiya's user avatar
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 ...
Della's user avatar
  • 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 ...
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
  • 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 ...
Memo's user avatar
  • 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 ...
folow's user avatar
  • 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 ...
Manngo's user avatar
  • 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 ...
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,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 ...
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
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 ...
Leonard's user avatar
  • 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 ...
PTL_SQL's user avatar
  • 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 ...
PTL_SQL's user avatar
  • 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. ...
Anas Tina's user avatar
  • 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 ...
Aleksey Vitsko's user avatar
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 ...
asmgx's user avatar
  • 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 ...
vPilot's user avatar
  • 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 ...
Belarmino Vicenzo's user avatar
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 ...
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
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 ...
Elena2020's user avatar
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 ...
Ali Sheikhpour's user avatar
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 ...
SQL_NoExpert's user avatar
  • 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 ...
Stephen Morris - Mo64's user avatar
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 ...
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
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 ...
anaigini's user avatar
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)...
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
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,...
axdna's user avatar
  • 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 ...
SQL_NoExpert's user avatar
  • 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 ...
coolmind1414's user avatar
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 ...
MFKDGAF's user avatar
  • 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 ...
Chris's user avatar
  • 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 ...
amanullah's user avatar

1
2 3 4 5
7