isql -S error

  • when I try "isql -S servername" or "bcp -S servername" from dos, I got error "request servername not found", but I can ping the server. any idea?

  • yes, it's started, I have several sql 2000, most of them working with "isql -S" and "bcp -S", only one that running named instance is not working. I changed registry on this server before, but don't know what's wrong I did. It's not a big deal, I just wonder how sql2000 working with isql and bcp.

  • Try using the server's IP address

    MW


    MW

  • quote:


    only one that running named instance is not working.


    Try isql.exe -Ststsql01\tst (Replace tstsql01 with your server name and tst with your named instance name)

    Edited by - Allen_Cui on 06/11/2003 12:08:49 PM

  • Thanks for the input.

    I may confused you guys by saying "named instance", actually from the server (say instanceserver) which is running named instance, I cannot run "isql -S otherservers", not to itself. and otherservers is ok to run "isql -S instanceserver"

    mworku, use Ip address get the same error.

  • Quoted from BOL about the definition of instance.

    "There are two types of instances of SQL Server:

    Default Instances

    The default instance of the SQL Server 2000 database engine operates the same way as the database engines in earlier versions of SQL Server. The default instance is identified solely by the name of the computer on which the instance is running, it does not have a separate instance name. When applications specify only the computer name in their requests to connect to SQL Server, the SQL Server client components attempt to connect to the default instance of the database engine on that computer. This preserves compatibility with existing SQL Server applications.

    There can only be one default instance on any computer, the default instance can be any version of SQL Server.

    Named Instances

    All instances of the database engine other than the default instance are identified by an instance name specified during installation of the instance. Applications must provide both the computer name and the instance name of any named instance to which they are attempting to connect. The computer name and instance name are specified in the format computer_name\instance_name.

    There can be multiple named instances running on a computer, but only the SQL Server 2000 database engine can operate as a named instance. The database engines from earlier versions of SQL Server cannot operate as a named instance."

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply