Forums

ASP

This topic is locked

User->IIS->SQL Server

Posted 18 Oct 2002 12:57:12
1
has voted
18 Oct 2002 12:57:12 Mateusz Kus posted:
Hello there!

This is my first post and I'm a real beginner so this may seem ultra basic for all of you pro ASP gurus.

I have a problem with user<->ASP<->SQL Server connection.
I have SQL Server with domain authentification set to identify users. Ive created accounts for each user allowed to view data. My problem is that when I'm testing my intranet with this configuration I get user login error as follows:

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.

What I guess is that IIS isn't passing [domain]+"/"+[user] string correctly (empty domain and user variable resulting with single "/" passed to SQL Server). Can anyone explain me what may be wrong?

PS Additionally - connection settings are working under DWMX. I can view data in Application/Databases/Test2/Tables/dbo.Foo from DW. Its just page that isn't shown correctly.

Reply to this topic