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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-18 : 14:25:24
|
B. John writes "Does anybody have a clue how to configure MSSQL 7.0, or knows where such info can be found? I do not want to overcomplicate the metter, so will write few lines of information and few questions.
(Client/Server for SQL is on the same computer, or more correctly should be on the same computer.)
I am using Microsoft Personal Web Server, where host is named. I am not sure if
<127.0.0.1 localhost> is in use, host name in use was picked up during installation (PWS installation) after Computer Name.
Important:
During installation of SQL 7.0 program did not connect to server.
-----------------------------------------------------------------
Question related to: SQL Server Network Utility
Active Server Library Configuration:
What is the difference between Computer Name and Server Name according to this logic?
Remember: SQL Server and Network Server are faked on the same computer
-----------------------------------------------------------------
Question related to: SQL Server Client Network Utility
What is the difference or dependency between Server Alias and Computer Name and what one has to do with each other?
-----------------------------------------------------------------
Final note: any time I try to Register SQL Server the error message is as follow:
(Microsoft SQL-DMO)
Error 340: General Error
-----------------------------------------------------------------
Also how to relate all above to MS ODBC Administrator (Utility)
One of the error messages I got:
Microsoft SQL Server ODBC Driver Version 03.70.0623
Running connectivity tests...
Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
TESTS FAILED!
-----------------------------------------------------------------
Very last question: Is there an individual who successfully installed SQL 7.0 Client/Server on the same machine. Answer even if you don’t know how it happened." |
|
|
|
|
|
SQL Server 7.0 installation