My SQL express database is not connecting

Hi all,

I'm new to Discountasp.net and a novice programmer in asp.net 2.0... i copied all my web project files as it is using my copy website feature in Visual studio 2005.. but after copying i run my website on the internet .. The sign in page uses a simple form authentication from a login control(custom) created by me which checks the username and password against a sql express database file and takes on to the next page but i am not able to connect... when i enter the username and password in the sign in page im staying in the same page.. what does this mean> some one please help...

Also can i use msgbox() function.. im getting an error when i use it on internet.. whats the solution...

Suggestions are kindly welcome

 

you mean to say that i have to create my datasource using a fully functional version of SQL server and upload it.. i cannot afford to buy your add on as of now .. so how to transfer my local database file here and with what modification in the connection string and any other place in my application ? and dont you support msgbox() function..

Post Edited (lifeisbeautiful) : 4/24/2007 4:02:55 PM GMT

 

let me see that im correct... you mean to say that i can design a database file in my local system using either sql express or sql 2005 and upload the .mdf file here using Attach MDF tool is it? anywayz i gotta buy your MS SQL 2005 add on is it?

 

Hi.

For clarification re: your MDF attach tool (along with the SQL2005 addon) ...
How difficult is it to use this ? Are there examples somewhere ...

And, after the "local" database is attached, for further development is the database now on the server and you work "online" or is it still on the local machine and has to be updated whenever new tables or database changes are done ?

This seems to be a recurring issue for people getting onboard with Visual Studio or the Express versions...everything works exactly as it should on the local machine (Thx Cassisi), but publishing and making it work on the net is not something thats so simple.

Also - also, will the membership tables and things that are created locally and function correctly as to Roles and meberships and so forth also do what they are supposed to after the attach tool is used ?

Thanks in advance,

Dave

 

The SQL 2005 Management Tool is fairly easy to use. Try reading this kb article for more information on our SQL Management Tool. http://kb.discountasp.net/article.aspx?id=10431
You will need to insure that you properly close down the database on your local machine first else you will get an error message.

Once you have uploaded the database on our server, it is a completely different database on your local machine from our SQL server. So what every direct changes you do on your local database will not be made on our database server, and vice versa.

Unfortunately once you have uploaded your database on our server, you will need to update your connection string on your web application to point to our server. So if your web applications points to your local db, you will need to update it to our db server along with the correct db name and db login.

--Also - also, will the membership tables and things that are created locally and function correctly as to Roles and meberships and so forth also do what they are supposed to after the attach tool is used ?

It should work as you are merely taking the objects from one database to the other. It should retain the same object names that your web application is referencing to. Keep in mind that the attach and restore tool overrides what ever is on the database on our server. So if you have 2 database's on your local machine, and you use the SQL Tool to attach one database when you attach or restore the 2nd database to our server it will override the original database you uploaded. The work around is one, merge both database together on your local machine, this way you only do one attach or restore procedure. Second, is you upload one database on our server, then rerun the aspnet_regsql.exe on our server. The last one is a little complicated but can also be an alternative. This will require the SQL 2005 import/export function. For instructions on how to use the import/export function of SQL 2005, please reference this ticket thread from our forum. http://community.discountasp.net/default.aspx?f=16&m=8808

 

I'll see what I can do -

Thanks for the detail !