Some tips for using ASP.NET with SQL Server 2017 If you use ADO to access SQL Server data in your ASP.NET, always create a Connection object explicitly, not implicitly. This can reduce the server overhead and simplify the controlling of a connection. Set the MultipleActiveResultSets (MARS) option in the SQL Server connection string. This option makes it possible to execute...
Tag: IIS
Troubleshooting SQL Server 2016 installation
Troubleshooting SQL Server 2016 installation If you have problems with SQL Server 2016 installation, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To install SQL Server 2016, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster recommended – Memory...