CMIS and SQL 2008 install

[sgavan]

Hi I have installed SQL 2008 onto our 2003 server, and created a datbase following the Serco instructions. I have created a new connection/ODBC I have tested it on the server and it works fine but when I try to connect from a client pc it says "connection failed sqlstate 28000" it looks like its trying to use the domain user account instead of the STUD_ADMIN I think. Serco dont have info on the sql install so I may be missing something on that part. Any help would be great.

Thanks

Ste

[michael2k6]

Sounds to me like in the connection from the client, you've used Windows Authentication rather than SQL authentication.
Create a new connection, make sure you use SQL Authentication.

Mic @ Serco

[sgavan]

Thanks that worked.

Ste