Post reply

How do you give a user access to Sql Server?

  • 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...

  • August 4, 2003 at 11:24 am

    #468472

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

  • August 4, 2003 at 11:32 am

    #468477

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

  • August 4, 2003 at 12:59 pm

    #468513

    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

  • August 4, 2003 at 1:47 pm

    #468525

    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?

  • August 4, 2003 at 2:11 pm

    #468531

    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...!

  • August 4, 2003 at 5:40 pm

    #468561

    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.

    .

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

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