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

learn more… | top users | synonyms

0
votes
1answer
510 views

SQL Server tempdb performance

I have been doing some .net performance tests on a bunch of different data access frameworks. One of the things I've noticed is that performance when accessing the tempdb table in SQL is much ...
1
vote
1answer
316 views

Will a SQL Server client alias survive a sysprep?

I want to sysprep a Windows Server 2008 R2 SP1 machine that has SQL Server 2008 R2 SP1 installed (for reference, SQL Server 2008 R2 has a new sysprep feature that allows the instance to be ...
2
votes
2answers
685 views

SQL Browser service doesn't work when Login account is anything but LocalSystem

I have a named instance of SQL Server 2008 R2. When I attempt to connect to the named instance I get the following error (if the browser service is set to logon as anything other than Local System): ...
1
vote
0answers
323 views

Unable to establish connection

I have some previous experience with MS Access and VB6 but very new to SQL Server and VB10 so need newbie responses please. I Think SQL Server compact is automatically installed with VB10 but I also ...
0
votes
1answer
151 views

Reverse tunnel with 4 participants (really a mess)

I have a server (Win 2008) and a desktop PC (Win 7) at my work behind a firewall. The server doesn't has internet connection for security (actually, it is in a remote datacenter), and the desktop PC ...
1
vote
1answer
814 views

Adding a linked server via Powershell

I'm trying to add a linked server to my local SQL Server 2008 R2 setup from within a Powershell script. Here's what I've been trying so far (and variants): EXEC master.dbo.sp_addlinkedsrvlogin ...
5
votes
2answers
2k 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 ...
1
vote
1answer
324 views

SQL2008 Max Memory set to 10GB, Target/Total perfmon counters report it's using 1.6GB. What's up?

Running SQL2008 R2 32bit on Windows Server 2003 Enterprise with 12GB of RAM. Inside the Memory settings of the SQL instance I've got max memory set to 10000MB but it isn't going past 1.6GB according ...
6
votes
1answer
2k 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 ...
1
vote
1answer
157 views

Why does SQL Server Management Studio fail to connect on the first attempt?

When accessing SQL server on a remote development PC via Management Studio the connection will consistently fail on the first attempt. After the failure I retry and can now successfully connect to the ...
1
vote
2answers
3k views

SQL Server stops regularly on every windows restart

Edit 3 & 4 Added Although the SQL Server instance is set to run automatically and TCP also is enabled in its Network Configuration, the SQL Server is stopped after each system restart. I have to ...
0
votes
2answers
70 views

MSSQLSERVICE 2008 R2

I have Microsoft SQL Server 2008 installed and running but I can't seem to see COMPUTERNAME/MSSQLSERVICE at all. I have COMPUTERNAME/SQLEXPRESS but that's not the right one. Ideas?
0
votes
1answer
111 views

Cannot resolve cluster resources on EC2?

I have created this cluster on Amazon's EC2 service. I can connect to the sql instance from the first node (there is only one node in the cluster at this time) using the cluster name, so I know that ...
2
votes
1answer
483 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
2
votes
1answer
1k views

How can I assign more than 2GB memory to my SQL Server 2008 R2 Web Instance?

I have a Windows 2008R2 Web server running SQL 2008R2 Web 64-bit. The server has 8GB of memory installed. See this from SSMS: In the SSMS management interface, I am unable to configure the server ...
2
votes
1answer
1k views

How to Configure SQL Server 2008 R2 Log Shipping

I need to set up a standby server using SQL Server Log Shipping. This is my first time doing this, so I'm following the instructions in the SQL Help step by step. Of course, I ran into a problem at ...
2
votes
2answers
137 views

Timeout in connection to a SQL Server instance in LAN

From one windows 7 machine I cannot connect anymore to any sql server instance that is in LAN and in same domain of this particular machine. I cannot connect from Management Studio, but also from any ...
1
vote
1answer
400 views

Remote Performance Monitoring SQL Server

I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor). On my machine, I have an instance of SQL Server ...
2
votes
1answer
2k views

SCCM 2007: I've moved my site database, how do I now delete the old site system?

I have a small SCCM 2007 installation. It has two 'site systems', the primary site system (SCCM01) and the database server (OLDSQL). For maintenance reasons, I had to migrate the database onto a new ...
2
votes
1answer
4k 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 ...
0
votes
2answers
534 views

SQL Server 2008 Web edition - access from another IIS?

We are planning to purchase and install SQL Server 2008 R2 Web edition for our live servers. The grand plan was to install a shiny new server with this SQL Server (web edition), and change the ...
1
vote
1answer
3k views

SQL Server 2008 R2 Writing To Text File

