Reply to Re: invalid server name error

Your name:

Reply:


Posted by Erland Sommarskog on 01/23/08 23:23

David Williams (dw149@acmex.gatech.edu) writes:
> I am looking for help with MS SQL Server 2005.
> Basically, there is an app I have installed taht runs
> on the client and talks the MS SQL server. The problem is that
> the client is giving me the message "invalid server name".

How long does it take for the application to say this? Normally,
this takes about 15 seconds. If you get this snap, the application
is picky about something. (The error message is not familiar, which
makes me suspicious.)

> I can map a drive from the client to the server using the exact same
> server name. I'm pretty sure the SQL instance is running because
> the app on the server says it is running. I have yet to actually
> look at the services tab to see if it is running.

I think that is a good idea.

> Is it possible to download an MS SQL client just to test the SQL
> connection? I don't have the MS SQL server CDs.

You can download SQL Server Express (command-line tools included) or
SQL Server Management Studio Express from here:
http://msdn2.microsoft.com/en-us/express/aa718378.aspx

> I cannot telnet to port 1421 on the server but I don't believe I have any
> FW blocks going.

Normally, SQL server runs on port is 1433.

One thing to check is that you have the right instance name. That is,
SQL Server can be installed as a default instance or as a named
instance. If it's installed as a default instance, you refer to it
by the machine name, but if it's a named instance, you need the instance
name do: SERVER\INSTANCE.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация