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
1answer
29 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
13 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
21 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
60 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
34 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
29 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
45 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
32 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
13 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
56 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
76 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
0answers
17 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
160 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
79 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
230 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
32 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
46 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
36 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
36 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
114 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
126 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
42 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
38 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
366 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
45 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
48 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
1answer
89 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
275 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 ...
6
votes
1answer
169 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
60 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
149 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
450 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
247 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
916 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
255 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
106 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
139 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
53 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
33 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
62 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
77 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
112 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
129 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
346 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
1k 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
2 3 4 5 6