Radius Server - SQL Server 2000 Logging of IAS...

Author

SQL Server 2000 Logging of IAS...

Rex A. Winn, Jr.

2004-04-29, 6:35 pm

I am trying to log to SQL Server 2000 and I keep getting the
following error regardless of what I do. I have verified the
permissions in SQL Server 2000 and tested the connection it
all looks good. But as soon as we try to authentication the
authentication fails with the information below. If I stop
the logging everything works like it should.

- Rex

Access request for user radius@test.com was discarded.
Fully-Qualified-User-Name = <undetermined>
NAS-IP-Address = XXX.XXX.XXX.XXX
NAS-Identifier = Test100
Called-Station-Identifier = 00-90-0E-00-85-6C
Calling-Station-Identifier = 00-06-25-42-1B-6E
Client-Friendly-Name = Test100
Client-IP-Address = XXX.XXX.XXX.XXX
NAS-Port-Type = Wireless - IEEE 802.11
NAS-Port = <not present>
Proxy-Policy-Name = ProxyForward
Authentication-Provider = RADIUS Proxy
Authentication-Server = XXX.XXX.XXX.XXX
Reason-Code = 80
Reason = The authentication or accounting record could not be written to
the log file location. Ensure that the log file location is accessible,
has available space, can be written to, and that the directory or SQL
server name is valid.

James McIllece [MS]

2004-05-04, 5:34 pm

"Rex A. Winn, Jr." <rex@community.nospam> wrote in
news:eWaiwZjLEHA.1264@TK2MSFTNGP12.phx.gbl:

> I am trying to log to SQL Server 2000 and I keep getting the
> following error regardless of what I do. I have verified the
> permissions in SQL Server 2000 and tested the connection it
> all looks good. But as soon as we try to authentication the
> authentication fails with the information below. If I stop
> the logging everything works like it should.
>
> - Rex
>
> Access request for user radius@test.com was discarded.
> Fully-Qualified-User-Name = <undetermined>
> NAS-IP-Address = XXX.XXX.XXX.XXX
> NAS-Identifier = Test100
> Called-Station-Identifier = 00-90-0E-00-85-6C
> Calling-Station-Identifier = 00-06-25-42-1B-6E
> Client-Friendly-Name = Test100
> Client-IP-Address = XXX.XXX.XXX.XXX
> NAS-Port-Type = Wireless - IEEE 802.11
> NAS-Port = <not present>
> Proxy-Policy-Name = ProxyForward
> Authentication-Provider = RADIUS Proxy
> Authentication-Server = XXX.XXX.XXX.XXX
> Reason-Code = 80
> Reason = The authentication or accounting record could not be written to
> the log file location. Ensure that the log file location is accessible,
> has available space, can be written to, and that the directory or SQL
> server name is valid.
>
>

Hi Rex --

IAS sends XML documents containing accounting data to a stored procedure in
the SQL Server 2000 or MSDE 2000 database. The stored procedure must be
named report_event.

Is that how you have your db configured?

--
James McIllece, Microsoft

Please do not send email directly to this alias. This is my online account
name for newsgroup participation only.

This posting is provided "AS IS" with no warranties, and confers no rights.

Rex A. Winn, Jr.

2004-05-04, 5:34 pm

Funny you would ask. I am reading an article right now:
http://support.microsoft.com/default.aspx?kbid=323723
that describes this process. What I find interesting is
that right before it covers the creation of this sproc
in the DB it mentions to tables:

record_main and record_data

Then the stored procedure procedes to insert data into
dbo.event_main and dbo.event_data. Makes me wonder how
anybody can get this working? Is it me or is the sproc
using different tables than the article?

So if that answer can be cleared up then here's the next
question. If you copy and paste the stored procedure code
in this article into the SQL Server 2000 SPROC Wizard
and "Test" the procedure I get an "Error Near Go" at the
very end of the SPROC.

Am I knocking at the right door? Is there some mad cat
up in a tree laughing while the mad hatter entertains
allice for tea? If this is what I should be doing then
I am going to guess that I just create the tables using
the SPROC tables event_main and event_data and that I
create the fields in the tables using only the fields
that are described in this SPROC correct?

If that is the case all that remains is to debug the
SPROC so that it will actually compile and save in the
main DB.

Thanks,

Rex

