I have a website that continuously hangs at 350 – 380 page requests per minute. It is a c# .NET 4 website running on a 2008 R2 server running iis 7 and SQL Server Express. It ultilises EF, version that came with .NET 4. I have compiled most of the queries. I generally have to … Read more
Is it possible to give windows 10 access to a SQL server hosted on windows server 2016? I have found resources for setting up a domain for my computers using a windows server. The windows server will host an instance of SQL Server Express. I have Windows computers that will need access to the SQL … Read more
I’m experiencing this error during the lifecycle of my DotNetNuke Installation. I’ve change the hosting server and now I’ve got a Windows Server 2012 with IIS 8 an SQL server 2008 r2 Express running on the same machine: 64bit, 12GB di RAM. The site works perfectly for 4 or 5 hours until when, randomly, start … Read more
I have a client that has several geographically dispersed installations of a 3rd party commercial product that logs data to their own instances of an SQL Express database (GE’s CIMPLICITY HMI if you are interested). He now wants to collect the logging data to central DB for long term storage (IE the local installations will … Read more
On the same machine with SQL Server 2008 R2 Express installed, can the last stand-alone version of the Management Studio be installed? That would be SQL Server 2008 Management Tools. Or does it have to be the latest version that comes with the R2 installer? Answer You can install the old management console side by … Read more
We have used SQL Server Express – various versions without issue. However we have an install on a VMware machine and there are severe performance issues. I have contacted VMware and Microsoft – Microsoft don’t explicitly support Express as its a free version. The problem is that as the database get larger, the performance gap … Read more
I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to discover that my database has outgrown the 10GB limit for Express. My current subscribers are under the 10GB limit, however the publishing database is 13GB. … Read more
I installed SQL Server 2008 on a workstation running windows 7 SP1. I am trying to connect to the server through the internet using a static IP address and port 1433. I can connect with this IP address on the same working station through the server management studio. However, when I try connection with a … Read more
I’ve created a self-signed certificate and configured with SQL Server Express. The encryption works fine on my PC. When I export the certificate to another PC I can import fine and can see the certificate in MMC under Personal > Certificates. However when I try to configure with SQL Server Express on the new PC, … Read more
We have a software package that our customers install on their user’s laptops. Part of the installer runs MS’s Sql Server Express 2014. We’re passing the command-line options to to the installer that are supposed to enable the SA login, and to grant sqladmin rights to the Windows BUILTIN\Administrators group. The installer command line we … Read more
