This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 54%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Hello Friends
I recently download SQL server on my desktop and also Microsoft SQL Studio version 18
I am really new to this , need some assistance
I created a DB by name Automic and Logins Automic. But when i try to login , it is getting failed . Not sure what im missing , could you please help me with that
Error message :-
%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
Server Name: DESKTOP-O3FCHKN
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
------------------------------
Program Location:
at System.Data.SqlClient.SqlInternalConnectionTds..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, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
could you please advice .
Hi @Bharat S ,
We have not received a response from you. Did the replies could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 62%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
anonymous userChaudhari Could you elaborate on you answer regarding 'Security and enable SQL server and windows mix mode' ? I cannot find that in Windows Server 2019 Data Center build 1809.
Since I cannot connect, navigating the Object Explorer is not an option.
I get exactly the same error messages as @Bharat S
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 77%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sql server has two login types for authentication one is sql server login where you need to enter user name and password and another is windows login where your windows creds are automatically used by sql server to provide you the integrated authentication without the need of entering password again.
Mixed mode authentication only works when enabled.
If you have forgotton your password for sql server login you will need to check with your DBA or if you had windows authentication you will need to be a part of AD security group which has permission to login in sql server , which one, this you will need to check with your team or manager for whom its working DBA can also provide you this info and then ask your AD team to add you in it.
Incase its your personal computer and server and you have forgotton password you can reset it by starting sql server in single user mode but thats an problem to solve with a different question so in case you still need help you can open another question and make sure you are chosing the right authentication type whiel trying to login using SSMS
Regards,
Shivam
Try right click on server "Desktop..." > Properties > Security and enable SQL server and windows mix mode.
Right click again on server and restart and then try connecting using Atomic login.
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Hi @Bharat S ,
There are two authentication modes for SQL server( windows authentication and Mix authentication). When you using Login Automic connect to SQL server, this login process using SQL server authentication. By default, we did not enable SQL server authentication. So you need to enable SQL server authentication as VaibhavChaudhari mentioned.
Please restart SQL server service to make this change effect.
If you want learn more about SQL server authentication, please refer to MS document Choose an Authentication Mode.
If the response is helpful, please click "Accept Answer" and upvote it, thank you.