Frontpage & MS SQL Connection Error-Please Help

From: Sam White (noSPAM_at_Please.com)
Date: 09/28/05 

Date: Wed, 28 Sep 2005 16:44:06 -0500

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 Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.inetserver.iis)