IIS Server - Frontpage & MS SQL Connection Error-Please Help

Author

Frontpage & MS SQL Connection Error-Please Help

Sam White

2005-09-28, 6:02 pm

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

bd1099@gmail.com

2005-09-28, 8:52 pm

I'd probably suggest skipping the Windows-Integrated authentication and
just using SQL authentication. The system DSN uses the currently
logged in user to authenticate against the SQL server. If no-one is
logged in to the web server (since you're working remotely through the
IIS side) it won't know what credentials to use.

bd1099@gmail.com

2005-09-28, 8:52 pm

Let me clarify my response just a bit. I know it basically says the
same thing, but just so there isn't any confusion...

I'd suggest modifying your system DSN to use SQL Authentication instead
of Windows Authentication.

Hardcode in the username/pass, and it should come right up.