I can see an IIS Server but connot see as SQL Server on same PC thru ODBC. Why?

Why is it that I can see a remote server in the browser on a workstation by typing in

ftp://MY_IIS_SERVER

but I cannot see an SQL Server 7.0 database on that same remmote PC. In other words, I cannot manually set up a Data Source Name for that SQL Server.

This happens only on WIN NT 4.0 boxes.First from your workstation can you ping MY_IIS_SERVER, if so then check that you have TCP/IP enabled using the 'Client Network Utility' that comes with SQL Server.

If you can not ping MY_IIS_SERVER, can you ping the IP address, xxx.xxx.xxx. If so then again make sure TCP/IP is enabled and then do 1 of 2.

1) Add an entry in LMHOST for MY_IIS_SERVER xxx.xxx.xxx
or
2) Use SQL Server Client Network Utility and add an alias to MY_IIS_SERVER

I believe I have installed SQLExpress ok but using the command prompt after that does not track

I am at the command prompt after installing SQLExpress and typing in the following: sqlcmd -S roger-xp-x2\SQLExpress -E and I get the following response: 1> and at that point I type in sp_grantlogin [roger-xp-x2\Roger and I get the following response: 2~ and not 2> I then type go and get a 3~ which I am guessing the tildes indicate errors. Any ideas where I am going amuck?

Roger

it looks like your missing a closing "]".|||

Thanks Dan, It only sounds too simple but I am hopefull that is all it is.

Roger