Running script on SQL 2022; "Cannot find data type dbo.ipaddress."

[ItAdmin712]

Trying to run these scripts on SQL server 2022. The IP Address fields cannot be created. The error is:
Cannot find data type dbo.ipaddress.

Is there a different data type that could be used?

[macn27]

@ItAdmin712 - you may want to look elsewhere for the script to setup the SQL database, although I'm sure that this script works well for some, I also had trouble with it. I would look further at the official Microsoft documentation specifically this web page - https://learn.microsoft.com/en-us/windows/win32/nps/sql-programmability#sample-stored-procedure I used the script there to create my database.

[JasonEverling]

Thats where I originally created this from, but 2016 days, you need to run for newer NPS versions, I havent had time to even look at updates in so long bc we no longer use NPS, using a docker freeradius mod bc it can do a little more we needed it to do

if exists (select * from dbo.systypes where name = N'ipaddress')
exec sp_droptype N'ipaddress'
GO

EXEC sp_addtype N'ipaddress', N'nvarchar (15)', N'not null'
GO`

and change columns from

[dbo].[ipaddress] NULL ,

to

[ipaddress] NULL ,