Connecting to SQL dbfs with existing code

No need to setup the web server as a primary domain
controller for the SQL Server connectivity to work.
After you configured the system DSN on the web server, did
you test the DSN as the very last step of setting up the
DSN? If yes, what error message did you get?
Linchi

quote:

---

>--Original Message--
>We recently moved our Access databases to SQL and are
>trying to get our pages to open the connections to the
>server. I've set the system DSNs on the server as needed.
>However, no connections are made. After reviewing several
>books, microsoft.com, etc...I'm severely frustrated. The
>only thing I can think that would possibly be an issue is
>that our webserver (Win2003) is not setup as a Primary
>Domain Server and we have to connect via http.
>Any suggestions are appreciated. THANKS!
>.
>

---

The test was completed successfully. That's what is perplexing.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Does the connection actually hit SQL Server?
Enable auditing for failed logins on SQL , then stop n start MSSQLServer
service.
Check the SQL Errorlogs after the failed connection attempt.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sqlsql

Connecting Sql Servers Seperated by a firewall

Hello,
I have two sql servers that reside in seperate AD forests and that are
separated by a firewall. I need to enalbe connectivity between the two sql
servers. In addition to port 1433 are there any other ports that need to be
opened
There may be some additional ports besides TCP 1433 that you mean need to
open depending upon your situation. Please take a look at this KB article
which provides an exhaustive explanation,
http://support.microsoft.com/default...b;en-us;841249
Il-Sung
Il-Sung Lee
Program Manager -- SQL Server Protocols
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"SteveB" <SteveB@.discussions.microsoft.com> wrote in message
news:DB639DA5-AAB2-46FE-BEF5-B3806B5C8E27@.microsoft.com...
> Hello,
> I have two sql servers that reside in seperate AD forests and that are
> separated by a firewall. I need to enalbe connectivity between the two sql
> servers. In addition to port 1433 are there any other ports that need to
> be
> opened

Connecting Sql Servers Seperated by a firewall

Hello,
I have two sql servers that reside in seperate AD forests and that are
separated by a firewall. I need to enalbe connectivity between the two sql
servers. In addition to port 1433 are there any other ports that need to be
openedThere may be some additional ports besides TCP 1433 that you mean need to
open depending upon your situation. Please take a look at this KB article
which provides an exhaustive explanation,
http://support.microsoft.com/defaul...kb;en-us;841249
Il-Sung
Il-Sung Lee
Program Manager -- SQL Server Protocols
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"SteveB" <SteveB@.discussions.microsoft.com> wrote in message
news:DB639DA5-AAB2-46FE-BEF5-B3806B5C8E27@.microsoft.com...
> Hello,
> I have two sql servers that reside in seperate AD forests and that are
> separated by a firewall. I need to enalbe connectivity between the two sql
> servers. In addition to port 1433 are there any other ports that need to
> be
> opened