.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server on Win Server 2008R2

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I have a wcf service that reads and writes data from a sql server mdf file. On this remote machine(windows server 2008r2) there will be many copies of that mdf file(all with same name)but in different folders for different users. Each users PC and windows phone app can connect to their own folder for data. Right now I have only one mdf file for testing and it is attached in SQL server. However when I tried to attatch a second one it sql server says it can't because it says databse of the same name already exists.

 How can I set this up on the remote machine SQL Server 2008  to work?

Thanks Jon

Thank You Jon Stroh

View Complete Post

More Related Resource Links

best practice SQL Server 2008R2 setup on 3 drives

Hi, I have read best practice lists for setting up SQL Server, but I don't have enough available drives to meet the optimal setup. I have 3 drives and below is how I plan on using my 3 drives: C (30GB) - Windows 2008 OS and SQL Program Files E (120GB) - SQL Master/Model/TEMPDB/MDF Files F: (60GB) - SQL LOG Files   Should I configure the above different?

Problem Installing SQL 2005 Enterprise on Server 2008R2 Enterprise???

I am trying to install SQL Server 2005 Enterprise onto a new WinServer Enterprise 2008R2 box.  I am using my MSDN disk that contains the various flavors of SQL Server 2005.  When I select to install Enterprise (64 bit) version all that is available for installation are the client tools, no server tools.  When I install the Standard version, the server tools are available. Is there a problem installing SQL 2005 Enterprise on WinServer Enterprise 2008R2???

Cannot Connect to SQL server with SQL 2008R2 enterprise On windows server 2008R2

I have 2 identical brand new servers Running Windows Server 2008 R2 not on a domain but simple LAN. I Installed a default instance of SQL server 2008 R2 enterprise on each one with all the default settings. No Problems during the Installaion. I Added the Windows Administrators Group and Users group to the SQL admins role during the SQL Server Installation. Remote connections are enabled on each server. I restored the same database from a copy on each Installation. Configured the user accounts on each maching and made them sysadmins and granted permissions where they were needed. Now from server A when i try to establish a connection to Server B from SQl server Management Studio I get An error stating that the server was not found or accesible. keep in mind i can \\server B\c$ and vice versa, named pipes are enabled. I have never had this problem before in my life. And it's happening on both servers. I really need each installation of SQL to be able to see the other remote installation as i have to create a mirror. -Chris

Error Enrolling Instance In Utility Explorer SQL Server 2008R2

When I try enrolling an instance the enrollment errors with "The collection sets on the specified instance of SQL Server must be stopped." I have stopped all the collection sets in various manners including disabling the scheduled job, all with no success. Any suggestions as to what else I can check? I have successfully enrolled another instance on the same server. Thanks!  

SQL server 2008R2 install on a server 2008 R2 failover cluster. Other resources won't failover to o

As the subject says, I've built a fresh install w2k8r2 and sql2k8r2 failover cluster. Sql works fine on the primary node, but when I test a failover it breaks. Specifically, if I were to stop the node1 cluster service (causing the cluster to switch to node2), windows changes the cluster DNS appropriatly and moves the shared storage just fine, but sql server doesn't failover.  Server Name, Disk Drives and Other Resources all go offline. I've verified that the advanced policies of the server name, IP, cluster drives all have both nodes checked as possible owners However, Other resources only lists node1 as a possible owner and there appears to be no way to add node2.  Under the Other resources, SQL Server and SQL Server Agent are listed. I'm sorta stumped, I've been combing the forums and have found similar issues, but nothing seems to explain why the two resources won't failover.

Install App that uses .NET Framework 4 and SQL Server 2008R2 Express (with Tools) - what .NET Framew


I am a little confused about how to install my application.  Written in C# using VS 2010 and targeted for the .NET 4 Framework.  It also uses a SQL Server 2008 R2 database.

In my installer I install .NET 4 Framework if not already present on the host machine.

For SQL Server 2008 R2 (with Tools) I understood I need Installer 4.5 and Powershell 1.0.  The install of install of 4.5 installer goes ok but requires a reboot.  The install of Powershell says it needs .NET Framework 2 SP2 - even tho' .NET 4 is installed.

