Unix Technical Forum

Frontpage & MS SQL Connection Error-Please Help

This is a discussion on Frontpage & MS SQL Connection Error-Please Help within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are NOT in a domain. The second ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 09:55 PM
Sam White
 
Posts: n/a
Default 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:14 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com