SQL server 2K authentication problem

Question

SQL server 2K authentication problem

Paul Gomez

Newbie

Points: 3
More actions
March 1, 2006 at 9:08 pm

#189544

Hi,

I have 2 stand alone Win2K servers in a network; A & B.
Server A has Web server configured and a web site based
on ASP. Server B has MS SQL 2000 database. When I
go to the website in Server A and it hits a ASP page where
the database connection with server B I get the following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

Here is my configuration details:

1. ASP pages has fildsn database connection.
   "fileDSN=mydatabse"
2. In Server A, the ODBC has a fileDSN configured
    for the database sitting in Server B with windows NT
    authentication using the network login ID.
3. In IIS (server A) - Directory Security, anonymous access &
   integrated windows authentication are checked.
4. In server A, in OS level, IUSR_SERVER-A account is there.

If these both servers are in a domain I could create the same
account in both servers but they are stand alone.

I would appreciate any help on this as I am going nowhere with
this issue for the last couple of days..

Thanks,

Paul

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Vichka Ten Centuries Points: 1218 More actions · Answer 1

Hi Paul,

I am just guessing... Try to play with connections and authentication, make it mixed (windows and SQL), refresh everything, create new connections... Something is there just not finding each other... Create new user (it says user '(null)' - is it should be that way? maybe it's not finding the users? create new account or something like that).

Try everything! Good luck!

sql_newbie Newbie Points: 9 More actions · Answer 2

When you setup your ODBC connection on Server A, did you run the 'Test Connectivity' test? You setup Windows NT authentication for your ODBC connection, but what is your SQL server's authentication settings set to? (Windows, SQL, Mixed)

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 3

By 'stand alone' I assume tat you mean 'workgrpoups'. If this is the case then you need to put things in a domain.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Perry-300990 Default port Points: 1451 More actions · Answer 4

Perry-300990

Default port

Points: 1451

March 6, 2006 at 4:44 pm

#625072

http://support.microsoft.com/kb/889615/en-us