How The Heck Do I Use A GUID As A Foreign Key In MSSQL 2005?

Okay, this is driving me nuts.  It *should* be simple but it is not.  I've spent the last 4 hours scouring the web for what should be a simple thing to find out.

I have the following tables, but everytime I attempt to create a foreign key constraint for the StudentLocations table I get an 'invalid type' error.  I have a GUID as the PK for the Students and the Locations table.  However, since I cannot create two GUIDs (as far as I can tell) for my StudentLocations table, I have instead defined the StudentLocations.StudentID, and StudentLocations.LocationID as binary(16).  Unfortunately, I can't match this binary(16) to the GUID Identity in a foreign key because I keep getting this stupid error of 'invalid conversion type!'. 

 So, how do I do what I am trying to do using GUIDs as my PK for the Students and Locations tables, and the above defined StudentID, LocationID in a StudentLocations table?

Thanks in advance for answering this question.  I should spend 5 minutes searching and then come here in the future...it's way less frustrating!:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Students]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Students](

[id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_Students_id] DEFAULT (newid()),

[first_name] [nvarchar](50) NOT NULL,

[middle_name] [nvarchar](50) NULL,

[last_name] [nvarchar](50) NOT NULL,

CONSTRAINT [PK_Students] PRIMARY KEY CLUSTERED

(

[id] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

END

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Locations]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Locations](

[id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_Locations_id] DEFAULT (newid()),

[address_1] [nvarchar](50) NOT NULL,

[address_2] [nvarchar](50) NULL,

[city] [nvarchar](50) NOT NULL,

[state] [nvarchar](50) NOT NULL,

[zip_base] [char](5) NOT NULL,

[zip_four] [nvarchar](4) NULL,

CONSTRAINT [PK_Locations] PRIMARY KEY CLUSTERED

(

[id] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

END

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StudentLocations]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[StudentLocations](

[id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_StudentLocations_id] DEFAULT (newid()),

[student_id] [binary](16) NOT NULL,

[location_id] [binary](16) NOT NULL,

CONSTRAINT [PK_StudentLocations] PRIMARY KEY CLUSTERED

(

[id] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

END