ms sql 2005 connection string and db file upload
-
Need support.... I d'like to copy a file aspnetdb.mdf (ms sql 2005 db) created with microsoft visual web developer 2005 to my websites host. I have already a website copied with asp 2.0 sites to my host without problems. But now it is the first time that i try to copy a ms sql 2005 db. The aspnetdb.mdf works fine on my local PC. Now the provider told me, that i have to create a db Login in his Control Panel for accessing sql 2005 server. I have to define a Login user name and a password. And later a sql 2005 db. My Problem: Why should i create an new sql 2005 db on the host server. I d'like to transfer my local sql 2005 db (microsoft visual web developer 2005) to the host? What changes are necessary in the web.config: The definition on my local pc: Do I have to add a user id and a password? What connection string is necessary to access to my host sql server? Do you know some recommended tutorials? I could not see a solution in the following video: http://www.asp.net/learn/videos/view.aspx?tabid=63&id=5 Thanks a lot for your support. You see -- I am a beginner.... Best regards ullk
-
Need support.... I d'like to copy a file aspnetdb.mdf (ms sql 2005 db) created with microsoft visual web developer 2005 to my websites host. I have already a website copied with asp 2.0 sites to my host without problems. But now it is the first time that i try to copy a ms sql 2005 db. The aspnetdb.mdf works fine on my local PC. Now the provider told me, that i have to create a db Login in his Control Panel for accessing sql 2005 server. I have to define a Login user name and a password. And later a sql 2005 db. My Problem: Why should i create an new sql 2005 db on the host server. I d'like to transfer my local sql 2005 db (microsoft visual web developer 2005) to the host? What changes are necessary in the web.config: The definition on my local pc: Do I have to add a user id and a password? What connection string is necessary to access to my host sql server? Do you know some recommended tutorials? I could not see a solution in the following video: http://www.asp.net/learn/videos/view.aspx?tabid=63&id=5 Thanks a lot for your support. You see -- I am a beginner.... Best regards ullk