How do I actually setup what users have access in SQL Express?
Please note that I am a SQL Server administrator so am comfortable
with creating id's etc in the full product. I cannot however find out
how to do this with Express.
In my windows application I have created the SQLE database and it's
settings are as the following.
Integrated security = true;
It is using windows authentication. (I'd use SQL authentication but
cannot find the server administration console - I expect because this
is express?)
My NT user id is being passed as the login which for arguments sake is
XYZ\mylogin
The database owner is XYZ\mylogin
The error is Login failed for user 'XYZ\mylogin
Thanks,
Rich.