Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Installing SQL 6.5

Posted on 1998-11-19
1
Medium Priority
?
178 Views
Last Modified: 2010-03-19
Ok.  I just got a brand new machine for home use and installed NT 5.0 (beta 2) and SQL 6.5.  Everything went smoothly, and SQL is (I believe) installed correctly.  Through SQL service manager, I can start and stop the server, but when I try to connect through ISQL/w or Enterprise manager, I get a DB-LIB error saying that the specified server cannot be found or does not exist...  I have installed SQL before (though it has been a while) and have never had this problem.  There is no networking card installed, but that shouldn't be a problem since I have talked with other people who have done the same thing with NT 4.

do I specify "(local)" or somesuch for the server name?  (I'm @ work so can't try it until tonight.)

Help???
0
Comment
Question by:percosolator
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
aliciaam earned 400 total points
ID: 1091887
SQL Server installation does not start the services:
MSSQL Server and
SQL Server Executive. You have to start them manually the first time.
You must register the server from server/register and probably you have standard security so... enter sa and no password which is the default for sql server 6.5.
If you can stop and start you should be able to access it. The name of the server is the same as the computer name.
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question