Questions tagged [sql-server-express]

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

Filter by
Sorted by
Tagged with
3
votes
2answers
15k views

How to install SQL Server Management Console in 2008 Express Version?

I started a dozen attempts to install the SQL Server Management Studio for the 2008 Express Version of SQL Server. What i use: Windows Vista 2007 SP 2 What i did: a) I downloaded the install file ...
3
votes
2answers
15k views

SQL Server Express 2014 Installation directory

I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked to select the installation folder of SQL Server. ...
3
votes
1answer
38 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 ...
3
votes
3answers
7k 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 ...
3
votes
2answers
6k views

Sync many client database to one central database

We have client application which can be installed on local machine where users can work offline and create projects in it. This application is already developed. Now we need to create Admin ...
3
votes
2answers
705 views

SQL Server Express Freezes for a couple minutes

I have SQL Server Express on an AWS micro instance. These instances have only 615MB of RAM. For the most part it performs fine. My application can make up to about 15 db connections. However, every ...
3
votes
1answer
114 views

linking databases for reporting

I am attempting to design a simple reporting feature for some financial market data. I have a few sets of data, and I am trying to figure out what will be the best way to organize the tables, in ...
3
votes
1answer
2k 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 ...
2
votes
2answers
171 views

Cannot find Database Mail feature in SQL Server Express 2012 SP1

I need to use SQL Server Database Mail feature in my project. However Database Mail seems not available on my development instance. There should be a 'Database Mail' node in the Object Explorer. In ...
2
votes
1answer
5k views

Could I realistically use SQL Server Express as a distributor database for transactional replication?

We have a group of users within my company that are running reports directly against our production database. It has gotten to the point where they are hammering it enough to cause performance issues ...
2
votes
2answers
251 views

‘PRIMARY’ filegroup is full. How do I increase temdb size in SQL Server Express 2017?

When I reindex a particular table DBCC DBREINDEX(@TableName, '',90) I get an error Level 17, State 2, Procedure aareindex, Line 21 [Batch Start Line 0] Could not allocate space for object ‘...
2
votes
1answer
229 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 ...
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 ...
2
votes
1answer
4k views

Install SQL Server Express without administration rights

