Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-express]

A free version of SQL Server

SQL Server Express is the free version of SQL Server that allows you to store limited amounts of data (up to 10GB in SQL Server Express 2012, less in prior versions) per database. It can be installed with or without the management tools (SSMS).

There are several different download options available here

46 questions
0
votes
1 answer

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 Server Agent Job" with this message: TITLE: Copy…
drewwyatt
  • 113
  • 8
0
votes
1 answer

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 works fine, and now I want to do some administration…
Eric Levine
  • 103
  • 5
0
votes
0 answers

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 discover that my database has outgrown the 10GB…
happydba
  • 1
0
votes
2 answers

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 authentication. We already have a SQLEXPRESS 2008 server,…
octopusgrabbus
  • 175
  • 5
  • 20
0
votes
2 answers

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 in this database, we have a separate database…
Paul Jones
  • 1
  • 1
0
votes
4 answers

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 - Microsoft don't explicitly support Express as its a…
Ian P
  • 103
  • 6
0
votes
1 answer

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' requested by the login. The login failed. Login failed…
Ropstah
  • 205
  • 5
  • 11
0
votes
3 answers

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 understand this uses sql server express 2008r2 which has…
Adam Butler
  • 369
  • 3
  • 9
0
votes
1 answer

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 to be the latest version that comes with the R2…
Nicholas
  • 245
  • 1
  • 4
  • 12
0
votes
1 answer

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 are interested). He now wants to collect the…
Peter M
  • 996
  • 8
  • 19
0
votes
2 answers

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 expensive. Any good ones? (Its need to be able to…
Adam Chetnik
  • 542
  • 6
  • 19
0
votes
1 answer

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 1 cpu only. Having a machine with 4 cores and…
Andrei Rînea
  • 310
  • 5
  • 17
0
votes
1 answer

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 choose restore database. Then I click on Device…
DecoArt
  • 1
  • 2
-1
votes
2 answers

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 on the same machine: 64bit, 12GB di RAM. The site…
shadowsheep
  • 133
  • 1
  • 8
-1
votes
1 answer

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 that came with .NET 4. I have compiled most of the…
Randir
  • 1
  • 1
1 2
3
4