Questions tagged [sql-server-express]

A free version of SQL Server

Filter by
Sorted by
Tagged with
0 votes
1 answer
3k views

Microsoft SQL Server Mangement Studio gives error when trying to add device for restoring backup

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 ...
DecoArt's user avatar
-1 votes
1 answer
83 views

Is it possible to give windows 10 access to a sql server hosted on windows server 2016?

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 ...
Server Fault's user avatar
0 votes
1 answer
883 views

Is it possible for a group policy to interfere with a Sql Server Express installation?

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 ...
jdege's user avatar
  • 193
0 votes
1 answer
3k views

Configuring Imported Self Signed SSL Certificate to SQL Server Express

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 ...
McCann46's user avatar
3 votes
2 answers
9k views

WSUS corrupted: Can't uninstall, repair, or remove (Error 0x800f0831)

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 ...
Dave's user avatar
  • 427
0 votes
1 answer
60 views

sqlexpress 2008 connection error 40 when connecting through internet static ip

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 ...
Nour Medical's user avatar
0 votes
3 answers
2k views

SQL Server Named Pipe Error

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 ...
deflator's user avatar
1 vote
2 answers
2k views

SQL Server express - Management studio installation hangs at native images installation

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 : ...
JayaprakashReddy's user avatar
1 vote
2 answers
10k views

Cannot connect to SQL Server from local machine to virtual machine hosted on another PC

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 ...
jmc's user avatar
  • 121
1 vote
1 answer
7k views

MS SQL Server Error 26 - Cannot connect

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 ...
MyDaftQuestions's user avatar
-1 votes
2 answers
2k views

MSSQL 2008 r2 Express: there is insufficient system memory in resource pool 'internal' to run this query

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 ...
shadowsheep's user avatar
0 votes
1 answer
459 views

Can a database created in MS SQL Server Express be exported to MS SQL standard?

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.
Chad Harrison's user avatar
-1 votes
1 answer
773 views

IIS Server hanging at 350 requests per minute

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 ...
Randir 's user avatar
2 votes
1 answer
135 views

Will SQL Server Express do in this specific situation

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 ...
user avatar
0 votes
2 answers
2k views

SQL Server Express and SharePoint

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 ...
skinneejoe's user avatar
1 vote
1 answer
3k views

Can SQL server 2012 Service Pack 2 be applied to an Express Edition instance?

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 ...
Massimo's user avatar
  • 71.3k
0 votes
1 answer
1k views

Database Copy Fails, but nothing fishy in the logs

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 ...
drewwyatt's user avatar
  • 113
1 vote
1 answer
111 views

Why does SSMS Restore Database to another database not copy the current state of the "From" database?

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, ...
Joel Peltonen's user avatar
0 votes
1 answer
3k views

How can I view the SQL Server database created by an ASP.NET MVC web application?

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 ...
Eric Levine's user avatar
2 votes
1 answer
2k views

SQL Command Line Setup Failing

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 ...
Petar Vučetin's user avatar
0 votes
0 answers
799 views

Identical tables, different sizes?

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 ...
happydba's user avatar
1 vote
1 answer
167 views

Are there any known problems installing Development Edition MS SQL Server Aside SQLEXPRESS

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 ...
octopusgrabbus's user avatar
0 votes
2 answers
6k views

Can SQLEXPRESS Authenticate using both SQL And Windows Authentication?

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 ...
octopusgrabbus's user avatar
0 votes
2 answers
2k views

MSSQL Server Express: How to reclaim unused space

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 ...
Paul Jones's user avatar
3 votes
1 answer
10k views

Connecting to SQL server instance on VM via host-only network

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 ...
Robert Koritnik's user avatar
0 votes
4 answers
1k views

SQL Server 2008 R2 Express and VMware

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 - ...
Ian P's user avatar
  • 103
2 votes
1 answer
1k views

Exceeding the DB size limit on SQL Server Express in READ_ONLY [duplicate]

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?...
Robin's user avatar
  • 173
1 vote
2 answers
17k views

SQL Server 2008 Express: How do you remove a Database Engine instance?

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 ...
Aximili's user avatar
  • 113
1 vote
1 answer
2k views

SQL server 2008 installation error

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 ...
Pramodtech's user avatar
0 votes
1 answer
243 views

Connect to SQL Server from web application doesn't work?

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' ...
Ropstah's user avatar
  • 205
0 votes
3 answers
4k views

How to get the most out of sharepoint 2010 with sql express database size limit?

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 ...
Adam Butler's user avatar
0 votes
1 answer
155 views

SQL Server Express 2008 R2 with old Management Studio?

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 ...
Nicholas's user avatar
  • 245
0 votes
1 answer
906 views

How To Simulate Publication Replication In SQL 2005 Express?

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 ...
Peter M's user avatar
  • 1,036
1 vote
1 answer
669 views

Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL

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 ...
eyston's user avatar
  • 123
0 votes
2 answers
118 views

SQL Server backup app

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 ...
Adam Chetnik's user avatar
0 votes
1 answer
310 views

Will two or more instances of SQL Server Express help on the same machine?

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 ...
Andrei Rînea's user avatar
2 votes
1 answer
375 views

Is an SQL Server (Express 2008 R2) database operational during backup? How about consistency?

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 ...
Andrei Rînea's user avatar
1 vote
1 answer
2k views

How to add full text feature to already installed SQL Server Express 2008

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 ...
user35042's user avatar
  • 2,711
4 votes
1 answer
2k views

Many instances of sql express use all the same cpu?

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 ...
user193655's user avatar
1 vote
2 answers
763 views

IIS7 application using wrong SQL Server 2008 Express database

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 ...
Remi Despres-Smyth's user avatar
1 vote
2 answers
208 views

Compatibility of SQL Server 2005 / 2008 and Windows XP UK Edition

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 ...
8kb's user avatar
  • 183
2 votes
3 answers
14k views

Add the current admin user to SQL Server Express 2008

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 ...
ProfK's user avatar
  • 493
1 vote
2 answers
3k views

Installing a new SQL Server instance fails

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 ...
user avatar
1 vote
2 answers
15k views

How do you find the name of an existing full text catalog in SQL Server 2008 Express?

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 ...
Kyle Noland's user avatar
  • 1,039
3 votes
4 answers
21k views

How many databases can SQL server express handle

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 ...
felixg's user avatar
  • 173
2 votes
4 answers
4k views

Rebuild master in SQL Express 2008

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