[sims] SQL Sims migration: SQL must be configured for local and remote connections.

[edutech4schools]

I am just about to carry out an SQL 2008r2 to SQL2012 migration and in the instructions it has the following,

 

By default, SQL Express is installed with limited or no network connectivity.

SIMS is a Client Server Application, so most users will need to enable

network connectivity.

For those who have installed SQL 2012 products themselves, the following

tasks need to be completed to enable suitable connectivity:

SQL Server must be configured for local and remote connections

(TCP/IP or TCP/IP and Named Pipes)

 

If SQL Express is installed with limited or no network connectivity, how do I enable this? Or is this simply saying that the server needs to be networked.

[Steve21]

It's the actual settings in the SQL configuration manager etc. Remote access is disabled by default on new installations.

 

Steve

[edutech4schools]

It's the actual settings in the SQL configuration manager etc. Remote access is disabled by default on new installations.

 

Thanks @Steve21

 

I have opened SQL Configuaratiion manager and enabled TCP and named pipes but have also noticed that the SQL Server Agent (SQL2012) is stopped. Should this be started?

[Steve21]

Browser Yes, Agent No. Unless you're disabling the dynamic ports and setting static etc.

 

Agent is just for automation/reports etc (So you may need it depending on what you're doing etc). Browser is for connectivity to clients.

 

Steve

[edutech4schools]

Thanks. Going to start the migration at 10:30. Fingers crossed.