SQL Server Performance Forum – Threads Archive

SQL 2000 and SQL 2005 on the same Server

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

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?

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.

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

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=’

‘ />]. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of 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.</center>

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.

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.

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.

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=’

‘ />]. Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no warranties for accuracy.

I have not really find a solution even after applying the above recommendations. 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=’

‘ />] AKTHAR

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.

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.

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.

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.

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

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.

]]>