Questions tagged [sql-server-2008-r2]

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

Filter by
Sorted by
Tagged with
3 votes
1 answer
3k 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 ...
3 votes
1 answer
4k views

SQL Server Report Services Not Configuring

This is kind of Frustrating as I know I am doing everything right, however SQL Server Reporting Services are not configured: To Configure I did these following steps Opened Reporting Services ...
0 votes
1 answer
29 views

I used the MSSQL Copy Databse Wizard to schedule a copy, how do I cancel it?

Thank you for taking the time to read this. I thought the wizard would be a good idea, but further discussion revealed that the backup/restore method of moving the database would be preferable. Now I ...
-2 votes
2 answers
6k views

how to update SQL Server 2008 to 10.50? [closed]

I have windows server 2008 r2 running SQL Server 2008 version 10.0.1600.22 Enterprise Edition (64-bit), and i want to update it to 10.50. i tried to install MSSQL Server SP1 and i got the following ...
4 votes
2 answers
247 views

Build mirroring on top of SQL2008R2 SQL cluster

On our SharePoint 2010 farm, we are using SQL 2008 R2. Currently, a SQL cluster (with 2 SQL server sitting at same data center) is built to provide auto-failover. However, it has no DR ability. We ...
1 vote
1 answer
3k 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 ...
0 votes
1 answer
4k 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
1 answer
151 views

Need to reset the SA password on our SQL 2008 R2 server. Will it break things?

Sorry for the very basic question, but I have discovered that our SQL Server 2008 R2 server (OS is also Windows Server 2008 R2) has a weak password for the "SA" account. I need to reset it ASAP, but ...
13 votes
8 answers
62k 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 ...
-1 votes
1 answer
499 views

Does Microsoft SQL Server 2008 R2 Service Pack 1 install the SQL Server?

Does the SQL Server 2008 R2 Service Pack 1 include the SQL Server when you install it? Cause after a long online search couln't found the answer.
0 votes
2 answers
111 views

Server 2008 R2 Replication Small Issue

I have two 2008 R2 Servers. When I Connect those two Servers By Name, I Can Use Replication. But When I Connect This Two Servers By IP Address, I Can't Use Replication. I Get Error Like: SQL ...
0 votes
1 answer
334 views

Setting up Windows Server 2008 R2 and SQL Server 2008 on a VPS

I wish to deploy trusted apps in a secure way. I got one empty VPS (with no operating system). But I don't know how to install Windows Server 2008 R2 (Enterprise/Datacenter) and SQL server 2008 (...
0 votes
1 answer
7k 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 ...
1 vote
2 answers
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
1 answer
160 views

Added SQL Server 2008 R2 to domain, can't send email

I had a standalone machine running SQL Server 2008 R2 that I joined to a domain. I set up an MSA and set all of the SQL services to log in under it. I can access the DB remotely and run queries, but ...
1 vote
2 answers
1k views

Issue installing SQL SERVER EXPR 2012/2016 on Server 2012 R2

I have been running SQL SERVER Express 2008 on Server 2012 R2 for some time. I recently began researching the migration process to move to SQL SERVER EPXRESS 2016. Because the original DB was migrated ...
0 votes
0 answers
481 views

2008 R2 SQL Server on AWS, CPU spikes every three hours

I have a Windows Server 2008 R2 virtual machine in Amazon EC2, running SQL Server 2008 R2. Every three hours, like clockwork, the server's CPU usage will spike to 100% for about 10 minutes or so, to ...
0 votes
1 answer
3k views

Accessing Mysql Database through ssh tunnel in SQL Server

I've had a look around for an answer to this online without much luck. I want to connect a MYSQL Database to SQL Server Management Studios through a ssh tunnel ODBC connection. I have usernames & ...
0 votes
1 answer
387 views

What are some recommended training resources for Windows Server 2008, IIS 7.5 and SQL Server 2008 R2?

My employer is starting a project to migrate one of our application server stacks from an open-source stack based on JBoss and PostgreSQL on Linux to a Microsoft stack powered by IIS 7.5, SQL Server ...
2 votes
1 answer
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 ...
24 votes
3 answers
46k 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 ...
3 votes
2 answers
12k views

Looking for robocopy ipg number

I have a robocopy job that creates a problem every time it runs. It saturates the bandwidth in such a way that no other traffic can get through. I read about the /IPG flag but am going in circles ...
1 vote
2 answers
5k views

sql server cluster - "the given network name is unusable" error in creation wizard

I'm trying to create a sql server 2008 R2 cluster. I've got two windows machines running server 2008 that are clustered and have all passed the validation tests etc. I'm now going through the "...
5 votes
4 answers
6k 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
1 answer
1k 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
0 answers
68 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
1 answer
350 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
1 answer
427 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: [...
4 votes
2 answers
9k 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
1 answer
6k 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
0 answers
3k 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
1 answer
55 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
1 answer
479 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
2 answers
6k 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
1 answer
819 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 ...
3 votes
0 answers
67 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 ...
1 vote
2 answers
57 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 ...
1 vote
0 answers
3k 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 ...
-2 votes
1 answer
44 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
1 answer
87 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
1 answer
36 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
1 answer
98 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
0 answers
72 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
2 answers
3k 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 ...
6 votes
5 answers
69k 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'. Reason: ...
2 votes
1 answer
997 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
3 answers
2k 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 - ...
1 vote
0 answers
267 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
1 answer
486 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
1 answer
1k 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 ...

1
2
3 4 5
8