A free version of SQL Server

learn more… | top users | synonyms

2
votes
1answer
28 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 ...
-1
votes
1answer
63 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 ...
1
vote
1answer
405 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 ...
0
votes
1answer
255 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 ...
1
vote
1answer
40 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, ...
0
votes
1answer
623 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 ...
1
vote
1answer
552 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 ...
0
votes
0answers
64 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 ...
1
vote
1answer
116 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 ...
0
votes
2answers
1k 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 ...
0
votes
2answers
823 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 ...
2
votes
1answer
2k 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 ...
0
votes
4answers
741 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 - ...
2
votes
1answer
303 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 ...
1
vote
2answers
8k 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 ...
1
vote
1answer
491 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 ...
0
votes
1answer
126 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' ...
0
votes
3answers
3k 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 ...
0
votes
1answer
128 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 ...
0
votes
1answer
590 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 ...
1
vote
1answer
508 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 ...
0
votes
1answer
74 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 ...
0
votes
1answer
178 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 ...
2
votes
1answer
275 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 ...
1
vote
1answer
592 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 ...
0
votes
2answers
4k views

SQL Server Express 2008 R2 fails on silent install /q or /qs . Windows 7 32 bit and 64 bit

I have a little problem. I can't get SQL Server Express installed within my application in windows 7 32 and 64 bit version. It gets installed correctly in windows XP. And it gets installed ...
0
votes
1answer
255 views

What is the problem with SQL Server 2005 Express?

I've eveloped and application using C# and Sql Server 2005 Express. I try to run the application on other computers. I install .Net everything's ok, when I try to install SQLEXPRESS three cases ...
3
votes
1answer
1k 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 ...
1
vote
2answers
431 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 ...
1
vote
2answers
123 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 ...
2
votes
3answers
5k 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 ...
1
vote
2answers
1k 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 ...
0
votes
2answers
3k 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 ...
2
votes
4answers
7k 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 ...
2
votes
4answers
3k 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?