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

learn more… | top users | synonyms

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
51k 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
4answers
25k views

Permission denied when creating database in Sql Server 2008 express

Running the following (generated by Sql Server Management Studio) on Sql Server 2008 Express under Vista: CREATE DATABASE [test] ON PRIMARY ( NAME = N'test', FILENAME = N'c:\Program Files\Microsoft ...
0
votes
2answers
3k views

SQL Server 2008 R2 Enterprise won't install on Windows 2008 R2 Enterprise

I've been trying to install SQL Server on a new Windows Server 2008. I have tried everything but I haven't been able to narrow down the problem. When the installation fails I get " Exit code (...
2
votes
1answer
609 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
3answers
7k views

SQL 2008 R2 Named Instance Client Connectivity Issues?

We're upgrading our software from using SQL 2000 to 2008 R2. Our customers will be installing an update which uninstalls 2000 and installs 2008 R2 under the same instance. So if no instance existed, ...
0
votes
1answer
676 views

Error installing SQL Server 2008 r2 on Windows Server 2008 R2 Sp1

I am managing my dedicated server, here's what I did: Made a fresh install of Windows server 2008 R2 SP1 from the MSDN install ISO. Then added the web server role that turns on IIS. DONE! Then I ...
0
votes
1answer
1k views

In-Place Upgrade from Windows Server 2008 R2 to 2012

I realize that this might not be the best place to ask this question but I'm not sure which one of the StackExchange websites this question belongs to except for ServerFault. I currently have a ...
0
votes
2answers
2k views

SQL Server 2008 R2 memory limit per instance or server?

I'm getting ready to deploy a new SQL server and realized that the memory limit of SQL Server 2008 R2 is supposedly 64GB of RAM (http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx). ...