Hi!

How do I log to the server using IIS service credentials?

Yes the database I'm trying to connect is the default for that user

When things get to this point I believe it must be a very simple thing that I'm not seeing.

- I restarted de SQL Server again

- Yes, I can connect using...

just to remember, I can connect to the SQL Server using Query Analyser (using the same user/password)

this is becoming too weird..:w00t:

here's what happened when trying your last suggestions:

conn.open "Driver={SQL Server};Server=192.168.8.93;Database=ead;Uid=ead;Pwd=webead;Trusted_Connection=No"

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)

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

Hi guys!

I created an ODBC connection and still did not get to connect...

here is what happened

using user sa

Provider (0x80004005)

Error not specified

/conn.asp, line 7

using user ead

Microsoft OLE DB Provider for ODBC...

Hi Steve 🙂

Thanks for helping me on this.

Before I posted my topic, I checked this. Yes, the SQL Server is configured to mixed-mode and I can connect when running ASP...