I am getting the error
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'xyz'.
I am connected with my user name and password. I am set as sqladmin and public as Server Roles.
I am connected through local SSMS and there is VPN connection to the server is also running.
When I remote login to the server, and login as my username and password, i can execute the stored procedure.
While working on local SSMS and SSRS reports, I was able to execute the stored proecdure and able to do tha work. Suudenly, I could not do that and i am trying since Yesterday.
Any suggestions are welcome.
View Complete Post