:::: MENU ::::

Posts Categorized / Windows Server

  • Feb 21 / 2012
  • 0
dbDigger, SQL Server Services, System Administration, Windows Server

Not able to connect SQL Server 2008 on network

Recently i deployed SQL Server 2008 along with SP3 on Windows Server 2008 R2. All installation and later configuration were managed through Remote Desktop. Later while trying to connect the instance on LAN from my desktop PC i got following error message

Not able to connect SQL Server 2008 on network

The generated error message is related to network access of instance. Back through remote desktop, first of all i checked for firewall issues but every thing was fine for that. Then after little exploration of SQL Server configuration manager i observed that TCP is disabled. I enabled the TCP in configuration manager as shown in snap

Enable TCP IP in SQL Server configuration Manager

A warning box appeared suggesting the SQL Server service restart for changes to take effect.

SQL Server Service restart required after enabing TCP IP

I restarted the service from configuration manager and again tried login from desktop PC on LAN. This time login was successful without any error message.
So make sure to enable TCP-IP for accessing the SQL Server 2008 instance on LAN. TCP-IP is by default disabled in SQL Server 2008 installation.

  • Dec 14 / 2011
  • 0
DBA Interview questions, dbDigger, Deployment, SQL Server Training, SQL Server versions and editions, Windows Server

SQL Server editions and Windows platform

Each of SQL Server release like SQL Server 2000, SQL Server 2005 and SQL Server 2008 is further categorized in editions based on their features and capabilities. For example, edition of a specific release may be any of following

  • Data center edition
  • Enterprise edition
  • Standard edition
  • Developer edition
  • Express edition
  • Apart from these there may be some other editions like run time edition or web edition. Some editions like Data center edition or enterprise edition can only be installed on Server OS while others may be installed on both server or client OS.
    For windows platform the term Server OS refers to different editions of

  • Windows server 2000
  • Windows server 2003
  • Windows server 2008
  • Windows server 2008 R2
  • While for windows platform, client OS would be any edition of following

  • Windows 2000
  • Windows XP
  • Windows vista
  • Windows 7
  • So while installing any SQL Server version, do consult the requirements related to OS.

    • Dec 13 / 2011
    • 0
    dbDigger, Memory management, SQL Server Training, System Administration, Windows Server

    A broad comparison of PAE and AWE memory extensions

    Physical address extension (PAE) and Address windowing extensions (AWE) both are used to address more than 4GB memory on 32 bit systems. I define both in following lines to remove the confusion regarding this concept

    Physical address extension (PAE)

    PAE is used by any OS to extend more than 4 GB ram for 32 bit systems. 32 bit systems natively cannot utilize more than 4GB of physical memory. As most of the server hardware is with much more memory than 4GB, it is required to make it accessible for 32 bit operating systems. For windows platform PAE is enabled by adding some parameter in boot.ini file.

    Address windowing extensions (AWE)

    AWE is a windows API used for supporting 32 bit applications to access more than 4GB of memory. It may be required for memory extensive software and applications. Read about enabling PAE for SQL Server.

    Consult us to explore the Databases. Contact us