Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-15 : 08:43:22
|
| Sushama writes "Whenever anonymous access is given to Default Website in Internet Service Manager, the ADODB connection fails - Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'. /engineering1/engg/Uni_list.asp, line 12 This is inspite of giving the username 'sa' in the connection string .Shall I have to configure the sqlserver ? If so what should be the new config. settings?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-15 : 11:56:44
|
| Is SQL on the same machine as IIS? What OS is this?Are you set up for mixed security on SQL?-Chad |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-15 : 12:19:02
|
| Please tell me you're not using the SA login for your web projects. If you're allowing anonymous web access and logging into SQL Server using SA, you're wedging the door open for someone to hack you. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-15 : 17:05:18
|
| And whatever you do, don't tell Rob that you're logging into your SQL Server from the web with User ID SA and the password is blank because that would surely push him over the edge.I agree 100% with Rob on this. A more secure approach would be to create a custom login that you will use from your web application that has severely restricted access and does everything via stored procedures.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
Whenever anonymous access is given to Default Website the ADODB connection fails