Solved

SQL server Access form client system

Posted on 2014-04-29
3
175 Views
Last Modified: 2014-05-14
Dear Sir,

 i was install Microsoft SQL server 14 standard on my windows server 2012 r2 standard
so i want to my SQL server access form my client system so please sages mi what i do

(witch Tool  use Please guide mi sir )
0
Comment
Question by:techgyan
[X]
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
3 Comments
 
LVL 8

Accepted Solution

by:
Ganapathi earned 500 total points
ID: 40029337
There are plenty of tools available on the market for both free and paid.

Embarcadero Rapid SQL - My suggestion
AnySQL Maestro
0
 
LVL 22

Expert Comment

by:plusone3055
ID: 40029350
this question is a little vague there are two possible things you are looking for here...

1. You just want to install the SQL server native client on another box  
http://technet.microsoft.com/en-us/library/ms131321.aspx

2. if you have SQl server installed on your windows server and you want to access it from another machine in your network you can just create an ODBC Connection on that box

here are the step by step instructions for that

https://www.youtube.com/watch?v=tUiaK5fRH7k
0
 
LVL 82

Expert Comment

by:David Johnson, CD, MVP
ID: 40029555
1. open firewall port 1433 for sql tcpip
2. sql configuration enable tcip protocol
3 if a member of a domain you can use windows logon otherwise sql logon (add users and groups to the applicable sql access group within sql server on a per database level using sql management studio 2014
0

Featured Post

Turn your laptop into a mobile console!

The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.

Question has a verified solution.

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

If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

623 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