I created a user with dbowner privileges through my windows authentication login on my local sql server box. But when I try and login with that same user through the sql authentication, it does not allow me to get in. I'm running MS SQL Server 2008 Express R2. I gave privileges to my table to this specific user and basically want to test it out so I can give coldfusion admin the datasource login. It's on a windows server 2008 box. Any help would be most appreciated.