I am trying to register a server under SSIS and the dialog box has NT
authentication and is greyed out so that I can not change it to th sa
account. When I try an connect, I get access denied. Anyone have any
clue as to what is going on?

Is your server configured as Mixed Mode Authentication?

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/79babcf8-19fd-4495-b8eb-453dc575cac0.htm



--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"Ferg" <kferguson (AT) comdata (DOT) com> wrote