ansaurus

Question

Unless I start Management Studio with "Run as administrator", I get a Login Failure (Error 18456)

Answer 1

+1 A:

Check how your SQL server authentication is configured. Most probably you have a login defined only for BUILTIN\Administrators, but don't have one for BUILTIN\Users or for you Windows account.

Update: As per comment reques - expanding my answer with some detail I provided as a comment.

Add a new login for BUILTIN\Users or your Windows account (LOCAL_MACHINE\MedicineMan :-)) and map the proper access rights. If you want to do DB admin rights, you should add login for your account. If you want just regular DB read/write, you can go for BUILTIN\Users.

Franci Penov 2010-04-01 07:43:22

I logged in as admin, found server properties and permissions. Indeed only BUILTIN\Administrators is on the list. Now what do I do?

MedicineMan 2010-04-01 07:52:07

Add a new login for BUILTIN\Users or your Windows account (LOCAL_MACHINE\MedicineMan :-)) and map the proper access rights. If you want to do DB admin rights, you should add login for your account. If you want just regular DB read/write, you can go for BUILTIN\Users.

Franci Penov 2010-04-01 08:15:08

@Franci - Add the comment to the answer body@ MedicineMan - Accept as answer :)

Slavo 2010-04-08 07:46:34

@Slavo, @Franci I found that the directions were not very clear. For this reason, I do not want to mark your question as accepted and award these points. Franci did direct me to serverfault where I ultimately got a well written answer to my question. I apologize if I could not understand your solution. I'm sure that it is excellent.

MedicineMan 2010-04-09 05:19:07

@MedicineMan - your choice, but the answer you got on serverfault is exactly the same I gave you here.

Franci Penov 2010-04-09 05:33:08

ansaurus

tags:

views:

answers:

Unless I start Management Studio with "Run as administrator", I get a Login Failure (Error 18456)

related questions