Stack Exchange Network

Stack Exchange network consists of 174 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).

0
votes
1answer
28 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
31 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
58 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
153 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
46 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 ...
0
votes
1answer
258 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
52 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
0answers
23 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
33 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
349 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
0answers
37 views

SQL Maintenance script not running in command prompt

I have successfully executed the MainetenanceSolution.sql in SQL Server Management studio 2012. But when I am trying execute the following script in command prompt (as administrator) sqlcmd -M -E -S ...
0
votes
1answer
73 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
974 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?
4
votes
2answers
253 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
2k 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
523 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
24 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
551 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
277 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
1k 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
165 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 ...
4
votes
3answers
6k 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
47 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
484 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
1k 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
32 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
821 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
1k 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
338 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 ...
3
votes
2answers
2k 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
85 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
389 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
462 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
332 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.)
7
votes
2answers
6k 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
408 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
4k 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
39 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
576 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+...
6
votes
1answer
2k views

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

Why are duplicate permissions appearing on the Securables GUI?
4
votes
1answer
136 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
631 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 ...
1
vote
1answer
1k views

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some ...
2
votes
1answer
3k views

Automate backup using Windows Task Scheduler

I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler. I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a ...
1
vote
3answers
7k views

Cannot install database engine services, replication and SQL writer

I am trying to install SQL Server 2012 Express, but I get this error (I try to uninstall and delete registry key, try to change account for database engine to NT Authority\System, but reinstall still ...
1
vote
1answer
440 views

Failed to attach SQL Express DB, Could not continue scan with NOLOCK

We have a remote client that had to rebuild their server and has been having trouble with their SQL Express database since. I cannot remotely connect to this client unfortunately. I had them run "DBCC ...
3
votes
3answers
1k views

Install Express/Standard side-by-side

I've reviewed these two existing questions: Install SQL Server 2008 Express on same machine as normal SQL Server 2008 install? Installing SQL Server Express in parallel of Standard ...and I believe ...
4
votes
1answer
358 views

Permission error when executing a 5.6 GB sqlcmd file

I am trying to run a very large file through the sqlcmd command and it works perfectly with files of 100 MB up to 1.4 GB. This is what I have tested so far, but when I try to run a file which is 5.6 ...
1
vote
2answers
89 views

Monitor executed SQL statements from external application [duplicate]

I have an external application connecting to a SQL Server 2008 Express database. Is it possible to monitor (view) the SQL statements that are generated by the external application at all? I am trying ...