This topic is locked
3 replies
|
R
|
Roger 1/22/2010 |
|
I have built numerous sites with ASPRunner and MS ACCESS. I never have any problems with my USER TABLE and a LOGIN PAGE using Access. However with MS SQL for the life of me I cannot get it to work. Every single login except GUEST returns an "Invalid Login". My Username and Password field are VARCHAR. I have check this entire forum, made sure I have no trailing spaces in the usename. I have tried both encrypted and unencrypted passwords. But, alas I can only log in as a GUEST. I can Hard Code one User and it works fine. I also use ASPMaker for some sites and I never have this problem using that application. Anyone have any ideas - this is driving me absolutely crazy.
|
|
|
Sergey Kornilov admin 1/22/2010 |
|
Hard to tell without seeing the actual application. I suggest to post your project to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. |
|
|
M
|
mgill2525 author 1/22/2010 |
|
With MS SQL, you have to "Explicitly" give permissions to the tables (each table) as well as for each action you wish the user to have. I definately recommend NOT using SA - period - at all. Create a seperate acount, give them appropriate DB_??? rights and permissions to the table actions. Depending on the version of MS SQL (can't just say SQL), there is 7, 2K, 2K3, 2K5, 2K8 etc), the method of doing this will vary, but if you are playing with MS SQL, you probably know how to do this. Cheers... |
|