SQL Server Performance

SQL 2000 and SQL 2005 on the same Server

Discussion in 'SQL Server 2005 General DBA Questions' started by Akthar, Apr 13, 2007.

  1. Akthar New Member

    Hi all,
    i have install one instance of SQL Server 2000 and 2005 on the same Server. IT works fine, but i am now having problem , On of the SQL Server services sometimes does not start. If SQL 2005 is stoppped then i can start sql 2000.

    Any Advice
    Akthar

    AKTHAR
  2. thomas New Member

    Do you get any errors when you try to start it? Anything in the Windows error log? SQL Server Error Log?

    What Service Packs have you got installed on each instance?
  3. MohammedU New Member

    As mentioned check the sql 2000 error log...
    And make sure both servers have enough memory to start....
    Do not use "Min memory server configuration"...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  4. ghemant Moderator

    quote:Originally posted by Akthar

    Hi all,
    i have install one instance of SQL Server 2000 and 2005 on the same Server. IT works fine, but i am now having problem , On of the SQL Server services sometimes does not start. If SQL 2005 is stoppped then i can start sql 2000.

    Any Advice
    Akthar

    AKTHAR
    Didn't get you!!!
    Do you mean that only one is started at a time? What's their in windows Event Viewer and SQL Error Log?

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  5. satya Moderator

    First thing to check on failure of services start, is if you are using a domain or local account then ensure the password is correct and that account is not expired. By posting the error will get you straight answer, otherwise you will see many questions for your thread [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>
  6. sonnysingh Member

    Really Glad that I found this thread cos I have been asked for the same installation..

    so please guide me that how should I install both server on the same machine? I mean what is the best way to do this installation so won't be any problem arise in the future???
    For instance SQL Server 205 require SP 2 and SQL Server 2000 require SP4. Shall I install them on different partitioned drives? or ????

    Thanks in Advance.
  7. satya Moderator

    I would like to ask what is your requirment, is it for production or development (test)?
    It is better to install SQL 2000 first and test the application and then install SQL 2005 seperately, having them on different partitions is upto you as there is no real benefit as they are installed into seperate directories or you can control using CUstom installation options.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  8. MohammedU New Member

    Also Configure the max memory setting and do not leave memory dynamic...

    You can create databases on different physical drives to get additional peformance...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  9. Luis Martin Moderator

    Also is a good idea to back a post how you resolve the problem, after all suggestion before[<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All in Love is Fair <br />Stevie Wonder<br /></font id="size1"><br /><br /><font size="1">All postings are provided �AS IS� with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  10. Akthar New Member

    I have not really find a solution even after applying the above recommendations.<br />I have just a work around: I have set the SQL Server 2005 Services to Manual and SQL 2000 Services to Auto. So as to enable SQL 2000 Server to start and then i start SQL 2005 Services.[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br /><br /><br />AKTHAR
  11. MohammedU New Member

    Did you apply the sp4 and cumultive hotfix to sql 2000 instance? if not try it...

    You can also create a job on sql 2000 instance to start sql 2005 intance at startup instead of starting manually...I know it is not a solution but another work around...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  12. satya Moderator

    Why to setup the services for 2005 different to 2000, as there will not be any issue.
    As suggested have you tested the compatibility of application and other components between 2000 and 2005 versions.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  13. sonnysingh Member

    Hi Folks

    It is definitely best way to learn new things.. it is quite enough info to start on the subject.

    Satya... it is for development test server
    MohammedU...SP4 and cumulative hotfixes already installed as 2000 installed.
    I am going to install 2005 SP2 and need to see what happen? any suggest for testing point of view to make sure that server is working fine after install the 2005 SP2.

    By the way guys I have installed as i mentioned that on two diffferent drives and looks healthy so far.

    Question is: I want to change the port number for both instances.
  14. satya Moderator

    Yes you have to change the ports and ensure they are open, as long as they work good and being a dev. server it should be healthy.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  15. sonnysingh Member

    Thanks Satya

    As I am new user for 2005... could you please guide me on which ports I should be go for? how I check that they are open if not open then how can I open them and configure them separately for 2002 and 2005???

    Thanks in Advance
  16. satya Moderator

    If you have used the dynamic port settings then by default it will choose the available port, but if any applications are used with specific port settings then they will fail. If not it is best to choose 3341 fo SQL 2005 and leavel 1433 for SQL 2000, I don't see any problem for the dev. server settings and for rest of production deployment go with following:

    http://www.microsoft.com/technet/prodtechnol/sql/2005/sql2005secbestpract.mspx
    http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1196387,00.html
    http://www.sql-server-performance.com/security_resource_kit_interview.asp

    http://sqlserver-qa.net/blogs/tools...r-domain-account-for-sql-server-services.aspx
    http://sqlserver-qa.net/blogs/bc/archive/2007/03/17/sql-server-2005-best-practices-analyzer-ctp.aspx

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page