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
2
votes
2answers
2k views

Re-map DB Users/Logins after Restore WITH STANDBY

This is related to my previous post.. Differential Backup Issue - Why? Is this Possible? Basically, the issue which I am having now is that in my restore process (as part of ETL), there are tasks to ...
5
votes
1answer
79 views

What would cause newly restored SQL Databases to show tables, but display an 'Invalid Object' error when trying to view table data?

Problem: As an untrained and involuntary SQL DBA, I'm taking a set of SQL 2008R2 databases and restoring to a new SQL 2008R2 server in another environment. The restore process goes fine and gives no ...
2
votes
2answers
6k views

Granting minimum select permission on system "sys" tables in every database

Our development team has created some SSRS reports that retrieve metadata only (no 'real' data) from every database. I am trying to lock down the service account running these reports to the minimum ...
2
votes
1answer
455 views

Application unable to connect after doing a failover ,Mirroring

After doing a failover to mirror database, the application is throwing below error Login failed for user 'NT Authority\anonymous logon'. reason: could not find a login matching the name provided In ...
2
votes
3answers
2k views

Logins Not being used in last one month

I have a requirement to create a query which can get the logins details which were not used in last one month. I have tried several way like extended events and audit tracing. But i'm unable to get ...
1
vote
5answers
17k views

Creating a SQL Login and User on an AlwaysOn Replica

I have a database (DB1) which is synced to (DB2) on another server (via AlwaysOn - SQL Server 2014). I want to give a user read access to DB2. I create a SQL login and database user in DB1. The new ...
0
votes
1answer
153 views

SQL Server Express 2012 SP1 let me log in, but shouldn't have

I connected to an instance of SQL Server Express 2012 SP1 on another machine via my workstation's SQL Server 2014 Management Studio. The instance has mixed mode authentication and I chose to log in ...
-1
votes
1answer
2k views

Deleted by mistake all logins

By mistake I deleted all logins from SQL Server 2008R (dev machine) Now I have only one login sa. When I try to connect to any database it shows me that my user does not have permission, so I can't ...
2
votes
3answers
1k views

User mapping to a standby database

I have a standby database that is being restored in standby mode using log-shipped transaction files downloaded from a vendor's sFTP site on a daily basis. Now, I am required to give a read-only ...
3
votes
1answer
169 views

Where can I find a list of reserved logins?

I have a web page where the user can configure a SQL Server login and password. I am trying to implement validation for this page. I looked up the requirements for a SQL Server login, and found this ...
0
votes
1answer
787 views

Cannot access SQL Server - SQL Error 18456

SQL Server Login is failing for one user where as others can access. Login is Windows Authenticated (Part of AD group user and admin access) I can see login in list of xp_logininfo members for that ...
1
vote
1answer
77 views

Connecting to SQL Server database from a .net application

I need to add a new form to an application which requires access to SQL Server to retrieve data from a single view and display it to the user. This application is an enterprise level application with ~...
1
vote
2answers
736 views

Server role with permission only to create server login, not alter one

I am working with Microsoft SQL Server Management Studio and I want to create a server role that has permissions to create server login but only create, not alter! Does anyone know what is the ...
1
vote
2answers
167 views

Difference Between Sign In and Login (Users and Groups)

I am trying to understand a paragraph from my notes, re Users and Groups in Active Directory. The phrase is: Users and Groups Sign in, they do not login. Now, what I (think I) understand is that ...
0
votes
2answers
2k views

Login in server suddenly lost mapping to their Users in databases

Mine is Always ON availability environment. I have 3 SQL 2014 servers(Primary and 2 replicas). Since one year all the logins working FINE in the servers. Some how suddenly, I am getting errors from ...
6
votes
1answer
21k views

How to lock a sql login after N unsuccessful login attempts

Consider I have login called sql_login. Can I lock sql_login login after 5 unsuccessful login attempts. When we create a login we can see there is option called password policy check the image. But ...
3
votes
5answers
13k views

Cannot login to SQL Server as a member of AD group