"James McIllece [MS]" <jamesmci@online.microsoft.com> wrote in message
news:Xns94DF92058F30Ajamesmcionlinemicro
s@207.46.248.16...
> "Rex A. Winn, Jr." <rex@community.nospam> wrote in
> news:eWaiwZjLEHA.1264@TK2MSFTNGP12.phx.gbl:
>
>
> Hi Rex --
>
> IAS sends XML documents containing accounting data to a stored procedure
in
> the SQL Server 2000 or MSDE 2000 database. The stored procedure must be
> named report_event.
>
> Is that how you have your db configured?
>
> --
> James McIllece, Microsoft
>
> Please do not send email directly to this alias. This is my online
account
> name for newsgroup participation only.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.

Rex A. Winn, Jr.

2004-05-04, 5:34 pm

James McIllece [MS]

2004-05-04, 6:34 pm

Hi Rex --

Thanks for pointing out the inconsistencies in this article. I'm working on
getting that corrected.

I can email you a new stored procedure you can try out, although I don't
have any help for the procedure and it is also an example (but I am sure it
is better than the one in the KB because it was just tested last week).

If you're interested in the sproc please send an email requesting the sproc
to me at wsdocs@nospam.microsoft.com.

Obviously remove the nospam first.

Also, I really enjoyed the mad cat/mad hatter/Alice in Wonderland imagery
in your last post. :-)

Thanks --

James

"Rex A. Winn, Jr." <rex@community.nospam> wrote in
news:u4uye8hMEHA.3292@TK2MSFTNGP11.phx.gbl:

> Funny you would ask. I am reading an article right now:
> http://support.microsoft.com/default.aspx?kbid=323723
> that describes this process. What I find interesting is
> that right before it covers the creation of this sproc
> in the DB it mentions to tables:
>
> record_main and record_data
>
> Then the stored procedure procedes to insert data into
> dbo.event_main and dbo.event_data. Makes me wonder how
> anybody can get this working? Is it me or is the sproc
> using different tables than the article?
>
> So if that answer can be cleared up then here's the next
> question. If you copy and paste the stored procedure code
> in this article into the SQL Server 2000 SPROC Wizard
> and "Test" the procedure I get an "Error Near Go" at the
> very end of the SPROC.
>
> Am I knocking at the right door? Is there some mad cat
> up in a tree laughing while the mad hatter entertains
> allice for tea? If this is what I should be doing then
> I am going to guess that I just create the tables using
> the SPROC tables event_main and event_data and that I
> create the fields in the tables using only the fields
> that are described in this SPROC correct?
>
> If that is the case all that remains is to debug the
> SPROC so that it will actually compile and save in the
> main DB.
>
> Thanks,
>
> Rex
>
>
>
> "James McIllece [MS]" <jamesmci@online.microsoft.com> wrote in message
> news:Xns94DF92058F30Ajamesmcionlinemicro
s@207.46.248.16...
> in
> account
> rights.
>
>

--
James McIllece, Microsoft

Please do not send email directly to this alias. This is my online account
name for newsgroup participation only.

This posting is provided "AS IS" with no warranties, and confers no rights.

Rex A. Winn, Jr.

2004-05-05, 1:33 am

An email will be coming soon. Glad you enjoyed the
imagery. I'm a bit like that at times.

"James McIllece [MS]" <jamesmci@online.microsoft.com> wrote in message
news:Xns94DF97A79F661jamesmcionlinemicro
s@207.46.248.16...
> Hi Rex --
>
> Thanks for pointing out the inconsistencies in this article. I'm working
on
> getting that corrected.
>
> I can email you a new stored procedure you can try out, although I don't
> have any help for the procedure and it is also an example (but I am sure
it
> is better than the one in the KB because it was just tested last week).
>
> If you're interested in the sproc please send an email requesting the
sproc
> to me at wsdocs@nospam.microsoft.com.
>
> Obviously remove the nospam first.
>
> Also, I really enjoyed the mad cat/mad hatter/Alice in Wonderland imagery
> in your last post. :-)
>
> Thanks --
>
> James
>
>
> "Rex A. Winn, Jr." <rex@community.nospam> wrote in
> news:u4uye8hMEHA.3292@TK2MSFTNGP11.phx.gbl:
>
>
>
>
> --
> James McIllece, Microsoft
>
> Please do not send email directly to this alias. This is my online
account
> name for newsgroup participation only.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.