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
1 answer
69 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 ...
user avatar
  • 1
0 votes
1 answer
28 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 ...
user avatar
  • 57
2 votes
1 answer
58 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 ...
user avatar
  • 2,337
2 votes
0 answers
44 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 ...
user avatar
2 votes
2 answers
226 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 ...
user avatar
  • 7,100
0 votes
0 answers
101 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 ...
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://docs.microsoft.com/en-us/troubleshoot/sql/security/...
user avatar
0 votes
0 answers
116 views

Invalid Urn filter on server level SQL Server error

I am trying to alter permissions to some of my users using GUI. When I press Script Out or OK, I am receiving this error attached. Has anyone experienced this error and what did you to resolve this ...
user avatar
1 vote
1 answer
55 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 ...
user avatar
  • 11
0 votes
1 answer
104 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 ...
user avatar
  • 231
-1 votes
1 answer
49 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 ...
user avatar
  • 231
0 votes
0 answers
135 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. ...
user avatar
  • 101
0 votes
0 answers
89 views

Create new user with sa login

In SQL Server 2019, is it possible to create a database user attached to the login sa? Like this: but I get this error: It says: Failed at creating the user "ssrs". The use of special ...
user avatar
  • 141
5 votes
3 answers
469 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 ...
user avatar
4 votes
3 answers
4k 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 ...
user avatar
  • 189
0 votes
0 answers
22 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 ...
user avatar
  • 37
4 votes
2 answers
4k 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 ...
user avatar
0 votes
0 answers
138 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 ...
user avatar
3 votes
2 answers
231 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 ...
user avatar
0 votes
3 answers
126 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 ...
user avatar
1 vote
1 answer
22 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 ...
user avatar
0 votes
0 answers
21 views

mysql contacts wrong ip

I setup my MariaDB on my virtual machine and I can successfully connect to it locally. I can ping the machine too. However, when I contact via the host machine, I do not understand why instead of 192....
user avatar
  • 13
0 votes
1 answer
116 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 ...
user avatar
  • 1,007
4 votes
2 answers
857 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 ...
user avatar
1 vote
1 answer
550 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 ...
user avatar
  • 131
0 votes
0 answers
236 views

Login to SQL Server cross domain AD Group user

Our MS SQL Server is on another trusted domain (Trusted Domain C). We created a Universal Group within Domain A with users from different forest domains and added the AD group onto the SQL Server. ...
user avatar
  • 207
0 votes
1 answer
306 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 ...
user avatar
0 votes
1 answer
83 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 ...
user avatar
0 votes
1 answer
85 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)...
user avatar
  • 25
0 votes
2 answers
668 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/...
user avatar
  • 1
2 votes
1 answer
447 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,...
user avatar
  • 91
4 votes
1 answer
95 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 ...
user avatar
  • 1,007
0 votes
1 answer
51 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 ...
user avatar
1 vote
0 answers
160 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 ...
user avatar
  • 11
1 vote
1 answer
21 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 ...
user avatar
  • 41
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 ...
user avatar
0 votes
1 answer
616 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 ...
user avatar
  • 1,007
0 votes
0 answers
27 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 ...
user avatar
1 vote
1 answer
151 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 ...
user avatar
0 votes
1 answer
61 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 ...
user avatar
  • 103
0 votes
2 answers
36 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 ...
user avatar
0 votes
2 answers
1k 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 ...
user avatar
  • 153
1 vote
1 answer
558 views

With SSMS on my local machine, is it possible to login to a remote SQL server on my VPN network via my Active Directory credentials?

I'm trying to login to a SQL server on my work network with a VPN connection to the network and by using my AD credentials. When I'm directly on my office machine, I use "Windows Authentication" as ...
user avatar
  • 24.2k
0 votes
0 answers
76 views

oracle 12c enterprise manager default login

I am just installed oracle database in my windows machine after installation it i can't able to login i dont have username only i know password . can any body help on this advance thanks
user avatar
  • 101
0 votes
1 answer
208 views

SQL Server Failed Login - SQL Server login (not windows) - Random times

We have the following situation and am wondering if anyone can suggest a way of determining the cause. One of our SQL Developers can log into, and use, the instances/databases fine and has a SQL ...
user avatar
1 vote
1 answer
1k views

Changing the login name for user dbo

I have a database where the owner is Login1 but the username dbo is assigned to Login - login2. I understand in order to change the login name for the username dbo to sa I will have to use the below ...
user avatar
  • 1,007
0 votes
1 answer
61 views

Does SSRS report user needs database level permission?

I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...
user avatar
  • 1,007
3 votes
1 answer
164 views

What happens if Always On High Availability nodes have different connection default languages?

I have been working on databases in a Always On High Availability group which - for reasons that I do not understand - have different default languages for an application's login on the primary and ...
user avatar
0 votes
1 answer
34 views

Does a login need to be created on MSSQL Always On replica before being granted roles on the primary? [duplicate]

Consider a SQL Server Login MyLogin that exists on PrimaryServer but not SecondaryServer in an Always-On Availability group. MyLogin has a number of roles already assigned. If the login MyLogin is ...
user avatar
  • 103
3 votes
1 answer
233 views

How can SUSER_SNAME return the localized user name?

I need to assign network service user to SQL Server database programmatically, so I am running this script: USE [MyDB] GO DECLARE @user nvarchar(50) DECLARE @SQLStatement nvarchar(500) SET @user = ...
user avatar
  • 131

1
2 3 4 5
7