In MySQL, I can set which hosts are allowed to connect to the server in the config file. Is there a way to do this in SQL Server?
Asked
Active
Viewed 546 times
1 Answers
0
Yes you can do all this via
- SQL Server Management Studio
- directly over SQL ( see http://msdn.microsoft.com/de-de/library/ms173463.aspx )
You can give access for domain users, groups or just create an independent user. There's lots information in the web so feel free to google some howtos.
stb
- 3,405
- 2
- 17
- 24
-
Sorry, maybe I wasn't specific enough: I want to limit the connection based on a user name/host name combination, like it is in MySQL. – johnmcp Jun 27 '12 at 08:34
-
so the user can just see specified databases, tables ? – stb Jun 27 '12 at 08:39
-
I'm not worried about limiting access to specific tables or database, I know how to do this. I want to be able to say userA@IP is allowed access to this database. Connections from any other IP are not allowed – johnmcp Jun 27 '12 at 08:47
-
Ah ok, now i understand what you are searching for. Haven't seen this in SQL Server so far, maybe have a look at this and see if its an option for you: http://stackoverflow.com/questions/7127602/restrict-sql-server-connection-to-specific-ip-address – stb Jun 27 '12 at 08:59