---
title: "Ansluta till M$ SQL 2000"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21840-ansluta-till-m-sql-2000"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Macce"
published: "2001-12-17T10:56:00.000Z"
updated: "2001-12-17T13:47:00.000Z"
replies: 1
views: 218
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/21840-ansluta-till-m-sql-2000"
---

# Ansluta till M$ SQL 2000

## #1 — Macce, 2001-12-17T10:56Z

försöker att via ASP ansluta till sql 2000...
jag har skrivit som LarsG beskriver en .udl-fil som connectar utmärkt:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=pp;Data Source=ILS-DELL

men när jag använder den till mitt ASP-script kommer detta felmeddelnade:

Feltyp:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'ILS-DELL\\IUSR_ILS-DELL'.
/inc_databas_open.asp, line 3

nån som vet vad jag gör för fel ???

Permalänk: https://www.webforum.nu/p/21840

## #2 — Macce, 2001-12-17T13:47Z

Det löste sig...

Windows NT Authentication 
The computer running SQL Server enables access to its data through Windows NT accounts. To enable Windows NT authentication, through the Internet Information Server (IIS) computer, Basic authentication must be enabled for the Web application. To do this, perform the following: 

1\. Start the Internet Services Manager. 

2\. Browse to the Web site, right-click the Web site, and then click Properties . 

3\. Click the Directory Security tab, click Edit under Anonymous access and authentication control, and then select the Basic authentication (password is sent in clear text) option. 

'tack till LarsG' :)

Permalänk: https://www.webforum.nu/p/353475

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21840-ansluta-till-m-sql-2000