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
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@.Please.com> wrote in message
news:wuCdnbihoqAZk6beRVn-3g@.giganews.com...
> 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
|||I meant to mention in my previous post that you can look up connection
string examples on www.connectionstrings.com
Keith
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbihoqAZk6beRVn-3g@.giganews.com...
> 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
sql