Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

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
0 votes
0 answers
25 views

SQL Server 2008 R2 Nested Query with a Function

I am helping another SQL Server DBA with an issue they have with just a particular SQL Server 2008 R2 instance. I have run this query successfully on my own 2008 R2 instances, 2012 instances, etc. I'...
user avatar
0 votes
1 answer
144 views

SNMP and SQL Server, is it possible to store the alerts in sql server without using any program?

I have an old system (a legacy system) that reads SNMP messages and stores (somehow) them into a SQL server 2008 tables (or 2008r2). The system is working, however, I am clueless about how it stores ...
user avatar
-1 votes
1 answer
43 views

Are SQL Server Compatibility Levels Transparent to the Client?

I'm working with a client through the process of modernising their old server infrastructure. They have left a McAfee ePO instance for too long without upgrading and we are now dealing with an ...
user avatar
0 votes
2 answers
31 views

MS SQL 2008 R2 disaster restore

I need to restore an MS SQL 2008 R2 server. The original server was completely destroyed, nothing to salvage. Yet there is backup of all data, plus system databases, master, msdb, model; .bak files. I ...
user avatar
  • 1,529
0 votes
1 answer
74 views

Upgrade to SQL Server 2017 from SQL Server 2008 R2

I want upgrade my server to SQL Server 2017 from SQL Server 2008 R2(version 10.50.1600.1) but upgrade rules failed on SQL Server 2008 R2 Service Pack3 or later is required this error Installing SQL ...
user avatar
1 vote
0 answers
30 views

MS SQL 2008R2 Peer-to-Peer replication Zombie data

We have two SQL 2008R2 boxes - each in a geographically separate data center - that stay sync'd using peer to peer replication (with a pair of smaller boxes acting as replication providers). This ...
user avatar
0 votes
0 answers
254 views

Cant connect to SQL Server 2008 from Window XP SP2 But work fine with SP3 and 7 and above?

Yesterday our windows server 2008 R2 Updated after 7 years! After that our Windows XP SP2 and Lower clients reported that the ERP software cant connect to server! But Windows 7 and above clients ...
user avatar
0 votes
1 answer
340 views

What to do with an old windows 2008 r2 server with old windows updates

I have an old windows 2008 R2 (SP1) server that hasn't had a windows update installed in a long time. We've ran out of space (less than 4 GB) and would like to clean up old windows updates to free up ...
user avatar
2 votes
0 answers
353 views

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL ...
user avatar
0 votes
1 answer
59 views

Need to add a login to a database for SSMS (Sql server) 2008 r2

I need to add a login to a database for SSMS (Sql server) 2008 r2 There is an answer to a very similar question here: How to add users to SQL Server 2008 Management Studio: https://stackoverflow....
user avatar
-2 votes
1 answer
5k views

sql server can't start error code 1814

My pc can't start sqlserver 2008 R2. this is my sql server errorlog 2018-05-02 16:32:47.26 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright ...
user avatar
  • 11
1 vote
0 answers
93 views

SQL Merge Replication Triggers Missing

In MS SQL Server 2008R2 SP3 Standard, I'm seeing an issue where reinitializing a merge publication with a new snapshot deletes all of the merge triggers from all of the tables, and then when snapshot ...
user avatar
  • 58
-2 votes
1 answer
436 views

I need to fully automate sql server restores , PLease help me

I'm New to Sql server and dont have experience in automate restores I need a script to restore a database from a .bak file and move the logical_data and logical_log files to a specific path. I can ...
user avatar
0 votes
1 answer
285 views

Unable to get SSRS 2016 to send subscription emails

I'm having an issue with sending reports via email on SSRS 2016 So basically I have a VM on the Azure platform configured as an SQL server. SQL01 (Windows 2012 Server) + SQL SERVER 2008 R2 + SQL ...
user avatar
  • 151
0 votes
1 answer
376 views

SQL: server 2008 database stuck in Restore

I have two SQL Server 2008 R2 servers one for PROD and the other for DR. I am trying to add log shipping for a database called School. Steps so far Back up School database Restore with database ...
user avatar
0 votes
1 answer
13 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 ...
user avatar
  • 63
-2 votes
2 answers
5k 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 ...
user avatar
  • 101
4 votes
2 answers
202 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 ...
user avatar
  • 217
0 votes
1 answer
110 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 ...
user avatar
-1 votes
1 answer
187 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.
user avatar
0 votes
2 answers
103 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 ...
user avatar
1 vote
2 answers
848 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 ...
user avatar
  • 170
0 votes
1 answer
126 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 ...
user avatar
  • 35
0 votes
0 answers
426 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 ...
user avatar
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 & ...
user avatar
  • 3
2 votes
0 answers
63 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 ...
user avatar
  • 1,097
0 votes
1 answer
693 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 ...
user avatar
  • 4,767
1 vote
1 answer
309 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: [...
user avatar
0 votes
1 answer
291 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) ...
user avatar
  • 1
1 vote
0 answers
2k 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 ...
user avatar
2 votes
1 answer
48k 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 ...
user avatar
  • 163
0 votes
1 answer
5k 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 ...
user avatar
1 vote
0 answers
59 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 ...
user avatar
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 ...
user avatar
0 votes
1 answer
52 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 ...
user avatar
2 votes
1 answer
5k 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 ...
user avatar
  • 23
0 votes
1 answer
6k 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 ...
user avatar
  • 111
3 votes
0 answers
65 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 ...
user avatar
  • 447
0 votes
2 answers
53 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 ...
user avatar
-2 votes
1 answer
41 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 ...
user avatar
1 vote
0 answers
69 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: ...
user avatar
1 vote
1 answer
93 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. ...
user avatar
  • 302
2 votes
1 answer
800 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?
user avatar
0 votes
0 answers
6k 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 ...
user avatar
1 vote
0 answers
255 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 ...
user avatar
  • 53
-1 votes
1 answer
385 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 ...
user avatar
  • 97
1 vote
1 answer
590 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 ...
user avatar
  • 133
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 ...
user avatar
1 vote
0 answers
233 views

MSSQL application failing to connect to database server

We run a very old application that connects to an MS SQL server 2008 database using the SQL server native client 10. Sometimes if there has been a power failure with the server the clients will stop ...
user avatar
0 votes
2 answers
2k views

SQL Server 2008 R2 does not utilize allocated memory

Our app runs on a server with 4 core CPU, 8GB RAM and Sql Server 2008 R2 Standard Edition (10.50.1600.1), 64 bit. Server dedicated to Sql Server, no other heavy service is running. We've set min/max ...
user avatar

1
2 3 4 5
8