How do you give a user access to Sql Server?

Question

Post reply

How do you give a user access to Sql Server?

jruiseco

SSC Enthusiast

Points: 192
More actions
August 4, 2003 at 11:17 am

#159831

I have a user that I want to give sql server remote access to. How do I do this without giving him direct access to the box? I have read that I can pass sql stuff through port 1433 but don't know more than that...
They will be accessing via Access 2000 or via Sql Server Desktop...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

hbkdba Ten Centuries Points: 1224 More actions · Answer 1

what exactly do you mean with 'direct access to the box' ?

jruiseco SSC Enthusiast Points: 192 More actions · Answer 2

I want the user to be able to view the tables, run queries, etc. directly from the database but on his machine...

SQLBill SSC Guru Points: 51440 More actions · Answer 3

Have the client go to the ODBC set up (usually in CONTROL PANEL, but might have to go to Administrative Tools to find it). It's sometimes listed as Data Sources (ODBC).

Select System DSN tab, ADD, select the SQL Server option, keep following all the directions. Eventually you get to the login window. Select the type of authentication (make sure you have created a login/password in SQL Server for the client), click the Client Configuration button and make sure TCP/IP is selected and in the window for port, make sure it's 1433.

There's more than that, but ODBC setup is pretty much self explanatory.

BTW-most 'front-ends' will bring up the ODBC connection tool when you first try to connect.

-SQLBill

jruiseco SSC Enthusiast Points: 192 More actions · Answer 4

In the ODBC setup what do I put in when I get to the "What SQL Server do you want to connect to?" Do I specify the IP address or what?

jruiseco SSC Enthusiast Points: 192 More actions · Answer 5

Nevermind... I figured it out. For more info see: http://www.1planhost.com/support/s_sql2000cnu.asp

From there it is a simple matter of registering the db in Sql Server.

Thanks for getting me going...!

mybid2003 SSCertifiable Points: 6620 More actions · Answer 6

quote:
Nevermind... I figured it out. For more info see: http://www.1planhost.com/support/s_sql2000cnu.asp
From there it is a simple matter of registering the db in Sql Server.

In the above article, it shows screen shots if you have SQL Server Client Installed at the user machine. But you would need to follow the method mentioned by SQLBill if your user is using Access 2000 to connect.

.