Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server-2008-r2]

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

0
votes
0answers
6 views

sql server heterogeneous replication

We currently have the below replication setup in SQL Server & it is working fine. SQL Server 2008 R2 is both “Publisher” and “Distributor” too. Oracle database 11g release 1 is “Subscriber”. ...
0
votes
0answers
70 views

Big PREEMPTIVE_OS_GETPROCADDRESS issue

We have plenty of PREEMPTIVE waits (PREEMPTIVE_OS_GETPROCADDRESS exactly) on our SQL SERVER 2008 R2. This is the most predominant wait on server (among MSQL_XP wait), the root cause is because we have ...
0
votes
0answers
10 views

WMI query to Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases returns nothing

Something changed Windows Server that I cannot place. Our inventory system queries database servers and reports on basic database information. I use it to get an inventory of db names in the ...
1
vote
0answers
140 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 ...
0
votes
1answer
36 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....
0
votes
0answers
48 views

Where could a SQL Server shrink operation be hiding?

I've started using the Blitz scripts from BrentOzar.com to help me improve the SQL server instances that I manage. One of the message lines has me stumped. The message is to the effect of 'SQL ...
0
votes
0answers
76 views

SQL Server on Linux as Witness server

Is it possible to use SQL Server on Linux as a Witness server for SQL DB Mirroring? The infrastructure I am supporting was built with the Witness installed on DB2 and there is no money available ...
-2
votes
1answer
973 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 ...
1
vote
0answers
62 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 ...
-2
votes
1answer
304 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 ...
0
votes
1answer
48 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 ...
0
votes
2answers
279 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 ...
0
votes
1answer
10 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 ...
-3
votes
2answers
3k 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 ...
5
votes
2answers
91 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 ...
0
votes
1answer
66 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 ...
-1
votes
1answer
69 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
2answers
101 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 ...
1
vote
2answers
672 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
1answer
60 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 ...
0
votes
0answers
326 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
1answer
1k 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 & ...
2
votes
0answers
46 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
1answer
407 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 ...
1
vote
1answer
115 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: [...
0
votes
1answer
178 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
0answers
1k 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
3answers
19k 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
3k 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 ...
1
vote
0answers
54 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 ...
3
votes
1answer
2k 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 ...
0
votes
1answer
50 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 ...
2
votes
1answer
3k 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 ...
0
votes
1answer
4k 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 ...
3
votes
0answers
60 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
2answers
51 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 ...
-2
votes
1answer
38 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 ...
1
vote
0answers
65 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: ...
1
vote
1answer
71 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. ...
2
votes
1answer
530 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?
0
votes
0answers
4k 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 ...
1
vote
0answers
178 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
100 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 ...
1
vote
1answer
549 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 ...
0
votes
1answer
977 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
vote
0answers
169 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 ...
0
votes
2answers
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 ...
0
votes
2answers
106 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
-1
votes
1answer
181 views

Windows update 2919355 causes our SQL based app perf to drop to 1/6 of previous perf

We have a VB6 app calling out to a local SQL2008R2 instance. We have had complaints about it's performance dropping considerably. After a lot of experimental research, we have determined at least 1 ...
1
vote
1answer
546 views

Minimal required user permissions for running MS CRM

We have several M$ CRM instances running. Each one has its own dedicated SQL Server instance. The permissions are set up in accordance with the Microsoft recommendations for setting up MS CRM. ...