The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
3answers
550 views

Who is the person using a SQL login?

Is it possible to find out who used a SQL-Server login? Let's assume we suspect a person to abuse a SQL login that is supposed to be used by an application only to logon to SQL-Server. Is the domain ...
4
votes
1answer
49 views

Need to list SQL Windows auth users on each SQL server and rename the domain name

We are doing an AD Domain NetBIOS rename. We have about 20 SQL servers, and on each we have a series of logins like OLD.DOM\sqluser1 etc. I want to do two things, and a third would be a bonus. I'm not ...
0
votes
0answers
19 views

Can't log in to MariaDB with --password=<password> but not with user-interactive login?

I can log into my MariaDB server when I put the password directly in the bash command, but not when I'm doing the user-interactive login (which is of course safer). root@vm# mysql -u root --password ...
1
vote
2answers
45 views

cannot login to MySQL remotely

users and root can log in locally with no problems. No user can login from a remote connection though from remote: [root@yoda:~] # mysql -v --host=r2d2.er.com --user=power --password='burp' power ...
1
vote
1answer
61 views

Tracing failed login attempts in Oracle

I have some users who are logging in with a wrong password and their accounts get locked. Now I need to find the source of the failed login attempt. The machine, username etc. Is it possible to find ...
1
vote
4answers
109 views

MySQL can't login and/or reset password

There are many similar questions, but none of them have helped me. I had been using MySQL on Windows with root/root credentials for a while, but since lately, I'm not able to login > mysql ERROR ...
3
votes
1answer
30 views

SQL Server: Interplay of personal login and group membership

I created a login for a user using his windows user then I created a login for an AD group in which the same user is a member. I did NOT give any access to the personal login any access to the DB and ...
0
votes
0answers
12 views

How to migrate logins ( not users ) from one instance to another? [duplicate]

I have lots of instances here where I work, and i'm planning to put all of them into just one. I will migrate all databases from these instances to only one instance. Ok, I can do this ( I will ...
1
vote
1answer
51 views

Azure SQL Database “Login failed for user” contained users.

I'm having a similar issue to this question (http://dba.stackexchange.com/posts/123094/edit)! I have followed the following article: ...
1
vote
1answer
35 views

What is the best way to store user profiles and logins?

