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).

-1
votes
2answers
44 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
63 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
49 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
21 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
32 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
225 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
36 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
71 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
722 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
216 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
462 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
23 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
466 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
229 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
145 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
5k 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
45 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
447 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
31 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
758 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
308 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
77 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
375 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
450 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
313 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
387 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 ...
2
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
2k 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
541 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+...
5
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
132 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
602 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
6k 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
0answers
122 views

SQL Server 2012 Express and Hardware Differences affecting performance [closed]

Here is the setup. I'm running SQL Server 2012 Express on the following two boxes: Box 1 (Server) : Dell T710 2x X5680 3.33Ghz Xeon 92GB Memory RAID 10 - 146GB Dell drives, w/ Cachecade SSD drive on ...
1
vote
1answer
402 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
354 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
87 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 ...
6
votes
1answer
11k views

How many users are supported on SQL Server 2012 Express?

I would like to say that i have gone through some of the sql blog and MSDN BOL, but still there is some confusion in mind like. The limitation of SQL Server 2012 Express is 10 GB. It is the ...
7
votes
2answers
22k views

Differences between the different installers of SQL Server 2014 Express

I'm trying to understand the differences between the different installers of SQL Server 2014 Express. If you are able to tell me whatever you can or find documentation on them, I'd appreciate it. ...
5
votes
1answer
874 views

How to create a server instance of just ComputerName instead of ComputerName\SQLEXPRESS

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014. I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that ...