Web Wiz Forums - Access to SQL Server

Print Page | Close Window

Access to SQL Server

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=18359
Printed Date: 13 April 2026 at 8:55am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access to SQL Server

Posted By: alanshort
Subject: Access to SQL Server
Date Posted: 11 February 2006 at 1:00pm

Hi Guys...

Please excuse any stoopid questions...

I have a 7.9 WWF running with Access, and have integrated it closely with my website. In the last few weeks, I've been having problems with "Microsoft JET Database Engine error '80004005' System resource exceeded." errors. I also have several other Access db's, so it looks like its time to move everything to SQL Server.

So... I've just installed a local copy of SQLServer on a machine here at home so i can get everything working and edit the code before i update it in production.

I've followed the guide on moving to SQL and the db was imported without errors. I've also edited common.asp and SQL_server_connection.asp however it looks like i haven't entered the correct credentials.

I installed SQL to use the system account, however when i put in the user/pass i get

"Microsoft OLE DB Provider for SQL Server error '80004005'

/rc1/forum/common.asp, line 260"

Probably a easy solution, but i can't seem to find it. What's the strSQLDBUserName and strSQLDBPassword and where do i get it from ? Is it my windows admin account ?

secondly...

I've read that i need to run msSQL_server_setup.asp, however I don't seem t
to have that file in my forum... Where can i get it .... ?

Thanks for your help.

Cheers
A

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 February 2006 at 1:34pm

It soudns like either your login details are incorrect, or you havn't setup the SQL Server to run in mixed mode.

The SQL Server needs to be running in mixed mode so you can login using a TCP/IP connection.

-------------
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