SQL connection

[mmarkym]

I've downloaded SQL Server to my computer. I'm trying to set up the connection. On the data links properties box from the Microsoft English Querry program its asking for 3 questions. A server name, Info to log on to the server, and select a database on the server. I've tried many different entries without any luck.

mark

mrkcl@msn.com

 

[AtomicChip]

Server Name: Generally, this can also be the server's IP address. If you don't know the name of the server that you set up, try inputting the computer's IP address.

Info to log on to the server: Is this a username/password combo? If so, you have two choices (depending on how you set up your server) - Windows authentication or SQL authentication (the latter is generally used for web development). If you do not have any user accounts set up, you could use the built-in "sa" account (did you set a password for this when you installed???)

Database: This will usually be populated automatically once a server is selected. If it is a textbox and not a dropdown list, enter the name of the database that you need to connect to.

-----------------------------------------------
"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy

 

[SQLBill]

Bear with me type question:

I've downloaded SQL Server to my computer.

What do you mean by that? Did you download a version of SQL Server? Which version? Did you INSTALL it? (Download and install are two different things - usually).

-SQLBill

 

[mmarkym]

I have installed SQL Server- version 2000.80.194.0

 

[mmarkym]

In step 2, after using my ip address in step 1, I dont know if I need a username and password or not. It asks for
a. Use windows NT integrated security

b. Use a specific username and password
Neither of which will work with the ip address in step 1.

I dont remember a username and password when I installed SQL server some time ago. Is there a way to find out what it would be?

Mark

 

[SQLBill]

Did you create any logins to the databases? Did you set your databases up for Windows Authentication or SQL Server authentication?

If you set it up for SQL Server authentication, try this (try it anyways)

Try option b 'Use a specific username and password'
and enter:

Username: sa
Password:

(just leave the password blank).

SA is the 'all-powerful' login. Default is a blank password.


Do you have Enterprise Manager installed? Have you registered a server?

-SQLBill