FOAK: SQL & IIS & buggery bollocks

Asking as a last resort and there are some what knows these things in here.

Just installed SQL 2000, set up users, set up dsn, to which I can connect to
the db through dreamweaver and run queries, so far so good. all appears to
be working fine using login 'MenuPlanner' (see below)

When I run the page on iis which is installed locally on the same machine as
sql server I get

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
requested in login 'MenuPlanner'. Login fails.

Is this an iis or sql issue? I completely stuck - any bright ideas, or
should I just lob it out the window and go and get pissed?

Ta

Buzby

 

Does it work if you use a connection string rather than a DSN? That
should help narrow it down a bit. I don't know about SQL Server, but I
gave up trying to get MySQL to work with a DSN. It's fine with DSN-less
though.

 

Works either way, just not on the local webserver. Just cannot figure it.

Buzby

 

User rights to the data directory?

 

I'd try disabling anonymous access in IIS (assuming you're using it) &
logon as Administrator when it prompts you. That'll at least indicate
whether it's the IIS user permissions or something else causing the
problem.

 

Where would I find that - I think it's all set as allow anonymous access as
far as I can see.

 

That's nailed the bugger. I owe you a beer. TYVM!

Buzby

 

No probs. If you find in the near future that everytime you open a
website, it prompts for a username & password for whatever site you're
visiting, it's because the local site you just disabled anonymous
access on is the default (port 80) & you're running an add-blocking
hosts file.

It took me a good half hour of head scratching to work that out the
first time it happened - oh how I laughed when I realised...