![]() ![]() ![]() 09:15:45.25 Server (c) Microsoft Corporation. 0 (X64)Įnterprise Evaluation Edition (64-bit) on Windows NT 6.3 (Build 14393: ) I have tried to enable the 'SA' account by following the steps in this tutorial: This video shows what the error is but the resolution steps are not very clear - my Administrator account is in the Administrators group but still unable to log in: I tried changing the Authentication option to SQL Server Authentication and logging in with the account specified during install (SMSadmin) - same error. Login failed for user 'SRV1\Administrator'. I get stuck on trying to log into Management studio for the first time - it doesn't allow me to log in as the local admin (SRV1\Administrator) - error: The 2 servers talk to each other no issues. I have a domain controller set up on Windows Server 2016 (DC1) and another server (SRV1) set up on which I've installed the SQL Server and Management studio. I have a home lab I'm progressively building in a virtual environment using VirtualBox. Problem: Just installed SQL server 2014 and SSMS 17.1 - cannot log into SSMS as administrator or the admin account specified during install. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |