Questions tagged [sql-server-2008-r2]
SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.
390
questions
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 ...