Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server-express]

For questions about Microsoft SQL Server Express (except Express LocalDB).

1
vote
1answer
41 views

What is using all my space?

I'm using SQL Server Express 2008 R2 and a third part application has its database on this database server. The database seems way bigger than I would expect considering what it is actually doing. ...
1
vote
1answer
64 views

Reviewing the design of a database about animals of two distinct species

I am creating a small database using SQL Server Express 2017. There are two animals (Foxes and Elephants). The Foxes table will have the columns: Identifier, Species, BodyLength, and FurColour. The ...
3
votes
1answer
191 views

Messages about parallel redo

Parallel redo is shutdown for database '' with worker pool size [2]. Parallel redo is started for database '' with worker pool size [2]. Starting up database '' I see this on a client PC a lot in ...
0
votes
0answers
52 views

SQL Server Express 2017 database size limitation

I have a database hosted on SQL Server Express 2017. The size was small like 200MB. Today I have copied 24GB tables to the same database from external database hosted on different server. The ...
0
votes
0answers
33 views

SQL Server query extremely slow. It fixes itself after rebooting [duplicate]

I have an SQL Server instance running on AWS RDS that is performing badly. A query that usually takes milliseconds to run, is taking minutes, causing my application to time out. This particular query ...
0
votes
0answers
18 views

Differences between Visual Studio Data Source vs External Database outside of Visual Studio

I've worked with many databases outside of visual studio. When I find myself working in Visual Studio having to work with either Oracle Express, SQLite or MS SQL Express - I have never used the ...
2
votes
1answer
42 views

Is there an Express version of Azure SQL DB?

With on-premise SQL Server, there are editions such as Express, Web, Standard, and Enterprise. Do those editions (or an analog) exist in Azure SQL DB, especially Express? My Google-Fu is failing ...
1
vote
1answer
89 views

Connecting to SQL Express Server 2017 with SQL Server Authentication Remotely

I have two systems that are on the same network. I am able to ping back and forth between these systems with their IP address and with their system names. I have enabled the TCP port 1433 inbound and ...
0
votes
1answer
187 views

How to trace security_error_ring_buffer_recorded errors in SQL Server 2014 Express

Just so everyone doesn't have a high expectation of my level of knowledge on this topic, I'm not a DBA; I'm a .NET developer who has to try and figure this out by virtue of being "the one most likely ...
0
votes
0answers
34 views

Database Mail on SQL Server Express 2017 [duplicate]

I followed this article to create a database mail for SQL Server Express 2017. I got it working but before that I had tried to create accounts and different profiles. How I do I list all database ...
-1
votes
2answers
76 views

SQL Server Express 2017 Database Mail Silent error

I have made an installation of a development environment in VMWare that contains: Windows Server 2016 SQL Server Express 2017 The objective is to perform migration tests of a base that is currently ...
1
vote
2answers
166 views

Shrinking a SQL Server 2008 Standard database to move it into SQL Server 2014 Express

I need to shrink a popular CRM database with SSMS to move it onto a new server. I am going from SQL Server 2008 Standard to SQL Server 2014 Express. Database is in Simple Recovery Model. It needs to ...
-1
votes
2answers
48 views

What permissions should be added to public users sql [closed]

I have a SQL Server and am looking at making it public. What I mean by this is: I can create a DB and give access to myself and friends etc. I need to create a login which can only view databases it ...
1
vote
1answer
912 views

Maximum concurrent connections to SQL Server Express 2017 installed on Windows Server 2016 Essentials

If I install SQL Server Express 2017 on Windows Server 2016 Essentials, what is the maximum number of users that will be able to connect concurrently across the network to the SQL Server Express ...
0
votes
2answers
56 views

backup the difference with sql server express between 2 timestamps

