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
Solved

SQL Server Client Side Configuration

Posted on 2011-09-15
3
326 Views
Last Modified: 2012-06-27
Hi All,
I have IBM websphere application server and need to configure a JDBC/database connection for a remote windows SQL server 2008?

What min I have to install at client side to connect to a SQL server database?
Is there anything like Oracle Instant Client (doesn't need a install)  for SQL server.

Thanks
0
Comment
Question by:crazywolf2010
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36544946
This is a very nice write up:
http://www.devdaily.com/java/edu/pj/pj010024
0
 

Author Comment

by:crazywolf2010
ID: 36546187
Hi Mate,
That is a brilliant article.

Unfortunately the JBDC drivers will only try and get connection to the database. Sometimes i need something more to debug jdbc connection issues. I am not a developer, i work as a DBA.

I want to know bit more on installing client side tools & configuring remote SQL server connections. At same time , I don't want to install MS visual studio. I will be OK as far as I can use sqlcmd and get connection to remote database. At least I can prove to the developers it's not my problem. What do I need on the box?

thanks
0
 

Author Comment

by:crazywolf2010
ID: 36558917
Hi,
What about SQL server workstation installation? Do you need that installed at every client machine which need access to remote SQL database?

Is it same like Oracle client installation which have all libraries,dlls,SQLnet files & sqlplus client side utility needed to carry a remote database connection?

Many Thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

856 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