Solved

Logging On To The Server For The First Time

Posted on 1998-08-04
16
186 Views
Last Modified: 2010-08-05
1)  When I launch ISQL_w  from my Windows NT machine, there are no servers listed to connect to.  I recently had Windows NT and SQL Server 6.5 installed on my machine and now I'm trying to understand what to do.  Is there something I need to do before I launch ISQL_w so that the server exists?  

Thanks!
0
Comment
Question by:John500
  • 9
  • 3
  • 2
  • +1
16 Comments
 
LVL 2

Expert Comment

by:odessa
Comment Utility
just type in your server pole your machine name, in Login id : sa in password: password you provided till setup

e.g.
SERVER     MY_MACHINE
Login I.D. sa
Password   ********
0
 

Author Comment

by:John500
Comment Utility
I'm not sure I understand you.  You said to type in your server pole/machine name. Where can this be obtained.  I know that if I were in Windows 95 I could type winipcfg in the Run box but this command isn't recognized from NT.

The other thing you said was to enter the "password you provided till setup."  What do you mean "till setup."  I'm assuming you mean the password I used to log onto NT?
0
 

Author Comment

by:John500
Comment Utility
I've increased the points by thirty because I was able to log on to the server but I'm still unable to access the server from Enterprise Manager.

From within the Server Manager window (within Enterprise Manager) the server I need is visible and has a green light but when I double click it I get a message that says "unable to log on to the server."

Any ideas why this is?  Once I access this server I wanted to create the database device etc...
0
 

Author Comment

by:John500
Comment Utility
I forgot to mention in the previous comment that the exact error message displayed is:

A connection could not be established with the server [SQL Server] Login failed

How could this be if the server is started?


0
 

Author Comment

by:John500
Comment Utility
In addition to the previous two comments, I have found the instructions for Adding a SQL Server Login.  This is required "Before a user can access an SQL Server..."

However, the instructions say that after selecting the appropriate server to then select the Manage menu and then Logins...

Although I have administrator privileges, when I select Logins... I get the same message stated above.
0
 

Author Comment

by:John500
Comment Utility
Requesting quicker response time!!  Thank you
0
 

Author Comment

by:John500
Comment Utility
Since the following statement is true and taken from the SQL's help file, why am I having the above difficulty when I am the SA?

The SA operates outside the protection system (SQL Server does not check permissions for the SA). The SA is also treated as the owner of whatever database he or she is using. Anyone who knows the SA's password can log on and act as the SA.
0
 
LVL 2

Expert Comment

by:Wiz_of_Oz
Comment Utility
but are you sure to can run a sql query system such as ISQLw without a SQL server installed onto your machine????

0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:John500
Comment Utility
I have an SQL Server installed on my machine.  I am also running Windows NT and have the SA rights.  
0
 
LVL 2

Expert Comment

by:odessa
Comment Utility
when you register in EM your server do you specify your password?
0
 
LVL 2

Expert Comment

by:Wiz_of_Oz
Comment Utility
when you installed your sql server what account you specified as administrator?
when you run isqlw what login name u use?
0
 
LVL 5

Expert Comment

by:mayhew
Comment Utility
You say you have a green light.  Do you also have a little red squiggly line just to right of the light?  This line tells if the database is connected or not.  Click the server legend button to see what the red squiggle line looks like.

It's possible you still need to register your server.  You can do this by right-clicking on the server icon in EM and selecting 'Register Server...'

Let us know what you find!
0
 

Author Comment

by:John500
Comment Utility
mayhew,

You were correct about registering the server.  I thought I did that but somehow I didn't.  Thanks.  The points are yours but I will need the option to grade.  Right now I can only comment.
0
 
LVL 5

Accepted Solution

by:
mayhew earned 50 total points
Comment Utility
John500,

I'm glad that worked for you!  :)
0
 

Author Comment

by:John500
Comment Utility
Hey mayhew,

How about looking at my other question titled:

Converting Data Elements From A Legacy System

I haven't been getting any responses to it!


0
 
LVL 5

Expert Comment

by:mayhew
Comment Utility
I'll take a look at it.

BTW, that question is showing as locked (someone has proffered an answer).

Most people probably won't respond if they think the current expert has a chance at a favorable evaluation of his/her answer.

Just so you know.  :)
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

771 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now