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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |