Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0

Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":

"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"

I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.

On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..

Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.

Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.

Any help will be very much appriciated

If you are not on a domain your best bet is probably to use SQL
Authentication. You will pass a user name and password from the web page to
SQL Server.

--
Keith


"Sam White" <noSPAM (AT) Please (DOT) com> wrote

I meant to mention in my previous post that you can look up connection
string examples on www.connectionstrings.com


--
Keith


"Sam White" <noSPAM (AT) Please (DOT) com> wrote