February 17, 2010 at 9:55 am
I have a sql 2005 sp3 instance on a windows server 2008 enterprise server. When I try to connect to the database engine from SSMS using my windows authentication (domain\user.name) it fails with error 18456 severity 14 state 11. What is strange is I can connect to the database engine from my personal PC using SSMS and same accout but not from SSMS on the windows 2008 server itself. In addition, I can connect to SSRS and SSAS from both locations using my windows account.
Exec xp_logininfo 'domain\user.name'
returns
domain\user.nameuseradmindomain\user.nameBUILTIN\Administrators
Clearly, my account is valid and a sysadmin of the instance.
Any thoughts would be greatly appreciated.
February 17, 2010 at 10:17 am
This may help.. I am not 100 % sure
On the Server, when opening the SSMS, right click and choose Run as Administrator
Also check with your System Admin to include your account in Access Control List (ACL), when I had this kind of problem, my System Admin resolved this issue by granting some permissions in it.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 18, 2010 at 9:00 am
Bru,
Thanks for the response. Running the app as an administrator does work.
DAM
February 18, 2010 at 9:20 am
Good to hear that Dan.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 20, 2010 at 6:38 pm
Bru Medishetty (2/17/2010)
This may help.. I am not 100 % sureOn the Server, when opening the SSMS, right click and choose Run as Administrator
Also check with your System Admin to include your account in Access Control List (ACL), when I had this kind of problem, my System Admin resolved this issue by granting some permissions in it.
Hi, Bru, what's the difference between "Open" And "Run as administrator"?
February 21, 2010 at 11:56 pm
Hi, Bru, what's the difference between "Open" And "Run as administrator"?
______________________________________________________________________________
It switches the SQL Server to run with the administrator account.
Cheers,
- Win.
" Have a great day "
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply