Web Wiz Forums - SQL Server Authentication

Print Page | Close Window

SQL Server Authentication

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8433
Printed Date: 07 April 2026 at 5:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server Authentication

Posted By: Snosi
Subject: SQL Server Authentication
Date 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

Replies:

Posted By: WebWiz-Bruce
Date 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?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Snosi
Date 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.

Posted By: danzig
Date 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

Posted By: michael
Date 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

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker