Last post Nov 14, 2014 02:13 PM by march11
Nov 13, 2014 02:54 PM|march11|LINK
I am running SQLEXPRESS with about 6 databases and websites.
I would like to open a connection to one table in one database for a developer to code some front end content, specifically in java script.
I am not new to IIS or server OSs, but I am new to the best way to keep all other databases secure and still provide access to this developer.
I understand I have to open a firewall port (maybe a few) and add a password. But how do I restrict the developer access to specific DB and/or table(s) once access to SQLEXPERSS is gained.
I have read few web pages already on this process but have not found anything that clearly walks through this set up. Including the correct way to configure the SQLEPXESS and the server. Server 03 and SQL 2008 R2.
Links and/or tutorials very much appreciated.
Nov 14, 2014 03:17 AM|Mikesdotnetting|LINK
You should create a SQL Server user account for the user and map it to the database that they are allowed to work on: http://sqlmag.com/database-security/securing-sql-server-tables
Nov 14, 2014 03:46 AM|wmec|LINK
Within VS project, what you need to have is just one connection string to connect to DB, which is like
<add name="conn2" connectionString="Data Source=192.?.?.?\your_db_instance;Initial Catalog=your_db_schema;Integrated Security=False;User ID=your_db_login;Password=??????" providerName="System.Data.SqlClient"/>
within Web.config/app.config file in your project, to ensure the project will work fine with the database.
Nov 14, 2014 10:20 AM|march11|LINK
Mike, great article thanks.
Do you have anything that covers the SQL config to allow the remote conections?
Nov 14, 2014 10:31 AM|Mikesdotnetting|LINK
Like this: http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx?
Nov 14, 2014 02:13 PM|march11|LINK
Thanks Mike, exactly what I needed.