sql server login

[unicorn11]

i have a asp connection into a sql server called as Server
for a site that i created it was working perfectly till

I ran a Sql server 7 service pack 3

then from login that was working before the update suddenly started giving this


[red]Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SERVER\IUSR_TRIPMEDIA-1'.
connect.asp, line 6 [/red]

i even tried running the sa account but error

but it is connecting through the Query Analyser

regards
Unicorn11
unicorn11@mailcity.com

Luck is not chance, it's toil; fortune's expensive
smile is earned.
Unicorn11
unicorn11@mailcity.com

[red]Luck is not chance, it's toil; fortune's expensive
smile is earned.[red]

 

[Cagliostro]

What kind of autentification had you used before? John Fill

ivfmd@mail.md

 

[unicorn11]

I am connecting via odbc/oledb drivers from my asp page
i also tried to create a dsn to connect to the site

regards Unicorn11
unicorn11@mailcity.com

[red]Luck is not chance, it's toil; fortune's expensive
smile is earned.[red]

 

[Cagliostro]

You might to not put some parameters in DSN string. In this case, if type of autentification changes you can get problems. John Fill

ivfmd@mail.md

 

[unicorn11]

Hi John
the problem has something to do iis anonomyus access
had to change it to nt access

regards Unicorn11
unicorn11@mailcity.com

[red]Luck is not chance, it's toil; fortune's expensive
smile is earned.[red]

 

[Cagliostro]

In this case, set/check again permisions. John Fill

ivfmd@mail.md