basic set up problem
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=25320
Printed Date: 04 April 2026 at 1:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: basic set up problem
Posted By: abossola
Subject: basic set up problem
Date Posted: 19 February 2008 at 4:46pm
alright, this should be much easier I know...but I'm struggling. I can't get past
Web Wiz Forums Database Microsoft SQL Server Setup. here is the error:
Error Connecting to database on SQL Server
Check the following is set up and correct:-
SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server
Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.
Detailed Error Message:
Login failed for user 'rxeob_user_forum'. Reason: Not associated with a trusted SQL Server connection.
Error Details:
Login failed for user 'rxeob_user_forum'. Reason: Not associated with a trusted SQL Server connection.
-------------------------------------------
Does this simply mean that I do not have full privligaes to the Database I am trying to use? It says owner is DBO but the user I created is of another name. I tried to give that user full rights but I'm pretty helpless when it comes to IIS and MSsQL server 2000.
thanks,
Andrew
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 19 February 2008 at 5:38pm
You need to make sure that SQL Server is installed in mixed mode to allow TCP/IP connections.
-------------
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: abossola
Date Posted: 19 February 2008 at 7:37pm
|
my host is not your normal everyday host, so they may need a little guidance in finding that setting.. any suggestions for them would be great?
|
Posted By: abossola
Date Posted: 19 February 2008 at 7:38pm
sorry.. so here is the new error -
Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute
|
Posted By: WebWiz-Bruce
Date Posted: 20 February 2008 at 9:07am
Check your SQL Server login settings in Web Wiz Forums.
If this is a local SQL Server install you would need to use 'localhost' as the location/name of the SQL Server. If it is the free SQL Server Express then you would use 'localhost\SQLEXPRESS' as by default the Express version installs with this name.
-------------
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
|
|