Solved

SQL server Access form client system

Posted on 2014-04-29
3
167 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 78

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

Are your corporate email signatures appalling?

Is it scary how unprofessional your email signatures look? Do users create their own terrible designs and give themselves stupid job titles? You can make this a lot easier for yourself by choosing an email signature management solution from Exclaimer today.

Join & Write a Comment

Resolve DNS query failed errors for Exchange
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

747 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now