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

learn more… | top users | synonyms

1
vote
2answers
232 views

SQL2008R2 Server access to XML templates in IIS7

I'm in a jam. working on a migration project from SQL 2000 to SQL2008 R2 on a windows 2008 R2 box with IIS7 now installed. The old server had 3 simple virtual directories with XML templates installed ...
5
votes
1answer
5k 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 ...
1
vote
4answers
12k 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 ...
3
votes
4answers
23k 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'. ...
2
votes
1answer
303 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
4k 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
625 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
2answers
1k 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). ...