Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
achesloc
Starting Member
1 Post |
 Posted - 2002-06-05 : 17:54:28
|
| I am have a lot of trouble remotely connecting to a new SQL 7 installation. I have removed TCP/IP from the list of network listen protocols. I have named pipes set as the default network client library for connecting, and i also set up a named pipes connection in the client network connection utility on the client from which I am trying to login. I have tried just about every combination of client network utility alias and server network listen protocols to no avail. In every case I recieve errors indicated that a connection cannot be established. Having read the documentation, my understanding is that the SQL server should listen for named pipes and multi-protocol requests and in order to connect to the SQL server with query analyzer or osql/isql you must register an alias in the client network utility. Currently the only way to connect the SQL server is through the asp pages which i have written, which uses a connection string with trusted connection, or directly logging in on the machine on which the server resides. I must be missing something, and i have read though just about every message on the forum trying to find some information. Also, given the default settings from installation minus TCP/IP (ie. namedpipes and multi-protocol), shouldn't supplying the <\\ServerName>, an id/pwd be sufficient to establish a connection to SQL Server with any of the utilties. Thanks in advance.Update: I have changed the user name and password on the client machine to reflect a valid user name and password on the computer running the SQL server. So, regardless of what I put in as id/pwd, it uses windows NT authentication. Basically, I can only login if the user accounts agree. I want to be able to login without this requirement.Edited by - achesloc on 06/05/2002 18:11:34 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-05 : 18:10:53
|
| Why did you remove TCP/IP? It's the one network library that is supported by all of the operating systems (well, supported by the most OS's) Named pipes does not work with non-NT operating systems like Win95, 98 or ME.Have you tried re-installing the TCP/IP library? |
 |
|
|
|
|
|
|
|
SQL 7 Remote Connection Problem