Avatar billede long Nybegynder
22. marts 1999 - 00:00 Der er 1 løsning

login problem med MS SQL Server 6.5

Vi har en web server, hvor SQL Serveren er installeret.
Jeg har oprettet en DSN ved navn "MedSql".

Når jeg kører scriptet får jeg denne:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not defined as a valid user of a trusted SQL
Server connection.

Avatar billede rdj Nybegynder
23. marts 1999 - 08:23 #1
Jeg fandt dette hos MS

SYMPTOMS
When you access an IDC script, you may receive the following error message:


  Error Performing Query
  *[State=3700][Error=18450][Microsoft][ODBC SQL Driver][SQL Server]
  Login failed- User: _ Reason: Not defined as a valid user of a
  trusted SQL Server Connection.


CAUSE
The error message above may occur in the following conditions:

Your SQL Server is not the same computer as your Internet Information Server (IIS).
You are using Microsoft Windows NT Challenge/Response authentication on IIS.
You are using Integrated or Mixed Security on the Microsoft SQL Server.
You are not are not providing the Username: or Password: values in your IDC Script.

WORKAROUNDS
There are two possible workarounds:

Install SQL Server on the same computer as the Internet Information Server and set up your ODBC System DSN to be Local Server instead or a remote computer name.

-or-
Use Basic Authentication instead of Windows NT Challenge/Response (for example, the user will be prompted to login using a dialog box)

MORE INFORMATION
When the client executes the IDC script, IIS must determine whether the datasource is local or remote. If the datasource defined as Local System, the query is passed to the SQL Server on the same computer. If the datasource is remote, IIS must make a network connection to SQL Server. When it does, it does not pass the credentials of user logged on to the client computer; instead, it passes a blank username and password.

The SQL Server tries to validate a user without a username; it fails, and it returns the following message to IIS:


  Login failed- User: _ Reason: Not defined as a
    valid user of a trusted SQL Server Connection


The Internet Information Server then passes the results of the query to the client web browser.


Jeg ved ikke om du har adgang til denne SQL server, men hvis du har så prøv at rette din odbc til SQL login. Hvis du ikke har sat andre bruger ind, kan du altid bruge sa som brugernavn og lad password være blank.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester