How to create ODBC to SQLServer in a LAN accessed by another LAN through gateway ?

Hi all!
I have two LAN connected with a single PC with two network cards. IP
addresses are 10.0.0.x for the first LAN and 192.168.0.x for the
second. I have a SQLServer at 192.168.0.109 and I would like to define
an ODBC that point to it from the other network, for example on a PC
with IP 10.0.0.164. TCP/IP ping works fine from 10.0.0.164 to
192.168.0.109, but ODBC doesn't work!
Anyone suggest some ideas or point me in the right direction ?
Thanks in advance
Eugenio ALESSIEugenio,
Do you have firewall between this networks?
try from 10.0.0.164: telnet 192.168.0.109 1433.
--
Regards,
Rodrigo Fernandes
"eugenio alessi" wrote:
> Hi all!
> I have two LAN connected with a single PC with two network cards. IP
> addresses are 10.0.0.x for the first LAN and 192.168.0.x for the
> second. I have a SQLServer at 192.168.0.109 and I would like to define
> an ODBC that point to it from the other network, for example on a PC
> with IP 10.0.0.164. TCP/IP ping works fine from 10.0.0.164 to
> 192.168.0.109, but ODBC doesn't work!
> Anyone suggest some ideas or point me in the right direction ?
> Thanks in advance
> Eugenio ALESSI
>|||No, I haven't any firewall...
Is there some user access policy to connect to SQLServer (I use sa
nopassword...)
Eugenio

How to create Logs?

Can anyone please tell me where and how to configure SQL log files. I am a
Network Admin person and don't know anything in SQL.Can you specify if its server error log file or database log file?
Thanks,
Sree
"iice" wrote:
> Can anyone please tell me where and how to configure SQL log files. I am a
> Network Admin person and don't know anything in SQL.|||I want to know all the details of the database starting from accessing,
execution details, error logs etc. Is there any way of seeing? Pls do help me.
"Sreejith G" wrote:
> Can you specify if its server error log file or database log file?
> Thanks,
> Sree
> "iice" wrote:
> > Can anyone please tell me where and how to configure SQL log files. I am a
> > Network Admin person and don't know anything in SQL.

how to create dynamic data sources in one report

Hi all
I would like to make one report that could connect to all servers on my
network (not all on the same domain, Mixed mode authintacation).
An example of use would be to click a link for each server to view the
result set for sp_who, sp_databases, version information or anything similar.
Does anyone know a source/article that would get me going in the right
direction? What I have found so far... well I am still looking.
much thanksFrom Books Online (RS 2005). This does not work in RS 2000
>>>>>>>>
Data source expressions are processed at run time or when a report is
previewed. The expression must be written in Visual Basic. Use the following
guidelines when defining a data source expression:
a.. Design the report using a static connection string. A static
connection string refers to a connection string that is not set through an
expression (for example, when you follow the steps for creating a
report-specific or shared data source, you are defining a static connection
string). Using a static connection string allows you to connect to the data
source in Report Designer so that you can get the query results you need to
create the report.
b.. When defining the data source connection, do not use a shared data
source. You cannot use a data source expression in a shared data source. You
must define a report-specific data source for the report.
c.. Specify credentials separately from the connection string. You can use
stored credentials, prompted credentials, or integrated security.
d.. Add a report parameter to specify a data source. For parameter values,
you can either provide a static list of available values (in this case, the
available values should be data sources you can use with the report) or
define a query that retrieves a list of data sources at run time.
e.. Be sure that the list of data sources shares the same database schema.
All report design begins with schema information. If there is a mismatch
between the schema used to define the report and the actual schema used by
the report at run time, the report might not run.
f.. Before publishing the report, replace the static connection string
with an expression. Wait until you are finished designing the report before
you replace the static connection string with an expression. Once you use an
expression, you cannot execute the query in Report Designer. Furthermore,
the field list in the Datasets window and the Parameters list will not
update automatically.
>>>>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"darwin" <darwin@.discussions.microsoft.com> wrote in message
news:73ED683D-87CE-416D-AB87-8E071E89C32F@.microsoft.com...
> Hi all
> I would like to make one report that could connect to all servers on my
> network (not all on the same domain, Mixed mode authintacation).
> An example of use would be to click a link for each server to view the
> result set for sp_who, sp_databases, version information or anything
> similar.
> Does anyone know a source/article that would get me going in the right
> direction? What I have found so far... well I am still looking.
> much thanks