Questions tagged [sql-server-express]

Question 1

I am in a project to harden our Windows 2019 Servers, one of which runs IIS and MS SQL Express 2022. I am attempting to create a new Audit in MS SQL Server Express 2022 (via SSMS). For security ...

Question 2

I just setup a SQL Server Express instance a Windows PC, added a couple SQL user logins, a database, a linked database, and a stored procedure. I can login via SSMS (on the same computer) with the SQL ...

Question 3

I have a Server Server 2008 R2 instance. I need to upgrade to SQL Server 2016 temporarily until an infrastructure upgrade to newer hardware and newer software. I try to upgrade to SQL Server 2016 ...

Question 4

Yes in Management studio I am trying to restore a backup from another server. So I am doing the following: This is a fresh install of SQL Server 2017 express Right Click on the Databases Folder and ...

Question 5

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 ...

Question 6

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 ...

Question 7

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 ...

Question 8

The following error is displayed when attempting to delete a row from within SSMS: string or binary data would be truncated This is well documented and I understand what might cause this. In this ...

Question 9

Have a single server site, running Windows 2012 R2 They had a long power cut, and the server uncleanly shut down when the UPS gave out. We had a few other programs and database issues, but I've ...

Question 10

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 ...

Question 11

I have been trying to install SQL Server Express for a few days now. I tried 2008, 2012, and now 2014 all with the same result. I cannot connect to the database remotely, even if I turn the firewall ...

Question 12

I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : ...

Question 13

I have installed SQL Server Express 2008 R2 on a Windows 7 virtual machine - this virtual machine is hosted on another PC on our network. I would like to connect to the server using SQL Server ...

Question 14

I'm trying to connect to my MS SQL SERVER Express 2012 database, which lives on my remote server. Everything is set up and configured correctly other than the Firewall. This is the first time I've ...

Question 15

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 ...

Question 16

As the title states, can a databse created in MS SQL Server Express be exported to MS SQL standard? For the inent of the question, the version in question is 2008.

Question 17

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 ...

Question 18

I'm doing research on the best suitable database for an in-house web application for our (non-IT) company. It's a web information system with few database-heavy tasks. Users can add new customer ...

Question 19

We have a client that would like to use SQL Server Express with SharePoint instead of forking out a minimum or $7000 for SQL Standard. I know SQL Standard is the best option here, but the price tag is ...

Question 20

I need to upgrade an instance of SQL Server 2012 Express Edition (SP1) to Service Pack 2. Can the standard Service Pack 2 package be applied to an Express Edition instance, or do I need to run the ...

Question 21

I am attempting to copy a database from a remote server (sql server 2008) to my local machine (running sql server express 2014). Everything looks great, right up until the job fails at "Execute SQL ...

Question 22

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...

Question 23

I have an ASP.NET MVC web application deployed to IIS on a Windows Server 2012 machine. When the application first starts, it will create the database and tables it needs if necessary. This all ...

Question 24

When running SQLEXPRADV_x64_ENU.exe directly SQL Installation Center shows up and I can install SQLEXPRESS just fine. I want to perform automatic command line install so I have done the ...

Question 25

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 ...

Question 26

I have an application running on SQL Express SQL 9.0. Are there any known problems installing a Development Edition of MS SQL Server 2008 R2 along side SQL Express? In other words, is there a known ...

Question 27

My question is will SQLEXPRESS work in both SQL and Windows authentication modes? I believe the answer is no, but I am not sure. We have a commercial application that will only work with SQL ...

Question 28

At our company we are using a proprietary third party custom application that uses SQL Server Express as its backend. As you are aware SQL Server Express 2008 has a hard 10GB limit. For the “old” data ...

Question 29

I've setup a virtual development machine with Windows Web Server 2008 R2 and installed SQL Server 2008 R2 Express on it as well. I didn't install any SQL tools on it, because I have them on the host ...

Question 30

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 - ...

Question 31

Possible Duplicate: Can you help me with my software licensing question? If my database is larger than 10GB and I'm using it in READ_ONLY mode, will I be violating the licensing agreement somehow? ...

Question 32

I tried upgrading SQL Server Express 2008 to SP1, but the Setup was very far from clear. I ended up with 2 database engines. I now want to install Management Studio Express, but it apparently means I ...

Question 33

I had installed trial version of SQL 2008 R2 on my machine with win 7 as OS. Today I uninstalled it since trial expired then I tried to install SQL 2008 express edition with Advanced services but I ...

Question 34

I'm trying to connect to my SQL Server express instance from my ASP.NET web application but it doesn't work. The generic error message given to the application is: Cannot open database 'xxx' ...

Question 35

We have had a consultant set up a sharepoint 2010 server for us to use for document management. I believe it is just on the basic (free) sharepoint that comes with windows server. From what I ...

Question 36

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 ...

Question 37

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 ...

Question 38

I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions ...

Question 39

We are using DPM 2010 to backup our Hyper-V cluster however we require an client/agent and server SQL backup app for all of our Windows VMs, as to purchase an Enterprise DPM licence for each VM is to ...

Question 40

I am curios whether having two or more of these instances on the same machine help using more RAM and more (logical) CPUs. By default an instance of SQL Server Express would only use 1 GB of RAM and ...

Question 41

I am expecting to have a long backup on a certain database and I was wondering if the application can access (read only? read/write?) it while it is being backed up. If read/write access would be ...

Question 42

I have an installed version of SQL Server Express 2008 but it does not have the full-text service. Short of uninstalling and re-installing the Advanced Services version, what is the easiest way to add ...

Question 43

Sql Server Express has the following major hardware limitations that has a consequence on performance: 1 CPU 1GB of memory My question is: if on a multicore machine many instances of sql server ...

Question 44

I'm stumped. I have a client site on a virtual private server - Windows Web Server 2008 SP2, IIS7, SQL Server 2008 Express. I'm trying to setup a second web application, to allow him to review ...

Question 45

Today I was told that the version of Windows XP for the UK is not the same as the one used in the US. Is this true? And if so, is there somewhere where I can learn the differences? Are SQL Server 2005 ...

Question 46

I have managed (in 'eksperiments') to remove both my Windows users from my SQL Express instance. I am now logged in as windows admin, and have re-created the corresponding SQL login, but I cannot ...

Question 47

I've previously in my setup installed SQL Server Express 2005. Now I've switched to SQL Server Express 2008. I updated the command line parameters to those documented for the latter. If the comp ...

Question 48

I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the ...

Question 49

I'm running a SQL EXPRESS 2005 server currently hosting ~50 databases. The databases serve clients' CMS/eCommerce websites. The connections are to a single instance, no user attached instances are ...

Question 50

.ldf file is corrupted so I need to completely rebuild master database on a SQL Express 2008 installation. Is there anything short of destroying the instance completely and starting over?