Answered by:
Install Sql Server 2012 Standard on Windows 7 SP1 Professional 32 bit

-
Hi,
I have a deployment scenario which I would like to validate with the knowledgeable before I attempt the configuration.
1. I have Windows Server 2012 R2 Essentials machine on which we have a intranet website hosted in IIS.
2. I have a SQL Server 2012 Standard installed on a machine with Windows 7 Sp1.
The web site needs to access the Sql Server database. Do you see any issues with the above configuration?.
Thanks,
Ravi.
Ravi
Question
Answers
-
Hello,
Yes, there are issues with Windows 7. Windows 7 will allow only 10 concurrent connections from the IIS server. That is by design.
Is that OK with your Web application?
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
- Edited by Alberto MorilloMVP, Moderator Tuesday, April 08, 2014 6:34 PM
- Marked as answer by tracycaiMicrosoft contingent staff, Moderator Tuesday, April 22, 2014 3:23 AM
-
Adding to Alberto hosting your standard database on client operating system is not a good idea.Its not robust as compared to Server ( windows server OS family).
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Marked as answer by tracycaiMicrosoft contingent staff, Moderator Tuesday, April 22, 2014 3:23 AM
All replies
-
Hello,
Yes, there are issues with Windows 7. Windows 7 will allow only 10 concurrent connections from the IIS server. That is by design.
Is that OK with your Web application?
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
- Edited by Alberto MorilloMVP, Moderator Tuesday, April 08, 2014 6:34 PM
- Marked as answer by tracycaiMicrosoft contingent staff, Moderator Tuesday, April 22, 2014 3:23 AM
-
Adding to Alberto hosting your standard database on client operating system is not a good idea.Its not robust as compared to Server ( windows server OS family).
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Marked as answer by tracycaiMicrosoft contingent staff, Moderator Tuesday, April 22, 2014 3:23 AM