Is there a way to install SQL Server Express without administration right? Is there a portable version? (I need to test SQL Server on my computer before using the server but I don't have ...
2
votes
1answer
103 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 ...
2
votes
3answers
5k views

After I replaced master mdf/ldf files, can no longer log in

Today I couldn't start SQL Server process anymore. Reason: The log scan number (213:18:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the ...
2
votes
3answers
10k 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 : ...
2
votes
1answer
540 views

In SQL Server, are there any other options of data Import and Export

I've been working with SQL Server since SQL Server 7. So I know about BCP, Bulk insert, openrowset and SSIS. My question is a simple one: Do you know of any other ways to Import/Export data using ...
2
votes
2answers
5k views

SQL Server Express: difference between connecting to localhost and localhost\sqlexpress

I am new to SQL Server and am following some tutorials. I have not yet created any databases. In SQL Server 2012 Management Studio I click on "connect" -> "Database Engine". I noticed that, using the ...
2
votes
1answer
5k views

SQL Server taking a lot of memory

I have SQL Server Express on my VPS(2GB RAM) with a database size of 1.5 GB that I expect will increase to 15 GB. I have noticed that SQL Server is using 1.5 GB RAM even when only small queries has ...
2
votes
1answer
371 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 ...
2
votes
1answer
2k 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 ...
2
votes
2answers
56 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 ...
2
votes
2answers
5k 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 ...
2
votes
2answers
2k views

Trigger to create a variable Table to be sent to service broker

I've setup a service broker for the first time and tested it... Looks good. Everytime a DML operation happens on a specific table; Let's say the Price Table, a trigger calls a stored procedure passing ...
2
votes
1answer
739 views

Selecting from an excel spreadsheet into SQL Server table

This question has been asked before but I tried giving full admin rights to the SQL Server user on C:\temp\ folder location (I am using Windows authentication into SQL Server Express). So for the ...
2
votes
1answer
29k views

user “sa” cannot connect to SQL Server Express 2008 R2

Goal: connect to SQL Server Express 2008 database using SQL Server authenticated account "sa", rather than my Windows authenticated account. When installing SQL Server 2008 Express, I took all ...
2
votes
2answers
3k views

Can't shrink WSUS SQL database

I have a Windows SBS2011 installed. It has file sharing, Exchange and WSUS running off it. WSUS console was, and always been, running slowly - I have no comparison with any other system, so I ...
2
votes
2answers
207 views

Error after removing sql server 2008 R2 Express edition and instaling Entreprise edition: Unable to connect to MyHost\MSSQLSERVER

So I'm having this issue after installing MS SQL Server 2008 R2 Enterprise edition, I'm getting this message error: Unable to connect to WIN7 \ MSSQLSERVER A network-related error or instance-...
2
votes
2answers
1k views

Importing CSV file using SQL Server Import and Export Wizard (SQL Server Express)

So I am having a heck of a time importing a CSV file. The ultimate goal is to create a repeatable process to import the file. The only way I've been able to import the file is in a roundabout way ...
2
votes
2answers
2k views

Table not shown up on Linked Server

I have a machine which have 2 SQLServer instances WINXP-PRO\SQLSERVER2000 (SQL Server 2000) WINXP-PRO\SQLEXPRESS (SQL Server 2005 Express Edition). In \SQLEXPRESS, I have database wavinet2 and ...
1
vote
3answers
3k 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?
1
vote
2answers
4k views

SQL Server agent option in SQL Server Express

I am using SQL Server 2008 Express. I don't have SQL Server Agent option in it. How can I enable it? I have searched on internet, but couldn't find anything. Do I need to install anything?
1
vote
2answers
33 views

Backing up SQL Server Express Edition on a VPS

I'm considering installing SQL Server Express Edition on a VPS. My understanding is that, among the limitations of Express Edition, some of them involve features that facilitate backups. Can someone ...
1
vote
2answers
173 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
vote
3answers
8k views

Inserting Serbian Latin and Cyrillic characters

I am using SQL Server 2012 Express as part of my asp.net development workstation. Database and table collation is set to Latin1_General_CI_AI. Attribute types are nvarchar(max) and varchar(max). ...
1
vote
1answer
17k views

Installing SQL Server 2008 Express Edition in quiet mode issue?

I want to install SQL Server Express 2008 in quiet mode. I know that we can use /ConfigurationFile="ConfigurationFile.INI" parameter to install SQL Server from a configuration file. The following is ...
1
vote
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
1answer
86 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 ...
1
vote
3answers
11k 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
732 views

How do I reindex my SQL Server Express database to free up space when it's already full?

Being the naive guy that I am, I let my DB get full (10GB is the max for SQL Server Express), and have now decided to drop columns to reclaim space. I'm dropping 10 columns from a ~50M row table to ...
1
vote
1answer
2k views

SQL Server Express 2008: Can I store database files (.mdf, .ldf) in directory other than the default DATA directory?

I have a SQL Server Express 2008 instance of which I am attaching databases from development systems quite often. Typically I transfer the .MDF and .LDF files to the instance's DATA folder and ...
1
vote
1answer
75 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 ...
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
1answer
2k 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 ...
1
vote
2answers
111 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 ...
1
vote
1answer
343 views

How to store lots of small text in a SQL Server database?

I have a table with a varchar(max) column that stores text ~4-10KB in size. Data is just being added - never modified, it is a log. My problem is that a table grows too large in size - I would like to ...
1
vote
1answer
102 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 ...
1
vote
1answer
480 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.)
1
vote
2answers
525 views

Feature of database-level audit in SQL Server 2012 Express edition

Like in SQL Server 2012 Enterprise edition, can we have database-level audit in SQL Server 2012 Express edition? Can we have Audit Folder in Security Tab?