Web Wiz Support and Community Forums : Access to SQL Server https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 10:22:17 +0000 Sun, 12 Feb 2006 13:34:29 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18359 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access to SQL Server : It soudns like either your login...]]> https://forums.webwiz.net/access-to-sql-server_topic18359_post99302.html#99302 Author: WebWiz-Bruce
Subject: 18359
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.
]]> Sun, 12 Feb 2006 13:34:29 +0000 https://forums.webwiz.net/access-to-sql-server_topic18359_post99302.html#99302 <![CDATA[Access to SQL Server : Hi Guys... Please excuse...]]> https://forums.webwiz.net/access-to-sql-server_topic18359_post99247.html#99247 Author: alanshort
Subject: 18359
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 closelywith 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 otherAccess 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 hereat home so i can get everything working and edit the code before iupdate 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'

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

/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



]]> Sat, 11 Feb 2006 13:00:00 +0000 https://forums.webwiz.net/access-to-sql-server_topic18359_post99247.html#99247