June 11, 2003 at 10:00 am
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?
June 11, 2003 at 10:52 am
Are you sure SQL Server is started?
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 11, 2003 at 11:32 am
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.
June 11, 2003 at 11:53 am
Try using the server's IP address
MW
MW
June 11, 2003 at 12:08 pm
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
June 11, 2003 at 2:44 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.
June 11, 2003 at 3:45 pm
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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply