Hi everyone,
Wondering if anyone can assist me with this; I've done some googling but haven't come across anything.
We have a dedicated server running SQL Server 2005, express edition. I recently set up the server to allow remote connections to the DB engine and everything is working just fine. However, I would really like to limit remote connections to just one user; IE if someone other than user XYZ connects remotely, they are denied. Any ideas?
Thanks in advance