July 10, 2011 at 4:41 am
Hi i am not able to login from my local system to other system on windows authentication mode.The other system is configured for windows authentication mode and i have access to system from administrator account .
Regards
July 10, 2011 at 4:59 am
Does the administrative account you're using have access to SQL? It's no longer a default that all administrative accounts are sysadmin.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2011 at 5:25 am
Yah its having SYSadmin role on sqlserver
July 10, 2011 at 5:45 am
Check the error log for the detail of the error.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2011 at 5:50 am
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (.Net SqlClient Data Provider)
July 10, 2011 at 6:45 am
Well that's pretty clear.
Use an account that is in a trusted domain or speak to the domain admin about adding a trust relationship.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply