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
4
votes
2answers
294 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
0answers
33 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
2answers
154 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
3answers
62 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
1answer
21 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
0answers
14 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....
0
votes
0answers
18 views

How can Azure PostgreSQL authenticate against Azure AD with username & password instead of a token?

I have used the documentation at https://docs.microsoft.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication to enable users in Azure AD to authenticate to an Azure PostgreSQL ...
0
votes
1answer
26 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 ...
4
votes
2answers
246 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
1answer
175 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 ...
0
votes
0answers
91 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. ...
0
votes
1answer
46 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 ...
0
votes
1answer
40 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
1answer
29 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)...
0
votes
2answers
324 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
vote
1answer
59 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,...
4
votes
1answer
54 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 ...
0
votes
1answer
47 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
0answers
78 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 ...
1
vote
1answer
14 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 ...
0
votes
2answers
45 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
0answers
28 views

Transfer AD Logins between Azure SQL Managed Instances

I am trying to transfer all logins part of an Azure SQL MI to another server. Have re-created the SQL logins with the help of 'sp_help_revlogin' script. Learnt that AD logins needs to be created ...
0
votes
1answer
133 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 ...
0
votes
0answers
19 views

Secure multi tenant login procedure

I have a multi-tenant solution today (client-server). Each database is separated from each other. Each db has its own login and own users. Now I am planning to take the move to a web application. This ...
0
votes
0answers
25 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
1answer
88 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
1answer
46 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 ...
0
votes
2answers
33 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 ...
0
votes
2answers
503 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 ...
1
vote
1answer
265 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 ...
0
votes
0answers
58 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
0
votes
1answer
117 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 ...
1
vote
1answer
699 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 ...
0
votes
1answer
28 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 ...
3
votes
1answer
162 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 ...
0
votes
1answer
32 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 ...
3
votes
1answer
147 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 = ...
2
votes
2answers
5k views

Query list of logins that have logged in the last X days on SQL Server

Is there any good query that included internal system objects like sys.dm_exec_sessions or sys.dm_exec_connections that would list logins that have connected to the SQL server over the last X days? 15,...
1
vote
0answers
24 views

Default Schema not being applied even after setting default schema and default DB

Hello Stack Exchange! I have an interesting problem! Let me set the stage for you: 1) Windows Authentication 2) Default Schema identityiq has been set for the user with login XCORP\USERA 3) ...
0
votes
1answer
33 views

How to create a new user in a remote offline database without elevating roles [closed]

An enterprise C++ system that needs to be "translated", uses ODBC for connecting to SQL Server Database. The system has one central main database, many distributed local databases, which are actually ...
0
votes
0answers
157 views

Randomly getting ora-01017

I have an Oracle RAC (12.1.0.2) installed on ESXi 6.5. RAC nodes are hosted on different physical servers and there is a storage hosting their shared disk. Here is my problem: Trying on Toad, SQL*...
1
vote
1answer
53 views

Audit logins and logouts [duplicate]

I need to trace and monitor client login connections (successful and failure) to our important SQL servers (20 MSSQL Server). What method do you recommend? Note: I think enabling "both failed and ...
0
votes
1answer
39 views

Why do I need DAC if I am able to connect to the server via sqlcmd?

DAC attracted my attention at the moment when I was unable to connect to the SQL Server using a traditional way (the reason was deleting logon trigger). I made some searches on the web and it turned ...
3
votes
2answers
118 views

Restore from SQL Server 2008 to 2014

When a full-backup is restored by the DBA, does the DBA need to restore permissions, users, and roles separately? Or does it all come with the full restore? I am from the dev team. We are migrating ...
1
vote
1answer
296 views

Login failed for user when trying to connect to Azure Postgre database from MSSMS [closed]

I created a database on Azure but can't log to it with MSSMS. I always have the Error 18456 even if I followed this tutorial. TITLE: Connect to Server ------------------------------ Cannot connect ...
1
vote
0answers
58 views

If a Login is not granted the db_ddladmin role on a database, but is individually granted CREATE VIEW on it, will they still be denied?

Since SQL Server permissions work as "deny first", I was wondering if that applies downward to individual permissions that are granted, if the parent permission isn't granted e.g. db_ddladmin is not ...
1
vote
1answer
43 views

Logging security events in MSSQL

I need to log events of admin changing someone's password, and user changing his password. How do I do that? I've found a nice solution based on Service Broker, however the resulting table only ...
1
vote
2answers
1k views

How to find unused logins in SQL Server?

I have a couple of databases on my server, each with its own users. Now I need to find and delete all those logins, which are not mapped to any user in any database. But I've also seen that it is ...
0
votes
0answers
106 views

Adding login of a pc on the network - Microsoft SQL Server Management Studio 2014

I have a small office network and I am trying to add new logins for the other PCs on Microsoft SQL Server Management Studio 2014 (all computers are Windows 7). I cannot seem to find the other ...
0
votes
1answer
72 views

Login failed for User 18456 State 5. User id works on other machines

I have a really weird login issue I've been pursuing. I experience this only on my Macbook Pro (2018) and only when logging into this one specific SQL Server 2016 database directly through a database ...

1
2 3 4 5
7