I decide to ignore this and carry on so manually install SQL Server 2008 R2 Express (with Tools).  It unpacks and complains it needs .NET Framework 3.5 SP1!

My application has to deploy to a disconnected machine installed in the cab of a logging harvester so I can't rely on automatic wwindows updates.


To deploy my app with SQL Server 2008 R2 (with Tools) do I need ...

  • .NET Framework 2.0 SP2 and
  • .NET Framework 3.5 SP1 and
  • .NET Framework 4



I had presumed all I would would be .NET Framework 4 since it is "mostly" backwardly compatible.

Install time and complexity is HUGE is I need all three Frameworks.


Can someone please clarify for me?




SQL SERVER 2008R2 concatenation of CAST causes timeout



In my company, somebody wrote stored procedure that works with MSDE and doesnt work with sql server 2008R2. With 2000 it takes few seconds and with 2008 there is a timeout after 600 seconds.

This is a part where I isolated the problem:


(SELECT TOP 1 MovementHeaderId

FROM MovementHeader )

FROM RetailTransactionLineItemExtended




FROM  Movement


MovementTypeCode ='SALE'


DocumentReferenceTypeCode ='TRANSACTIONLINE'

AND DocmentReferenceCode = cast(RetailTransactionLineItemExtended.TransactionOriginalTransactionID as varchar(20)) +'/'+    cast (Ordinal as varchar(20) ))

And IsPetrol=0


New installation of SQL Server 2008R2 -Giving time out error


Hi all

I did side by side installation of SQL Server 2008 R2 RTM with no CU and I given a Alies name to the installation,until now applications working fine.Yester day SAN storage devices(iSCSI) are upgraded with new software.

after that I am getting an error

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)"

action required I found in Microsoft site is "Make sure that you have configured the firewall on the server instance of SQL Server to accept connections"

realy I don't know where I have configure this setting Please some help regarding

Thanks in Advance


Is it possble to create Active-Active Cluster in SQL Server 2008R2


Hi All,

Another question...
I am new to SQL Clustering.

Can we create Active-Active cluster on SQL Server 2008 R2 Server, which will be having facility to loadbalancing Databases on Clustered Hardware, i.e. some Databases will be on SQL_Cluster_Host_A and Some will be on SQL_Cluster_Host_B.

Or is there any way to configure the above thing?


SQL_Cluster_Host_A will host Database 1, and SQL_Cluster_Host_B will host Database 6,7,8,9,10.
When Host A will fail all DBs will goto Host B, and vise versa.


Error when synchronizing a 2008SP1 Database with a 2008R2 database using Microsoft SQL Server Manag


I am trying to synchronize two databases and getting the below error.  I am using Microsoft SQL Server Management Studio 2008 to sync the two databases.  One of the databases is running Analysis Services 2008SP1 (the source) and the other is running Analysis Services 2008R2 (the destination).  I have tried the Microsoft SQL Server 2005 Backward Compatibility tool and that did not work.  My thought is that the different versions are causing a conflict.  The surprising thing is that it appears to be working and then fails.  Keep in mind I am using an administrator account.  Can someone please advise?

Thanks,  A.L.

Total Size=20563KB

Errors in the OLE DB provider. The server returned the following error

SQL Server 2008r2 Best Practice Analyzer report error


Hi All,

recently I was playing with SQL Server 2008r2 BPA. I have installed Baseline Configuration Analyzer in my workstation and my server has BPA installed.

Now when ever I try to run analysis on my workstation. I always get following errors,

1. User is not a member of Administrators group on remote machine, OR

2. Powershell Remoting is not Enabled on Remote Server


Now I am sure that I am Admin of that server machine and I have enabled the PS Remoting (because when I try to rerun the commands to enable remoting in PS it says it is enabled). Also, I can run BPA on my server if I run it locally (by logging into the server m/c).

If any one has any suggestion, I will really appreciate it.



HELP! Upgraded web db to 2008r2 Web. DTS job on master server now broken


Hi. I had 2 SQL Server 2000 Standard servers. 1 was a master server, the second was the web server. there was a DTS job on the master server that coppied specific tables from the master to the web server.


We recently upgraded the hardware and decided it would be a good time to try upgrading the SQL server... however we were jjust going to start with the Web server.


