Showing posts with label mainly. Show all posts
Showing posts with label mainly. Show all posts

Monday, March 19, 2012

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 Mark
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?eventid=18456&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 ___
=?Utf-8?B?TWF0dGhldyBNYXJr?=
<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?eventid=18456&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 ___
> =?Utf-8?B?TWF0dGhldyBNYXJr?=
> <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
>

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
>

Wednesday, March 7, 2012

Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backups
and t-log backups.
ThanksNiles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:
> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for backups
> and t-log backups.
> Thanks

Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backups
and t-log backups.
Thanks
Niles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com
|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:

> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for backups
> and t-log backups.
> Thanks

Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backup
s
and t-log backups.
ThanksNiles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:

> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for back
ups
> and t-log backups.
> Thanks