I am newbie to sql and have sql server express edition installed on my PC and contains a database 'Jdatabase' on 1sept and took a backup(by right clicking on database -> tasks->backup using 'sql ...
1
vote
1answer
31 views

One instance, four clients, one is slow

We have a small office setup with one Windows Server 2012 running SQL Server 2016 Express. The database is hosting files for our accountant software. This is a multi module software that runs ...
1
vote
1answer
43 views

SSRS 2016 on SQL Server 2014

I have question about using SSRS 2016 on SQL server 2014 First of all, I don't have much experience with Reporting services. Company use SQL server 2014 and they have SQL database on it (DB is ...
3
votes
1answer
683 views

SQL Server 2016 Linked Server OPENQUERY Hangs

I've been trying to figure out this linked server problem for about a week now with no luck. The set up I have is a linked server from an instance of SQL SERVER 2016 to an instance of SQL SERVER 2016 ...
0
votes
1answer
85 views

SQL Maintenance script not running with SQL Server Express

Hello and thank you for making such a well-designed script available to the public. I have client with some heavy db fragmentation and performance issues. I would like to use your scripts to help ...
1
vote
3answers
2k views

Couldn't find sql server agent in Sql Server 2014 Management Studio?

Is there any way to add it in SQL Server Express edition?
5
votes
2answers
337 views

Enabling admin connection on SQL Server Express to fix logon trigger

Well, luckily I got this error on my test environment. I'm so scared about this error that I disabled all logon triggers I was using on production environment. I created the famous logon trigger, ...
3
votes
1answer
3k views

SQL Server Express Instance Memory vs Memory Limit

SQL Server 2014 express edition is published as having a memory limit of 1 GB. What do the SQL Instance Memory Properties do with respect to this limit? For example, I can set the minimum and maximum ...
4
votes
2answers
677 views

Replicate single table from SQL Express to SQL Enterprise 2014

We have a small branch app that stores some data in a SQL Express Database. We want to have an almost real time copy of this table in our headquarters, were we have SQL Enterprise 2014. I say almost, ...
0
votes
1answer
28 views

Define relationships for 3 tables

I have 3 tables that are currently defined as: Is this the best way, or should I use an associative table? I put the relationships backwards, 1 group can contain many users and many students. There ...
0
votes
0answers
740 views

NLShimImpersonate Error 5023 - SQL Server Express - AWS RDS

I'm seeing a ton of these security_error_ring_buffer_recorded, error 5023, events in my AWS RDS SqlExpress instance. I noticed this while trying to investigate timeout errors I started getting in my ....
0
votes
1answer
363 views

SQL Express 2014 Installation Fails with SSL Error

I've got a user that wants to install SQL Server Express 2014 on his Windows 10 laptop. The default installation fails: 2017-11-13 13:39:31.31 Server Microsoft SQL Server 2014 - 12.0.2000.8 (X64)...
3
votes
2answers
2k views

Why is SQL Server Express creating twenty users on my system?

I was taking a look into Computer Management->Users and found that SQL Server Express has created a lot of users for me. Why? Is my system infected? The descriptions all say, "Local user account for ...
2
votes
1answer
187 views

MDF Backup: “Login failed” Error

I'm creating a VC# application using Visual Studio. On startup, it opens a MDF file (SQL Server Express database). When I execute BACKUP DATABASE db.mdf TO DISK=backup.mdf I get the backup.mdf ...
5
votes
3answers
8k views

SQL Server Express 2012 Database Size Limit

I checked the forum there are other similar topics but my scenario is different. for myDatabase under database properties -> General tab it shows: Size : 25285.31 MB Space Available: 3989.13 MB And ...
2
votes
2answers
55 views

how to perform regular backups of SQL Express 2008 R2 databases [closed]

Which instruments to choose to implement backup strategy on 150 servers with SQL Servers Express Edition 2008 R2? The strategy should also include checkdb, index and statistics maintenance. In case of ...
0
votes
1answer
557 views

Updating SQL table from Excel sheet (using powershell)

I am using the below code to complete a bulk import into SQL, but I think I have run into a problem with my method. $serverName = "pjim-app-02\tsg"; $databaseName = "User_Data" ; $tableName = "dbo....
1
vote
1answer
2k views

SQL Server Import Wizard Excel into SQL Server 2016 Error 0xc020901c

I am trying to import an Excel file with 3914 rows of data into an existing table on SQL Server 2016 Express through the SQL Server Management Studio. I imported a similar file last month, but this is ...
3
votes
1answer
34 views

New database not using the model configuration

On a SQL Server 2008 R2 Express instance, I have the "auto Close" option set to "False" on the [model] database. However, When I execute CREATE DATABASE [test];, SQL Server creates the database with ...
4
votes
4answers
956 views

Can't create a server role using GUI in SQL Server 2014 Express [duplicate]

I am still new to DBA and learning. I am having an issue when creating a Server Role using GUI. The option to create the server role does not seem to be visible in the Menu But when I create a role ...
1
vote
1answer
2k views

SQL Server Express support for TLS1.2

I have installed SQL Server 2014 Express Edition ( 12.0.2000.8 x64 ) on a Windows server 2012 machine. Because of the POODLE vulnerability, our IT department is going to disable TLS 1.0 and all ...
1
vote
2answers
369 views

SQL Managment doesn't use all memory, queries fail due insufficiënt memory

In Microsoft SQL Server Management Studio 12.0.4100.1 I have a table with about 12.600.000 records. If I try to show the TOP 1000 of these records with an ORDER BY [bigint column], the query runs for ...
2
votes
2answers
3k views

Express edition core limits ambiguity

We have an application that uses MSSync to download data from a server into a client's SQL Server Express 2005. The client's have a dual core with hyperthreading so, a total result of 4 cores. I have ...
1
vote
1answer
94 views

microsoft sql express 2012 authentication connection issues - can't login

I am a novice when it comes to Windows networking authentication, as well as just getting my feet wet with SQL Express, so please bear with me, hopefully this is a simple fix but so far the obvious ...
5
votes
2answers
434 views

Optimizing SQL Server for an app that repeatedly hits the database with the exact same query?

I am dealing with performance issues with a Windows app that uses SQL Server Express (2014) on the back-end. I have managed to get this running a lot better primarily by reviewing the indexing SQL ...
1
vote
1answer
487 views

What determines the maximum number of concurrent connection to SQL Server 2016 Express

After some googling, there seems to not have a straight forward answer to the question. MSDN Forum mentions it depends on CPU, Memory usage, database size etc. Could someone help explain or perhaps ...
1
vote
1answer
398 views

Is it possible to set up ADSI linked server in SQL Server Express?

Is there any limitation in SQL Server Express that prevents you from creating a linked server to Active Directory? (I don't have an AD environment available to test.)
8
votes
2answers
7k views

SQL Server 2016 high idle CPU and queries extremly slow

I have a ~10 day old installation of WinServer2012R2 and SQL Server Express 2016 for testing. I am the only user on this machine. A database with a .bak from SQL Server 2005 of ~250MB is restored ...
0
votes
2answers
443 views

A way to syncronize data in sql express

I have 2 servers, one with SQL standard and the second one is express. I wanted to know if there is any tool or any way to synchronized the databases and making it work like replication without the ...
3
votes
3answers
5k views

SQL Server mdf file too large

I have a .mdf file that is 10gb. This is the max file size. How can I reduce the file size? I do not need the data, I just need to be able to write new data to the database. I have deleted a ton of ...
1
vote
2answers
3k views

How to enable odbc connnections in new sql server setup? [closed]

Fresh server 2012 R2 Essentials install, trying to get SQL Server Express to accept ODBC connections. My database is setup and I have all of my data populated, but now I am trying to get my reporting ...
1
vote
0answers
40 views

Installing SQL Server Express from SQL Server Developer Installer

If I install SQL Server 2012 Express using the SQL Server 2012 developer installer, do I still have access to all features available from the Advanced Services and/or With Tools versions of SQL Server ...
0
votes
3answers
622 views

Why does my hard-drive fill up when executing a query?

I have a very complex SQL query that I execute in SQL Server Management Studio. As the query is running, I notice that my harddisk is filling up, until the point it's completely full (I'm talking a 10+...
7
votes
1answer
3k views

Why are duplicate permissions appearing on the securables GUI in SSMS?

Why are duplicate permissions appearing on the Securables GUI?
4
votes
1answer
145 views

New SQL Server from backup; application has successful login on 1 database, but fails on another: 0x80040e4d

Our SQL Server crashed and burned, the hard drives destroyed. No hope of recovery. We need to get a very important application working again; this is on a different server. We've set up a new SQL ...
0
votes
1answer
695 views

What are the minimum requirements for running a dtsx package on a PC?

One of my clients has some very specific needs to get a spreadsheet run through some ETL processes I have created. I have developed an SSIS .dtsx package which imports an Excel spreadsheet into SQL ...