sql login issues within godaddy hosting account

Discussion in 'MySQL' started by doKtorhallam, Nov 28, 2007.

  1. #1
    hello all, i am having a problem with a site i have hosted on godaddy that i hope someone can help me with. i created the site in vis web devel 2005 express and sql server 2005 express. my default setting for sql was to use windows authentication. i created the site and used the asp.net configuration tool and created roles, users, set it up for forms authentication for internet use, then built the site. then i installed the database publishing wizard and used it to generate the .sql file, then used the file in godaddy hosting control center to create/populate the server databse, then used copy website utility in vis web dev to upload files to server, then connected through ftp and updated the root directory web.config file connectionstring settings to match the host server. in development local environment the site runs perfect, logins and all. but the live server on www, the site runs fine in the anon pages. when i try to log in, i get an error in the login box as if the password was incorrect. i have had many forum posts on asp.net official site forums trying to solve the issue, but am not very familiar/knowledgeable with sql server configuring/setting/scripting/querying. i have had some suggestions as to the problem, it was suggested that i attach the db to sql mgmt studio, create a user, give them full access rights, recreate the objects, tables, etc and rerun the .sql query on the new tables, etc. to repopulate, then regenerate a new .sql file and re-upload it. i got stuck on how to proceed with this right after i made the new user(which i created a specific sql authentication login for, not windows). the site was currently bought and hosted by me for this specific purpose of testing/learning.
    with the trouble i am going through with this, i would first like any help on this issue, but in general, could it be better to create a databse first in sql mgmt studio, then create the user with full access, then attach the db to a project in vwd, then create users/roles/access rules last? is this an easier/better way to go about this?
    thanks in advance for any tips/suggestions/help.
     
    doKtorhallam, Nov 28, 2007 IP