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

SQL Server 2008 R2 Express : Login failed for user

I have an application in C#2010, a database in SQL Server 2008 R2 Express, I don't have any problem to connect to my database MyDB on my work PC where I developed the application. But when I tried to install it on an other PC, and after configure my…
aEk BKF
  • 131
  • 1
  • 2
  • 15
1
vote
1 answer

Getting error while Installing SQL Server 2008 R2 Express edition

I am trying to do a silent unattended installation of SQL Server 2008 R2 Express edition. I am using the below code to achieve it
Abhishek Kumar
  • 129
  • 2
  • 3
  • 6
1
vote
1 answer

Error when using sqlmaint.exe with SQL Server 2008 R2 Express

Before my migration from MSDE (SQL Server 2000) to SQL Server 2008 R2 Express, I used the following sentence to take a backup of my database : C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn>sqlmaint.exe -S…
Emmanuel
  • 11
  • 2
1
vote
3 answers

Connect Delphi to SQL database

I'm using Microsoft SQL Server R2 Express to create databases. When I try to connect to a database using delphi, I have to use this Connection string : ADOConnection1.ConnectionString := 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial…
Ouerghi Yassine
  • 1,835
  • 7
  • 43
  • 72
1
vote
1 answer

Error when adding values to an Access ADP form bound to a SQL stored procedure with a join

I have an Access 2003 ADP project that connects to SQL Server 2008 Express Edition. When I try adding values to a form that has as it's RecordSource a SQL Strored Procedure that uses a JOIN, I get the following error: You can't update the record…
user1202134
  • 233
  • 2
  • 10
1
vote
1 answer

Where does the Output go when Print 'Something' in a Trigger?

I'm using SQL Server 2008 R2 If I want to show Print statement from trigger to my .aspx page, Is it possible to return any variable value from trigger ? Is it possible to use string function i.e. String.Contains() and String.Split() on column value…
madi virgo_007
  • 21
  • 1
  • 4
  • 9
1
vote
2 answers

How to create Table with Module name Prefixed?

I downloaded AdentureWorks Database and found a new style to create a table like below. Sales.SalesOrderHeader Person.Person Sales.SalesOrderDetail Can you explain how to create table which can have a module prefix ? Please let me know if you have…
user1499112
1
vote
3 answers

How to generate the Alter,Update & Create Script in SSMS?

Hi I am using SQL SERVER 2008 R2, I have 2 databases 1] ABC (with only structure like schemas, tables but no data in the table) 2] ABC1 (with schemas, tables and data in the tables) I did the comparision at Schema and Tables level, I found a table…
Vikrant More
  • 5,182
  • 23
  • 58
  • 90
1
vote
1 answer

SQL trigger updating table using another table

Hi everyone I am still sort of new to SQL, I have a slight problem and maybe someone can help. I have researched all about triggers and what I read make sense, but I can't get the answer I need from it for some reason so I will explain what I need…
quatre432
  • 47
  • 1
  • 11
1
vote
1 answer

.NET compact framework and SQL Server Express 2008 R2

I am having problems in picking the right collation / locale on a Windows Embedded Compact Edition 6.0 device. I am using .NET compact framework 2.0 on said device. I am having difficulties inserting the letters ŠĐČĆŽšđčćž in the database. I am…
JJ_Jason
  • 349
  • 8
  • 24
1
vote
4 answers

Fail to Install SQL Server 2008 R2 as a feature pre-requisite in a WIX project

We have a WinForms project that requires SQL Server 2008 R2 Express. The application is Deployed using MSI installer with a Bootstrapper executable created by WIX. So we need to run SQL Server installer from our installer. A WIX project has few…
LucID
  • 151
  • 1
  • 9
1
vote
0 answers

C# WPF SQL Server Express local db ObjectContext.CreateDatabase yields error 26

I've created a WPF app that utilizes SQL Server 2008 R2 Express as its backend. Using EF, I build my database by issuing a Objectcontext.CreateDatabase() method. This method (on some workstations) results in a SQL Server Error 26 - Error Locating…
user1156862
  • 35
  • 7
1
vote
1 answer

Can't select Reporting Services in Management Studio?

I've installed Sql Server 2008 R2 Express Advanced SP1 for my client including Reporting Services. I've configured the Reporting Services but when opening Management Studio I can't open the Reporting Services.. Is this a missing feature in Expres or…
Ralf de Kleine
  • 11,464
  • 5
  • 45
  • 87
1
vote
0 answers

Network-related or instance-specific error when running SQL Server 2008 R2 Express

I have Problem when I run my web project Error : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and…
Abdalmohaymen
  • 89
  • 2
  • 8
0
votes
2 answers

SQL Server 2008 R2 First-Time Connection Issues

We've been experiencing a strange issue with SQL 2008 R2 (10.50.1600) installed as a named instance. In order for any external clients to connect, we have a certain procedure we have to follow, but should not have to. Now I did in fact open the…
Jerry Dodge
  • 26,858
  • 31
  • 155
  • 327
1 2 3
…
14 15