Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
My team lead, pointed out the issue. As I could not find the issue/solution here, posting it for others. I knew I could not use windows authentication, so I was trying to use SQL Server Authentica...
Answer
#1: Initial revision
by
James Jenkins
·
2020-08-21T17:53:28Z (over 4 years ago)
My team lead, pointed out the issue. As I could not find the issue/solution here, posting it for others. I knew I could not use windows authentication, so I was trying to use SQL Server Authentication, this was the problem. To access SSMS as a different user - When opening SSMS from your PC; Shift + right click > ‘Run as Different User’ enter ID ‘Admin1’ + password, proceed as normal.