I have created a login for an AD group: CREATE LOGIN [MYDOMAIN\Development Admins] FROM WINDOWS WITH DEFAULT_DATABASE=[master] One of the members of that AD group is a user named DBGuy. I can see ...
0
votes
2answers
86 views

Restricted logins with automatic full permission in databases

My scenario: I have some groups with full - and inappropriate - access to all Sql Server instances. I want to change that. My Plan: Give full and automatic access to all databases (it is customer ...
1
vote
1answer
63 views

InnoDB MySQL account usage history

I would like to view the account usage history. I know it can be viewed via my.cnf through the general query log. But it will slow down the usage of the DB significantly. Is there a way to mitigate ...
3
votes
1answer
1k views

Login issues for the same SQL login on mirror server working fine on principal server

I will try my best to describe the situation, while we've been trying to figure this out: We have this SQL Login [LA] which shows successful connection on principal server in the sql error logs [...
0
votes
1answer
62 views

Enabling SQL Server authentication for restored database user

I've restored a remote database to my local, and it contains some users which are used to execute jobs. We are trying to execute the job and it is seems to return a connection error (connection to ...
12
votes
3answers
2k views

Determine whether mixed mode auth is enabled without logging in?

Is it possible in SQL Server to determine whether mixed mode authentication is enabled without logging on to SQL Server?
0
votes
1answer
47 views

SQL Server 2014 user login keeps being dropped

I have an issue where I have a user login which keeps being dropped randomly without any trace in the error log. How do I find out why it's behaving as such or who is doing this, even though I am sure ...
1
vote
2answers
2k views

Should domain "Users" group be removed from the SQL logins for database security?

I am coming from a security standpoint. I see quite a lot of SQL DBs with the entire domain "Users" group ("XXX Domain\Users") added as a login account in SQL. Does this mean that all users in the ...
1
vote
1answer
60 views

Delete SQL Server 2008 R2 server logins mapped to offline databases

I have circumstances that a server can host many databases and a lot of them get offline and transfered elsewhere from time to time. This causes lots of server logins to be created and stay there ...
1
vote
2answers
3k views

SQL Server - login failure every day at same time with the service account

I have dozens of SQL Servers, on many different versions. Many of them have an error in the SQL Server error log EVERY DAY at just about 2 am. Login failed for user 'TheDomain\...
2
votes
2answers
129 views

Error while trying to export logins from SQL Server 2000 to SQL Server 2005

I'm trying to migrate logins from an instance in SQL 2000 to a destination instance in SQL 2005. I've used revlogin before as explained here: https://support.microsoft.com/en-us/kb/246133 (I'm ...
4
votes
2answers
1k views

SQL server Principal and Mirror logins and permissions Issue

In a mirroring setup where server A is my principal and server B is my mirror, I had some issues related to logins and permissions at the time of fail-over. During fail-over Server B became my ...
0
votes
1answer
1k views

Proper way to create logins on Always on

What is the proper way to create logins on Always on? An application database requires an active directory login and I created that on the primary node. The database is still not in the availability ...
0
votes
1answer
357 views

TEMPDB full causing login problems with server login trigger

We have a server trigger used to prevent some logins from accessing SQL Server via SSMS in our DEV environment. CREATE TRIGGER [Deny_SQLLogin_SSMS_Trigger] ON ALL SERVER WITH EXECUTE AS 'sa' FOR ...
12
votes
1answer
64k views

Where are the username and password stored in postgresql?

I'm using the PostgreSQL database. In it I create users. So I want to know Where are the User name and Password stored? Whether the Password is stored as plain text or encrypted data? Whether root ...
3
votes
2answers
1k views

How to add a flexible database role to a database?

I know there are two types of roles, one predefined (fixed), another user-defined (flexible). Here is my use case: I have a large number of AD Groups, and I am trying to map them up to a role and ...
0
votes
2answers
1k views

SQL Server users and application users

I have develop a web application in MVC4 it is a application about credit and financing. Application is used by 40 to 50 users at a time. Application reporting is very heavy takes 2 to 3 minutes in ...
0
votes
1answer
130 views

Unable to drop database user without login

One of our developers with blanket privilege on a database wanted to create a regular user mapped to a login when what he mistakenly created was a user without login and now I'm unable to remove the ...
1
vote
0answers
346 views

SQL Server 2012 SP_HelpUser loginid dbroles

I need to display the list of all the roles a login is associated with. The logins are SQL Server logins. I tried all three: Execute sp_helpuser 'example' and SELECT MP.name, RP.name FROM sys....
3
votes
2answers
5k views

SQL Server - Windows Group Authentication

I am trying to understand how to create Windows Group based access to a SQL Server (2012) database the right way. I was able to successfully add a Windows group to the Server Login and I have a ...
5
votes
2answers
14k views

Create a user with privileges to create users

For our software we need a MySQL user who is able to create other MySQL users. This is possible with the MySQL root user but we do not want to use the root user in our software application. Is there a ...
3
votes
1answer
2k views

Why and for what possible reasons 'sa' gets locked?

Last night all of our systems failed and connections to the database kept dropping. We watched the log today and found out that this was the message: Login failed for user 'sa' because the account ...
-3
votes
1answer
50 views

Permission issue [duplicate]

I have restored one db of one instance from uat to anthother dev instance of the same server but how to fix orphan users I got 106 users how to fix and how to create logins is there any script for ...
0
votes
2answers
548 views

Adding sql users via linked servers

I need to add a windows user and set role to sysadmin for a bunch of linked servers and cannot figure out the syntax to make the current linked server active for the query to add the user and role. ...
3
votes
2answers
4k views

SQL Login keeps losing access to databases

We created a SQL Login account for reporting use only (SSRS), we'll call it 'MyReportAcct'. We've used this account for some time and it is created for every newly installed instance. It has been ...
7
votes
1answer
23k views

NT SERVICE\SQLTELEMETRY User

I've noticed that SQL Server 2016 installations include a new default login called NT SERVICE\SQLTELEMETRY. I'm aware that for the free editions of SQL Server 2016 you agree in the license to allow ...
1
vote
1answer
126 views

How can I restrict which computers can connect to an instance of SQL Server?

I'm not sure if this is a more a database or sysadmin question, so let me know if it doesn't fit. Because of some licensing agreements, I've been asked to find a way to restrict which computers on ...
3
votes
2answers
715 views

user/login name on process unknown

SQL Server version is 11.0.5569.0. The user/login for the process on a server is as follows: S-1-9-3-412646706-1242810017-220819094-3312857753 This is not an orphaned user (as suggested below) ...
2
votes
1answer
423 views

Access Denied for root MySQL

Disk space was full on my server and I needed to do a mysqldump. I tried logging into MySQL, but temporarily forgot the password. I then tried using the --skip-grant-tables & , but I received an ...
2
votes
5answers
87k views

ORA-01017: invalid username/password; logon denied from sql developer but sqlplus logins

I've a strange behaviour of Sql Developer with OS Authentication, 4.1.3 32/64bit, gives ORA-01017 while sqlplus is logging in without any problem. This is the example answer sqlplus gives me: ~ ...
0
votes
2answers
62 views

SharePoint Database Creation Failure

I wonder if this question will need to be moved to the SharePoint SE site, but I believe this could be a simple a SQL Server security fix. A little back story: Back in April we upgraded our ...
9
votes
2answers
3k views

enable query log for single database

I am having many database schema in mysql 5.6 server, now the problem over here is that I want to catch the queries for one schema only. I can not enable query log for entire server as one of my ...
3
votes
1answer
112 views

How keep overview about database permissions?

As DB-Administrator I need to keep overview about my servers and databases in general - and from a security context about logins, users, db-roles and permissions in particular. It is possible to ...
2
votes
1answer
63 views

System Database Migration and Security - Log Shipping or DB Mirroring

I've setup log shipping between two servers (they used to be mirrored). What is the simplest or most efficient way to mirror the system databases between the primary and secondary? Is it just a ...

1 2 3
4
5
7