RE: Access to a remote SQL server through ISA server

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 11/27/03 

Date: Thu, 27 Nov 2003 00:27:21 GMT

Make a network trace on both sides (SQL1) and (SQL2).
Use osql.exe connect to the remote server and execute sp_tables. This
should return a list of tables in the current database.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • SQL 2000 transactional replication is generating snapshot every hour
    ... SQL2 subcribed to SQL1, and publisher+distributor for SQL3 ... and at the same time SQL2 is generating a snapshot for every publication it ... 2GB) every hour for every publication. ...
    (microsoft.public.sqlserver.replication)
  • Re: OT: security
    ... this remote file will be included into ... the script and executed. ... Note that the remote server would have to ... Mechanisms such as the above allow attackers to execute any code they ...
    (comp.lang.php)
  • Windows security
    ... I want to back up a database from SQL1 and restore it ... I want mydbowner to have db_owner rights on mydbase on both ... course the login doesn't exist on SQL2. ...
    (microsoft.public.sqlserver.security)
  • Re: copying data from one server to another
    ... EXEC sp_addlinkedserver 'RemoteServer', N'SQL Server' ... Based on security settings you may need to map remote server logins. ... Then you just run a normal query referencing the linked server table with 4 ... 'SET IDENTITY_INSERT ON' before execute insert ...
    (comp.databases.ms-sqlserver)
  • INSERT takes ages...
    ... On a remote server I execute the following ... Now I wish to put the resultset ... Hans Brouwer ...
    (microsoft.public.sqlserver.programming)