Authentification problem with SQL Server 2000

Hello !
We use SQL Server 2000 (standard edition) under Windows 2003 Server.
Due to a hardware failure, we have fully set up the server after having
formating the hard drives. After having installed Windows Server 2003, we
have installed SQL Server 2000, then we have restored the databases from our
last night SQL backup.
Curiously : all our Windows XP users can connect to the server, but not our
Windows 2000 users! We have tried to create an ODBC data source with Windows
authentication : failure. With SQL authentication : failure.
But the same user, with his same userid, on another PC under Windows XP : no
problem.
And it was working well before the crash. Can anybody give us an explanation
? a solution ? a help ?
Thank you,
GilbertDo you have TCP/IP enabled on the SQL Server as an allowed connection type?
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Gilbert Tordeur" <gilbert.tordeur@.jci.com> wrote in message
news:O56wq5lQIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hello !
> We use SQL Server 2000 (standard edition) under Windows 2003 Server.
> Due to a hardware failure, we have fully set up the server after having
> formating the hard drives. After having installed Windows Server 2003, we
> have installed SQL Server 2000, then we have restored the databases from
> our last night SQL backup.
> Curiously : all our Windows XP users can connect to the server, but not
> our Windows 2000 users! We have tried to create an ODBC data source with
> Windows authentication : failure. With SQL authentication : failure.
> But the same user, with his same userid, on another PC under Windows XP :
> no problem.
> And it was working well before the crash. Can anybody give us an
> explanation ? a solution ? a help ?
> Thank you,
> Gilbert
>|||Hi Warren,
Thank you for your answer. Could you tell us where to look at, to answer
your question ?
Gilbert
"Warren Brunk" <wbrunk@.techintsolutions.com> a crit dans le message de
news: eUKerPpQIHA.5980@.TK2MSFTNGP04.phx.gbl...
> Do you have TCP/IP enabled on the SQL Server as an allowed connection
> type?
> --
> /*
> Warren Brunk - MCITP,MCTS,MCDBA
> www.techintsolutions.com
> */
> "Gilbert Tordeur" <gilbert.tordeur@.jci.com> wrote in message
> news:O56wq5lQIHA.4476@.TK2MSFTNGP06.phx.gbl...
>|||http://technet.microsoft.com/en-us/...y/ms174212.aspx
You need to use the SQL Server configuration manager which has an option for
viewing which connections are allowed...
Its under your start menu programs in the same group as SQL Server...
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Gilbert Tordeur" <gilbert.tordeur@.jci.com> wrote in message
news:uiXkOQvQIHA.2208@.TK2MSFTNGP06.phx.gbl...
> Hi Warren,
> Thank you for your answer. Could you tell us where to look at, to answer
> your question ?
> Gilbert
> "Warren Brunk" <wbrunk@.techintsolutions.com> a crit dans le message de
> news: eUKerPpQIHA.5980@.TK2MSFTNGP04.phx.gbl...
>|||Hi Warren,
Sorry to be a bit late, but : Thank you !
And a Happy New Year,
Gilbert
"Warren Brunk" <wbrunk@.techintsolutions.com> a crit dans le message de
news: OJDKPu5QIHA.5288@.TK2MSFTNGP04.phx.gbl...
> http://technet.microsoft.com/en-us/...y/ms174212.aspx
> You need to use the SQL Server configuration manager which has an option
> for viewing which connections are allowed...
> Its under your start menu programs in the same group as SQL Server...
> --
> /*
> Warren Brunk - MCITP,MCTS,MCDBA
> www.techintsolutions.com
> */
>
> "Gilbert Tordeur" <gilbert.tordeur@.jci.com> wrote in message
> news:uiXkOQvQIHA.2208@.TK2MSFTNGP06.phx.gbl...
>

Authentication failure - can't find domain accounts

We're getting an error where we can't add a login with the full dns name of a user - domain.xyz\user, for example. Get an error 15401, "Windows NT user or group domain.xyz\user' not found". The domain has a different Netbios name and DNS domain names, so we can add the user when we use the form "netbiosname\user". So far so good.

Unfortunately, we have another application - Office Share Point Server whose shared services provider won't run, giving errors in the event log every 60 seconds that "Windows NT user or group 'domain.xyz\user' not found".

It looks as if SQL insists upon listing users in the form netbiosdomainname\user, and applications that look for domain.xyz\user simply fail to authenticate.

Suggestions?

jnfranc at yahoo period com

SQL Server only understands NetBIOS names for Windows principals (i.e. when creating a login), but authentication via SSPI should work normally.

Please let us know if you still require help on this issue, if so, we will need more details regarding the failure, if possible the SQL Server error number/message.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

Authentication failure - can't find domain accounts

We're getting an error where we can't add a login with the full dns name of a user - domain.xyz\user, for example. Get an error 15401, "Windows NT user or group domain.xyz\user' not found". The domain has a different Netbios name and DNS domain names, so we can add the user when we use the form "netbiosname\user". So far so good.

Unfortunately, we have another application - Office Share Point Server whose shared services provider won't run, giving errors in the event log every 60 seconds that "Windows NT user or group 'domain.xyz\user' not found".