I used to write to text files from SQL Server using the code listed below: DECLARE @FS INT --File System Object DECLARE @OLEResult INT --Result message/code DECLARE @FileID INT ...
0
votes
1answer
495 views

Clarrification for SQL Server Express 2008 R2 on CPU limit (CPU based on core based)

I'm aware that SQL Server Express 2008 is having few limitations on the database size and the CPU utilization. In MSDN documentation it was mentioned on the express edition would use only one CPU. I ...
0
votes
3answers
2k views

Interpreting SQLIO test results

I've been running a series of load tests on a dedicated DB SAN from a pre-production cluster (Dell R710 connecting to a dedicated RAID10 SAN over 2 gigabit ethernet connections), and I'm not sure if ...
1
vote
2answers
671 views

Upgrade sql server 2008 to 2008 R2, in-place upgrade or new install

When upgrading we normally create a new install and migrate databases over, but we are going to test out in-place upgrade from sql server 2008 to sql server 2008 r2 (standard) in our development ...
2
votes
3answers
8k views

Filegroup cannot be removed because it is not empty error with no files

When I try to remove 'MYFILEGROUP', I get the error that the filegroup cannot be removed because it is not empty. I already removed all tables, indexes and deleted all files associated with the group. ...
0
votes
1answer
759 views

What happens when Mirror times out with Principal, but Principal does not timeout with Witness or Mirror?

We have three SQL server 2008 r2 servers (principal, mirror and witness) setup for mirroring (with safety option). I see in the Mirror server logs that there was a "The mirroring connection to ...
7
votes
1answer
10k 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 ...
4
votes
5answers
49k 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'. ...
1
vote
3answers
3k views

SQL Server 2008 R2 Clustering inside VMware

I am working on a new Windows 2008 R2 / SQL Server R2 HA cluster and we are planning on running this inside of VMware ESX 5. I have read and heard differing views on using SQL clustering inside of ...
0
votes
1answer
207 views

Reconnect dbo to login SQL Server

I've got a SQL Server 2005 Express database on a Vista system (DotNetNuke) with the dbo user connected to a login of foo. This is the account that DNN uses to log in to the db. I made a backup of ...
1
vote
4answers
4k 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 ...
4
votes
3answers
15k 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: ...
5
votes
2answers
11k 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 ...
0
votes
1answer
191 views

SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark ...
0
votes
1answer
97 views

SQL Server 2008 R2 Licensing [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I want to add a named instance of SQL Server 2008 R2 on one of the server. Server already has 2 named instances on ...
2
votes
3answers
5k views

How can I make my SSIS process consume more resources and run faster?

I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports. I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server ...
1
vote
1answer
2k views

SqlServer 2008R2 sp1 CHECKDB crashes when spatial index present

We've been having an issue with DBCC CHECKDB crashing with an access violation (null pointer deference) on Sql Server 2008R2 when spatial indexes are present. It is repeatable with DBCC CHECKDB WITH ...
-1
votes
2answers
138 views

How to Redirect and do not Display the real source url address

How can I use host http://192.168.2.27 but my back end will display http://192.168.2.21? Sample: When i type www.google.comin my browser, I want it to go to wwww.yahoo.com but the url address will ...
1
vote
2answers
97 views

Sql Server 2008 R2 connection error

I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client. But it shows the following error: cannot connect to SMSERVER\SMTECH How ...
2
votes
1answer
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 ...
0
votes
1answer
566 views

Can't reset sa password

I am trying to drop and recreate sa account to reset the password. IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sa') DROP LOGIN [sa] GO I am getting an error Cannot use the ...
2
votes
3answers
339 views

Scaling Out SQL Server 2008 R2

I am looking into the possibilities of how to scale out the sql server 2008R2. simply scaling up wont be enough. "p2p replication" and "distributed partitioned views" look interesting, but both ...
-1
votes
1answer
230 views

Fresh install of SQLSERVER 2008 r2 Express, what's my server name? [closed]

See this image: http://imgur.com/WxAQc It's a fresh Win7 install, fresh 2008 r2 install. For the life of me I can't work out what to enter as server name, I've tried: TOM Localhost SQLEXPRESS ...
8
votes
3answers
13k 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 ...
0
votes
1answer
967 views

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial ...
2
votes
1answer
580 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) ...
1
vote
1answer
276 views

SQL Server 2008 R2 Backup

I see this error message in log BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages. SQL Agent is disabled. I never issued backup ...
1
vote
2answers
121 views

using win7 pc instead of windows 2003 server

Simple question, in terms of hosting an Asp.net-mvc/SQL Server 2008 R2 Express based app, will a powerful Windows 7 PC do? I just wonder if there is anything I'm missing here, being an App Dev and not ...
3
votes
4answers
759 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 ...