Stack Overflow
Stack Overflow

Questions tagged [sql-server-2014-express]

For questions specific to the scaled down, free edition of SQL Server 2014

Microsoft SQL Server 2014 Express is free and contains feature-rich editions of SQL Server that are ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

The SQL Server 2014 Express release includes the full version of SQL Server 2014 Management Studio. For a complete list of supported features in SQL Server Management Studio, see Features in SQL Server Management Studio.

Source: Microsoft (SQL Server 2014 Express)

334 questions
40
votes
6 answers

After installing SQL Server 2014 Express can't find local db

I have downloaded and installed SQL Server 2014 Express (from this site: http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx#Installation_Options). The problem is that I can't connect/find my local DB…
Mantvydas Ozerenskis
  • 765
  • 1
  • 6
  • 16
27
votes
7 answers

I can't get a Sql Server localdb connection to work on a computer that does not have SqlServer Express installed

I have a C# console application written using Visual Studio 2012. In the application I am using a Sql Server localdb connection to a database to store information. This is working fine on several computers, all of which have Visual Studio…
MDig
  • 649
  • 1
  • 6
  • 10
25
votes
4 answers

SQL Server Express 'NEW TRIGGER' BUTTON IS DISABLED

I am new to SQL Server Express and I want to create a new trigger on my table. But I found that the 'New trigger' button in my table's trigger folder shows Disabled. When I right click on trigger folder it shows 'New trigger' button disabled and in…
user3541569
  • 259
  • 1
  • 3
  • 4
21
votes
1 answer

Cannot create SQL Server Express Login - Login Failed for User

I have created a new login for SQL Server Express as follows: USE [master] GO CREATE LOGIN [Test] WITH PASSWORD=N'SF#$%GD%^J675JFS4fds' MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON GO ALTER SERVER…
Shaun Luttin
  • 133,272
  • 81
  • 405
  • 467
16
votes
4 answers

Can not connect to sql server from docker supported asp.net core project

I have a ASP.NET Core 2.2 project for which I turned on docker support. The project runs fine as long as it does not require database connection. For e.g Login. When I enter user credentials, I get the error as below. An unhandled exception…
Chaitanya Gadkari
  • 2,669
  • 4
  • 30
  • 54
13
votes
4 answers

Can't connect to SQL Server 2014 Express

I'm having trouble connecting to a freshly installed instance of SQL Server 2014 Express. I'm not even totally sure what information you would need to help, so please bear with me as I'm very much an amateur. If I can provide anymore information to…
Chris Martin
  • 383
  • 1
  • 3
  • 8
12
votes
1 answer

Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName

I am trying to create an App Service web app in the Azure Portal and to connect the web app to my local on-premises SQL Server database using the new Hybrid Connection feature. Created a simple ASP.NET application using Visual Studio 2015 and…
praveen gogula
  • 599
  • 3
  • 6
  • 22
9
votes
7 answers

Referenced table is not coming in my model through entity framework 5.0

I am using MVC 4 and entity framework 5.0, i have a database and this database contains 6 tables named as following. tblUser_family tblUser_location tblUser_info tblUser_photo tblUser_settings tblUser_social when i am creating the .edmx file then…
Ashish-BeJovial
  • 1,829
  • 3
  • 38
  • 62
9
votes
3 answers

Get a single record from SQL Server the correct way

I'm using Ado to retrieve a single record by id. Observe: public async Task GetImage(int id) { var image = new Image(); using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); string sql =…
Luke101
  • 63,072
  • 85
  • 231
  • 359
9
votes
4 answers

WPF C# application using local database

I am a novice when it comes to using a database in an application. My task (and sort of a goal) is to create an application in WPF using C# that can connect to/use local database stored on user's computer. The database 'file' should be easy to…
Quass1m
  • 315
  • 2
  • 4
  • 11
8
votes
3 answers

Use the same transaction in different methods with Entity Framework Core

EDIT (02/03/2018) : Since Entity Framework Core 2.1, EF Core implements transactions, cross-context transactions, ambient transactions and transactions scopes so this question is now out of date. This is the official documentation about the…
AdrienTorris
  • 9,111
  • 9
  • 34
  • 52
8
votes
1 answer

IIS AppPool to SQL Server permissions (adding NT AUTHORITY\IUSR)

I've got a new server build running Windows Server 2012 R2, IIS 8.5 (inc. ClassicASP feature) and SQL Server 2014 Express. I want to use Application Pool Identity to connect to the database. The database is set to "Windows Authentication Mode". My…
Chris Walsh
  • 3,423
  • 2
  • 42
  • 62
6
votes
1 answer

UNION of non-nullable columns is nullable

Running MS SQL server 2014 express. Suddenly one of the columns in a view became nullable, despite being a union of two non-nullable columns. Please help me understand what's going on here: and the UNION: What am I missing? Edit with more…
naasking
  • 2,514
  • 1
  • 27
  • 32
6
votes
3 answers

Why my selection between two dates in the same table doesn't work?

I use SQL server 2014, i try the following query to select between two dates in the same table, the datatype is nvarchar, i executed the following query it just shows me three rows such('30/03/2015','30/04/2015','30/04/2015'),but in reality there…
R.salih
  • 135
  • 8
4
votes
1 answer

SQL Geography Intersect always returns 1

I'm trying to determine whether a point is within a polygon. The results I'm getting back appear to be always returning 1 regardless of whether the point is within the boundary or not. DECLARE @point GEOGRAPHY = GEOGRAPHY::Point(54.2225,-4.5366,…
Braydie
  • 716
  • 9
  • 27
1
2 3
…
22 23