It looks as if SQL insists upon listing users in the form netbiosdomainname\user, and applications that look for domain.xyz\user simply fail to authenticate.

Suggestions?

jnfranc at yahoo period com

SQL Server only understands NetBIOS names for Windows principals (i.e. when creating a login), but authentication via SSPI should work normally.

Please let us know if you still require help on this issue, if so, we will need more details regarding the failure, if possible the SQL Server error number/message.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

sql

Audit login failure (with generation of alerts)

Hi,
I'm looking for a method to generate a Alert (Through SQL Agent) when a
login failure is detected on my SQL servers.
I managed to audit this through profiler, but I'm looking for something
which can be handled by the SQL Agent.
Thanks,
Chris
________________________________________
______
It's still better that if it would have been worst, isn't it ?
C'est toujours mieux que si c'etait pire !Set up an alert of 18456, and have it respond by sending you an Email.
Simon Worth
"Chris V." <tophe_news@.hotmail.com> wrote in message
news:Oy7wUnjKFHA.484@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm looking for a method to generate a Alert (Through SQL Agent) when a
> login failure is detected on my SQL servers.
> I managed to audit this through profiler, but I'm looking for something
> which can be handled by the SQL Agent.
> Thanks,
> Chris
> --
> ________________________________________
______
> It's still better that if it would have been worst, isn't it ?
> C'est toujours mieux que si c'etait pire !
>

Audit Login Failed Event

I know my SQL server is detecting a login failure, but how do I know who log
in incorrectly? Is there a way to record the IP Address or PC name. I need
to find out if someone just typed in a bad password or if someone Is trying
to hack my server.
thank you
JohnAudit Login option is limited with info on the structure of the Windows
Event Log. You can get more info, including comuter name, with Profiler.
Check the Profiler in Books OnLine if this is what you need.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jwtimoney" <anonymous@.discussions.microsoft.com> wrote in message
news:418A7655-A12B-4246-8BFD-491F6F087615@.microsoft.com...
> I know my SQL server is detecting a login failure, but how do I know who
login incorrectly? Is there a way to record the IP Address or PC name. I
need to find out if someone just typed in a bad password or if someone Is
trying to hack my server.
> thank you
> John|||As Dejan says, Audit Login failuers in SQLProfiler.

Audit Level

Hello Group,
when the Audit Level is changed from Everything to Failure, do I have to
stop and restart the SQL Server Windows Service?
RichYes you need to restart.
-Sue
On Fri, 17 Feb 2006 08:03:29 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:

>Hello Group,
>when the Audit Level is changed from Everything to Failure, do I have to
>stop and restart the SQL Server Windows Service?
>Rich

Audit Level

Hello Group,
when the Audit Level is changed from Everything to Failure, do I have to
stop and restart the SQL Server Windows Service?
Rich
Yes you need to restart.
-Sue
On Fri, 17 Feb 2006 08:03:29 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:

>Hello Group,
>when the Audit Level is changed from Everything to Failure, do I have to
>stop and restart the SQL Server Windows Service?
>Rich

Audit Level

Hello Group,
when the Audit Level is changed from Everything to Failure, do I have to
stop and restart the SQL Server Windows Service?
RichYes you need to restart.
-Sue
On Fri, 17 Feb 2006 08:03:29 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:
>Hello Group,
>when the Audit Level is changed from Everything to Failure, do I have to
>stop and restart the SQL Server Windows Service?
>Rich

Audit Failures whenever I start the SQL Enterprise Manager

Hi,
When ever I start the Enterprise manger client from my laptop(Client), I see
the Failure Audit in the Security Eventlog. I registered all the servers
using sql authentication. I am running SQL Enterprisemanger on Windows Xp.
Here is one of the error:
Unprotection of auditable protected data.
Data Description: SQL Server Registration
Key Identifier: 1f3ba71a-6f52-4e58-8007-43ced74242b4
Protected Data Flags: 0x0
Protection Algorithms: 3DES-168 , SHA1-160
Failure Reason: 0x8009000B
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Can anybody having the fix for this, because my securtiy Auditing team
questioning these failures.
Thanks
rb
1. Do you have encryption enabled on the client or server?
2. When this happens is the laptop connected to the network?
3. Do you have any IPSec rules setup for the SQL Server?
"rb" <srbssr@.yahoo.com> wrote in message
news:efxp4cN9EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> When ever I start the Enterprise manger client from my laptop(Client), I
see
> the Failure Audit in the Security Eventlog. I registered all the servers
> using sql authentication. I am running SQL Enterprisemanger on Windows Xp.
> Here is one of the error:
> Unprotection of auditable protected data.
> Data Description: SQL Server Registration
> Key Identifier: 1f3ba71a-6f52-4e58-8007-43ced74242b4
> Protected Data Flags: 0x0
> Protection Algorithms: 3DES-168 , SHA1-160
> Failure Reason: 0x8009000B
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Can anybody having the fix for this, because my securtiy Auditing team
> questioning these failures.
> Thanks
> rb
>