Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.

1718 questions
12
votes
1 answer

connect to sql "server group" with php to run query over multiple databases

I am trying to connect to an MSSQL Server group with PHP and action a select query over a view . I can connect & pull results from the server . I can connect & pull results from a DB With MSSQL under registered servers (top left) you can create a…
benaw
  • 121
  • 5
11
votes
4 answers

Entity Framework won't persist data in SQL Express (MDF)

I was developing an application using Entity Framework and storing data in a .mdf database. My code can read the data, apparently it can save too, but only apparently. It get no erros, while the program is running it act like the data was saved, I…
Alaor
  • 2,181
  • 5
  • 28
  • 40
11
votes
3 answers

SQL Server bacpac fails on local import in latest update (Online index operations can only be performed in Enterprise edition of SQL Server)

I have an SQL Azure database and connect to it in SQL Server Management Studio. I do Export Data Tier Application and then Import Data Tier Application for the .bacpac file to get it into my localdb. Or I use Tasks - Deploy Database. Either way, it…
Vince
  • 583
  • 5
  • 20
11
votes
1 answer

How to install SQL Server Reporting Services (SSRS) on an existing SQL Server Express install?

I have SQL Server 2005 Express, but I haven't got SQL Server Reporting Services (SSRS). How do I install it separately? Do I have to download the whole SQL Server setup again, or is there any separate setup for only SSRS?
sqlchild
  • 8,754
  • 28
  • 105
  • 167
11
votes
3 answers

No services listed when SQL Server Express 2008 R2 Installed on local computer

I cannot get my local computer to run SQL Server. I looked in the SQL Server configuration manager and noticed that there are no SQL Server Services listed. That can't be right. I also noticed that There are two Managers listed in the SysWOW64…
scojomodena
  • 842
  • 1
  • 14
  • 24
11
votes
5 answers

.mdf is too new (661) my database supports version 655

I am using SQL Server 2008 express and i want to import .mdf and i get this error: .mdf version is 661, your db supports the version 655 Which version is 661 and how to import it in sql Server 2008.
senzacionale
  • 20,448
  • 67
  • 204
  • 316
11
votes
4 answers

How to get BIDS for Visual Studio 2008 SP1?

I currently use Visual Studio 2008 SP1 and have been migrating older projects into VS2008 but existing SSIS and SSRS (2005) projects have not been compatible with VS2008. It has been a pain to maintain those BIDS projects as a separate solution. I…
BlackMael
  • 3,198
  • 5
  • 25
  • 42
10
votes
2 answers

How to make SQL Server find a login matching the name provided?

I have just restored a database backup to my local SQL Server express instance. In management studio under the server instance node I went to: Security -> Logins -> New login... Then I filled in a login name, password and chose SQL Server…
Ropstah
  • 17,538
  • 24
  • 120
  • 194
10
votes
2 answers

Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053

I am running Windows 7 32 bit and I have IIS, Visual Studio 2008, 2010 installed. I am haunted by this error in SQL Server 2008 which is: Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053: The service did not…
redoc01
  • 2,107
  • 5
  • 32
  • 64
10
votes
5 answers

Since LocalDB is for development purpose, then use what DB for production?

I'm getting a little confused here between LocalDB and SQL Server Express. I have read from websites that LocalDB is an improved version of SQL Server Express (source). I would assume this implies that LocalDB is replacing SQL Server Express. The…
Carven
  • 14,988
  • 29
  • 118
  • 161
10
votes
3 answers

System.Data.DataException error occurred in EntityFramework.dll

I have been following this tutorial Getting Started with Entity Framework 6 Code First using MVC 5. When I got to the section where I need to run the program and click on Student so that the program would create database I get the following error.…
Pheap
  • 2,349
  • 4
  • 18
  • 13
10
votes
4 answers

How to set (combine) two primary keys in a table

For a small sales related application, we designed database using logical data model. Come to the stage to convert in to physical model. While creating table in SQL Server Management Studio Express, according to our logical data model, we need to…
panindra
  • 646
  • 2
  • 11
  • 33
9
votes
1 answer

Replication from one SQL Server Express to another

I have one SQL Server Express instance with a pretty normal well formed database. I need to have the data continuously replicated to a SQL Server Express instance on another server. Now, I know that SQL Server Express does not include the Publisher…
Niels Brinch
  • 3,033
  • 9
  • 48
  • 75
9
votes
1 answer

Linked Server In SQL Server Express

I am developing an app where i have a local database in SQL Server Express. During work in local database, we need to execute a query on another SQL Server / live server and its return a value and with this value we execute a query in local server.…
JSJ
  • 5,653
  • 3
  • 25
  • 32
9
votes
3 answers

How to warm up a sleeping SQL Server database

We have a job which runs every morning in CruiseControl.net to import a datafile into a DB. Our problem seems to be that some nights the DB goes to sleep over night. When we run the script in the morning our connection times out while we wait for…
Pete Duncanson
  • 3,208
  • 2
  • 25
  • 35
1 2 3
…
99 100