.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 2005sp3 in Windows 2008R2.

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

I have install Sql 2005sp3 on windows srvr 2008R2 standard, and I did the setup for on surface Area configuration, for TCP/IP, name pipes.

But in and my windows Windows 7 32 bits, when i do browse for the server using sql server I don't see it.

also I have other server winodws 2008 and Sql server 2005, but is working fine.

I have a winodws 200 for DC.

Any help is welcome. thank you.


View Complete Post

More Related Resource Links

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

Renaming Windows 2008R2 with SQL2008 and re-IP


Hi all,

I hope I can get an answer here.

I currently have a Win2003 with sql server in production that I need to move everything from there to a new server Win2008R2 with SQL2008 at 64bit.  I named the new server differently with also a different ip address so it would not conflict with the old one after I finish moving everything. So now that I have everything done I have to rename and re ip address the new server to the old server name. So is it safe to do that or do I have to re-do everything from scratch again?

Any help would be greatly appreciated.




Ajax.net does not work in windows 2008R2 or windows 7 64bit


Hi ,

I got this error for ajax website

ASP.NET Ajax client-side framework failed to load

. it works well in windows 2003 , 2008 and vista , but in windows 2008r2 and windows 7 , I get this error and ajax does not work.

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.

Windows authentication SQL 2005 on Windows 2008R2 problem and SP streaming


Hello all,

At our customers site we are building a POC (Prove Of Concept) setup and ran into problems. First of all we install SQL 2005 Standard without ServicePack. After this we apply Service pack 3 for SQL. Now we have the problem that the domain admins are not able to connect to the instance in any way. Error is 18456 with state 11. After searching the web I found out that due to UAC, local admins are no longer sysadmins on SQL by default. So I did these two commands:

EXEC sp_grantlogin 'domain\Domain Admins'

EXEC sp_addsrvrolemember 'domain\Domain Admins', 'sysadmin'

Where I of course replaced domain with the appropriate domain name. For Domain Admins this does not seem to work! Also applied it to BUILTIN\Administrators. The local administrator can connect. I then created a new domain group named 'DBadmins'. I applied the exact same commands as stated before to this group, members of this new group can login. When I add the group Domain Admins to the group DBadmins, they do can login. This is of course not a desirable construction. I want all Domain Admins to have access. So I have 2 questions:

1> How can I make sure the Domain Admins group

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

Windows 2008R2 + MS SQL 2005 Express + "Synchronize" tool ? Where it is ...


Hello Everyone,

I just installed in a test setup a replication from SQL Server 2005 to SQL 2005 Express. Everything work fine. However, I like to schedule it to run ever hour. On the express machine, a Windows 2008R2, I cannot find the "Synchronize" tool (Normally in accessory folder). After looking online I ended up copying it from another machine. However, it does not work well.


Where is that tool in Windows 2008R2 ? I am doing something wrong ?



Windows Service Applications Tutorials

You can easily create services by creating an application that is installed as a service. For example, suppose you want to monitor performance counter data and react to threshold values. You could write a Windows Service application that listens to the performance counter data, deploy the application, and begin collecting and analyzing data.

Serving Silverlight Apps from Windows Mobile

Even if mobile dev is not my every day work, thanks to the .Net Compact Framework, it's still .Net programming.

Here is the scenario:

You come back home, you have a windows mobile phone wifi capable and you want to quickly get access to your phone pictures from your home network.
You just activate the Wifi, run my app and then browse to the provided link from any computer on the network.

Getting Started with Windows SharePoint Services

Of all of the capabilities of SharePoint, I thought I would start with the most basic installation - as a corporate intranet. It is likely that we will need to discuss some of the elements of SharePoint as we go along, so this also gives us the opportunity to review these elements for future reference.

Before going into too much detail, I would like to point out that you can try the core SharePoint framework (known as Windows SharePoint Services or WSS) for free. On Microsoft's Web site you can download a trial version of Virtual PC 2004 (VPC). Using VPC, you can install the Windows 2003 Evaluation Kit and the WSS add-on. This combination will give you 45 days to evaluate the setup.

Building a Searchable Phone Directory with Windows SharePoint Services

I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

Getting Started with Windows Communication Foundation

Windows Communication Foundation (WCF) provides a unified framework for rapidly building service-oriented applications that makes it easy to build and consume secure, reliable, and transacted Web services. It unifies the capabilities in ASMX, WSE, Remoting, COM+, and MSMQ; therefore developers need to learn only one programming model.

Application Architecture in Windows Forms 2.0

Applications have special support in Windows Forms. For starters, you can manage and tailor your application's lifetime, and, when the work flow is disrupted by an unhandled exception, you can choose from several methods of response. Then, there are several application models that you can employ, including Single Document Interface (SDI) and Multiple Document Interface (MDI) applications, each of which can support either multiple-instance or single-instance mode, the former the VS05 default and the latter requiring special consideration. All applications, however, can discover and use a wide variety of information about the system and environment they execute in.

Application Architecture in Windows Forms 2.0-Single-MDI Applications

Consider an MDI application like Microsoft Excel; files opened from the file system (by double-clicking) are all opened as separate child windows within the parent Excel window.7 For the first instance of an MDI application to open a new child window to display the file that was passed to the second instance of the application, the second instance must be able to communicate with the initial instance.

Windows Presentation Foundation and your architecture

Windows Presentation Foundation (WPF) is a new client user interface technology that ships as part of the .NET 3.0 Framework. Architects have long faced the challenge of selecting an appropriate presentation tier technology for their applications. In recent times, if you are developing for the Windows platform, it was at least a fairly short list. You either built a web application, a smart client, a mobile device, or some combination of those depending on your target audience. Which one you picked gave you a fairly short list of practical options in the .NET space - ASP.NET, Windows Forms, and Compact Framework respectively.

New Features in Windows SharePoint Services 3.0

Windows SharePoint Services 3.0 (WSS 3.0) is the next version of WSS 2.0, released on 2007, and Microsoft Office SharePoint Server 2007 (MOSS 2007) is built on top of this. Windows SharePoint Services 3.0 takes full advantage of Microsoft ASP.NET 2.0 and the core Microsoft .NET 2.0 runtime. WSS 3.0 offers a lot of new features and programmability support. I have consolidated a list of new features and enhancements in the below section:

How to programmatically add controls to Windows forms at run time by using Visual C#

Create a Windows Forms Application
Start Visual Studio .NET or Visual Studio 2005 or a later version, and create a new Visual C# Windows Application project named WinControls. Form1 is added to the project by default.
Double-click Form1 to create and view the Form1_Load event procedure.
Add private instance variables to the Form1 class to work with common Windows controls. The Form1 class starts as follows:
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