login failed Error 18456 Help needed!

I'm a developer who's used mainly SQL Server 2000. I've installed 2005 at
work and use the client tools with no problem.
I have Vista at home, new machine. I installed Sql 2005. I've tried both
system login and Windows Authen. I am the only user and hence an admin on
this box.
I open 2005 Mgmt Studio. I want to attach databases. But I can't even get my
Database engine to connect, despite that fact my Server shows up in
Registered Servers.
When I choose Connect, I then browse for Server(only one), I use Windows
Auth and get error Login failed for user ....error 18456.
Something this simple, shouldn't be so difficult.
While I've connected at work with no problem, I guess that's the issue,
there was no problem and since I'm not a newbie, I'm kinda pissed off. Can
anyone help me?
Since I'm at home for the next 3 days, and since I'm registered using my
work email address, I'd appreciate a direct email to me at
matthewmark@.verizon.net.
Thanks,
Matthew MarkWhat's the error state and error description in the SQL Server log
files? They should give you a more detailed reason why you can't
logon.
Check if this helps:
http://eventid.net/display.asp?even...56&eventno=8175
&source=MSSQLSERVER&phase=1
________________________________________
_________________
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
examnotes
<MatthewMark@.discussions.microsoft.com> wrote on 11 nov 2007 in
microsoft.public.sqlserver.connect:

> I'm a developer who's used mainly SQL Server 2000. I've
> installed 2005 at work and use the client tools with no problem.
> I have Vista at home, new machine. I installed Sql 2005. I've
> tried both system login and Windows Authen. I am the only user
> and hence an admin on this box.
> I open 2005 Mgmt Studio. I want to attach databases. But I can't
> even get my Database engine to connect, despite that fact my
> Server shows up in Registered Servers.
> When I choose Connect, I then browse for Server(only one), I use
> Windows Auth and get error Login failed for user ....error
> 18456.
> Something this simple, shouldn't be so difficult.
> While I've connected at work with no problem, I guess that's the
> issue, there was no problem and since I'm not a newbie, I'm
> kinda pissed off. Can anyone help me?
> Since I'm at home for the next 3 days, and since I'm registered
> using my work email address, I'd appreciate a direct email to me
> at matthewmark@.verizon.net.
> Thanks,|||In the server erro log you can fine an entry related to the error.
Check the description of the STATE code here:
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
i hope this help !!!
Claudio Riefolo
MCSE - VCP
"Vera Noest" wrote:

> What's the error state and error description in the SQL Server log
> files? They should give you a more detailed reason why you can't
> logon.
> Check if this helps:
> http://eventid.net/display.asp?even...56&eventno=8175
> &source=MSSQLSERVER&phase=1
> ________________________________________
_________________
> Vera Noest
> MCSE, CCEA, Microsoft MVP - Terminal Server
> SQL troubleshooting: http://sql.veranoest.net
> ___ please respond in newsgroup, NOT by private email ___
> examnotes
> <MatthewMark@.discussions.microsoft.com> wrote on 11 nov 2007 in
> microsoft.public.sqlserver.connect:
>
>|||I'm not sure I understand, but I think your problem is that you are relying
on your membership in the local administrators group for permission to
connect. Vista doesn't give you that permission automatically. So try the
"Run as Administrator" option when you start Management Studio. After you
connect, add your own login as to the SQL Server. Then in the future you
won't have to run as administrator.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matthew Mark" <MatthewMark@.discussions.microsoft.com> wrote in message
news:0282CF87-7003-4CFB-8C0B-C8BC88BAD87C@.microsoft.com...
> I'm a developer who's used mainly SQL Server 2000. I've installed 2005 at
> work and use the client tools with no problem.
> I have Vista at home, new machine. I installed Sql 2005. I've tried both
> system login and Windows Authen. I am the only user and hence an admin on
> this box.
> I open 2005 Mgmt Studio. I want to attach databases. But I can't even get
> my
> Database engine to connect, despite that fact my Server shows up in
> Registered Servers.
> When I choose Connect, I then browse for Server(only one), I use Windows
> Auth and get error Login failed for user ....error 18456.
> Something this simple, shouldn't be so difficult.
> While I've connected at work with no problem, I guess that's the issue,
> there was no problem and since I'm not a newbie, I'm kinda pissed off. Can
> anyone help me?
> Since I'm at home for the next 3 days, and since I'm registered using my
> work email address, I'd appreciate a direct email to me at
> matthewmark@.verizon.net.
> Thanks,
>
> --
> Matthew Mark
>