Re: Not Able to Create/Remove DSNs

From: AmazingWolf (amazingwolf_at_hotmail.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 12:19:11 +0200

Hi,
Did you say you choose windows authentication and also put a username and a
password? I think that the username and password are only for SQL
authentication.
Try doing it again without the username and password, maybe it will help.

Wolf

"Stephanie Jones" <stephanierjones@msn.com> wrote in message
news:7C5E3721-EEF5-476B-9C4B-76B0809D74D0@microsoft.com...
> I have a Windows 2000 server with SQL Server 2000 (Standard edition)
installed and IIS 5. I have gone through the motions of creating a System
DSN in the ODBC Data Source Administrator. During the creation process,
everything goes fine even down to testing the Data Source Connection. Here
are the steps I am taking:
> Administrative Tools/Data Sources (ODBC)
> Click the System DSN tab
> Click the Add button
> Select SQL Server driver
> Click the Finish button
> Create a New Data Source to SQL Server dialog box opens
> Give my DSN A name "testDSN"
> Select the Server (on the same server)
> Select the With SQL Server authentication . . . option
> Enter Login ID
> Enter Password
> Change the Default Database: to the proper database.
> Click the Finish button
> Click the Test Data Source button
> Test Successful
> Click OK.
> But no testDSN in System Data Sources list box.
>
> I am not allowed to remove any of the DSN either.
>
> Can someone tell me what the problem is.
>