The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
11 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 ...
2
votes
1answer
54 views

ORA-01017: invalid username/password;logon denied

There were other similar questions asked, but none that were able to tell me why I can't connect using a C# .NET web site I've stood up. While I know this forum is more for DBAs connecting to ...
1
vote
1answer
42 views

How to give an existing server login access to an attached/migrated database

I'm migrating databases from SQL Server 2012 to 2014. I detached the databases from source server, then copied the files (.mdf, .ldf, etc.) to the new server and attached them. That process went fine, ...
1
vote
1answer
20 views

To find out last activity/access date and date of expiration for all SQL Server 2012 User login

Apart from enabling the Audit on the SQL server, is there any other way we could find out the last activity/access date and date of expiration for all SQL Server User login ? Also using DMVs wont work ...
0
votes
1answer
17 views

How do you list all logins for Sql Azure?

What queries can I use to list all logins for a server and database in SQL Azure? I tried running select * from sys.sysusers but I'm guessing that's just showing the users
0
votes
0answers
23 views

Azure invalid SID - is SID even necessary?

I'm migrating a database from SQL Server to Azure Database Server. I'm doing this manually, because many SQLs have to be rewritten (sp_addextendedproperty, XML Open commands etc). So I grab the ...
0
votes
1answer
26 views

How to display User Mapping for offline databases?

When I use the GUI (SSMS) to review the User Mapping, where the Login has mapping to a database that is offline (or otherwise not available) I get the message below and it only displays Mapping for ...
0
votes
1answer
38 views

SQL Server 2014 login issue

I have a login issue here. I created a new user login in SQL Server 2014. I tried to connect to my database using this new login and the below error pops up Message Error: 18456, Severity: 14, ...
0
votes
0answers
34 views

Error: 18456, Severity: 14, State: 11. Login-based server access validation failed with an infrastructure error

We are getting the above error on a SQL 2012 server running Windows Server 2008R2 when connecting using an application and a service account. The server also has Config Manager database and GAP policy ...
1
vote
2answers
46 views

User cannot select from table but their permission appear to show that they should be able to

I attempted to revoke delete permissions to most users in a database by using the deny and revoke sql commands and checking the deny box for delete when adding the table as a securable in the UI. ...
0
votes
1answer
33 views

How to find the AD user that logged in to SQL Server using SQL Login [duplicate]

Some users are logging into database servers locally, opening SSMS and logging in to SQL Server using SQL logins to run queries. How can I find the AD user that logged in to SQL Server using a SQL ...
2
votes
3answers
43 views

SQL Login currently in use or not

Recently we did a change on a client's production server. The change was to rename an sa login. Once we renamed the sa login we found out the client was having a problem because sa login was used in ...
1
vote
2answers
117 views

Confused Logins and Users in SQL Server

In SQL Server, when setting permissions with a Grant statement, we do it on Users, not Logins. For example: CREATE LOGIN login1 WITH PASSWORD = 'sssssssss'; use mydb; CREATE USER user1 FOR LOGIN ...
1
vote
1answer
56 views

Standard naming for a credential systems

Is there a standard naming convention in regards to credential oriented systems? (Logins) The only one I could really come up with (in a shorthand form) is using the word "Gateway". Representing a ...
0
votes
0answers
28 views

User mapping to one DB dropped for one login periodically

I have a domain user (DOMAIN\ReServer) that was created to allow SSRS reports to access various databases. Those DBs that reside on SQL instance RS01\Prod have never been a problem. One DB resides on ...
1
vote
1answer
98 views

Can we create multiple users in one login in SQL Server 2008?

I have one database where I want 4 users in that particular database, so do I have to create 4 logins, one for each user ? I want multiple users from one login. I tried to create a second user by ...
1
vote
1answer
21 views

Checks to be done, before/after changing the windows login password? [duplicate]

Here we have a scenario where a Service account , added under security as sysadmins for windows login, going to have its password change as per windows policy. Since windows team, server admins are ...
0
votes
1answer
38 views

To list the databases and logins

Can anyone tell me the query to list the databases and SSRS reports and different logins in a particular server ?
1
vote
1answer
39 views

Cannot log in with default user on Mac 10.10

I am running PostgreSQL on a Mac 10.10 PostgreSQL 9.3.5 on x86_64-apple-darwin12.5.0, compiled by Apple LLVM version 5.1 (clang-503.0.40) (based on LLVM 3.4svn), 64-bit I am having trouble ...
0
votes
1answer
37 views

Unable to find Audit specification when I try to create Server level audit

I am trying to use 'SERVER_PRINCIPAL_CHANGE_GROUP' audit action on a SQL Server to capture the sp_addlogin events. But when I try to create a Server level audit using GUI, I am not seeing the Audit ...
2
votes
1answer
53 views

I want to find out in SQL SERVER 2012, who is creating SQL Logins and on which date

I was trying to find out in sql server 2012, who created login and which date. Can any body help on this thanks,
7
votes
2answers
401 views

Property class Length Annotation PersistedResolvableAnnotation

I am trying to deploy an ssdt project using sqlpackage.exe utility. I get the following error (in German): Fehler bei der Erstellung des Bereitstellungsplans. Die Bereitstellung kann nicht ...
3
votes
2answers
88 views

Handle expired SQL login's passwords in SQL Server

Is it possible to change the password for a login with an expired password using SQL Server Management Objects (SMO) programming? Many times during working hours I got this message from a production ...
1
vote
1answer
32 views

Login Schema Role User Setup

Environment: Windows Server 2012 SQL Server 2014 Standard Public website (Site-A) on Server Private website (Site-B) on Server Windows App running on workstations SQL Server 2014 Standard: 2 ...
5
votes
3answers
606 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
63 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
37 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
58 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
546 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
890 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
37 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
15 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 backup-...
1
vote
1answer
254 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: https://azure.microsoft.com/en-gb/documentation/articles/sql-...
1
vote
1answer
43 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
82 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
33 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 $ORACLE_HOME/network/admin/...
1
vote
2answers
51 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 ...
2
votes
1answer
307 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
130 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 ...
1
vote
1answer
58 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. ...
1
vote
1answer
2k 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
157 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
34 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
267 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
47 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
528 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
134 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. ...
1
vote
1answer
1k 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
80 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 select?...
0
votes
1answer
152 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 ...