Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2012-03-22 : 06:46:29
|
| Hi,I was trying to connect to one Server through RDP and able to do it without any issues. But when trying to connect SSMS, gives the error message "Login Failed for the User (Microsoft SQL Server, Error : 18456). When I check in the Logs, displayed "Login failed for user "--". Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]".I've googled for the exact solution, but didn't find any proper one. SSMS is working fine with SQL Server Logins, am trying to connect through my admin (Domain) account which has SA permissions and one thing is my account is only the one which has SA permissions on that Server.I've tried couple of options.i.e.Disabled UAC (User Access Control) and set the option "Run as Administrator", but those didn't work. So please help me in this case, as I should be able to connect to the Server ASAP. |
|
|
|
|
|
SQL Server 2008 R2 Issue