Questions tagged [sql-server-express]
A free version of SQL Server
46
questions
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 ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 : ...
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 ...
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 ...
-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 ...
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.
-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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 - ...
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?...
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 ...
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 ...
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' ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?