I have installed SQL Server 2008r2 Web edition on the web server, the master server still has Server 2000 standard.


The DTS job cannot connect. 


I tried to create a SQL Server Agent job, and configuring a Multi-server configuration with a Master/Target role, but I keep getting errors. If I try to set it up on the master server, I get an "Access Denied" message from the target server (2008r2 web) If I try to configure from the target server, I get a "Login failed for user (null)" despite the fact that the connection used to the master server is done with SQL Auth using the dbo account.


So then I linked the web server to the master server in Server Objects. And I tried to build a "Insert into Webserver.db.dbo.table select from Masterserver.db.dbo.tablename" but that query just takes forever... I even put a limit on the select (TOP 100) and it still wouldn't run quickly

SQL Server 2008 R2 on Windows 2008R2 Ent - Drives+Raid Configuration + W2008 Disk Initialization


Hi, I just want to make sure that we setup this server the best way possible as we are moving from a previous box where

performance was affected mainly because of partitioning and SQL memory optimizations.


The Hardware:

Dell PowerEdge R710 

  • Intel® Xeon® X5660, 2.8Ghz, 12M Cache,Turbo, HT, 1333MHz
  • 64GB Memory (8x8GB), 1333MHz Dual Ranked RDIMMs
  • PERC H700 Controller
  • 8 x 300GB 10K RPM Serial-Attach SCSI 6Gbps 2.5in Hotplug Hard Drive
  • Virtual Volume 1: 2 Drives = Raid 1 - for the OS
  • Virtual Volume 2: 2 Drives = Raid 1 - for the ldf's
  • Virtual Volume 3: 4 Drives = Raid 10 - for the mdf's

Windows 2008R2 64bits is installed on Volume 1.

- I would like to know what suggestions you might have for the Initialization of the other 2 volumes (MBR or GPT).

- Any other settings like partition align = 64

- Memory Settings at the OS level.

- Memory Settings on SQL.

- Any other recommendations.

Changing the SQL Port of a Clustered SQL Server 2008 in Win Server 2008R2



The above setup is in vmware. The 2-node cluster works fine. Able to failover to and fro.  Just that when I tried to change the port 1433 to 12345, the cluster is not able to online the SQL Service. Below is the application error log:

[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 274d; message = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

The service status becomes Pending Online and after a while, it becomes offline. Using the SQL Configuration Manager, I revert to 1433 and it works fine again. May I know what am I missing ?





Can not find TUTORIAL directory after downloading the "SQL Server 2008R2 product code samples" pack

Any ideas on how to optain the TUTORIAL directory that should be in C:\Program Files\Microsoft SQL Server\100\Tools\Samples? I installed the 2008R2 product samples package several times? What is up with it?

Upgrade from Win Server 2003R2 to 2008R2 breaks SQL 2005 Reporting Services


Upgraded a 64-bit Xeon server (domain controller) from WinSvr2003R2 EE to WinSvr2008R2 EE, no problems with the upgrade process -- AD is functioning as it should.  However, an instance of SQL Server 2005 Reporting Services that was installed on the server now fails with "Error -- The underlying connection was closed:  Could not establish trust relationship for the SSL/TLS secure channel."  

This is an internal site; access is via http on port 80, no SSL.  I assume that the "secure channel" referred to is between the WinSvr2008R2 server and the SQL Server box that houses the database, but I'm not really sure.  In poking around for a solution I was inspired to reinstall the existing SSL cert on the new server, but that didn't help.  There is no cert installed on the database box, but until the upgrade it worked fine.  I've tried a couple of recommended tweaks to the config files for the report server and its web services, no luck there.

I'll be grateful for any ideas.

Jim Shilliday

Jim Shilliday

Jim Shilliday

Linked server desde SQLServer 2008R2 (64x) hacia Oracle 9i



Tengo el siguiente problema para crear un servidor vinculado, espero alguien me pueda ayudar

Tengo un servidor con SQL Server 2008 R2 64x y requiero crear un servidor vinculado hacia una base de datos de Oracle 9i, cuando intento crear el servidor no encuentro el provider Microsoft OLE DB Provider for Oracle, para realizar la conexión como se hace en SQL 2005.

¿Alguien sabe que pasos debo realizar para poder crear el servidor vinculado?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend