Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008r2-express]

Use this tag for questions specific to scaled down, free edition of SQL Server 2008 R2.

223 questions
1
vote
1 answer

Cannot open database requested by login

I have a SQL Server 2008 R2 Express database. I have written a Delphi application that uses a TADOConnection object to connect to the database. It works just fine on my computer. It fails to connect from other computers on the network. It gives the…
WeststarEric
  • 321
  • 1
  • 2
  • 12
1
vote
1 answer

Importing Excel Data into SQL Server 2008 R2 Express

There seems to have been many discussions on this but I couldn't find something specific to what I am looking for. I am trying to use a query to import data from Excel to an existing table in SQL Server. My query is: INSERT INTO DailyRawData …
MilesToGoBeforeISleep
  • 183
  • 1
  • 2
  • 17
1
vote
1 answer

Installing SQL Server 2005 Express on a server that already has SQL Server 2008 R2 installed

I am trying to installing SQL Server 2005 Express edition on a Windows Server 2008 where we already have SQL Server 2008 R2 Express edition installed. Will that be possible?
Yukesh57
  • 49
  • 1
  • 8
1
vote
0 answers

Visual Studio 2013 Click Once With SQL Server Express 2008 R2

I am struggling to find information on if it is possible to use command line arguments for SQL Server 2008 R2 Express when it's deployed as a prerequisite with an app. I would like to configure SQL Server Express for network connections and login…
Paul
  • 207
  • 1
  • 3
  • 14
1
vote
1 answer

Migration MSSql Db - from SQL Server 2008 R2 Enterprise backup can restore in SQL Server 2008 R2 Express version

I have a quick simple question: can a SQL Server 2008 R2 Enterprise/ Developer edition backup be restored in a SQL Server 2008 R2 Express version? Source: SQL Server 2008 R2 10.50.1600.1 RTM Developer Edition (64-bit) Destination: SQL Server…
Ajay2707
  • 5,690
  • 6
  • 40
  • 58
1
vote
2 answers

Cannot start SQL Server agent

I re-installed w7 ultimate and installed Microsoft® SQL Server 2008 R2. Firstly, it was problem of permissions, because I had error log like this User does not have permission to perform this action That's why I tried this link: SQL Server 2008…
user3454492
  • 63
  • 2
  • 5
1
vote
2 answers

How can I improve the speed of this SQL query?

We have two devices collecting data at roughly 30-second intervals. The devices are located at two widely-spaced sites. The absolute time of each collection for each site can vary +/- 30 seconds. Occasionally, a site will go offline for various…
Mozzis
  • 421
  • 4
  • 7
1
vote
1 answer

Cannot connect to SQL Server 2008R2 Express

I have just installed SQL Server 2008 R2 Express. I haven't set anything unusual during the installation process. Everything was default, that the instance name is SQLExpress, the connection is via SQL Server with user sa and my password. I have…
Celdor
  • 2,437
  • 2
  • 23
  • 44
1
vote
0 answers

SQL Installation Help...cannot fix Database Engine Error, Need remote assistance now

Have been using SQL Server 2008 R2 Express for years, and my db engine somehow got corrupt. Installed/reinstalled, da da da... I've got 2 days in now trying to fix known nagging error without success: Database Engine recovery handle failed I am…
user3805931
  • 11
  • 1
1
vote
1 answer

SQL Server Express: How to determine SP memory usage

I am developing with Microsoft SQL Server 2008 R2 Express. I have a stored procedure that uses temp tables and outputs some processed data usually within 1 second. Over a few months, my DB has gathered a lot of data almost reaching the 10 GB…
Jyotsna Sonawane
  • 303
  • 1
  • 3
  • 17
1
vote
1 answer

How to solve it when there are multiple SQL Server instances, but can only connect to one?

Using SQL Server 2008 R2 I have 2 SQL Server instances on my PC, SQL1 and SQL2. I have Windows XP installed in a VirtualBox. In XP, I have an application which can connect to SQL Servers. When I try to connect to SQL1, everything is fine, but when I…
user1651105
  • 1,727
  • 4
  • 25
  • 45
1
vote
1 answer

Looking for a free DNN community edition website Backup and restore procedure working with DNN 7 and SQL server express 2008 r2

I am looking for a free DNN community edition website Backup and restore procedure working with DNN 7 and SQL server express 2008 r2. I usually design and develop website in local PC as my connection speed to the actual server is low. And then I…
Yashil
  • 170
  • 1
  • 2
  • 13
1
vote
2 answers

Large script failing on SQL Server 2008 R2 Express

I need to run a "large" script on SQL Server 2008 R2 Express and it is failing with There is insufficient system memory in resource pool 'internal' to run this query. The script is around 10MB saved to disk, contains about 54000 top-level…
Herman Schoenfeld
  • 8,464
  • 4
  • 38
  • 49
1
vote
0 answers

RazorPDF not working on build server

I'm creating an application which uses the RazorPDF nuget package for creating PDF document. When using this on a local development pc everything works fine but when I deploy on a server, I always get the standard error: "Error. An error occurred…
TammenOtter
  • 21
  • 3
1
vote
3 answers

VS C# constring for Microsoft SQL Server Express 2008 R2

I'm making a C# application that uses SQL Server 2008 R2 Express on Windows 7 64bit. The problem I'm facing is I can't connect to my database because my connection string is wrong. I'm using a .udl file to make the connection string and this is what…
Sandy Budiyanto
  • 31
  • 1
  • 4
1 2 3
…
14 15