The tag has no usage guidance.

learn more… | top users | synonyms

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
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 ...
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
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
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 ...
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
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 ...
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
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 ...
1
vote
0answers
77 views

Querying number of tries since last successful log, checking IP as well as user

I asked this question before on stackoverflow, but it might fit better here, since it is mainly about database performance. The actual question With performance in mind, how would you go about ...
1
vote
0answers
217 views

how can Audit All Login To SQL Server BY ODBC Connection

I MAke Report By Access Form On SQL database I make ODBC Connection For login To Update the data From Database Now I want Audit All logins To know who make Update today Or who make Update Now ? ...
0
votes
0answers
18 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 ...
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 ...
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 ...
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. ...
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, ...
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 ...
0
votes
0answers
126 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. ...
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
0answers
106 views

Restored database is missing user

I have a SharePoint content database that has been restored into our test environment. I am getting errors in the SQL log indicating our SharePoint service account is not able to access the database. ...
0
votes
0answers
4k views

Login failed for user 'x'. Reason: Could not find a login matching the name provided

I get this error Login failed for user '****'. Reason: Could not find a login matching the name provided. [CLIENT: 10.4.3.5] Right around 3 AM ish but the application connecting to sql server ...