I need to store user profiles and logins. Is the best way to do that to have a table for logins (email, username, and password) and a separate table for their profile/info (e.g. their progress in ...
0
votes
2answers
50 views

SQL Server 2012 Login Failure

As of this morning we have had thousands of failed login attempts to our SQL Server 2012 box. Error : Login failed for user 'Domain\User'. Reason: Infrastructure error occurred. Check for ...
0
votes
0answers
22 views

Create connections in sqldeveloper. 12505 error

I have oracle 12c installed in my ubuntu 15.10, I can run sqlplus with sqlplus / as sysdba and run it in a CLI. But I want to be able to use it with sqldeveloper. cat ...
1
vote
2answers
40 views

How to enable a user using a script?

I create a user with CREATE LOGIN... sp_grantdbaccess does not seem to enable the user How can I enable a user using a script? UPDATE: GRANT CONNECT does not seem to work, maybe I wasn't clear ...
1
vote
1answer
94 views

Running SQL job: The login is from an untrusted domain and cannot be used with Windows authentication

I have two databases in different servers (server1 , server2) server1: Login : login1 / password :123 /member of sysadmin (user user1,password:pass) server2 : Login :login1 / password :123 ...
0
votes
1answer
71 views

Is it possible to know the remaining 'expiration of sql login password date' & ‘maximum password age’ through T-SQL

I would like to say that today incident whatever i have faced related to Microosft SQL Server 2012. I had logged in Microsoft SQL Server 2012 at starting working hour of office time ,but at the mid of ...
5
votes
0answers
79 views

Always On Availability Group, Always redirect user to read only instance

We have an Always On availability group with a primary and a read-enabled secondary. We have a user for the implementation team who uses the database to check the correctness of the data that they are ...
1
vote
1answer
51 views

SQL Server login not working

I have a user who was added with windows authentication to a SQL Server 2008 R2 machine. He had left the company a few months ago, at which point his AD user was disabled and moved to a different OU. ...
11
votes
2answers
876 views

Hyphen in my computer's name causing T-SQL error

I’m a developer, not a DBA (which is showing, I’m afraid). I am trying to run Report Builder 3.0 with SQL Server 2014 Express on my home computer (named John-PC) and cannot run my reports. I ...
1
vote
1answer
766 views

Cannot connect to MySQL sever with MySQL Workbench

I am using MySQL 5.6.26 Community Server on a Mac OSX 10.10.4. The server is running, according to the preference pane utility. Also I can connect to the server using the command line tool with the ...
0
votes
0answers
87 views

Periodic connection timeouts

I have an application that runs every minute using the Windows Task Scheduler. One of the first things the job does is connect to a SQL Server 2008 instance to record that the application started. A ...
1
vote
0answers
31 views

Repeated login issue SQL Server 2008 R2 (SSIS)

I'm trying to figure out an issue I'm currently having with an SQL Server connection - there has been a few issues with timeouts on a SSIS package, where it has failed a login attempt - however as far ...
3
votes
1answer
96 views

SQL Server 2008 : force user to change password at next login

How can I force users to change their password at next login? I want all my user change their password at next login to choose new password with new policy. user must change password at next login ...
1
vote
0answers
34 views

Elasticsearch For Login Purpose

Is it secure to index users' credentials, such as passwords (hashed) and usernames, in ElasticSearch for login purpose? //Practical Issues
6
votes
1answer
342 views

Azure: Many Failed Login Attempts Logged

I run a SQL Server on an Azure Virtual Machine. I have noticed in the Event Logs of the server lots of failed SQL Login attempts using a ton of different usernames (none of which exist): Login ...
2
votes
1answer
70 views

SSDT: Create User in a database not being part of the project

I want the user of my SSDT Database Project to be created as a user in another database on the same server and give it permissions to connect and add it to the db_datareader role. I failed to do so. ...
3
votes
1answer
34 views

How to get the AD account associated to a Proxy?

on the picture below, you can see, I have a sql server job called "Backup SSAS DBS_" that Run as: PowerShell_Proxy How can I find out the AD (active directory) account associated with that Proxy ...
0
votes
1answer
593 views

How to change the login for a database's dbo user?

I just finished a successful install of SQL Server 2014 Express, onto a domain-joined VM instance of Win8.1. During setup which I ran under DOMAIN\Admin I accepted the default configuration of adding ...
2
votes
2answers
68 views

How to identify database users and their owned schemas before dropping server logins?

While deleting logins, there might be a possibility that there are users in databases along with chances that they own schemas in those databases. Is there a way to find this out with a single ...
0
votes
1answer
93 views

Failed SQL Login - Source server same as destination cannot locate SPID SQL Server 2014

Bit of a confusing one here. We are getting repeated messages in the SQL Server error log as below for a SQL Server instance: NT AUTHORITY\SYSTEM Reason: Failed to open the explicitly specified ...
0
votes
0answers
130 views

CREDENTIAL mapped to Login to gain access to file resource for Bulk INSERT

According to BOL, this should be a fairly straight-forward solution to my problem, but unfortunately, it is not working and I have not been able to find much online about using CREDENTIAL mapping. ...
3
votes
1answer
142 views

How to create a login and user that can only access one schema in one database

I have executed the following: USE [MyDatabase]; GO CREATE LOGIN [MyDomain\MyAccount] FROM WINDOWS WITH DEFAULT_DATABASE=[MyDatabase]; CREATE USER [MyDomain\MyAccount] FOR LOGIN [MyDomain\MyAccount]; ...
0
votes
0answers
110 views

Why is Activity Monitor Login blank, and what is that process doing?

I observe regularly occurring User processes (User Process = 1) connecting from load-balanced application servers to a database server (see Environment Details below) on the same internal network, ...
4
votes
2answers
134 views

Rebinding a SQL Server user to its login after a restore with this user

After performing a restore of a SQL Server (v12.0.2000) database, I figured that a user needs to be remapped to its login (this issue seems to be known as orphan users). And one of the simplest way to ...
3
votes
2answers
120 views

Prevent logins loss when restoring a database

I'm backuping and restoring databases accross two sql server (v12.0.2000). But it looks like whenever I restore a .bak file, the login I created on the database that was backuped is no more existent ...
1
vote
0answers
37 views

Log shipped database server user SID is created automatically

We have a production server "prod" which has a user say 'test' that lets the users connect to the application and a logon trigger which stops them from connecting to the server through SSMS. I ...
0
votes
0answers
49 views

SQL Server Phantom Login

I have log shipped a database from one SQL Server 2008 R2 server to another in standby mode for reporting purposes. Permissions are granted via a Windows AD Group called DOMAIN\DB Access Group which ...
2
votes
1answer
142 views

Should I delete disabled windows Active Directory accounts from SQL 2008?

Is there a risk of not deleting unused Windows logins that have been disabled in AD or is it simply a housekeeping issue? e.g. Windows authentication is used to provide database access. A user leaves ...
5
votes
2answers
328 views

How to monitor history of logins to database if login auditing is not enabled?

I have a number of databases on multiple servers that don't seem to be used any longer. Can't find their owners, there are no processes linked to them, nothing got written to the tables for a few ...
2
votes
1answer
58 views

SQL Server Active Directory login groups with limitation

I'm DBA in my organization and use SQL Server 2012 and 2014. I requestd to define multiple group in active directory such as Developer, DBA, supporter and ets... and add my users to this groups. after ...
0
votes
0answers
127 views

ASP.NET Session Database - what user to create?

I am migrating a .Net 3.5 website with SQL Server 2005 Enterprise databases to SQL Server 2012 Enterprise (website still .Net 3.5). It uses ASP.NET session state database of type "t" Temporary. ...
11
votes
1answer
1k views

Does sys.sql_logins.is_policy_checked mean that the policy has been checked?

When I look in sys.sql_logins, I see a column called is_policy_checked. Can I trust that my password policy has been checked for all of the logins where this column value is 1?
1
vote
2answers
34 views

removing sql logins from one server, after migrating to another server, but all the databases were not migra

Here are the details of the production environment: I have 2 serevrs, A1 and A2. I have completely transfered 100 logins from server A1 to A2. Server A1 contains 5 DATABASES. But I moved only 2 ...
3
votes
2answers
370 views

Getting all databases which a sql logon can connect

I need to know all databases in a SQL Server on which a user can connect. With sys.databases I get all databases and with sys.server_principals or sys.syslogins I get all server logons. But I can't ...
0
votes
1answer
392 views

Only local administrators can connect remotely

I'm facing a problem that when I try to connect to the SQL Express instance from client to server. The Server logs an error: SSPI handshake failed with error code 0x8009030c, state 14 while ...
0
votes
1answer
748 views

SQL Server : how to disable connections to a linked server?

SQL Server Linked Server to default instance - service is disabled but connection is still possible I have a server called SWLON1 that has SQL Server 2005 and SQL Server 2008 r2 installed. The SQL ...
1
vote
1answer
70 views

Preventing orphaned users in SQL Server 2008 R2

I've recently had a situation where a database was refreshed from production to staging, and the users on the database ended up orphaned. These are sql server users, not mapped to windows ...
1
vote
1answer
117 views

SQL logins Audit for SQL Server 2005/2008

For the Security Audit of SQL servers 2005/8 R2, We are looking for a method which can list us SQL accounts which have not changed password for last X days. For a single login we can do it via ...
0
votes
0answers
195 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. for linked servers

I am trying to execute a query to pull data from another server. I added the server as a linked server to the another one but I am getting the following error when I try to execute the query Login ...
0
votes
1answer
4k views

Login failed for user - Error: 18456, Severity: 14, State: 38 [duplicate]

I am trying to run and ADODB command in MS Access 2012 to exec a stored proc in our SQL server 2008R2 database, but I keep getting error 38 and SQL profiler shows the following: Error: 18456, ...
5
votes
2answers
2k views

How to change default database to all logins?

I'm bit new to SQL Server and I'm trying to script out Microsoft SQL Server (2005-2014) post installation activities and I got bit stuck on altering logins. Corporate policy states that none login ...