Solved

SQL server Access form client system

Posted on 2014-04-29
3
172 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 80

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

Don't miss ATEN at NAB Show April 24-27!

Visit ATEN at NAB Show to learn how our "Seamlessly Entertaining" solutions deliver fast, precise video streaming without delays for the broadcasting and media environment. ATEN will showcase its 16x16 Modular Matrix Switch (VM1600) and KVM Over IP Solution (KE6900 series).

Question has a verified solution.

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

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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…

685 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