SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.

learn more… | top users | synonyms

0
votes
1answer
2k views

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I ...
0
votes
2answers
2k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
0answers
9 views

can't find out the cause that blocking active processes

I have a small problem with one of servers. It's a test server on which I have SQL 2008 R2 installed. I see huge blocking events, For some reasons I see sleeping processes that are blocking active ...
1
vote
2answers
4k views

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed ...
0
votes
1answer
2k views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
2
votes
1answer
2k views

How to uninstall SQL 2008R2 Reporting Services via the command line?

I am running SSRS 2008R2 x64 on a Windows Server Core 2008 R2 instance. I need to fully uninstall the SSRS instance leaving the DB's in tact. I know this is normally done through the Programs and ...
4
votes
4answers
4k views

Speeding up SQL Server temp table processing with a RAM Disk

A system we are developing consists of a Web app frontend, and a backend that does a lot of data processing using stored procedures in SQL Server 2008 R2 (please, don't ask why...). These stored ...
0
votes
1answer
26 views

What kind of SPN is required to delegate client credentials to a SMB Share?

I'm trying to delegate KERBEROS authentication from an SQL Server to a file server over OLEDB. Is there a particular Service Principle Name that is used to delegate credentials from an SQL Server ...
2
votes
0answers
15 views

Virtualised SQL Server Cluster test environment error “originally formatted with sector size 4096”

I am trying to set up an environment for testing a clustered SQL Server upgrade, so I have built a replica here on VMware Workstation 11. I have provisioned 3 servers for this, two Windows Server ...
0
votes
0answers
1k views

Error during Veeam SQL log backup: “Failed to flush file buffers”

My company uses Veeam Backup & Replication to make backups of our VMWare-hosted virtual machines. We use Veeam's SQL log backup feature for our MS SQL 2008 R2 server. Our backup repository resides ...
0
votes
1answer
22 views

SQL Server Mirror issue on Mirror side

Team, I am having an issue on one of my Mirroring environment. It is SQL2008R2. DB mirror was somehow broken between principle and Mirror side. Someone(Not sure who is he/she due to offshore support) ...
1
vote
1answer
69 views

MS Native SQL driver 10.0 and SQL Server 2008 connection creation failure

I'm trying to narrow down and debug quite elusive error: State: 08001 Code: 258 Msg: [Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. State: HYT00 Code: 0 Msg: ...
9
votes
3answers
14k views

How to update a CLR Assembly without dropping assembly from SQL Server

How can i update a CLR function (or procedure) assembly dll without having to drop and re-create the assembly in SQL Server (2008 R2)? As it stands now if i update an assembly (e.g. to add a new ...
0
votes
0answers
20 views

A timeout occurred while waiting for memory resources to execute the query in resource pool 'internal' (1). Rerun the query

When I run this query Select -- Generate the row number ROW_NUMBER() over(order by MenuOrder) as 'rownum', -- get the minimum data from query (Select top 1 ...
4
votes
2answers
3k views

Installation of SQL Server 2008 R2 hang on Setup-Support files

I'm installing SQL Server 2008 R2 on a customer Windows Server 2003. Setup started ok, installed .NET framework and some Setup files, rebootet. After that I ran setup for a new single-server ...
2
votes
1answer
142 views

ASP.NET MVC Getting Error 504 after 10 minutes of File Upload

I have an ASP.NET MVC2 Web application, working with SQL Server 2008 R2, running with IIS 6.2. I have a functionality where one particular admin needs to upload about 5000 documents, which then get to ...
1
vote
0answers
40 views

Issues identifying SPNs

Background We are performing a server move. In the process, new servers and service accounts have been created. I'm getting two issues which I think are related to SPN's: I've created some SQL ...
0
votes
1answer
48 views

SQL Server, local instance, No process is on the other end of the pipe

On a fresh installation, on my local SQL server instance, using SQL Server Management Studio, I can login with my Windows authentication, but not with my sa user. In both cases, I'm using (local) as ...
0
votes
1answer
342 views

C#/asp.net application runs fine on localhost (intranet), but not on server (Internet)

I'm a total n00b when it comes to SQL Server admin stuff, so sorry if this is basic. I've designed a website in C#/asp.net with a SQL Server backend on my local machine. Runs perfectly when I open the ...
0
votes
3answers
15k views

Why is my DB read-only when attached to SQL Express, but not with SQL Web?

I have an .mdf/.ldf pair, originally created in 2008 R2 Standard, and well under 10GB, with ACLs: d:\db snapshot\DB_NAME.mdf SERVERNAME\SQLServerMSSQLUser$ACCOUNT$MSSQLSERVER:F OWNER RIGHTS:F ...
3
votes
0answers
180 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
1
vote
0answers
20 views

MS sql server 2008 R2 database is in suspect mode

I have an darabase on MS sql server 2008 R2, which is currently showing principle, Disconnected / suspect. I have tried, to set DB in emergency mode but got failed and showing message database is in ...
0
votes
1answer
19 views

Can a sql job using a DTS package access data from the wrong column? (turned out to be bad join condition)

We are seeing a Sql job / DTS package fail because it is fed non-numeric character data into an int conversion routine. The data looks like with very high probability that it comes from another ...
0
votes
1answer
267 views

Cannot see linked server properties in SQL Server 2008 R2

I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000. When viewing the properties of an existing linked you, you cannot see (or edit) any ...
3
votes
2answers
4k views

Attempting Unauthorized operation - SQL 2008 R2 install

I've been banging against this for a few days. Keep getting this unauthorized error when trying to install SQL 2008 R2 on a Windows 7 machine. I've changed permissions on the key, does not fix... ...
0
votes
1answer
337 views

The MSDTC transaction manager was unable to push the transaction to the destination transaction manager due to communication problems

I have a BizTalk server and a SQL server which BizTalk sends messages via WCF-SQL to. The BizTalk server has been calling to this server for over a year with no problems. I came in this morning any ...
0
votes
1answer
395 views

Clustered instance - kerberos double hop woes

We've recently migrated our virtualised SQL databases to a bare metal solution in an active/active cluster. Everything is working great except SQL Reports. Ok, so a rundown of our setup here as it ...
2
votes
0answers
54 views

After move SQL isn't releasing memory for queries

We recently made a move from one VM hosting environment to another. The machine we moved is a clone so all settings are identical pre- and post-move. However in our new environment our SQL server is ...
0
votes
0answers
1k views

Error in install sql server 2008 rn [closed]

When running the SQL Server 2008 setup, I receive the following error message: TITLE: Microsoft SQL Server 2008 R2 Setup The following error has occurred: Unable to open Windows Installer file ...
0
votes
2answers
40 views

SQL 2008R2 Failover Cluster without File Share

We are looking to set up a failover cluster for our SQL 2008R2 database. To accomplish this, we have 2 servers, both equipped with Fusion I/O cards that will both have identical copies of our ...
3
votes
4answers
2k views

Ola Hallengren's SQL Backup to Network Location not working

I have set up Ola Hallengren's SQL Server Maintenance Solution on several SQL Express servers (2008 to 2012 R2) in the past few years. I recently have started having issues with the network backup ...
0
votes
0answers
2k views

Server 2012 slow performance on ESXi 5.5

I'm having performance issues with a virtual Server 2012 that is installed on an ESXi 5.5 (HP-ESXi-5.5.0-iso-5.71.3). The hardware server is an HP ProLiant DL380p Gen8. The server 2012 is acting as ...
0
votes
0answers
13 views

schema specific object access in sql server is not happening after restoring backup

I have an application which is accessing sql objects(stored procs/tables) etc which are defined under a schema 'A' for example A.my_stored_proc. This application is working fine as intended when I ...
-2
votes
1answer
28 views

Seting local MSSQL Server as Database Server [closed]

I have my web site hosted at EC2 server. If I want to give user an option to use their local MSSQL server, so how can I configure that. First of All, Is it Possible? Do I need Static IP? How to ...
0
votes
1answer
45 views

Multiple SQL Standard Instances on 4 Processor/32-core Server

We have a large 4 processor/32-core server with 192GB of memory available in the data center and over twenty small SQL Standard databases to consolidate. They are a mix of SQL 2012 and 2008 R2 for ...
0
votes
1answer
27 views

SQL Installation Error In Memory, Can i just add a database to an existing SQL Instance

We have an SBS server running 4 Microsoft SQL 2008R2 instances. I need another for an anti-spam product, but the install fails with an error about possible corrupt memory. I've done some digging and ...
1
vote
1answer
40 views

2K8 Cluster - SQL Instance broken on one node

Using a 2-nodes cluster 2008R2 Failover Cluster. A new clustered instance was created (I double checked it's clustered). Instance was installed on node1. When we try to move it to node2, it failed. ...
1
vote
0answers
44 views

Server 2008 R2 permissions not working

First of all: i posted this yesterday but put in the wrong email so I can't access it again. I am configuring a 2008 R2 server for learning experience. The problem I'm having is the following: ...
3
votes
2answers
784 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
9
votes
7answers
28k views

Activity monitor is unable to execute queries against server

Is there any fix to get SSMS activity monitor working? Problem: SQL Server Activity Monitor fails with an error dialog: TITLE: Microsoft SQL Server Management Studio The Activity Monitor is ...
4
votes
5answers
50k views

Cannot login to SQL Server 2008 R2 with Windows authentication

When i try to connect to SQL Server (2008 R2) using Windows authentication: i cannot: Checking the Windows Application event log, i find the error: Login failed for user 'AVATOPIA\ian'. ...
2
votes
1answer
77 views

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
2
votes
3answers
1k views

Amazon EC2 MS SQL Instances

We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one - ...
0
votes
1answer
23k views

Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, ...
1
vote
0answers
93 views

Unable to configure SQL Server log shipping, latch error

SQL 2008 R2, SP1 CU8 both servers, next to each other in the rack, ~10 small databases (total under 50GB). I found that log shipping was broken (for a long time), rebooted secondary as a ...
-1
votes
1answer
37 views

Restoring From Another Dev's MDF on Same Database: MDF Cannot be Overwritten

Here is the situation: We have multiple developers. We want to import/export(restore/backup) .bak files whilst working on the same, but local, databases(Each dev has a local instance of DB: A). The ...
0
votes
0answers
277 views

Database mirroring issue - Both database is showing principal disconnected

My mirror database went down for a week and when i started it again. It was stuck in recovery disconnected mode. To fix the problem i misunderstood someone and ran the below command. ALTER DATABASE ...
0
votes
1answer
208 views

SQL Server 2008 Agent service wont start

We previously had SQL Server 2008 R2 Express to try some things out (I know it is by design that the agent service is disabled in this version) After proving the concept, we upgraded to the standard ...
2
votes
1answer
4k views

Connecting to SQL server instance on VM via host-only network

I've setup a virtual development machine with Windows Web Server 2008 R2 and installed SQL Server 2008 R2 Express on it as well. I didn't install any SQL tools on it, because I have them on the host ...
1
vote
1answer
231 views

SQL Server 2008 R2 connection sometimes fails with 'incorrect login'

As part of our testing suite, next to the Unit Tests which mock everything and don't require a database connection, we also have Integration Tests which do require a database. The Integration Tests ...