Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a SQL server 2012 setup to use windows authentication.

Remotely I can connect to "Server A" no problem with domain credentials but when I try to locally connect to "Server A" with SSMS it errors out to say that there is a login failure.

I have all the correct permissions set I beleive any other suggestions?

share|improve this question

closed as unclear what you're asking by Max Vernon, Paul White, RolandoMySQLDBA, Mark Storey-Smith, Jon Seigel Oct 4 '13 at 3:07

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
When you connect locally, are you logged-in to Windows using a domain account? –  Max Vernon Oct 1 '13 at 16:06
2  
What is the state and the rest of the message (check the error log)? See sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/… –  Aaron Bertrand Oct 1 '13 at 16:09
1  
@MaxVernon right. are you logged in as a domain user or are you logged in as a local admin. are you logged in locally using the same domain account as you are when you login remotely? also, please note that you cannot simply rely on BUILTIN\Administrators as of SQL Server 2008. –  swasheck Oct 1 '13 at 16:11