Questions tagged [sql-server-2008-r2]
SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.
390
questions
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 ...
18
votes
1
answer
55k
views
How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?
I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
14
votes
1
answer
41k
views
Why is MS SQL Server Using NTLM Authentication?
Windows Server 2008 R2.
SQL Server 2008 R2 installed.
MSSQL Service runs as Local System.
Server FQDN is SQL01.domain.com.
SQL01 is joined to an Active Directory domain named domain.com.
The ...
13
votes
8
answers
78k
views
Can't login to SQL Server in Single User mode
I've been trying all sorts of different combinations of startup flags to SQL Server 2008 R2 Express and I can not get past this error:
Login failed for user 'LOCALSERVER\Administrator'. Reason: ...
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
...
11
votes
3
answers
208k
views
How to completely remove MS SQL Server 2008 R2 x64 which was uninstalled incorrectly?
On my Windows 7 Ultimate x64 I can't do anything with the existing instance of MS SQL Server 2008 R2. It was my mistake to uninstall some components related to SQL Server before running the main ...
9
votes
2
answers
30k
views
How to allow the local Administrator to have access to SQL Server?
One of our clients has an installation of SQL Server Express 2008 R2 that we more or less manage for them. Today I need to create a new database(a fairly rare occurrence). So I go to login as the user ...
8
votes
1
answer
19k
views
How to add a group to the sysadmin fixed server role in SQL Server 2008 R2?
How can i add a group to the sysadmin fixed server role in SQL Server 2008 R2?
See my related question for details step-by-step screenshots detailing showing that you're not allowed to add groups ...
7
votes
2
answers
61k
views
How to shrink 40GB LOG file
I have a problem that is my log file in SQL Server 2008 is grown to 40Gb and I wanted to shrink it. The query I am using is
ALTER DATABASE DatabaseName SET RECOVERY SIMPLE
use DatabaseName
GO
...
7
votes
1
answer
5k
views
Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?
Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?
Scenario is I have SQL 2008 R2 installed as a named instance MACHINENAME\...
6
votes
6
answers
37k
views
Can't connect to SQL Server 2008R2 on Windows Server 2008R2
I reinstall a server Windows Server 2008 R2, I installed SQL Server 2008 R2 no problem during installation. When I try to connect with "Microsoft SQL Management Studio" via sa account or Windows ...
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: ...
5
votes
4
answers
6k
views
Log Shipping to an Existing Database
We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial backup/...
5
votes
5
answers
16k
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 ...
5
votes
3
answers
28k
views
Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration
in the Console , SQL Server Configuration Manager
I get error 10048 when start sql service
and this in event history:
The SQL server service terminated with server-specific error. Only one usage ...
5
votes
2
answers
6k
views
Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?
I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still ...
5
votes
2
answers
3k
views
How quickly will SQL Server release RAM when the OS signals a low memory condition?
From the SQL Server 2008 R2 Books Online:
Server Memory Options
When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical memory. ...
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 ...
4
votes
4
answers
2k
views
Is there a performance advantage to isolating database logs and data on different volumes (same RAID array) across a SAN?
On my old server, I separated them on to different RAID arrays to improve performance. Using a SAN is new to me, so I'm not sure of the optimal configuration.
SAN: 48 drives. 10K 600GB SAS. RAID 50. ...
4
votes
5
answers
26k
views
Sql Server 2008 - Cannot connect to local default instance
I recently rebuilt my machine to Windows 7 x64, installed Sql Server 2008 enterprise. I can connect fine to other remote instances via Management Studio (be they 2000, 2005 or 2008), but i cannot ...
4
votes
2
answers
4k
views
How to change max server memory in SQL Server
I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter.
Now I can't even connect to the server.
Is there a ...
4
votes
1
answer
23k
views
SQL Server linked server: "Cannot start more transactions on this session."
i am trying to perform an INSERT operation against a linked server:
DBCC TRACEON (3604, 7300)
BEGIN TRANSACTION
INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, ...
4
votes
2
answers
251
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 ...
4
votes
3
answers
7k
views
How do I encrypt SQL Server traffic with IPSEC?
I've found all sorts of documentation on what IPSEC is and how to (in very non-specific ways) configure it, but I can't seem to configure a Windows Firewall With Advanced Security rule that both A) ...
4
votes
1
answer
3k
views
SQL Server Maintenance Plan: Rebuild Indexes and Transaction Log Backup File Size
In my nightly maintenance plan, I was doing everything - reorganising and rebuilding indexes, updating statistics, etc. There's an hourly maintenance plan that does a transaction log backup.
I ...
4
votes
2
answers
3k
views
MS SQL access to restored database without sysadmin role
I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
4
votes
1
answer
9k
views
Difference between "SQL server 2008 standard" and "SQL server 2008 standard for small business"?
There seems to be a big difference in price for these licenses, but after a lot of googling I can't find any info on how the two compare.
The blurb for the "small business" version is:
"This edition ...
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 ...
3
votes
4
answers
895
views
Implications of having IIS on SQL Server 2008 R2 machine
an application needs to have IIS on the same box of Reporting Services.
Today SSRS and SQL stay on the same clustered box.
I need to evaluate the options which for me are:
Installing IIS on both ...
3
votes
3
answers
86
views
Transferring SQL Server 2008 R2 tables/data from dev box to server
I'm nearing the end of site development, and am now facing transferring my table structure and data from my development machine to the live server. SQL Server 2008 R2 is already installed and ready ...
3
votes
2
answers
80
views
Can I create SQL v10.0 databases in SQL R2 server?
Is there a way to create non-R2 databases in an R2 database server? I was hoping to do this in the compatibility options during the database creation, but only options are available for 2005 and 2000. ...
3
votes
2
answers
5k
views
Cannot resolve the collation conflict between "SQL_Latin1_General_CP437_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
I'm trying to copy over a schema from one server to another, and I keep getting the following error and I have no clue where to start from to debug this issue...
Error 2 SQL01268: .Net SqlClient ...
3
votes
2
answers
305
views
Can I use a powershell script to install db/website when the database is separated from the webserver?
My boss is on vacation and I'm supposed to have this installation script done by the time he returns. Unfortunately, I've realized that the script I developed won't work on the target server setup and ...
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 ...
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 ...
3
votes
1
answer
6k
views
Tables in the SQL Server "master" database, will they cause problems?
Folks, please be kind on me... I'm just an 'accidental' DBA due to our DBA resigned, so I'm totally a newbie in DBA...
You see, I have this application, "ESET Remote Administration Server" (ERAS) ...
3
votes
1
answer
1k
views
Is SQL Management Studio 2012 avaliable, without Engine itself?
On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened.
Is it possible to get SQL Management Studio 2012 ...
3
votes
1
answer
10k
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 ...
3
votes
3
answers
6k
views
Does SQL Server 2008 R2 lock memory pages by default?
Does anyone know if the locked pages of SQL 2008 ENT R2 x64 operates as ON as default (I assume it does as my SQL memory usage does not show up in task manager) on Server 2008 R2 x64.
And if so, ...
3
votes
1
answer
4k
views
vCenter SQL Express Database Maintenence
After performing a simple install of vCenter 5.1 with all default chosen including the sql express database, what should we do to ensure continued operation without manual intervention?
Currently we ...
3
votes
1
answer
7k
views
KB2494088 Always Fails : How to get it to install (or stop trying to)?
I have a problem where KB2494088 (a SQL Server 2008 R2 patch) continually fails to install when I reboot my system. Downloading the manual patch and trying to apply it says:
The SQL Server patch ...
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 ...
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... ...
3
votes
2
answers
1k
views
Cloning a machine after SQL Server 2008 R2 Express installation
We're rolling out laptops to some of our staff that will require SQL Server 2008 R2 Express be installed. We'd naturally prefer to do the setup of the laptops (including the installation SQL Express) ...
3
votes
1
answer
5k
views
SQL Server mirroring refuses to work. Tearing my hair out
I'm trying to attempt what I thought would be a very simple process - the mirroring of a database between two MSSQL 2008 R2 servers within the same domain.
Both servers are configured similarly, and ...
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 ...
3
votes
1
answer
1k
views
SQL Server 2008 R2 Temporary Login Issue
We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling.
Last night, all web applications lost the ability to login to the database for 6 ...
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
5
answers
3k
views
SQL Server 2008 R2 transactional replication over VPN
I'm having difficulty setting up replication over a VPN.
I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server.
SQL Server is running on a non-standard port. I have ...
2
votes
4
answers
6k
views
What happened to IIS lockdown?
A long time ago before I left the Windows environment, there was such a thing as "IIS lockdown tool" - something that Microsoft provided for free. It was meant to well lock down your IIS instance and ...