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
0answers
27 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*...
0
votes
0answers
18 views

How does CAL licensing work with SQL Server 2017? [closed]

If I wanted to license SQL Server 2017 using the CAL license structure, which accounts accessing the server would I need to also license? (I'm reading through the licensing datasheet.) E.g. I imagine ...
1
vote
1answer
29 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
33 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
111 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
47 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
36 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
35 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
133 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
25 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
0answers
32 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 ...
0
votes
0answers
33 views

Add a DL as a login in azure sql managed instace

I am able to add individual AD logins as a login in azure sql managed instance, when i try to add a DL is the same way i am getting the following error. error: Principal '' could not be found or this ...
0
votes
1answer
152 views

I am trying to connect My R studio to SQL Database on the Remote Desktop

The SQL Server on the remote desktop is configured to have neither login nor password, it is configured to use Windows Authentication. Code I am using the following code to connect: library(DBI) ...
0
votes
0answers
44 views

Error 18456 when moving database to new environment

Last night I moved a database from Server Q (QA) to Server P (prod). Part of the process was to remove some QA logins we use and replace them with production logins. Things seemed to go well but ...
0
votes
1answer
26 views

Will an AD Account inherit all the User Mappings to databases that it's parent AD Group is mapped to?

If a Windows AD Group and an AD Account that belongs to that AD Group are both setup as Logins on a SQL server, will the AD Account Login inherit all the User Mappings that it's parent AD Group Login ...
5
votes
1answer
110 views

SQL Server - How does contained database user password expiration work?

I've recently started working with contained databases and I do not understand if/how contained database users have passwords that expire. MSDN documentation says they do - With a SQL Server login, ...
-1
votes
1answer
57 views

SQL server login get unwanted high privileges on a db when created

We have a demand to create a new user with the ability to SELECT only 4 specific tables. In order to do that we create the login and map it to the requiered db : USE [master] GO CREATE LOGIN [pos] ...
5
votes
1answer
91 views

how to stop using sql server login credentials in a linked server?

I have a linked server based in Italy server_italia that connects to a server based in Oregon USA ORDB1 we are on different but trusted domains. The connection from server_italia to ORDB1 is made ...
0
votes
3answers
192 views

Check if a SQL Login exists without SA

How can I check if a SQL Login exists for an arbitrary domain user if the account I'm running doesn't have SA rights to the instance (but will be dbo on at least one DB) Ideally I'd like the solution ...
2
votes
1answer
122 views

Msg 15404, Level 16, State 10, Procedure xp_logininfo - missing permissions [duplicate]

I have a server based in the USA, where I am not a domain admin, and my permissions are limited to sql server only - where I am sysadmin. after a migration of a few databases to a new server, I ...
1
vote
3answers
725 views

SQL Server 2017 login language display is wrong

I have just done a clean install of SQL Server 2017 (CU15) on two of my servers, and have noticed that the displayed language for all my logins shows ARABIC instead of '' or 'English'. Here is the ...
2
votes
2answers
191 views

logins without any users

There are several logins in my SQL Server that don't have user mappings to any database; they are simply dummy logins. Someone created the login but it does not have any associated users. I need to ...
0
votes
1answer
78 views

Login permission on Availability group database

We have an availability group database. Just wanted to check on the below statement whether it needs to be run on all replica (By failing over and making it primary)or it can be run on the primary ...
1
vote
0answers
42 views

Login connection data and time

I wonder if there is a way to query SQL Server to find out dates and times a login has connected to a particular server?
2
votes
1answer
95 views

SQL statement to hide all system databases in Server from a server login

I want to create a Windows authentication server login and make it cannot see any system databases e.g.master, model. I know that we can control view definition in database level e.g. database user, ...
-1
votes
1answer
43 views

SQL Server: Sql query to find the list of the servers where the login is present [closed]

How to find the list of the servers where the login is present(other than registered servers)
0
votes
0answers
31 views

How configure security to query second same server database

I have a database which holds all my permissions and a central database which holds all the logins for all my application. I need to create view that queries both database which reside on the same ...
2
votes
2answers
51 views

Login failed errors while DB refresh in progress

We have a 2.5TB refresh in Production, I have automated the refresh of latest production backup to lower environment every Sunday night. And during this activity, SQL error log is filled with ...
2
votes
1answer
63 views

How to get the SQL-server login name of an integrated security account?

Let's say I'm a user in windows domain DC (DataCenter). My user-name is DC\Somebody I'm in group DC\Developers Now SQL-Server has the login group called DC\Developers, and with that, I can login on ...
0
votes
1answer
49 views

Mapping an MSSQL Login to the secondary replica in a High Availability Group

I'm trying to map a login to a user in a database on the secondary replica of a two node High Availability group. Obviously this fails since the replica is offline. Is there a way for me to create ...
0
votes
2answers
64 views

sql server: get all the databases in which a login is being used

I'm creating a few migration scripts to generate a sql server database from scratch. In my '0005-create_login.up.sql' script I have something like: CREATE LOGIN [mylogin] WITH PASSWORD=N'xxx=', GO ...
1
vote
1answer
178 views

Delete orphaned SQL Users

I have a Microsoft SQL Server that had a database called SQLDATABASE. It also had a user called SQLUSER. The SQLDATABASE was deleted but not SQLUSER. SQLUSER only belonged to SQLDATABASE. I want to ...
0
votes
1answer
994 views

Cannot open database “dbname” requested by login.The login failed.Login failed for user 'DOMAIN\Windowsusername'

I had a database which i dropped using the below command. USE master; GO ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO DROP DATABASE dbname; Now when i refresh the connection in ...
1
vote
1answer
88 views

Server Principal SID showing as NULL and name as empty string

In my SQL Server 2016 server,i set up a user logins Audit for Login successful and Login Failed action. Here is the script. USE [master] GO CREATE SERVER AUDIT SPECIFICATION [...
0
votes
0answers
24 views

SQL Server login accounts while configuring SQL Server Reporting Services

I configured reporting server in a new app server for my .NET application and, since I am new, I looked at the old app server reporting service config and did the work. So after installation, I ...
0
votes
2answers
363 views

User and login mapping after an SQL Server restore

I need to restore a DB from an SQL Server instance to another and I am well aware that the DB users will be transferred but the logins won't. I have created a script to be able to create the logins on ...
0
votes
2answers
2k views

Login failed for user NT AUTHORITY\IUSR

I have some developer colleagues in my office that are having a problem similar to this one: db connection uses an anonymous logon instead of the domain user the connection string (he is working on ...
0
votes
0answers
22 views

Can I enable Login when I can't connect to the instance? [duplicate]

I have a cloned a customer machine to a Virtual machine. I had access from my code (SqlConnection) to the database through a database-Login where I could use window autentication. I disabled my ...
0
votes
1answer
67 views

How do I add a directory, or bulk, of users to Microsoft SQL Server permissions

I have a front end program in Visual Basic that is using SQL Server as a "back end". The only way I can get permission for login to use the SQL server is by adding each name or computer individually ...
0
votes
0answers
89 views

init_connect not executing

From this question I was able to make my init_connect = "CALL mydb.Warnings()", but a user login in does not triggers the SP. the SP is like: CREATE DEFINER=`root`@`localhost` PROCEDURE `Warnings`...
1
vote
3answers
3k views

Default phpMyAdmin Login Credentials

I downloaded and installed phpMyAdmin 4.8.5 on my windows. Upon opening it in the browser, it immediately asks for a Username and Password. I tried to submit root for username while leaving the ...
0
votes
1answer
289 views

How to use 'mysql -uroot -pXXXX' on Debain 9.8?

My apologies for this lame question. Debian 9.8 changed some things and mysql is broke but I can't seem to fix it. I installed MySQL on Debian 9.8, which now installs MariaDB 10.1. After install I ...
0
votes
1answer
89 views

how to get complementary information from sp_readerrorlog

when auditing what are the failing logins in one of my server, using the sp_readerrorlog procedure I get the following result, when running the following query: EXEC sp_readerrorlog 0, 1, 'Login ...
10
votes
5answers
2k views

How to deny access to SQL Server to certain login over SSMS, but allow over .Net SqlClient Data Provider

We have a situation where Developers do not have any UPDATE permissions, BUT they work with applications and see connection strings -> they know passwords from some SQL accounts (example SQLLogin1) ...
1
vote
1answer
359 views

Naming Convention for Login, User and Roles? [closed]

What are the Naming Conventions for a Login, A database User and a Database role? Is there any best practice to follow?
0
votes
0answers
45 views

SQL Server login error while revalidating the login on the connection [duplicate]

Recently we started seeing the below error in our environment. Failed to open the database ‘XXXX’ configured in the login object while revalidating the login on the connection. Any suggestions?
4
votes
3answers
1k views

Create login with SID as string

I'm trying to create a login as follows: CREATE LOGIN [Test] WITH PASSWORD='Test123', SID=SID_BINARY(N'S-1-5-21-408552231-458724953-3089381293-513') But no matter what it looks like SID only accepts ...
1
vote
1answer
83 views

Privileges on SQL Server

I come from Oracle Database and now I am trying learn SQL Server and I don't undestand why may I viewer others databases, like the master for example, with a common user without privileges in this ...
2
votes
1answer
370 views

Connecting to SQL Express Server 2017 with SQL Server Authentication Remotely

I have two systems that are on the same network. I am able to ping back and forth between these systems with their IP address and with their system names. I have enabled the TCP port 1433 inbound and ...
-2
votes
3answers
100 views

Determine which data a SQL login account has access to?

I am a new DBA and am trying to do some documentation on the SQL estate that I am responsible for. Currently I have no documentation on anything so this is all from scratch. I am hoping to find out if ...