This thread is for discussions of Building an E-Commerce Shop Front.

But having a hell of a time getting past this bloody error message

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'MartinC'. Reason: Not associated with a trusted SQL Server connection.
/musicmad/CategoryList.asp, line 12

Have been through user admin changed everything to no avail anybody?

Martin

Found the following using google...

-----

A connection could not be established. Login failed.
Reason: not associated with a trusted SQL Server connection

After a few minutes of messing about and scratching my head, I remembered that while I was trying something else out I had previously set my default client connection type to TCP sockets, which of course don't support trusted connections! Oops. All went well once I had restored the default connection to named pipes. IOW, your SQL Server must support named pipes or multiprotocol for this method to work, which may require rerunning the setup application.
-----

Also, take a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q307002

Got that working somehow dont ask me how but without password (good secruity) sql2000 pants! Anyway now have an issue adding items in the pop list or any list come to think of it doesnt allow items to be added this must be a cookie issue and i have checked to see them enabled locally. Can cookies be tested locally?

I am making 2 sites and one of them is asking people to use their credit cards to be validated and once that has done they can move onto the paying members section.

PSN
THE WORLD OF SOCCER

hello, very good article. however since i am familiar with access, and learning asp. i was wondering if i could use access instead and what code should i use  in order to use msaccess instead of sql ...for this tutorial. Thanx a bundle

is it possible to use microsoft SQL Server 2000 while going through your instructions and how much does it differ

should be exactly the same!

I' trying to connect a simple Frontpage web (using the database wizard) to a database in sql servre 2000. I'm on a network supported by win server 2003 using win xp as clients. I've created login account in the "security" folder of sql server and gave it system admin rights. I also created a user account for that login to access the database and gave it "owner" rights. However everytime i try to write to the table in the database through the website (which is published to IIS on the network server) i get the message Database Results Error (invalid authorization specification). sql servre is configured to accept windows authentication only.

Any help (hopefully more detailed) on this issue will be grtefully received as I'm a novice sql server user.

I am having the same issue.  I created the pages using MS SQL 8.0 and FP2002.  Did you ever get this problem resolved?  Please post if you found a solution.  
Thanks
Charity

Is there an example anywhere of the customer log in?

 

Thanks

 

Frank