Tagged Questions

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

learn more… | top users | synonyms

2
votes
2answers
244 views

SQL Server 2008 R2 Cluster with HOSTS file entries to active node on the application servers

I questioned the decision of a colleague concerning the use of a HOSTS file entry on an application server (standard SQL database backed .NET solution), which I think would cause connections to the ...
1
vote
1answer
2k views

Do I need Windows CALs for a dedicated SQL Server database server? [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? This would seem an easy enough question, but I wasn't able to find any definite answer anywhere. If I'm running SQL ...
0
votes
1answer
345 views

exe hangs when scheduled from SQL Agent, but fine when run by user

I have a SQL Agent job on a clustered SQL 2008R2 server on Windows 2003 Enterprise. It's an Operating System (CmdExec) step, running an executable. When it runs on schedule, the process does start up, ...
2
votes
4answers
343 views

Data file size - SQL Server 2008

I am transferring a database that i made onto a server machine, but the size of the database is around 8GB, for some reason. It shouldn't be needing so much space as i only have a few hundred records. ...
2
votes
1answer
60 views

How to set up SQL Server to offer high availability during windows updates

We have a load-balanced web farm talking to a single SQL server instance. It is easy to demote web servers, install Windows updates, reboot, and then bring them back into the fold. However, we have to ...
3
votes
3answers
3k 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) ...
0
votes
1answer
2k views

SQL Server 2008 service pack installation error

When I am trying to install the SQL Server 2008 service pack I am getting the error as: There are no SQL Server instances or shared features that can be updated on this computer, and The version ...
0
votes
2answers
112 views

Backup for SQL & Server 2008 R2?

What's the best/easiest backup solution for my use case? Windows Server 2008 R2 Has a finance program called The Financial Edge (Blackbaud) that uses SQL Server 2008 R2 to keep its database Stores ...
4
votes
2answers
1k 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 ...
2
votes
0answers
387 views

SQL Server 2008 R2 mirroring failing

I have two Windows 2008 R2 (Amazon EC2) instances running SQL Server 2008 R2. I use 9TB striped disks (9x1TB EBS volumes) for storage. One server is running as principal and second one as mirror. Both ...
-4
votes
1answer
915 views

Does SQL Server 2012 Developer Edition exist? [closed]

On my server, I have SQL Server 2008 R2 Developer Edition installed, and setup don't want to upgrade it to SQL Server 2012 Express. Does SQL Server 2012 Developer Edition exist?
3
votes
1answer
631 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 ...
0
votes
1answer
286 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
245 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
435 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): ...
0
votes
1answer
147 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
424 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
1k 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
241 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 ...
5
votes
1answer
883 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
101 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
623 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
67 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
106 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
369 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
719 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
662 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
96 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
289 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
1k 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
2k 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
424 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
2k 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
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
469 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
4k 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
459 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 ...
4
votes
1answer
4k 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 ...
3
votes
4answers
20k 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
168 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
2k 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
6k 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
6k 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
141 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
95 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
1k 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
122 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
84 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 ...