Hello all,
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".
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.

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

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

The server is W2k
the client is WIndows XP home


Thanks,
David






--
David Williams
Georgia Institute of Technology, Atlanta Georgia, 30332
Email: dw149 (AT) prism (DOT) gatech.edu

David Williams (dw149 (AT) acmex (DOT) gatech.edu) writes:
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 think that is a good idea.

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

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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks a lot Erland.

This is very helpful.

It takes about 10 seconds for the app to reject the login.

Sorry about the port 1421 miscommunication.
I am a MySQL person and was told by the vendor that
SQL runs on port 1421.

I'm going to try and download the client.
I appreciate that link a lot.

What is funny is out of 10 computers, 2 of them started
working magically and I have not changed anything.
This is some Windows quirkiness that is confusing me
making me think this is more of a networking thing than
SQL.


I'll followup with whatever I find.




--
David Williams
Georgia Institute of Technology, Atlanta Georgia, 30332
Email: dw149 (AT) prism (DOT) gatech.edu

David Williams (dw149 (AT) acmex (DOT) gatech.edu) writes:
Often when you cannot access SQL Server it's a networking issue of
some sort. Particularly, when the problem is not all machines.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hello all,
it turned out to be a networking issue.
I tried mapping the drive to the server again before connecting and it worked this time.

I guess when I mapped the first time, it wasn't really mapped or just a quirk.
Either way, the server was not mapped and thus the invalid server name.

Thanks!
David

--
David Williams
Georgia Institute of Technology, Atlanta Georgia, 30332
Email: dw149 (AT) prism (DOT) gatech.edu