Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [logins]

For questions about login credentials and accounts used to access a database resource, typically at the server or instance level.

1
vote
1answer
35 views

Query of sys.login_token doesn't include particular windows group while connect within workgroup

I had two SQL Server Logins which correspond to two windows groups: MachineName\MyAppAmdin MachineName\MyAppUser And I use select principal_id, name, [type], usage from sys.login_token where ...
5
votes
5answers
123 views

How to tell which windows group login I used when logging in via windows authentication

I created two SQL Server Logins which correspond to two windows groups: MachineName\MyAppAmdin MachineName\MyAppUser Then in the database, I created two users with the same name and mapped them to ...
1
vote
0answers
30 views

Switching users in PgAdmin

I'm looking for a way to enable switching between users in pgAdmin 4. I'm aware of the possibilty to change user from the properties-dialog before connecting. However this isn't useful when I'm ...
2
votes
2answers
295 views

Pass data from a table row into a create login statement using dynamicSQL [closed]

I have a lab exercise that involves creating a script that uses dynamic SQL and a cursor to loop through each row of a table and then create a loginID and more. We've done NO work concerning cursors/...
2
votes
1answer
91 views

SQL Server - Remove all logins that they are asossiated with orphan users

I have an SQL Server 2008R2 that had lots of databases. The procedure was that a logins were created and users were mapped to databases. Most of these databases have been removed from the server ...
1
vote
0answers
20 views

Unlink Windows login from database user in SQL Server contained database

I'm migrating databases from SQL Server 2012 to Server Server 2017, and switching SOME of them to partially contained. I've done SQL Server backups and restores to actually move the databases, and ...
1
vote
1answer
46 views

The current security context cannot be reverted

Msg 15199, Level 16, State 1, Line 29 T he current security context cannot be reverted. Please switch to the original database where Execute As was called and try it again. execute as login=...
2
votes
1answer
431 views

Logon failed for login due to trigger execution

I have been trying to login using one of my sql server logins but I am getting the error message below: General Error Message Copy Message Text TITLE: Connect to Server -----------------------------...
2
votes
1answer
176 views

How to script out the grant view on login permission?

I create the following login without any permissions. USE [master] GO IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'Radhe') CREATE LOGIN [Radhe] WITH PASSWORD=N'...
1
vote
1answer
35 views

Changing the “default database” opton in login

I am looking for a way to change the option of "default database" to master for all the logins on my instance from current user database in order to maintain the consistency. Application code logins ...
4
votes
2answers
332 views

Azure SQL Server Database Error: 18456, Severity: 14, State: 1

Why can't I login to my SQL Server database on Azure, and how do I correct this? No one in our company has changed the password of our Azure SQL Server database administrator user, yet I'm getting the ...
2
votes
3answers
74 views

Cleaning up specific domain logins on about 50 servers and therefore the users

There is a specific need to clean up logins from the SQL Servers after migration from one domain say abc to new domain foo. After migration as we still have those old logins and users under naming of ...
1
vote
1answer
69 views

Cannot add Network Service as User/Login

I want to setup ProGet on a 2016 server with SQL Express and IIS. Both the service and IIS web runs under the Network Service user. None seem to be able to access the Database on a local SQL Express ...
0
votes
1answer
36 views

Is Query Slower When There Are More Columns in one Table?

I'm trying to build a login function and was wondering: Does more columns in a table mean the longer (and slower) the query takes to return a result? I'm asking because I'm debating on whether to ...
1
vote
0answers
20 views

Ideal and Efficient Way of Handling User Logins with Multiple Types (i.e. Employee, Client, etc.)?

I'm developing a database where I will have two types of users: Employee and Client. I'm thinking it would be ideal to just have one big USERS TABLE with a user_ID as PK and Type column to ...
2
votes
1answer
414 views

SQL Server Error while creating User

I tried creating a user with all privileges but I am getting this error: Microsoft SQL Server Management Studio Create failed for User 'Hru'. (Microsoft.SqlServer.Smo) Additional ...
2
votes
1answer
547 views

Login lacks connect endpoint permission in SQL Server - Error 18456, State: 149

I have a fresh database I've setup, which I can connect to and perform operations like normal via the SQL Server Management Studio. I have two accounts I created for my application to use, and both ...
0
votes
1answer
106 views

SSIS Transfer Login Task Error

I have created an SSIS Transfer Logins Task. I have selected the SourceConnection and DestinationConnection and both valid and active. I have selected certain Windows group accounts to transfer ...
3
votes
1answer
88 views

Get notified when user with administrative privileges logs in

I have less than a handful of users that have sysadmin role membership. I would like to be notified (emailed) when one of them logs in. Is creating a trigger the best way or is there some kind of ...
0
votes
3answers
280 views

How to Audit Successful Logins for certain logins only?

I need to setup auditing (logging) of successful logins on SQL Server (date, time, who), not for all logins on a server, but only for a small group of logins (developers) In short, me only ...
1
vote
3answers
358 views

help in connecting the sql server 2017 developer edition

I have installed the sql server 2017 for non production environment in my PC. It has installed successfully. when connect using sqlcmd it was throwing an error login failed for login sa. it didn't ...
0
votes
0answers
142 views

Error authenticating proxy

I'm trying to schedule an SSIS packages through SQL Server Agent and am aware that a proxy account may need to be created to simulate an AD user with the relevant permissions to access any given file. ...
2
votes
2answers
140 views

Unable to connect to localhost with mysql utilities

I installed mysql utilities on my ubuntu server today, so I could use mysqldbcompare, but I just cannot connect to the mysql server with it (localhost). I created an entry into the .mylogin.cnf, using ...
0
votes
1answer
22 views

Preserving existing logins during database refresh

I am trying to do database refresh within Sql server 2014 instances from lower env to production for making it to golive. All the required logins exist on current prod and as far as I understand while ...
0
votes
1answer
537 views

The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys' (Error 229)

Window account is getting the below error when trying to connect into the SQL instance via management studio 2014. The SELECT permission was denied on the object 'configurations', database '...
0
votes
0answers
14 views

One of the DB Roles Not Showing Up Under A Login

Upon a request that I received, I have queried out the all the database roles under a particular login. To make sure that the result is correct, I opened up that particular login and went over to ...
0
votes
0answers
446 views

Login failed for user '<mysqllogin>'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>] issues

Over the last 10 days or so, I've started to get 'Login failed for user ''. Reason: Failed to open the explicitly specified database. [CLIENT: ]' entries nearly every 5 mins in my SQL 2008 logs and I ...
1
vote
1answer
69 views

Object Level Security

I have a database that will be shared across multiple related types of applications for different users. I want to be able to restrict each database user to essentially have full control over their ...
0
votes
1answer
44 views

How to enable failed login profle on MySQL

We are trying to implement failed_login profile for account lock on MySQL. didn't find it on documentation. Our version is 5.7.12.
-1
votes
1answer
31 views

Installed with Windows authentication but dont know the SQL server UID & PW

i have installed SQL express without providing any user ID or password, ie. with Windows Authentication, now i want to login using SQL Authentication UID & PW, but i dont know what is my UID &...
1
vote
0answers
243 views

SQL Server Login auditing capturing Logon events when set to Failed logins only

I have an issue where within my SQL Server 2016 Standard instance, Login auditing is set to Failed logins only but within the ERRORLOG file, it is capturing Both failed and succesful logins. Once I ...
0
votes
0answers
29 views

How to set Max Query Execution Time for Certain Logins in SQL Server [duplicate]

In SQL Server, is there an ability to limit allowed single query duration for certain logins (users) ? I would like to limit some logins so they won't be able to run queries more than 30 seconds. For ...
3
votes
2answers
96 views

create sql server login for own domain account

I have a working SQL Server instance to administer. I do not have a SQL Server login and do not know any other logins. I do have a Windows domain login to the server as a local admin. How can I add ...
2
votes
1answer
73 views

How do I enable md5 authentication for only one user?

I just installed Postgres 9.2 on CentOS 7. I want to keep peer authentication for all my users except one, which I would like to be able to access via "psql" through any user's account. I tried ...
0
votes
1answer
320 views

“sudo -u postgres psql postgres” does not ask for password

I've taken over a system using postgres. When logging in, if I use ... sudo -u postgres psql postgres ...it does NOT ask for a password. However, if I do ... psql -U postgres -h localhost postgres ...
6
votes
1answer
332 views

Disable multiple logins in one step

Is there a way to disable multiple sql logins based on a set of users in a table? For example: ALTER LOGIN (Select userid from tbl_user) DISABLE;
0
votes
0answers
22 views

Include_Path Complications Using XAMPP

I'm creating a login system for a website using php. I have finished the code, but whenever I must include() a php file the code runs into the error: Warning: include(db.php): failed to open stream: ...
0
votes
0answers
183 views

Same Domain Linked Server Login Failing

I have several SQL Server instances. All of them are setup in the same domain, and have been working for years. One of these instances serves as an aggregator for the data of the others, and a sync ...
0
votes
0answers
77 views

How to make Oracle accept any password for login?

We have an old application which we need data and reports from. The application is configured to retrieve data from Oracle DB and the login username and password are hardcoded in the application. ...
4
votes
3answers
127 views

Capturing the Login Failure alerts specifc to bad password attempts

I am unable to figure out the way to capture only those failed logins, which have failed with the error: Login failed for user X. The password did not match... Yes I can read that info out from ...
2
votes
1answer
622 views

Minimum credentials on SQL Server to connect via Power BI Desktop

Note: This is not a Power BI issue, this is a DB credential issue. In Power BI Desktop, I am trying to connect to a database, but I only want that user to have SELECT access. I have one User that is ...
1
vote
0answers
104 views

SQL Login failure, 18456, STATE 43

I've seen Aaron Bertrand's extensive post, and I've asked on Twitter #sqlhelp, but have not gotten an answer for what this error with state 43 means: Error: 18456, Severity: 14, State: 43 Login ...
0
votes
3answers
86 views

The mapped logins are removed when database is restored

Whenever I restore a database all my logins associated with that database are removed. How can I avoid this ?
1
vote
3answers
178 views

Migrate logins tagged to specific databases users

We are doing migration from SQL2008R2 to SQL 2014 for some of the databases hosted on 2008R2 to 2014 and remaining DB's to other servers. I am aware of migrating the login using dbatoo or using ...
0
votes
1answer
49 views

Find ClientHost using ClientIP - SQL Server 2014

Recently we started getting alerts as below : EventID 18456 - Login failed for user 'abc'. Reason: Could not find a login matching the name provided. [CLIENT: xx.xx.xx.xxx] EventID 17828 - The ...
1
vote
0answers
20 views

How to deliberately lock out an SQL Server 2014 login without changing security policy

We came up with a series of SQL Server instance checks for the login used in our software product. One of the checks examines the login and determines if it's locked out. The code in the check needs ...
2
votes
2answers
912 views

Error: 18456, Severity: 14, State: 46

I am facing the below error : Login failed for user 'NT AUTHORITY\SYSTEM' : Reason: Failed to open the explicitly specified database. Reason: Failed to open the database configured in the login ...
2
votes
1answer
79 views

Fixing Orphan user on Snapshot mirror

I am sort of confused about orphaned users in database snapshots created on the partner server participating in database mirroring. Server A acts as principal for database X, with server B as its ...
0
votes
1answer
47 views

Can't log into mysql shell

When I try to log into the mysql shell with: mysql -u root then I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) How do I log onto ...
0
votes
1answer
27 views

MySQL - Unable to login with password, but without password its working

I have a master-slave setup, Slave is not in read only mode.(we can do all writes). I have created a user. create user 'bhuvi'@'%' identified by 'bhuvi'; grant all privileges on *.* to 'bhuvi'@'...