Unable to login sql server 2008 on windows server 2008

You wont be able to login into the account i.e. the sql server account as the login will fail when you try to login into the sql server 2008 after installing the active directory.

It is recommended that you do no install active directory on the server on which you have installed SQL Server 2008. This is not a problem with windows server 2003.

If you install sql server on a windows server 2003 domain controller you will still be able to login into the sql server but is not the case with the sql server 2008 bcz while logging into the sql server the sql server authentication system looks up for the system on which you installed the sql server ... rather then looking into the active directory.

SQL Server installation x64 on 64 bit windows

While doing the installation of SQL Server 2008 on windows server 2008 64 bit version, if you try to change the installation path of the sql server... you get an error message as:

Error on install : The INSTANCESHAREDWOWDIR command line value was not specified.

IN order to resolve this issue you can perform the following steps so as to overcome the installation error while installing the server on another drive.....

1.       Run the setup, select all the features you want to install. DO NOT change the install folder, press next

2.       When you see the screen displaying the configuration summary, check the config.ini path, then copy/paste the file on another drive/folder

3.       Edit this file to set correct values for INSTALLSHAREDDIR & INSTALLSHAREDWOWDIR (for my case I set D:\Microsoft Sql Server and D:\Microsoft Sql Server (x86)).

4.       Run setup from the command line : setup.exe /q /action=Install /configurationfile=

This is all you need to do n enjoy working on SQL Server 2008 with a much higher performance as compared to 32 version windows.

Hi....

Hi all....
This is Vinit here. In this blog I will be updating you about my latest developments and will also help you acknowledge you about latest technologies (basically Microsoft Technologies n Sun Technologies)...Enjoy Developing Applications with me just for fun n knowledge.