Re: Static IP On WInXP machine? Is it possible?

In message <4c3df3F147gl4U1@xxxxxxxxxxxxxx>, Andrea Montanari <andrea.sqlDMO@xxxxxxxxxxx> writes
hi,
ARTMIC wrote:
Hello Can anyone tell me how to configure SQL Server to handle static
ip requests from the internet. The sql server is installed on a
windows XP Pro machine.

Is the above even doable? OR does the sql server need to be installed
on the Windows 2000/2003 server OS before the static IP can work?

Thanks

SQL Server will listen to all incoming connections on the appropriate TCP/IP
port (usually 1433 for default instance)... you have to put rules on the
firewall to define specific incoming ip addresses...
actually is not a good idea to "open" SQL Server directly to the outer
net... an application server should layer requests as you are opening the
door to lot of security issues...

In other words use something like a Web Service or Data Service to deal with the requests and pass data to / from SQL Server.

--
Andrew D. Newbould E-Mail: newsgroups@xxxxxxxxxxxxxxxxx

ZAD Software Systems Web : www.zadsoft.com
.

Relevant Pages

  • Re: SQL thinks its Slammer
    ... Take a look at the Windows layer. ... It turned out that SQL Server was able to handle so many more requests per ... 2000 SP4 has the slammer fix, and if multiple queries are used the SQL ...
    (microsoft.public.sqlserver.security)
  • Re: ThreadAbort Exceptions !! HELP !!
    ... Well we checked for queued requests last night and there were none during ... Looks like our SQL server box is ... trace seems to usually point at a webservice not an aspx page. ... System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: SQL Server 2000 and Latching problem
    ... these requests. ... How much ram on the SQL Server? ... > I have an application that acts as a database "server" where it captures ... > clients requests have to be queued. ...
    (microsoft.public.sqlserver.connect)
  • SQL Server 2000 and Latching problem
    ... as the clients could talk to the database directly. ... anything if the SQL server is dedicated or not. ... Are these mostly read only requests or do they involve Inserts, ...
    (microsoft.public.sqlserver.connect)
  • Re: Update Performance
    ... First thing I would do would be to add a unique index on the id column. ... Pro SQL Server 2000 Database Design - ... >I have a stored procedure that is executed on every web request that we ... > If I comment out this line, I get about 350 Requests a second. ...
    (microsoft.public.sqlserver.programming)