Frontpage & MS SQL Connection Error-Please Help

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
.

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • Frontpage & MS SQL Connection Error-Please Help
    ... Hi, I have 2 servers, both with Windows 2003 Standard edition. ... Through OBDC I created a connection to the SQL db. ... I get the this error when I select the "System Data Source on Web ... 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.. ...
    (microsoft.public.sqlserver.clients)
  • Frontpage & MS SQL Connection Error-Please Help
    ... Hi, I have 2 servers, both with Windows 2003 Standard edition. ... Through OBDC I created a connection to the SQL db. ... I get the this error when I select the "System Data Source on Web ... 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.. ...
    (microsoft.public.sqlserver)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
Loading