You put me on the right track there. Turns out that I had server authentication set to
'Windows Authentication' mode rather than the required
'SQL Server and Windows Authentication mode
When craig says change to
SQL Server and Windows Authentication mode the trouble is that I can't find were to change this even though Craig desbribes it very well,
The only thing is that I can only find windows authentication mode but not the 'SQL Server and Windows Authentication mode' as Craig refers to. they are seperated not together, I can only chose one of them not them together?
Thats why I am asking if there could be a difference between 2005 and 2008 visually?
best regards