I have the similar problem here. looks like CR2008 does not like SQL server alias, I have to use the instance name for the login. give it a try.