Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008-r2]

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

SQL Server 2008 R2 was released to manufacturing on April 21, 2010. SQL Server 2008 R2 adds certain features to SQL Server 2008 including a master data management system branded as Master Data Services, a central management of master data entities and hierarchies.

SQL Server 2008 R2 includes a number of new services, including PowerPivot for Excel and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, Reporting Services Add-in for SharePoint, a Data-tier function in Visual Studio that enables packaging of tiered databases as part of an application, and a SQL Server Utility named UC (Utility Control Point), part of AMSM (Application and Multi-Server Management) that is used to manage multiple SQL Servers.

The first SQL Server 2008 R2 service pack (Service Pack 1) was released on July 11, 2011.

390 questions
-1
votes
2 answers

SQL Server 2008 R2 installation hangs

On a freshly installed Windows Server 2008 R2 Standard SP1 I am installing SQL Server 2008 R2. After configuring setup, install starts, but then it will hang on: Install_sqlSupport_KatmaiRTM_Cpu64_Action: InstallFiles. Copying new files. What…
Sam
  • 909
  • 5
  • 15
  • 28
-1
votes
1 answer

SQL Server 2008 R2 remote connection

I am having problems making my ms sql server 2008 take remote connections, local workes fine. I have enabled the TCP/IP and the server browser server in the sql server config I have opened the ports in the firewall, have also tried shutting it…
Androme
  • 411
  • 2
  • 6
  • 12
-1
votes
1 answer

Difference between SQL Server 2008 Express and Workgroup in regards to CAL's

I am currently using SQL Server Express edition, and am thinking of upgrading to SQL Server Web or Workgroup edition. My question is what restrictions will I experience with the introduction of CAL licensing
Dustin Gamester
  • 101
  • 2
-1
votes
2 answers

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 not display the www.yahoo.com. I think I can…
meloi
  • 31
  • 1
  • 1
  • 3
-1
votes
1 answer

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

See this image: https://i.stack.imgur.com/dpj52.jpg 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 All fail. Can someone help me? Also, in…
Tom Gullen
  • 385
  • 4
  • 8
  • 24
-1
votes
1 answer

Are SQL Server Compatibility Levels Transparent to the Client?

I'm working with a client through the process of modernising their old server infrastructure. They have left a McAfee ePO instance for too long without upgrading and we are now dealing with an unsupported upgrade path. As part of this modernisation…
Jesse Wyatt
  • 3
  • 2
-2
votes
1 answer

sql server can't start error code 1814

My pc can't start sqlserver 2008 R2. this is my sql server errorlog 2018-05-02 16:32:47.26 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition…
j_nug
  • 11
  • 1
  • 1
-2
votes
1 answer

I need to fully automate sql server restores , PLease help me

I'm New to Sql server and dont have experience in automate restores I need a script to restore a database from a .bak file and move the logical_data and logical_log files to a specific path. I can do: restore filelistonly from…
DBA_Fresher
  • 1
-2
votes
2 answers

how to update SQL Server 2008 to 10.50?

I have windows server 2008 r2 running SQL Server 2008 version 10.0.1600.22 Enterprise Edition (64-bit), and i want to update it to 10.50. i tried to install MSSQL Server SP1 and i got the following message "the are no sql server instances or…
Saad
  • 101
  • 1
  • 5
-2
votes
1 answer

Seting local MSSQL Server as Database Server

I have my web site hosted at EC2 server. If I want to give user an option to use their local MSSQL server, so how can I configure that. First of All, Is it Possible? Do I need Static IP? How to configure an Firewall? For Example pinging: "static IP…
10K35H 5H4KY4
  • 119
  • 1
  • 9
-2
votes
1 answer

Which is easier to configure Replication for: MySql 5.5 CE vs SQL Server 2008r2 Express?

As the question states, which server is easiest to setup replication for? My needs are: A local master and a remote (VPN connected) slave. I am no where near expert in either database so which would be the easiest to configure and maintain? Also…
Robert H
  • 101
  • 4
-2
votes
2 answers

What replication should I use for my Sql Server

We have a dedicated server that will host our client's database for a web portal. To connect to this database, you need an ip address. I figured I'd try Merge Replication since I already have the snapshot Publication on the server done. When I…
ErocM
  • 226
  • 7
  • 23
-2
votes
3 answers

Does SQL Server 2008 R2 Express expire?

Q: Does SQL Server 2008R2 expire? What happens is: My pages crash out of the blue I cannot connect with mgmt studio or query analyzer with previous setup. When i go to the server and try the management studio installed there it says it's…
nwarner-jvc-com
-3
votes
1 answer

Does SQL Server 2012 Developer Edition exist?

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?
abatishchev
  • 541
  • 1
  • 9
  • 31
-4
votes
1 answer

Setup network between 2 computers connected using wifi

In my office I have a WiFi Router that allows 2 computers to connect to Internet. I have 2 questions - How can I create a network between these 2 computers for file sharing? Can I access SQL server installed on 1 computer from 2nd computer? If…
Nitesh
  • 103
  • 1
  • 8
1 2 3
…
25
26