December 29, 2009 at 2:46 pm
My company still has several clients that it supports that use SQL 2000. From the reading I have been doing this has been a problem in the past that in SQL 2005 was resolved by the addition of the browser. I have tried adding the server with SP_AddServer making sure port 1433 was open and listening. Does anyone have any other suggestions? I have tried SP_AddServer, still no dice.
susamb01int06\training instance can not seem to talk to susamb01int06.
Migration Failed: Unable to get information from SQL Server: susamb01int06.
14 Oct 2009 11:12:41 liquibase.commandline.CommandLineMigrator main
SEVERE: Unable to get information from SQL Server: susamb01int06.
java.sql.SQLException: Unable to get information from SQL Server: susamb01int06.
December 30, 2009 at 3:56 am
I’m sorry but your message is not very clear. From what I understand, you want to know if you can install SQL Server 2000 and SQL Server 2005 on the same machine and then let SQL Server Browser service listen on default port and map each request to the correct server. If this is the case then the answer is yes. SQL Server Browser is installed with SQL Server 2005, but it can work with SQL Server 2000 and even with SQL Server 7.
You also wrote that you tried to add the server with sp_addsrver. I guess that you are trying to configure linked server. If I’m correct then pleas use sp_addlinkedserver instead of sp_addserver. The reason for that is that sp_addserver exists for backwards compatibility and it creates a remote server instead of linked server.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2009 at 6:48 am
I am sorry I was not clearer. Let me try again. I am loading/updating a program that currently exists on a total SQL 2000 setup, no 2005. When I try and upgrade the database on the susamb01int06\Training instance I get the error of:
Migration Failed: Unable to get information from SQL Server: susamb01int06.
14 Oct 2009 11:12:41 liquibase.commandline.CommandLineMigrator main
SEVERE: Unable to get information from SQL Server: susamb01int06.
java.sql.SQLException: Unable to get information from SQL Server: susamb01int06.
susamb01int06 is the default instance but does not seem to want to talk to the training instance. make more sense?
January 3, 2010 at 1:28 pm
Your error looks like it is having problems connecting to the default instance, not the training instance. What do the logs on the default and training instances say?
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply