SQL Server Configuration

hii,
pls anyone help me on how to configure SQL Server in a client system. i'm new in sql server. i just develop a small application in vb backend as sql server. i used ODBC DSN to connect SQL Server to vb and it's working in server. now i'd like to install the appliction in client system. could anyone tell me, which type of sql server(connectivity only or client tools) i need to install in client system. pls explain to me
satdreamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SaxonWicaCommented:
Try to install MDAC 2.8. This should be enough.

You don't really need to install sql server client tools, unless you want the users to be able to run query analyzer or other client tools against the server
satdreamAuthor Commented:
thankx for quick replay. while i try to create ODBC, it's showing some errors.

error 1:
=====
connection Failed
----------------------
SQL State : '28000'
SQL Server Error : 18456
[Micorsoft] [ODBC SQL Server Driver] [SQL Server] [Login Failed for user 'TSERV\user1']

erro 2:
=====
Micosoft SQL Cerver Login
SQL State : '01000'
SQL Server error : 10061
[Micorsoft] [ODBC SQL Server Driver] [TCP/IP Sockets]

error 3:
=====
connection Failed
----------------------
SQL State : '080001'
SQL Server Error : 17
SQL Server doesnot exist or access denied

these errors came in diifrent time. i tried to create DSN in windows authenication and sql server login. i cannot create dsn succesfully in client system.

SaxonWicaCommented:
I don't really think that it was caused by the SQL Server driver. To test it, try the following :

1. Create a blank file (use notepad or other editors). Save it as .udl file (Example : testing.udl)
2. Double click it
3. Select OLE DB provider for Microsoft SQL server
4. Move to the connection tab, set the connection then try to test the connection. If it works, the problem most probably came from incorrect setting of your DSN ODBC

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

satdreamAuthor Commented:
thankx so much SaxonWica. it's working very well now. i just insatll the sql server connectivity only. i think i had also problem in my network settings too.
if you don't mind could u pls give some ideas abt sql server configuration in server and also the things what i should take care abt at the installation time. if i must ask it as a seperate question, i will.
SaxonWicaCommented:
One thing for sure that you have to pay attention on the network protocols being used. Notice on installation time, you will be prompted for protocol you want to use (TCP/IP or IPX) and make sure if you select TCP/IP, it runs on port 1433.

I think you can ask a separate question so that the other experts can also help you with this.

Regards,
satdreamAuthor Commented:
hi SaxonWica
thankx for ur great help.

thankx and best regards,
SaxonWicaCommented:
Glad I could help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.