New Set Up Of SQL Server 7.0

You need to install the client connectivity from SQL Server, that's all.
Obviously, you ccould an also install the client tools, so you have Query Analyser and Enterprise Manager for managing the database that is located on the server...

CHeers

you need to go to the odbc administrator
and setup a user dsn

steps would be:
   1.add new
   2.pick sql server on the list
   3.provide the name of the connection
     you want for it.  this is the name
     you'll be using in your program that
     connects to the database via odbc
     also provide the correct server name
     otherwise it won't be able to find it.
     you need to provide a valid login id
     and password that was already setup in
     sql server.
   4. pick how you want the server to
      authenticate the login.  i normally
      use sql server authentication.
      click client configuration and pick
      what protocol your using..like tcp/ip
   5. just follow through...at the end
      you can actually test the connection if
      it work.

hope this helps.
   

I encountered Connection Failed.
Should I need to set any username and password to particular database?

Ricky

I encountered Connection Failed.
Should I need to set any username and password to particular database?

Ricky

first off, try to ping your server
from that workstation.  just want to
make sure that your workstation can
see the server.

as for the dsn setup...on the second
screen where you have a check box that
says, Connect to SQL Server to obtain.....
enter a valid SQL Server user id and password.
make sure that this user id and password is
a valid login account in your SQL Server.

if you can give me the error message displayed
below that connection failed error i could
help you figure out what is wrong.

Experts,

Just a word of caution:  questioner has not closed any of his/her questions.  For the record:

Questions Asked 13
Last 10 Grades Given  
Question Grading Record 0 Answers Graded / 0 Answers Received

Anthony

---------------------------
Microsoft SQL Server Login
Here is the error message:
---------------------------

Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

---------------------------
OK  
---------------------------

I just re-formatted my server because of the virus.
Let see how it works later. Thanks you

ghadley,

This is a list of your open questions. Since you became a member here, you have yet to close a single one. Besides being completely unfair to the Experts who have provided assistance, you are shirking your responsibility as a Member of this site.

https://www.experts-exchange.com/questions/20376959/Web-Server-In-Window-2000.html
https://www.experts-exchange.com/questions/20374459/DNS-problems.html
https://www.experts-exchange.com/questions/20347625/New-Linksys-router-with-Window-2000-Server.html
https://www.experts-exchange.com/questions/20344161/Questions-on-dsn-in-Win-2000-Server.html
https://www.experts-exchange.com/questions/20344125/Questions-on-IIS-in-Win-2000-Server-Client.html
https://www.experts-exchange.com/questions/20356366/MS-Words-With-Sql-Server-7-0.html
https://www.experts-exchange.com/questions/20380917/New-Set-Up-Of-SQL-Server-7-0.html
https://www.experts-exchange.com/questions/20343726/Javascript-Function-Running-difference-on-IE-5-0-and-IE-5-5.html
https://www.experts-exchange.com/questions/20303268/VB-Simple-Question-easy-50-pts.html
https://www.experts-exchange.com/questions/20341129/DNS-IN-IIS-5-0.html
https://www.experts-exchange.com/questions/20314846/ASP-UserName-And-Password.html
https://www.experts-exchange.com/questions/20284374/Sending-txt-html-or-xml-file-to-IIS.html
https://www.experts-exchange.com/questions/20258122/Web-Storage-System-in-Exchange-2000.html
https://www.experts-exchange.com/questions/20381906/Window-2000-Server-Virus.html

Please attend to these questions by closing them appropriately as quickly as possible. Admin has been informed of your misbehavior.

Netminder
CS Moderator

Punitive grade changed.

Netminder
CS Moderator

ghadley,
Ok, I got it.  Now, here is the point we are at.  I will ask Netminder to close all your questions in the next 72 hours.  I have sat here at my PC for a while and considered all posts related in all your questions.  It appears you are abusing the site and that will not be tolerated.  You can contact me at Computer101@Experts-exchange.com to resolve this, but the bottom line is, if your questions are not resolved, Netminder will handle them.  I will afford you this opportunity to excel here at the site, step up to the plate and hopefully make a change in your question activity.

Thanks

Computer101
E-E Admin

ghadley,
I have made it clear my intentions.  Recommend you post in your open questions or your account will be suspended.  The initial request was for 72 hours but seeing you have subscribed to E-E since then, consider this your time limit.

Computer101
E-E Admin