I'm trying to connect sql server to dreamweaver mx to the Northwind database however keep getting "login failed for user 'MOH'. Reason not assosiated with a trusted SQL server connection. I'm not sure where im going wrong.

Have you set up a connection to the sql server through the 'server network utility' first?

Have you made a login through the security node in sql server.

Is the server you're connected to on your local machine or is it a hosted deal?

This'll be really simple to sort out, just let me know the above.

Julian Parkinson
analogue.co.uk

I haven’t setup a connection through server network utility, however I have just looked at it and added ‘Multiprotocol’ in Enabled protocols.??

With regards to login through the security node in SQL server, I’m not sure what that is but when I setup SQL server I did not apply any passwords I let it use the main windows security.

Every thing is on my local machine.

OK, here goes...........I went to a wine tasting eve last night so i'm not 100%!!!!

1. SQL server is ok within windows security but you'll need to set up a 'Login' for web pages to be able to talk to the database. To do this, (in the Management Console) go to the 'Security' folder, expand it, the click on 'Logins'. In the main window (which should have two user accounts like 'BUILTIN/Administrator' and maybe 'sa') right click and create new login.

Give the login a name, set security to be 'SQL Server Authentication', give it a password, select the Northwind dropdown from the db dropdown.

Then go to the database access tab, check the database you want to access, then set the 'database roles' - check 'public' and 'db owner'.

Click OK, re-enter your password and you're done (for that part).

Now, using the login details (username and password) you can set up a SYSTEM DSN in windows (administrative tools) to talk to the database. Don't set up a USER DSN as this probably won't work with your default IIS account!!


The only stumbling block I can foresee is a protocol issue, but go through the above first.

Is your machine on a fixed IP?


Hope this helps. I know the Microsoft documentation and website is no use what so ever.

Useful sources of reference are:

SQL Server 2000 The Complete Reference - Osborne books
www.sql-server-performance.com

Julian Parkinson
analogue.co.uk

The precise message I receive when testing is (Login failed for user ‘NorthDmx2’, Reason: Not associated with a trusted SQL Server connection.). However I do get the Northwind icon to acknowledge a connection has been added. When I go on to the next stage there are no tables for me to select from.

Since every thing is on your local host try this, right click onto the database, go into security panel and check windows and sql server authentication.

This should solve the probelm.

The precise message I receive when testing is (Login failed for user ‘NorthDmx2’, Reason: Not associated with a trusted SQL Server connection.). However I do get the Northwind icon to acknowledge a connection has been added. When I go on to the next stage there are no tables for me to select from.