Error 18456
-
Hello,
I am running SQLServer2008 and SQL Management Studio 2008. I am trying to run a SQL server on my local machine and manage it with the management studio. I cannot seem to figure out how to log on.
I know the server name is the instance name, which I left default in the installation. It errors out with Error 18456, saying it is unable to log on.
I feel dumb, let me know what I've done wrong.
Thanks,
Josh
-
I woud try "Microsoft® SQL Server® 2008 Management Studio Express" edition, here: http://www.microsoft.com/downloads/en/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. -
Did you choose to add yourself as an admin during install? Also did you choose Windows authentication only or Mixed? If mixed, login as 'sa' and use the password you setup. Once in, you can add your windows account to have access to the instance by adding it under Security folder.
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
Just windows authentication. And I am pretty sure I added myself as admin during the install. How do I check that?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply