Well...guys...I found my issue after a long day of searching....
I was trying to create a user from dbo...so that ain't going to work never ever...
But i kinda like solved my problem...I just added the dbo to the users table....and that kinda like worked..
Sorry that I'm asking all kind of stupid questions, but I'm a total noob in SQL
Thanks for the replies, and the time taken.