Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Database Connection Issues
 CJWSoft Support Info : Database Connection Issues
Subject Info: 2003Server + SQL2005 problems A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
TimC
New User
New User
Avatar

Joined: January/01/2008
Location: United States
Online Status: Offline
Info: 1
Added: January/02/2008 at 12:20am | IP Logged Quote TimC

I have review ALL of the SQL Connection postings & links re: SQL datafiles & connections in the 2003Server & SQL2005 Server Studio.

I'm hope someone has had success with connectionstring and the creation of a SQL file from scratch, including permissions thereto.

I have already downloaded the 'aspprotect_v8_new_installation_script.zip' and followed the link to www.connectionstring.com. Testing each and every on of those, but yet failed with the closes that I ever got close to was "Login failed for user 'aspprotectuser'" via the troubleshooting within dataconn_inc.asp

Any help or direction would be greatly appreciated.



__________________
Thx,
Tim
Back to Top View TimC's Profile Search for other info by TimC Visit TimC's Homepage
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1722
Added: January/02/2008 at 2:41am | IP Logged Quote cwilliams
The app works fine on 2003 server and sql 2005. That is actually what I do all development on.

Is the SQL server professionally set up by a hosting company ?
If not you my not have enabled a very important setting called "SQL Serter and Windows Authentication Mode" Without it on you'll never be able to login using SQL server accounts from ASP code via a connection string.

__________________
Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d - P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com