Web Wiz Support and Community Forums : SQL Server Authentication

Web Wiz Support and Community Forums : SQL Server Authentication https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 07:25:50 +0000 Tue, 30 Dec 2003 22:49:22 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8433 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server Authentication : That happens when the SQL Server...]]> https://forums.webwiz.net/sql-server-authentication_topic8433_post43755.html#43755 Author: michael
Subject: 8433
Posted: 30 December 2003 at 10:49pm

That happens when the SQL Server is configures on Windows Authentication only, either change it to mixed mode in the Server Properties if you have Enterprise Manager, or you can do it directly in the Registry > Open regedit and navigate to >
HKLM>Software>Microsoft>MSSQLSERVER>MSSQLSERVER& gt; and change the Login Mode Value to 2 (restart service after that)

Alternatively you can add the ASP user to the database using SQL Script which may be risky if you don't do it right.

No reponsibility if you f up your Registry
]]> Tue, 30 Dec 2003 22:49:22 +0000 https://forums.webwiz.net/sql-server-authentication_topic8433_post43755.html#43755 <![CDATA[SQL Server Authentication : Same error here :) I believe my...]]> https://forums.webwiz.net/sql-server-authentication_topic8433_post43723.html#43723 Author: danzig
Subject: 8433
Posted: 30 December 2003 at 4:56pm

Same error here :) I believe my problem is in user permissions . Here is a cut and paste of my error . I think I will work on fixing it tonight :)

my error -->

Microsoft OLE DB Provider for SQL Server error '80004005'

/FORUMS3/common.asp, line 249

]]> Tue, 30 Dec 2003 16:56:02 +0000 https://forums.webwiz.net/sql-server-authentication_topic8433_post43723.html#43723 <![CDATA[SQL Server Authentication : Hello, Yes I believe I have...]]> https://forums.webwiz.net/sql-server-authentication_topic8433_post43699.html#43699 Author: Snosi
Subject: 8433
Posted: 30 December 2003 at 2:36pm

Hello,

Yes I believe I have entered the correct details in SQL_server_connection.asp

servername "local"

DBUserName "sa"

PassWord "PassWord"

DatabaseName "MyForum"

I am recieving the standard error message when connection fails.

" Error Connecting to database on SQL server. Check the following is correct: Name of SQL Server, Database name, and the details in SQL_server_connection.asp."

I have multiple other ASP applications running with a SQL back end but this one has me stumped.

I am sure it is an error on my end that I just over looked.

]]> Tue, 30 Dec 2003 14:36:59 +0000 https://forums.webwiz.net/sql-server-authentication_topic8433_post43699.html#43699 <![CDATA[SQL Server Authentication : What error are you getting? Have...]]> https://forums.webwiz.net/sql-server-authentication_topic8433_post43694.html#43694 Author: WebWiz-Bruce
Subject: 8433
Posted: 30 December 2003 at 2:12pm

What error are you getting?

Have you entered the correct details to connect to your MS SQL Server into the SQL server connection file?

]]> Tue, 30 Dec 2003 14:12:09 +0000 https://forums.webwiz.net/sql-server-authentication_topic8433_post43694.html#43694 <![CDATA[SQL Server Authentication : Hey, I need a little assistance...]]> https://forums.webwiz.net/sql-server-authentication_topic8433_post43692.html#43692 Author: Snosi
Subject: 8433
Posted: 30 December 2003 at 2:04pm

Hey,

I need a little assistance with the SQL Server set up. I have read the instructions numerous times and have a fair understanding of MS SQL Server but still "No Joy".

Off the topic.... Can the Access version be Up-Sized to SQL Server? Looking at the code the big difference is the connection details. Is this a true or mostly true statement?

Any help would be greatly appreciated!

Thanks,

Snosi

]]> Tue, 30 Dec 2003 14:04:23 +0000 https://forums.webwiz.net/sql-server-authentication_topic8433_post43692.html#43692