Joined the instance to the Simple AD domain.ĥ. Reconnected in Management Studio using the new SQL login I just created.Ĥ.
#SQL SERVER SA ACCOUNT FOR REMOTE LOGIN WINDOWS#
Enabled mixed Windows Auth and SQL Auth mode. Launched SQL Management Studio and connected with Windows Authentication. Connected to the instance with the local Administrator account. Created a Simple AD using AWS Directory ServiceĢ.
#SQL SERVER SA ACCOUNT FOR REMOTE LOGIN PASSWORD#
I suspect that there is some interaction between SQL Server Management Studio and Simple AD when encrypting the password that might be failing. If I RDP into the EC2 instance as a domain user and use sqlplus to connect to the RDS database it works as expected. This lag is not present when RDP'd into the EC2 instance as Administrator. In addition, when I enter the sa password in SQL Server Management Studio, there is significant lag (1+ seconds) between typing a character and when it displays in the password field. When I RDP into the EC2 instance as a domain user, SQL Server Management Studio fails to connect to the RDS instance using SQL Server Authentication (sa account) with the following error message:Ĭannot connect to .com. When I RDP into the EC2 instance as the Administrator, SQL Server Management Studio can connect to the RDS instance using SQL Server Authentication (sa account).
The Windows machine is a member of a Simple AD domain. The user KMT can log in locally on the remote SQL.I'm using SQL Server Management Studio 2012 to connect to an RDS SQL Server 2012 instance from a Windows 2012 R2 EC2 instance. I am not an SQL guru, must be something I am missing here.
User KMT have sysadmin rights on remote SQL. Server Name: Remote server IP\VISMA, 11433Īt .ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)Īt .CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)Īt .CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)Īt .TryGetConnection(DbConnection owningConnection, TaskCompletionSource 1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at .TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)Īt .TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource 1 retry, DbConnectionOptions userOptions) at .TryOpenInner(TaskCompletionSource1 retry)Īt .TryOpen(TaskCompletionSource`1 retry)Īt .Open()Īt .(UIConnectionInfo ci, IServerType server)Īt .() When I try to log in using any other account than SA the following error occurs:
0 kommentar(er)
