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

learn more… | top users | synonyms

0
votes
3answers
1k 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
584 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
6k 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
574 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 ...
6
votes
1answer
6k 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
31k 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
2k 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
186 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
3k 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 ...
2
votes
3answers
9k 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
8k 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
157 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
3k 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
127 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
96 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
1k 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
456 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
327 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
224 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 ...
6
votes
2answers
8k 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
681 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
514 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
212 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
115 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
575 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 ...
2
votes
1answer
3k views

SQL Server 2008 R2 - RAM = 128GB, PageFile = 192GB?

Is there a definitive guide for PageFile size on the latest 64-bit servers with large amounts of RAM? I've seen conflicting recommendations, and am wondering if the latest releases have changed the ...
4
votes
4answers
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. ...
0
votes
1answer
3k views

how remotely connect to sql server 2008-r2 installed on vps(virtual private network)? (firewall and sql server 2008 configs)

i have sql server 2008 r2 installed on a virtual private network (vps) with one ip valid ... my sql server instance info for connect on server(vps) is like below : server type: database engine server ...
0
votes
4answers
6k views

How to configure MS SQL Server 2008 R2 (login failed for user)?

I want to connect to database with such connection string: connectionString="Data Source=111.111.111.111;Initial Catalog=test;User ID=user;Password=password" So, I have default SQL Server ...
-1
votes
2answers
3k views

SQL Server: How to edit a view without scripting it?

How can i edit the definition of a view without having to "script" it in SSMS? The previous easy-to-use tools from Microsoft let me: Enter wait a moment Make change Carefully move mouse to large OK ...
0
votes
1answer
402 views

SQL 2008 R2 Active/Active/Passive Cluster Does Not Allow Linked Servers Both Ways

We are designing an active/active/passive failover cluster using SQL 2008 R2. We have two separate instances of SQL 2008: instance A is on node 1, and instance B is on node 2. Right now I'm trying ...
1
vote
2answers
951 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 ...
1
vote
2answers
770 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
2answers
451 views

How to migrate SQL 2005 to SQL 2008 R2 on new hardware with same server name

We have a need to migrate from existing hardware that is running SQL 2005 to new hardware running SQL 2008 R2. When all is said and done we want the same IP and hostname that was on the "old sql ...
0
votes
1answer
166 views

Audit Records queried from SQL Server 2008 (Database and Analysis Services)

I'm preparing a clinical data warehouse and I need to be able to audit the specific records that users query from either the relational database or the analysis services cubes. The key requirements ...
2
votes
1answer
367 views

Exceeding the DB size limit on SQL Server Express in READ_ONLY [duplicate]

Possible Duplicate: Can you help me with my software licensing question? If my database is larger than 10GB and I'm using it in READ_ONLY mode, will I be violating the licensing agreement ...
1
vote
1answer
2k 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 ...
0
votes
1answer
103 views

Need help creating server out of Personal PC for small project

I have a Software engineering project in the near future in which a couple of students will be working on. I would like to host the database and maybe a source control server on my Local PC with hopes ...
0
votes
2answers
491 views

Is there any way to view history of time-zone settings in Windows Server 2008?

One of our servers has been set with an incorrect time zone for months and it has affected some of our data in SQL Server. Is there any way to see when time zone settings were made on the server?
4
votes
1answer
8k 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 ...
0
votes
3answers
3k views

How to get the most out of sharepoint 2010 with sql express database size limit?

We have had a consultant set up a sharepoint 2010 server for us to use for document management. I believe it is just on the basic (free) sharepoint that comes with windows server. From what I ...
0
votes
1answer
643 views

I can connect to a server via named pipes with sqlcmd but a vendor tool is getting Named Pipes Provider, error: 40

I have a windows service running on my workstation that is part of a vendor supplied tool that connects to a database. It will not startup the error I get 4 errors in the event log with the following ...
1
vote
0answers
40 views

Sql Server 2008 R2 Web Edition - an administrators guide?

I've been hunting around on Google and have so far failed to find a book or online guide for how to administer and lock down Sql Server 2008 Web edition. Specifically I've come from 10 years of MySQL ...
0
votes
1answer
136 views

SSRS Data Driven Subscription empty destination folder

I have a SSRS Data Driven Subscription, the reports are save to a folder, I use the Overwrite Write Mode, however there are old reports that aren't generated anymore that lingers on the folder, I ...
0
votes
1answer
79 views

Question on SQL Server 2008 R2 Web with 1 processor MOLP

My client are considering getting the above mentioned SQL server license but I have no idea of what MOLP is actually. Before I say "OK, go ahead" to them, I want to know something: Is the SQL ...
1
vote
1answer
1k views

Minimum SQL login permissions for an AD domain group

I've created a web application that uses a SQL Server 2008 R2 database in the background. Application uses integrated security SSPI connection to database so users need granted access to database ...
0
votes
1answer
200 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
1
vote
1answer
418 views

Can only debug once

I can only debug a query once, after that I get this error and have to restart Management Studio. Unable to start T-SQL Debugging. Could not connect to computer '(local)'. The requested name is ...