Solved

SQL server Access form client system

Posted on 2014-04-29
3
170 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
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 79

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
Read this checklist to learn more about the 15 things you should never include in an email signature.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

785 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