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

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

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

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

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???

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.

Problem connecting using ODBC from Windows Server 2008R2 x64




I have strange problem: when I'm trying to create new “System DSN” (ODBC Data Source Administrator) using either SQL Native Client or “integrated” SQL Serve source I’m getting next:

Connection failed:

SQLState: '08001'

SQL Server Error: 1326

[Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [1326].

Connection failed:

SQLState: 'HYT00'

SQL Server Error: 0

[Microsoft][SQL Server Native Client 10.0]Login timeout expired

what strange for me – is that I can create this Data Source either on the other machine (Windows XP there) or on the server host (Server 2008 x64)…

Windows Firewall turned off on that host and I have no idea what to check next…

Any help appreciated.


Best regards...

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

Does SQL 2005 Enterprise Edition come preloaded on Windows Server 2003 Virtual Server.

Does SQL 2005 Enterprise Edition come preloaded on  Windows Server 2003 Virtual Server. I found this link http://www.microsoft.com/downloads/details.aspx?FamilyID=77f24c9d-b4b8-4f73-99e3-c66f80e415b6&displaylang=enMr Shaw

Can't install SQL Server 2008 Enterprise on Windows 2008 Enterprise

A new fresh Windows 2008 installed and install all avaliable updates. Then install SQL server 2008, it firstly install some update too. Then reboot and run setup.exe again, it always give me the following message:Managed SQL Server Installer has stopped workingWhat's wrong with it? how to solve this issue?

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?

SQL 2008 R2 problems on a Windows 2008 R2 Enterprise server

We are receiving the following error message when installing SQL 2008 R2 on a Windows 2008 R2 Enterprise server. "Unhandled exception has occurred in your application. if you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. It specialist

How to install Sql server 2008 Enterprise edition in windows 7 (32 bit system)

am install Sql server 2008 SP1 But same Problem again Plz Give me Reply Plzzzzzzzzzz Which edition Support in windows 7?

Installing SQL Server 2008 R2 Enterprise on Windows 7 - Setup Suport Files

The problem is when i try to install a new instance of SQL Server 2008 R2 Enterprise the wizard stops working when is trying to install Setup Support Files, and nothing happens. I cannot add the entire log file of the instalation, so i leave only the last lines. : ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping Action: FinishPage 2010-09-10 11:46:24 Slp: Action is being skipped due to the following restrictions: 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected. 2010-09-10 11:46:24 Slp: ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping property RequireMode of class: StopAction 2010-09-10 11:46:24 Slp: Input of property will not be set due to the following failed restriction(s): 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected. Can you help me?    

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.

SOS: Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But networ

Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect! System:   Windows Server 2008. Error 18456

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

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

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