from this website you can see that the connection string for the MS SQL Server 2005 has to be something like:
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
can you connect to the server from the SQL SMS ?