All was good as for accessing through both Management Studios but I struggled to get the web applications to connect to the 2012 databases.
These are all probably standard SQLServer Gotchas but they all got me.
Gotchas:
- In the config I created a user 'sa' but this was disabled by default.
- find the user, right click & go to properties
- click on 'Status' & select Enabled
- The database it self did not allow Sql Server authentication.
- Right click on the database server instance & select Properties
- click on Security
- Select the second option 'SQL Server & Windows Authentication'
- Port Configuration
- The default port for SQL server is 1433 so I needed to set up a different port for 2012
- Run up the 'SQL Server Configuration Manager'
- Inder the tab 'SQL Server Network Configuration' there will be two entries, one for the 2008 service & one for the 2012 service
- Select tge 2012 service
- select the TCP/IP protocal name & Right click & select Properties
- Select the 'IP Addresses' tab
- On mine the 'TCP Port' field was blank for all entries. I changed everyone to be 1533
No comments:
Post a Comment