Msg 6522, Level 16, State 2, Line 2
A .NET Framework error occurred during execution of user-defined routine or aggregate "geocode": 
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
System.Net.WebException: 
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at MappointGeocoder.MapPointRef.FindServiceSoap.FindAddress(FindAddressSpecification specification)
   at Spatial.MpGeocoder.Geocode(String streetAddress)

alter database pubs set trustworthy on
go

use pubs
go

sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

create assembly geocode from 'C:\temp\MappointGeocoder.dll'
with permission_set = external_access
go

create assembly ser from 'C:\temp\MappointGeocoder.XmlSerializers.dll'
with permission_set = safe
go

create function dbo.geocode (@address nvarchar(4000))
returns nvarchar(100)
as
external name geocode.[Spatial.MpGeocoder].Geocode
go

select dbo.Geocode('One Microsoft Way, Redmond, WA 98052');
go


create function GeocodePoint(@address varchar(100))
returns geography
as
begin
declare @g geography;
select @g = geography::STPointFromText(dbo.Geocode(@address), 0);
return @g
end
go

select dbo.GeocodePoint('One Microsoft Way, Redmond, WA 98052').ToString();
go

quote:

---

To run this sample you must have a MapPoint Developer Account.
Visit https://mappoint-css.live.com/mwssignup/Default.aspx?wa=wsignin1.0 to obtain this account.

Once you have obtained the account, change the code in Geocoder.cs to add your userid and password.
Uncomment the code for a proxy server if you use a proxy server, and recompile the .NET assembly.

This format mandates the order of coordinates as "longitude, latitude" rather than "latitude, longitude".
This is suitable for use with SQL Server's GEOGRAPHY data type.

---