Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-express]

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

The Microsoft® SQL Server® Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment.

Source: Microsoft (SQL Server 2012 Express)

401 questions
2
votes
1 answer

SQL Server error with tying my database to Form controls

I am using Visual Studio 2012 Professional with SQL Server 2012 Express. I have created a new Windows Form (C#) project and started out by creating a new data connection and named it MyShop.mdf. From there I created two tables: Customer and Order. …
Anthony Darden
  • 137
  • 1
  • 5
  • 13
2
votes
1 answer

When WebSecurity fails a login, it stores the LastPasswordFailureDate as being wrong by 11 hours

It's currently 12:56am, 29/3/2013 (Australia). When I get a username/password combination wrong, the database reports that the last login failure is 2013-03-28 13:56:18.517 It's behind by 11 hours. I'm using out-of-the-box WebSecurity and…
Rowan Freeman
  • 15,724
  • 11
  • 69
  • 100
2
votes
1 answer

SQL Server 2012 Developer Default Instance not working

I just installed SQL Server 2012 developer edition with a default instance of MSSQLSERVER. The problem I'm facing is when I launch Management Studio and connect using the server name - (LocalDb)\v11.0 - it works perfectly, but when I try to put in…
skywalker2909
  • 1,636
  • 2
  • 31
  • 46
2
votes
1 answer

Can't browse all the table

I have problem with the Entity Framework ver. 5 ConnectionString with ADO.NET Entity Data Model. When I use the generated connectionString with Username and Password I can't map/browse all the table from my database.
spajce
  • 7,044
  • 5
  • 29
  • 44
2
votes
1 answer

Visual Studio 2012 and SQL Server Express

Is it possible that the Visual Studio Ultimate that was installed in my machine didn't include SQL Server Express, they didn't turn any option off when installing, they simply installed it following the default options.
Rafael
  • 2,413
  • 4
  • 32
  • 54
2
votes
1 answer

Setting NOCOUNT status with local variable

I'm trying to store the NOCOUNT status so that I can return it to its original state at the end of my procedure, but all it does is give me an Incorrect syntax near 'NOCOUNT'. error. What am I doing wrong? IF @@OPTIONS & 512 <> 0 /* check…
Deina Underhill
  • 557
  • 1
  • 9
  • 23
2
votes
2 answers

SQL Server 2012: Login to PC-NAME\SQLEXPRESS works, but not to local/(local)

I'd like to login to my SQL Server 2012 Express with servername local or (local) but it doesn't work. The only servername which works is PC-Name\SQLEXPRESS. local/(local) has to work somehow because I have to use the following connection…
mosquito87
  • 4,270
  • 11
  • 46
  • 77
2
votes
3 answers

SQL Server 2012 Express, Connection error 26, Local connection

I am working locally on new laptop (windows 8 x64) with SQL Express 2012 SP1 x64, and I get the following connection error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not…
user2036960
  • 21
  • 1
  • 2
2
votes
0 answers

SQL Server 2012 Evaluation database to SQL Server 2012 Express?

I have taken over a client, who had an inhouse developer. The inhouse developer used SQL Server 2012 Evaluation (which I believe/assume is Enterprise)? Regardless, their SQL Server eval has now expired, and they are "locked" into buying SQL Server,…
Louis van Tonder
  • 3,664
  • 3
  • 31
  • 62
2
votes
2 answers

Where can I access the tables under Master table in SQL Server 2012 Express?

I did a select * from mytablename and it is clearly there. But under the GUI Microsoft took out the tables link?
user1771731
  • 21
  • 2
2
votes
2 answers

Moving database files created by SQL Server 2012 Express to SQL Standard 2008

I am planing to built database driven website with DotNetNuke and SQL Server Express 2012 on my laptop and than host it on web server that has SQL Server 2008 Standard edition. Is SQL Server 2008 compatible with database files created by Server…
Juan
  • 127
  • 1
  • 7
2
votes
3 answers

How do I find what is the named instance of my SQL Server 2012 Express instance

Using SSMS to validate my ServerName\instance ... I can only get it to connect with the dot . (or computerName). I thought the default instance was .\SQLEXPRESS ... but this does not work. It seems Visual Studio 2012 also expects (.\SQLEXPRESS)…
user1691774
  • 21
  • 1
  • 1
  • 2
2
votes
0 answers

java.sql.SQLException: Network error IOException: Connection timed out: connect

I have installed SQL Server 2012 Express in my laptop and tried to run a sample java program as follows: import java.sql.*; public class Ex2 { Connection con; Statement st; ResultSet rs; public Ex2(String query){ System.out.println("IN…
user1499642
  • 51
  • 2
  • 4
2
votes
3 answers

EF Code First with SQL Server Express 2012 ConnectionString

Everything works just fine with the following connection string.
Budoray
  • 155
  • 2
  • 2
  • 10
1
vote
1 answer

Python QtSql.QSqlQuery result wrong in connection with SQL Server database and float values

I create a GUI with PyQt5 and display a SQL Server database table in a tableView widget. The id, date and text columns are OK, but I have also four float columns. The result from the float columns are None if there is a value in it and if the Value…
rico
  • 11
  • 2
1 2 3
…
26 27