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'
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
Topic Options
Post Options
Thanks(0)
