Re: Allow a customer access my sql server over the internet
From: Carlos Eduardo Rojas (carloser@mindspring.com)
Date: 04/07/03
- Next message: Andrew J. Kelly: "Re: Application concerns OVER Login"
- Previous message: Ney André de Mello Zunino: "Re: SQL Server service: run under which account?"
- In reply to: YA: "Allow a customer access my sql server over the internet"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Carlos Eduardo Rojas" <carloser@mindspring.com> Date: Sun, 6 Apr 2003 18:59:48 -0400
You can accomplish this by opening tcp port 1433 on your firewall (or
whatever port you assigned to sql server). If your clients connect to sql
server using integrated authentication, they'd have to login to the windows
domain first. However, this is not recommeded for security reasons. If you
definitely need to do this, at least change the default tcp port used by sql
server.
---- Carlos E. Rojas SQL Server MVP "YA" <ra294@hotmail.com> wrote in message news:OJHx$LC$CHA.2368@TK2MSFTNGP10.phx.gbl... > I am trying to allow a customer access a certain view in my SQL Server > programmatically using ASP. > > I am using SQL Server 2000 with Windows authentication. > > What's the easiest way to do that? > > Should I create a new SQL Server user for him? > > Which ports should I open in the firewall? > > Which connection string should he use? > > > > Thanks for your time. > > ra294@hotmail.com > >
- Next message: Andrew J. Kelly: "Re: Application concerns OVER Login"
- Previous message: Ney André de Mello Zunino: "Re: SQL Server service: run under which account?"
- In reply to: YA: "Allow a customer access my sql server over the internet"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
