[sims] cant login to Sims from client after migration to SQL2012. PLEASE HELP

[edutech4schools]

I have just completed a migration from SQL2008 (FULL) to SQL2012(Express) using the CAPITA migration tool.

 

I have tested Sims and FMS on the server and all works OK but when I try to login into Sims (Not tried FMS) from a client I get a login error reason 0.

 

All was OK from the clients prior to the migration.

 

I have checked the connect.ini file in C......Sims which has a redirect to S:\Sims and the actual connect.ini file in S:\Sims has server\sql2012

 

Please help.

Edited November 18, 2014 by edutech4schools

[Mcshammer_dj]

check your sql server has tcp and pipes enabled on the network section

[vikpaw]

Same server?

If not, make sure the ports are allowed through the firewall.

[edutech4schools]

check your sql server has tcp and pipes enabled on the network section

 

I think so, I was advised to open sql server config manager and find / enable tcp/ip and named pipes, which I have done.

 

Could it be that the SQL Browser service is loged in as a local service but all the other SQL services are logged in as local system??

 

- - - Updated - - -

 

Same server?

Yes, same server

[Mcshammer_dj]

Have you restarted the services

[jinnantonnixx]

Is DNS pointing to the correct (new) server?

 

 

Also check your server is configured to receive connections over the network.

"Surface Area Configuration" is often overlooked, as typically it's only ever looked at once, then forgotten about.

 

http://mssqlfun.com/2012/09/14/surface-area-configuration-tool-available-in-sql-server-2008-onwards/

Edited November 18, 2014 by jinnantonnixx

[edutech4schools]

Have you restarted the services

 

That seems to have done the trick.

 

Thanks given to all for a speedy fix.

[vikpaw]

reboot the server ..?