Change Database Connection for EF Model in VS

Q) How do I connect my EF Entity Model to a different database?


When you add an entity Model to your project a db connection wizard is presented where you specify the connection details. If you want to change the database name or server at some point you can edit the connection string in the app.config file for the project containing your entity model.

Windows Server 2008 Sql Server 2008 Firewall Configuration

After installing Sql Server 2008 an exception needs to be added to the firewall.

Sql Server uses the following Ports as noted here
I only opened up 1433.

Beyond using SQL Browser, you can perform a network scan looking for services listening on default ports for any of the SQL components. These default ports are

Database Engine	1433
SQL Browser	1434 for DB engine
SQL Broker	4022, by convention
Analysis Services	2383
Reporting Services	80/443

I found some instructions here http://msdn.microsoft.com/en-us/library/cc646023.aspx

I ran this command.

PS C:\Users\Jimmy>netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope= SUBNET profile = CURRENT

IMPORTANT: Command executed successfully.
However, "netsh firewall" is deprecated;
use "netsh advfirewall firewall" instead.
For more information on using "netsh advfirewall firewall" commands
instead of "netsh firewall", see KB article 947709
at http://go.microsoft.com/fwlink/?linkid=121488 .

Ok.

PS C:\Users\Jimmy>