david.1982 0 Light Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.