I went ahead and changed the service account to a domain account which resolved the issue.

Thanks for the idea!

So I just created this to illustrate what I'm looking to do.

CREATE TABLE STYLE(

[StyleID] [smallint] NOT NULL,

[StyleName] [varchar](50) NOT NULL,

[Activestatus] [bit] NULL

)

GO

CREATE TABLE REPORTHEADER(

[StyleID] [smallint] NOT NULL,

[ReportHeaderForeColor] [varchar](50) NULL CONSTRAINT...