Lost in the forest--sqlserver

Question

I have multiple questions regarding sqlserver.  This will probably get me a reprimand for violating the rules, but I would appreciate someone's overview of where I've been and where I am going. Here goes:

I've been developing in ASP.NET/VB for about a year on a Vista machine using Visual Web Developer Express.  I am now using a trial of VS2010 which will expire in a short time and I still have not got a final confirmation that I can deploy my applications to my hosted server.  Most of my time has been spent in determining how to install one version of this and that and then reinstall and hope for better results.  My database application is really the only thing that is keeping me from moving ahead.  My host tells me that I need to convert the server 2008 database to a 2008 R2 format to run the application.

Here come the questions.  

1.  I was told by my host to simply run sqlserver management console to run the conversion.  I acquired this animal to no avail.  Whatever I tried, I was told to try something else.

2.  I got a very respectable answer the other day that told me that all I need to do to convert from 2008 to 2008R2 is to do a backup of 2008 and a restore to a 2008R2 instance.  The only question raised by this easy-to-understand process is what must I do to do a backup.  I have been programming for a long time and always understood backup to mean a simple process of copying a file for safekeeping.  Not so here!  It seems that I would have to read for a very long time to understand how to go about in this environment.  I saw no option to do this backup within the sqlserver2008 software.  I suspect that I need to run setup again to obtain that option.  Since I installed server 2008 myself, I do not understand why the proper setup option was not given me.  Nonetheless, my first question is merely a confirmation that this is what I need to do to obtain a backup capability.

3.  Assuming that I have the backup capability, what is the next stumbling block? Will a 2008R2 instance be required in order to do the restore?  I do not have a 2008 R2 instance so how will I do the restore?  Do I need to be running ss2008R2?  If so, then that leads me to the next question.

4.  If I was running  2008R2 server, then I presume I would not need to do any kind of conversion, backup/restore and I would be ready to deploy the application and the database, correct?  The only question this raises is whether a sqlserver2008R2 is compatible with VS2010 which is what I am running now. 

 

I hope these questions are easy for a knowledgeable respondee.  Thanks anyone.

 

---

eps123

Answer 1

Hello,

First install SQL Server 2008 R2 with Tools from the following link:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23650

This will install SQL Server Management Studio, tool that you will use to perform the backup/restore.

Use the following procedure to backup your database on the SQL Server 2008 instance and then restore it on the SQL Server 2008 R2 instance.

http://msdn.microsoft.com/en-us/library/ms187510(v=SQL.100).aspx

http://msdn.microsoft.com/en-us/library/ms177429(v=SQL.100).aspx

Change the database connection.

http://weblogs.asp.net/nannettethacker/archive/2008/02/17/creating-a-database-connection-to-a-remote-sql-server-database-within-visual-web-developer.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

I certainly marked the response as an answer because it completely provided me with the steps to accomplish my backup (item 2 of my list).  However, it did not answer my other questions (items 3 and 4).  I will restate item 3 here.  Assuming I have installed 2008R2 and backed up my ss2008 database, what do I need to do?  Do I create a 2008R2 instance so that I can restore to it?

This question above leads me to my item 4 in my original posting.  Basically, that question is:  Does 2008R2 work with Visual Studio 2010 that I have been using?  If so, then I will not need to do any conversions, backups and restores in the future, and be able to deploy applications and databases directly to my remote host.  Correct?

Thanks for your response ASAP.

EPS123

 

---

eps123

Answer 3

Hello,

Q#3. On the first link I provided above you will find a download that will provide you SQL Server 2008 R2 Express and SQL Server Management Studio. Once you install from the link the SQL Server 2008 R2 instance will be created.

Q#4. SQL Server 2008 R2 and VS 2010 are made to work together. I do not see any more conversions in the future, unless a new VS is used in the future.

If you have more questions please just ask me.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

 

Answer 4

Thank you much Alberto,

I anticipate a few bumps in the installation, but its nice to know where you are going and why.

 

---

eps123

Answer 5

Hello,

I will keep visiting this thread, in case you need me.

Thank you for your kindness and for visiting this forum.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 6

I encountered the first bump when I began the link you sent.  I followed instructions to download the manager (4.5 I believe) and was stopped in the process of installing with a popup indicating, from memory, "elevated permissions" or similar.  I do not know how to proceed.  I cannot react because I do not know what the msg means.  If it means I do not have priviliges, I cannot get them since I am as administrator.  Any suggestion is welcomed.

 

---

eps123

Answer 7

Hello,

Please provide me a print screen of the error or provide me the exact error as it is displayed on screen.

If you were running SQL Server setup, please post in this thread the summary.txt log file if it exists. The following article will help you locate the log:

http://msdn.microsoft.com/en-us/library/ms143702.aspx


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 8

Sorry Alberto, I started over and chose a different path thus eliminating the popup diagnostic I was getting before.  This time I seemed to have gotten to a SQLSERVER2008 R2 installation.  I chose new install and proceeded as if I knew what I was doing.  It looks like I was in the process of configuring the server and got stuck.  I do not remember that the 2008 install was as difficult.  I believe that this one will require me to study for a year.  I'm trying to not whine and complain because I am seeking your help, but I cannot believe that this is intended for an average user.  I'll try to paste in the status window I was at when I adjourned.  Please advise me as to the easiest way to proceed.  Is there a shortcut that will assume that an average mortal is doing this, and does not need all the bells and whistles and options?

Thanks for your patience.

 

---

eps123

Answer 9

Hello,

Maybe the following guide helps you:

http://www.sqlcoffee.com/SQLServer2008_0013.htm

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 10

Thanks for the guide.  It tells me I need download manager 4.5.  The MS site tells me to select which files are applicable to download.  I take some guesses about this and end up with apparently the right one.  I then get the failure indicated by the following screenshot.  This is the failure that I was referring to 2 days ago.

Thanks for your further guidance.  I am getting an error in trying to submit this reply with some kind of html error.. Not to belabor this, the screenshot only shows that I am extracting the 4.5 exe and then a pop-up saying "the requested operation requires Elevation"

An update to the above:  I tried running the install 4.5 as administrator, and eliminated the previous diagnostic, but only to be replaced by an even more ridiculous one saying "There is not enough storage to execute this request"  or something similar.  Hope this is useful, at least as far as determining what is wrong with my environment. 

eps123

 

---

eps123

Answer 11

Hello,

Please share with me a print screen of the error.

Thank you in advance.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 12

---

eps123

Answer 13

---

eps123

Answer 14

Hello,

I don’t know why I cannot see the image from the office or using my USB wireless. Send it to amorillo @ sqlcoffee.com.

Thank you.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 15

Thank you again, MVP.  After two weeks of struggles, it turns out that all I needed to do to make this installation work was to disable the Firewall as you suggested.  Now I am excited that I can maybe get something done.  I am ready for step 2 which is to backup my little DB and then restore to my r2 instance.  I started to do this and was stumped immediately, so I think I need to do some more reading and stumbling before seeking more help. 

I just wanted to get back to you ASAP to acknowledge the progress, so thanx again.

EPS123

 

---

eps123

Answer 16

Hello,

Please post here the error or a print screen (or a link to the print screen). Sharing the issue on the forum you may advance faster.

I am glad you are advancing in your project.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 17

I have a problem with the process and hope someone can set me straight.  Earlier in the thread, Alberto, you seemed to set me straight with a nice tidy explanation of where I was going with the backup and restore procedures.  I seemed to have had a problem installing sqlserver 2008R2, and I thought that the problem was resolved.  Since I cannot follow the steps you gave me for the backup procedure, I think I have an additional problem.  You seemed to be saying that I should have both ss2008R2 and management console.  I see the 2008r2 as a program on my system, but it does not provide me with a link to the management console.  I really hope that this is my problem at this juncture, and if so, please tell me where I have strayed.

Thank you in advance.

eps123

---

eps123

Answer 18

 

Hello,

I am glad to see in this forum again, you can download and install SQL Server Management Studio from the following link:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22985

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 19

Sorry Alberto but I am still confused.  As I said before, I believe I have successfully installed SQLServer 2008 R2 on this computer.  The link you provided seems to be doing the same thing although the ID is slightly different than the one you had provided earlier.  Maybe its me.  Is Management Studio and SS R2 the same thing?  If they are, then nothing is going to be different if I repeat the install.

As I said before, if "R2" is correctly installed (which I think it is), then it does not give me a link to the management option (that I thought would allow me to do the backup).  Sorry to be a pain.

eps123 

 

---

eps123

Answer 20

 

Hello,

Please run SQL Server Discovery Report, this way we will know if you installed SQL Server Management Studio. If it is not listed, then download and install the last link I posted.

http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 21

You're batting 1000!  Did as told, and discovered that the report was empty even though "R2" was indicated as a program on my System and I recall getting a successful install message when I tried your link before.  No matter, I did repeat the install and the discovery report showed that monitor was present.  Clicked on your next instruction for accomplishing the backup and got the following instructions

__________________________________________________________________________________________

After connecting to the appropriate instance of the Microsoft SQL Server Database Engine,
 in Object Explorer, click the server name to expand the server tree.

Expand Databases, and depending on the database, either select a user database or expand
System Databases and select a system database.

__________________________________________________________________________________________

My problem here is that I cannot identify my user database.  (It is one that I employ within VS2010).  Any ideas??  Thank you.

---

eps123

Answer 22

 

Hello,

Open SQL Server Configuration Manager, start SQL Server Browser Service. Then run the following command at the Command Prompt:

SQLCMD –L

This will give you the name of the old SQL Server instance and the new SQL Server instance. Connect to both instances using SQL Server Management Studio and expand the databases folder, looking for your user databases.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 23

Thank you Alberto,  I did as you suggested, but this procedure merely identified two server instances (if this is the correct terminology) that I discover when I drill down in the connect screen  of the R2 management studio.  I have been aimlessly wandering and probing trying to find my database so that I can do that backup.  I have tried probing all types of database files (from System to temp) to no avail.  I have tried obtaining help from every source available to me and found reams of items, but none provided me any relief.  Please tell me where to go or what to do to get this done.

Thank you again in advance.

eps123

---

eps123

Answer 24

 

Hello,

Please search your hard drive for all files with extension .mdf (*.mdf), maybe there you can identify the database you created.

http://www.windows7news.com/2009/06/30/finding-files-faster-with-windows-7-search/

http://windows.microsoft.com/en-US/windows-vista/Tips-for-finding-files

Try to attach it to the newly installed instance with the following procedure. Then you will see the database listed on SQL Server Management Studio.

http://msdn.microsoft.com/en-us/library/ms190209.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 25

I do not need to search the computer.  I know precisely where the MDF file is located.  My problem is being able to drill down to it in "R2 Studio".  Once I have logged in, the only way I get to explore is by exercising "Attach to Databases".  Then, I can explore to c:\users\newadmin, but no further, and my database is down further at ..\documents\visual studio 2010\websites\website34\app_data\.  Its probably something very basic, but I sure don't get it.  Just to review, I am running sqlserver 2008R2.  Help?

eps123

---

eps123

Answer 26

 

Hello,

It seems a matter of permissions to access the folder. The following resources may help:

http://www.blogsdna.com/2159/how-to-take-ownership-grant-permissions-to-access-files-folder-in-windows-7.htm

http://www.w7forums.com/take-ownership-files-and-folders-t2345.html

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 27

Thank you for this answer.  Before I even try it to see if it solves my current problem, I can predict that it will be the solution to this and several other past problems in VS2010 that I have worked around or swept under the rug.  Like several other comments on the thread you provided, I too cannot understand why this step was made necessary.

eps123

---

eps123

Answer 28

 

Hello,

It seems to me that people has not been able to deal with the security enhancements that have introduced since Windows Vista. The fact that windows account run applications with low privileges makes it hard for the majority of users.

Every time I start a new course about databases at universities, issues related with permissions always arise.

By the way, using the “Run as Administrator” option may help you get rid of a lot of issues also.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 29

I wish I had good news to report.  I have tried running as administrator as your last suggestion gave me.  I have done everything suggested by your previous "take ownership" article mostly verifying ownership rights and roles for my own user, system and administrators.  When I run "management studio" as admin I get two choices of database engines (EPS\SQLEXPRESS or EPS). For both of these,  I have opted to attach to DATABASES and then drilled down attempting to find my own database MDF file which is located in "COMPUTER\USERS\USERNAME\documents\vs2010\websites\website34\app_data".  I cannot get below username to documents in order to find the mdf, and I have rechecked the permissions on "documents".  

I hope you have some other option for me to try, or something else to read and study.  I'm getting kind of discouraged because this step was only supposed to be necessary to avoid some steps that I perceived as being more  difficult.

Thank you.

     

---

eps123

Answer 30

 

Hello,

On a previous screenshot you posted (Jan 11) I can now see you are using NT AUTHORITY\Network Service to start SQL Server service. That account has the lowest privileges on the computer. I would suggest to change the service account by a Windows account with administrative privileges on the computer.

You can also provide permissions to that account on the folder where the database file is located.

Let me know if you need step-by-step instructions on that.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 31

I would be very thankful to get the details on both steps, eg., changing the Service Account and changing the permissions on the DB account. I'd like to try it on my own but I sense that we are so close that I would hate to muck things up at this juncture.

Thank you

eps123

---

eps123

Answer 32

 

Hello,

Try creating a new user account with administrative privileges, with the following article:

http://www.bleepingcomputer.com/tutorials/create-new-user-account-in-windows-vista-7/

On step 6 choose Administrator.

Now change the service account of SQL Server using the following procedure:

http://msdn.microsoft.com/en-us/library/ms345578(v=sql.105).aspx

Assign Full Control permissions on the app_data folder using the previous article I posted.

The following thread may be helpful:

http://stackoverflow.com/questions/2579709/cant-attach-mdf-into-sql-server-management


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 33

Thank you again Alberto.  Your post took me through the steps and I obeyed.  I created a new administrator account which did not include any steps I had not taken when I created the account that I have been running under.  I took the step to make the new account, named VS2010, the starter of SQLEXPRESS.  One question on that step is "should I have done the same for the 4 other services listed (I believe 2 involve MSSQL and 2 are agents for something) ?  I proceded to give full control to the account for my "WEBSITES" directory which seemed to carry down to the website containing the app_data file containing the MDF I want.  I then execute R2 and get the result shown below

Obviously my question is how to proceed to correct this.  Maybe the configuration which took place for the new account when I first ran R2 is different.  Should I perhaps make the old account the sqlserver startup?  Have I missed something?  Looking forward to an answer.

eps123

---

eps123

Answer 34

 

Hello,

It seems an issue related with you are logged in with a user that is not sysadmin in the SQL Server instance. When you installed setup you should have make a click on a button saying “Add Current User” on the “Database Engine Configuration” page of setup, but this is not a problem, Parmesh is given you a workaround on the following thread:

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/91a27e23-c760-4ac1-80f4-0fac220c1adb/

The “Run as Administrator” option is worth a try if the above does not work.

Try to add your Windows account as sysdamin on the SQL server instance.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 35

Hi Alberto,

I've pasted in the Parmesh "Workaround"  below".  Can you please give me a hint as to where to apply this procedure and how to get to T-SQL.  I'm very unknowledgeable on T-SQL, MSSQLSERVER among other things, so if you could give me a starting point of where I need to read up on what I am doing, it might make things easier.

Thanks again

eps123

___________________________________________________

This is a known issue when attaching a database through SSMS using a login which is not sysadmin, one hits this error.

The workaround for this currently is to use T-SQL to attach database .

CREATE DATABASE [databasename] ON

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\databasename.mdf' ),

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\databasename_log.LDF' )

FOR ATTACH

---

eps123

Answer 36

 

Hello,

Once you open SQL Server Management studio and get connected to the SQL Server instance. Make a right click on the server name and select New Query.

Paste Parmesh code, [change databasename] with the name of your database and change the path where the database files are located.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 37

Alberto,

We have a success!  Tried the Parmesh procedure three times before I figured out that the System was objecting to the Creation of a new Log file.  When I eliminated that step in the procedure, I got success, and following that I was able to add my file finally.  I should now be able to get to the database to do my backup, correct?

Alberto, I have been in this business for almost 50 years, getting support and giving support, but I have not run into anyone who has been as diligent as you have been thru this saga.  I do hope you receive the recognition you deserve, and please let me know how or where I can further post this accolade.

Thanks again,

EPS123

 

---

eps123

Answer 38

 

Hello,

This success really belongs to you, since you have had the patience and persistence to keep beating obstacles for two months now.

The best recognition I can have is what you have learned during this process. Keep using SQL Server. If you have any issues just let us know by creating a thread in this forum or sending me an email.

Please go ahead with the restore.

Thank you for your kindness. This has been a great experience for me also..

Regards,

Alberto Morillo
SQLCoffee.com

Answer 39

Everything went as advertised.  I did the backup and it reported as successful.  I proceeded to restore the database and assigned a different name to it than the original using the same location as the original that procedure also reported success.  (Should I have used the name and location of the backup set as the database to restore?)  The resulting restored DB is the identical size as my original.  It was to be a converted (to R2 format) db that I can move to my host.  How do I (or will I) be able to identify the format of the R2 file?

Do you need more information from me?  Please let me know.  I can tell you that I did deviate from the directions as follow.  When I first attempted the backup,  I got an error that resembled a security violation (I have a screen shot if its relevant).  I decided to try running the backup in the original administrator account rather than the new account I had created.  I did this on a hunch since that account is the owner of the DB and I do not recall any way that higher privileges were granted when I created the new account.  Anyway, there were no objections either on the backup or on the restore. 

Anxiously awaiting your response.

EpS123

 

---

eps123

Answer 40

 

Hello,

Please run the following instructions on the database using SQL Server Management Studio:

DBCC TRACEON (3604); 

GO

DBCC DBINFO

GO

DBCC TRACEOFF (3604);

Examine the results and look for the number next to “dbi_createVersion =”. If the number is equal or greater than 660 the database has been upgraded to SQL Server 2008 R2.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 41

Thanks for that, but the results are as follow:

I complained too early, and fortunately for you I have gotten back to correct my response before you got to it and wasted your time.  Anyway, when I figured out that the (3604) is relevant and should not be followed by a ".", I ran successfully in both my new admin user account and my old user account that is the owner.  The newly restored MDF indicates a dbi_create version of 611 to my great joy.  For the heck of it, I ran the query on the old mdf hoping to see something less than 600 but I did not get it.  The dbname was not provided, or was listed as master, (with a value of 611).

For now, Alberto, I will try to proceed to install the restored file on my host and see what happens.

Thank you again.

eps123

Answer 42

 

Hello,

Please use the USE command to set the database before running the code I posted above.

USE YourDatabaseName

It seems you ran the procedure over the master database J

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 43

Hello Alberto,

You helped me resolve the last issue beautifully and now I am in a desperate situation trying to repeat what I had before I lost my disc.  If you are no longer in the forum support business, then maybe you can refer me to the proper place or person to answer a couple of basic questions.  I am using Vista to host my Visual Studio 2010 that has been installed successfully.  But, when I tried to return to where I had been before my crash, I discovered that my recovered system does not have a sql server on it.  Sooooo, my basic question is what do I need to install?  Following our thread from before, I believe you said that I could go directly to a sqlserver 2008R2 which is the format I need to get to.  Is it that simple?  Please help me by answering directly or referring me.

Thanks in advance.

EPS123

---

eps123

Answer 44

Hello,

I am really glad to see you again in this forum!

Please download SQL Server 2008 R2 with Tools included from the following link:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=23650

Prior to install SQL Server, do not forget to create a user account first, to use it as SQL Server service account.

http://www.bleepingcomputer.com/tutorials/create-new-user-account-in-windows-vista-7/

On step 6 choose Administrator.

The following guide may help you installing SQL Server 2008 R2 Express:

http://blogs.msdn.com/b/petersad/archive/2009/11/13/how-to-install-sql-server-2008-r2-express-edition-november-ctp.aspx (On step 7 change the account name and password for the newly created account).

Just let me know if you have any questions.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 45

Thanks for the quick response.  I'm trying hard to make few mistakes.  Therefore this question:

The download instructions say to prepare by downloading several items, among them, Framework 3.5 SP1.  I have already had framework 4.0 installed in conjunction with my VS2010 install.  Do I skip the 3.5?  Second question is: The user account I am to create is where I will operate?  Or just a name to provide to the server?

---

eps123

Answer 46

Hello,

Please enable .NET Framework 3.5 using Control Panel -> Program and Features -> Turn on or off features, if the computer has Windows 7.

The user account is for SQL Server use only, and remember to assign a strong password to the account like p@ssw0rd.

In 10 minutes I have to leave to the university… in case you see it takes me sometime to reply.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 47

Thank you again Alberto, the install went smoothly and seems to be just what I needed to restore my VS2010 capability.  I am now ready to take on my deployment puzzle once more.

eps123

---

eps123

Answer 48

Hello,

I am really glad!

Thank you for letting me know and for visiting this forum again.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 49

Hello Alberto,

I am re-contacting you because you are the only person that has helped me in all the time I have spent on all forums.  My problem is in configuring my website to run.  It runs beautifully on my local server, but no matter what I have tried, does not function on my host provider.  Reams of suggested solutions and recommendations have been directed at me.  Most of these suggest a link that will provide a solution, but no cigar.  One of your own finest (BBCOMPENT1) went as far as to log in to my site to assist me, but it fell short, I lost my computer's files, and have not been able to reconnect with him.  I have posted requests for help on several sites, free or not, and have not been successful.  What I am trying to do is not rocket science, but is seems that short of enrolling in a PHD program, I cannot proceed. 

Anyway, Alberto, can you give me a name of someone I can turn to so that I can move ahead?  I will be additionally thankful.

Sincerely,

eps123

---

eps123

Answer 50

Hello,

I would try to help you first. Let’s see if we are able to put this to work together.

Please let me know what IIS you are using or what windows version has the PC where you developed your Web site. I suspect it should be a matter of configuring IIS on the Web hosting.

Any explicit error you can share with us, would give me an idea of what we may need to do to make your Web site work. Do not feel discouraged, setting up a Web site is always like that for me too. Many details involved.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 51

Alberto, as always your responsiveness is greatly appreciated.  I am using Visual Studio 2010 employing Framework 4.0 on a VISTA computer.  My website is essentially a menu whose options all work with the exception of item 2, selection 1 (DATABASE TEST).  The menu works fine from day1, so I have assumed that only the database application is sensitive to the WEB.CONFIG file. I have been thru several generations of this file and none has worked. 

My web site is http://leads2012.net if you want a first hand look at the problem.  The failure that I get is the page that is displayed when the DATABASE TEST option is selected.  The current WEB.config file is pasted here below.

<?xml version="1.0"?>

<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
  <connectionStrings>
    <add name="ApplicationServices" connectionString="data source=SQL2008_835653_juliedvd;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
      providerName="System.Data.SqlClient" />
    <add name="JulieDVDConnectionString" connectionString="Data Source=SQL2008_835653_juliedvd;AttachDbFilename=|DataDirectory|\aspnetdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

  <system.web>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.0" />

    <authentication mode="Forms">
      <forms loginUrl="~/Account/Login.aspx" timeout="2880" />
    </authentication>

    <membership>
      <providers>
        <clear/>
        <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices"
             enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"
             maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
             applicationName="/" />
      </providers>
    </membership>

    <profile>
      <providers>
        <clear/>
        <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
      </providers>
    </profile>

    <roleManager enabled="false">
      <providers>
        <clear/>
        <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/" />
        <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />
      </providers>
    </roleManager>

  </system.web>

  <system.webServer>
     <modules runAllManagedModulesForAllRequests="true"/>
  </system.webServer>
</configuration>
_________________________________________________________________

My FTP login information can be provided to you in case you want it.  Please let me know what is missing from the above and I will get it to you promptly.

I will be traveling North for about 10 days, but my computer will be accessible to me (or anyone I designate).

Thanks in advance,

eps123 (Eli)

---

eps123

Answer 52

Hello,

Eli I just removed the information about the Web hosting.

Let me see what is needed to make it work.

Allow me a few hours to get back to you.


Regards,
Alberto Morillo
SQLCoffee.com

Answer 53

Hello,

It seems the connection string you are using is not correct. That connection string is good on an instance using SQL Server Express, but SQL2008_835653_juliedvd is not an Express instance. User instances can be used on Express instances only.

The connection string you should be using for that instance and from the application is:
"Data Source=tcp:sql2k802.discountasp.net;Initial Catalog=SQL2008_835653_juliedvd;User ID=SQL2008_835653_juliedvd_user;Password=******;"

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 54

Hi Alberto,

I seem to have lost a previous message to you, but it was only thanking you and saying I would apply your correction when I got to a good  with spot on my trip.  Anyway, I finally got to try something and no success.  I am groping, but I tried to apply the info you gave me above to the config.web file.  I'll paste in the edited version below, but what I got when I tried it was a bold message saying that the file was "badly formed".  Here is the latest file if it provides you any insight.  The only thing I have gleaned from this is that the config file only involves the Database application since deleting it from the root restored the menu to its previous state.

____________________________________________________________________________________

 <?xml version="1.0"?>

<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
  <connectionStrings>
    <add name="ApplicationServices" connectionString="data source=tcp:sql2k802.discountasp.net;initial catalog=SQL2008_835653_juliedvd;User ID=SQL2008_835653_juliedvd_user;Password=******.";Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
      providerName="System.Data.SqlClient" />
    <add name="JulieDVDConnectionString" connectionString="data source=tcp:sql2k802.discountasp.net;initial catalog=SQL2008_835653_juliedvd;User ID=SQL2008_835653_juliedvd_user;Password=******.";AttachDbFilename=|DataDirectory|\aspnetdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

  <system.web>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.0" />

    <authentication mode="Forms">
      <forms loginUrl="~/Account/Login.aspx" timeout="2880" />
    </authentication>

    <membership>
      <providers>
        <clear/>
        <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices"
             enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"
             maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
             applicationName="/" />
      </providers>
    </membership>

    <profile>
      <providers>
        <clear/>
        <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
      </providers>
    </profile>

    <roleManager enabled="false">
      <providers>
        <clear/>
        <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/" />
        <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />
      </providers>
    </roleManager>

  </system.web>

  <system.webServer>
     <modules runAllManagedModulesForAllRequests="true"/>
  </system.webServer>
</configuration>

---

eps123

Answer 55

Hello,

The database name is now SQL2008_835653_juliedvd on the ISP side.

You may have to backup the database on your PC and restore it on the SQL2008_835653_juliedvd database (MS SQL Database Manager -> SQL Tool Suite). You don’t have to use the AttachDBFilename on the connection string. Use the connection string I provided above and provide the appropriate password.

The following resources may help you with the backup/restore procedure:

http://community.discountasp.net/showthread.php?p=29437

https://my.discountasp.net/mssql2008-tools.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 56

Thank you Alberto,

Just got back to my problem today and found myself groping to interpret what you said and translate to an action on the web file.  I suspect I need to learn XML to understand the syntax of the statements.  Where do I begin?  Having applied your suggestion, I received the following:

_______________

Server Error

Internet Information Services 7.5
Error Summary
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.
Detailed Error Information
Module    IIS Web Core
Notification    Unknown
Handler    Not yet determined
Error Code    0x8007000d
Config Error    Configuration file is not well-formed XML
Config File    \\?\E:\web\leads2009ne\htdocs\web.config
Requested URL    http://leads2012.net:80/
Physical Path    
Logon Method    Not yet determined
Logon User    Not yet determined
Config Source

    1:  <?xml version="1.0"?>
    2:

Links and More Information This error occurs when there is a problem reading the configuration file for the Web server or Web application. In some cases, the event logs may contain more information about what caused this error.

View more information »
_____________________________

The config that I had modified is pasted in below:

______________________________________

 <?xml version="1.0"?>

<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
  <connectionStrings>
    <add name="ApplicationServices" connectionString="data source=tcp:sql2k802.discountasp.net;initial catalog=SQL2008_835653_juliedvd;User ID=SQL2008_835653_juliedvd_user;Password=******.";Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
      providerName="System.Data.SqlClient" />
    <add name="JulieDVDConnectionString" connectionString=SQL2008_835653_juliedvd;User ID=SQL2008_835653_juliedvd_user;Password=leadss01.";
      providerName="System.Data.SqlClient" />
  </connectionStrings>

  <system.web>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.0" />

    <authentication mode="Forms">
      <forms loginUrl="~/Account/Login.aspx" timeout="2880" />
    </authentication>

    <membership>
      <providers>
        <clear/>
        <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices"
             enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"
             maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
             applicationName="/" />
      </providers>
    </membership>

    <profile>
      <providers>
        <clear/>
        <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
      </providers>
    </profile>

    <roleManager enabled="false">
      <providers>
        <clear/>
        <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/" />
        <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />
      </providers>
    </roleManager>

  </system.web>

  <system.webServer>
     <modules runAllManagedModulesForAllRequests="true"/>
  </system.webServer>
</configuration>
________________________________________

I have ignored the backup/restore portion of your response only because at this time I do not feel it has anything to do with the error I am experiencing.  I am now promising a capability to a client and sailing along with the development of the application in VS2010.  Many tables to be added with much sql, but I believe that the basic configuration will remain the same (hope this is true).

Sorry for my ignorance.

Eps123

---

eps123

Answer 57

Hello Eli,

Your application is expecting the same set of tables you have on the PC where you developed the application. That is the reason I am asking you to first backup the database on your PC and restore it on the ISP database server.

Please remove “Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" from the connection string.  

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 58

I will try to answer this response now, since I erred n my last answer.  First I tried doing the restore-backup procedure you suggest.  In doing that I referred to your original link on how to backup a database.  Last time I did this with your able assistance, I believe I only used the procedure for SQLSERVER2008, but now I have the SQLSERVER2008 R2, so I referred to that potion of the link as shown below.

To back up a database

• After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

• Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.

• I believe the connection is proper but following directions, I do not know how to proceed.  Which "User database"  or which "System database" do I select?  Furthermore, in exploring, I do not even see a mention of my MDF database.  So, I am back to go, and would love to have your assistance in telling me what I am doing, or have done wrong.  

Thank you,

Eps123

---

eps123

Answer 59

Hello Eli,

We need a copy of the application database you have on the personal computer on the ISP database server. The application as you have it on your PC is working with a database you created. Since you want to publish the application on the Web we need to recreate the database on the Web, or the application won’t work.

The following tools will help you recreate the database on ISP database server:

http://community.discountasp.net/showthread.php?p=29437

https://my.discountasp.net/mssql2008-tools.aspx

I am sorry if I am not able to explain myself properly.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 60

Hello Eli,

Another way to recreate your database on the ISP server may be using the following article:

http://sqlblog.com/blogs/john_paul_cook/archive/2009/10/13/ssms-tips-and-tricks-scripting-inserts.aspx

Create a script of the database using the article and try  to run it on the ISP server.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 61

Hello Eli,

Another way to recreate your database on the ISP server may be using the following article:

http://sqlblog.com/blogs/john_paul_cook/archive/2009/10/13/ssms-tips-and-tricks-scripting-inserts.aspx

Create a script of the database using the article and try  to run it on the ISP server.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 62

Thank you Alberto,

What you are sending me seems to be a workaround that has merits, but I am struggling as much trying to figure out what to do as the procedure of backup which is where I started.  Can you please help me understand why I am not able to accomplish what I did last March (with your help).  

To back up a database

• After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

• Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database

• ________________________________________________

• I am connecting using management studio as shown in the next screen shot, but I cannot get further.  I am working in a windows account that is the original installation account.  As far as I know I have the admin privlidges, but can you tell me if I am doing anything obviously wrong, or how to proceed?  Thank you Alberto.  EPS123

---

eps123

Answer 63

I failed to enter the screen shot, but it is merely a connection screen of Management 2008R2 that indicates SERVER type: DATABASE ENGINE,  SERVERNAME:  EPS-PC/SQLEXPRESS, and Authentication is WINDOWS

---

eps123

Answer 64

Hello,

The backup/restore procedure we were working together back in March may not work with your ISP. Thus, in this scenario the provided resources (links above) from your ISP should be used.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 65

Thank you Alberto, I now understand.  I was proceding to try the ISP procedure when I was interrupted by a sqlserver express failure.  It was working wonderfully til yesterday when it happened all of a sudden.  I've found reams of documentation on this error 40, but so far none of the easy solutions have worked.  I will return to my original problems when I restore my server. 

eps123

---

eps123

Answer 66

Hello,

Please share with the full error message. I may be able to find a solution faster to that error.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 67

Hopefully, I inserted both images successfully.

and the same thing from visual studio

Both messages occur after any attempt is made to connect to the server.  I tried going thru SS2008 R2>config>services and saw that the service had not been started, and then when I tried to start it, I got the same failure response.  Thanks for asking,

eps123

---

eps123

Answer 68

Hello Eli,

It seems you included an image on the last post but I cannot see it. Please write the error and post it in this thread.

Maybe the corporate network is not allowing me to see the image.

Thank you in advance.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 69

Sorry Alberto, I had tried to paste in and one was not successful, and then I attached both.  Anyway both pop-ups are the same as follows;

A network-related or instance-specific error occurred while establishing
a connection to SQL Server.  The server was not found  or was not accessible
.  Verify that the instance name is correctand that SQL Server is configured to allow
remote connections. (Provider: Shared Memory Provider, error:40- Could not
open a connection to SQL Server)

EPS123

---

eps123

Answer 70

Hello Eli,

Please make sure that TCP/IP and Named Pipes protocols. Do not start the VIA protocol. Use the following article for this purpose.

http://msdn.microsoft.com/en-us/library/ms191294(v=sql.105).aspx

Then try to start the SQL Server service again.

If the service does not start, please share the ErrorLog with us. The following article may help you locate the file on this.

http://support.microsoft.com/kb/966659

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 71

Thanks Alberto, did as told, assuming you meant that TCPIP and Named Pipes protocols are to be enabled.  I did find Named Pipes disabled and I enabled.  Tried to restart sqlserver SERVICE but it failed.  Tried to explore for the log files but the article's guidance was not exactly right.  I did discover a log directory in the neighborhood and I suppose I'll try to place the contents on the Sky Drive if I can figure out how to do that. 

---

eps123

Answer 72

Hello,

Please let me know if the following resources help you to share the logs with us:

http://windowslive.ninemsn.com.au/livesuite/article/792828/how-to-guide-sharing-files-with-skydrive

http://www.bing.com/videos/search?q=how+to+share+files+on+skydrive&mid=CED9BC771002AE61C9D2CED9BC771002AE61C9D2&view=detail&FORM=VIRE2

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 73

I think I figured it out, but I am not sure that the link I sent was directed properly.  The log files are on the sky drive, but please confirm that they are accessible.

eps123

---

eps123

Answer 74

Hello Eli,

Please post the link to your public folder in skydrive in this thread.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 75

https://skydrive.live.com/redir?resid=1716E1D78DCBF8CE!146

is the link to folder ALBERTO on my SKYDRIVE

Sorry about slowness

---

eps123

Answer 76

Hello,

Please try to repair the SQL Server instance with the following article:

http://msdn.microsoft.com/en-us/library/cc646006(v=sql.105).aspx

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 77

Thank you Alberto.  I did try the repair and got an error trying to connect during the process.  Reverted to the account I had set up for the original install to do the repair.  The repair seemingly went better but the net result was the original failure to connect to SQLServer Express.  Rather than going into a lengthy investigation I decided on a removal and re-install of R8.  That seems to make all problems go away.  Connection is now successful, my databases can all be connected to and only one problem remains with respect to a return to normalcy.  My local browser is functioning but it is failing in completing a requested update.  I am suspecting that this is a file protection problem and I will proceed to verify and correct the issue without assistance.  This will make me a better person.

Thank yo for now.

eps123

---

eps123

Answer 78

Hello,

I am glad you have SQL Server working now.  

Let me know if you need assistance with your browser.

Have a good day!

Regards,

Alberto Morillo
SQLCoffee.com

Answer 79

I have not attempted this solution because I interrupted myself encountering some sql related problems in VS2010 on my local server.  Not sure how to create a script of the database when I do return.  My current problems are posted under "gridview" .  I have tried researching this problem with no success.

Thanks.

eps123

---

eps123

Answer 80

Hello,

I am not sure to understand what issue you are facing this time? Is it related to Visual Studio or SQL Server? Please provide more details.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 81

Thanks for your time, Alberto.  At the time I wrote my response I was not even sure where the issue laid.  I got redirected to the asp.net, reposted the question, and discovered the problem in a couple of hours.  The problem was really a VS problem and the answer I found was occurring as far back as 2007.  At any rate, I am delighted to get back to my original database problem. You had asked me to script  database in order to proceed with the process.  I do not know what this means, so can you give point me in the right direction to learn what I need to?

Thanks ,

Eps123  





---

eps123

Answer 82

Hello Eli,

We need a copy of the application database you have on the personal computer on the ISP database server. The application as you have it on your PC is working with a database you created. Since you want to publish the application on the Web we need to recreate the database on the Web, or the application won’t work.

The following tools will help you recreate the database on ISP database server:

http://community.discountasp.net/showthread.php?p=29437

https://my.discountasp.net/mssql2008-tools.aspx

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 83



Alberto, I tried complying with the suggestions.  When I got to the step of restoring the database, the restoration process failed.  I was directed to check with support and got more questions from them than answers.  For some reason, I cannot paste the answer into this response, so I will summarize:

What version of MS SQL is this coming from?  (I do not know the answer to this, SQLServer Express is what?)

Control panel error indicates the backup is incorrectly formed.  This means 2 things: 

1.  Need to remove the file from the server (obvious) and create a new file wit a .BAK extension.  (To get the backup I made, I copied the MDF and renamed the file to .BAK from .MDF on the server.)

2.  Make sure that the local instance of MS Sql is not of a newer version than the database add-on I am trying to restore.  (This one leaves me totally blank).

___________________________________________

Outside of these questions, I should tell you that the MDF that I am backing up has no relationship to the original MDF I created in name or content.  I will as always appreciate your response.

eps123

---

eps123

Answer 84

Hello,
You have SQL Server 2008 R2 Express Edition.

1. Use the following guide to create a SQL Server backup.

http://msdn.microsoft.com/en-us/library/ms187510(v=sql.105).aspx

On step 12 select “disk”, then click on the “Add” button and then click on the ellipsis “…” button. Select where you want to put the backup file and on the “file name” field put a name like “backup1.bak”.

2. The version of SQL Server on the hosting should be SQL Server 2008 R2 or higher. Ask them what version you have purchased.
Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 85

Used Management Studio 2008 R2 to connect, then expanded databases tree.  That did not show any user databases.  I am wondering if my DB is really R2 because, if you remember, we went thru a long process of backing up sqlserver 2008 DB, and then restoring locally before moving the restored DB to the ISP.  Following that, I lost my drive, restored my datafiles and re-installed 2008R2 software.  How do I discover what my MDB file is?  Hope I am not confusing you.

eps123

---

eps123

Answer 86

Hello,

As long as I remember you were trying to upgrade from SQL Server 2008 to SQL Server 2008 R2.

It seems to me you are using a user instance. Please try the following post to backup that instance:

http://blogs.msdn.com/b/sqlexpress/archive/2007/03/20/backup-and-restore-with-user-instances.aspx

On the BackupDeviceItem put the path where you want the backup to be placed.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 87

You are correct, but I believe I lost the work that was done when you helped me it seems ages ago.  The reason I am suspecting that the DB is 2008 vs 2008R2 is because I should not have the difficulty I am having in connecting in Management Studio.  Here is what happened last time.  I backed up the 2008 MDF.  I acquired Management Studio.  Did the restore.  and then sent the MDF to the ISP.  They were happy that it conformed to 2008R2, loaded it attached it and I have never seen anything beyond that.  Meanwhile, I lost my hard drive and ended up re-installing management Studio and have never done anything beyond that.  I have not done anything to inform Visual Studio that I wish to create R2 databases, or to stop creating 2008.  My new database has been created, so I suspect I am in a 2008 environment as I was before.  Do I make sense, because I may be ignorant, but not lazy, so I will do whatever I have to do to get the job done.

Thanx

---

eps123

Answer 88

Hello,

If your ISP already have the database restored for you then you just need to update the connection string in your application to make it work:
The connection string you should be using from the application is:

"Data Source=tcp:sql2k802.discountasp.net;Initial Catalog=SQL2008_835653_juliedvd;User ID=SQL2008_835653_juliedvd_user;Password=******;"

Change the Catalog with the name of the database on your ISP site and provide the appropriate password.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 89

Alberto,

I don't think I made myself clear.  I need to know how to back up my database on my local computer.  The database I am using works fine and I can connect to it routinely thru the VS 2010 server manager.  When I follow the procedure using Management Studio 2008R2 as shown below, I cannot get past step 2.  What am I missing?  2008 R2 displays EPS-PC/Sqlserver Express as the database engine.  When I expand databases I cannot ever see my database as reflected in VS 2010.   

• After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

• Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.

I have gone back to the beginning of my thread in January and the problem is the same.  Your help is appreciated as always.

Eps123

---

eps123

Answer 90

Hello,

This is because you are using a “User  instance”. The following article will let you know how to use Management Studio with that instance:

http://blogs.msdn.com/b/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

Regards,

Alberto Morillo
SQLCoffee.com

Answer 91

Thank you so much.  You had alluded to user instances before, but I guess it did not register.  I was able to follow this reference and actually connect as it is advertised.  I then identified my database, rightclicked to get tasks uder which I went to "Backup".  I keep getting the same error as shown in the attached screenshot.  I tried specifying the ".BAK" file in a variety of places since the error indicates an access violation, but nothing worked

---

eps123

Answer 92

Hello,

Please assign full control permission to the service account starting SQL Server service. Use SQL Server Configuration Manager to know which account is set to start SQL Server service. The following article will help you assign Full Control permissions:

http://answers.microsoft.com/en-us/windows/forum/windows_7-security/i-want-full-access-to-all-my-files-and-folders-in/1567bf63-b1f5-40a5-be3f-150dce4c5aed (How to Grant Permissions in Windows 7)

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 93

Thank you.  I did not revise permissions as you suggested, but you did confirm my suspicions that it was only a file ownership issue.  Therefore, I merely defined the backup file in the user account that I was running in and everything worked fine.  I am going to return to the ISP's procedure now to restore the backup.  Thank you again for your patience.

eps123

---

eps123

Answer 94







Alberto, this is Deja Vu and seemingly puts me back where I started about a year ago.  I am sending you the conversation between myself and my ISP after the latest failure to restore a database.  I have asked them to tell me what I need to do to start over.  I do not care about any previous database on the server or what it was created with.  I now have a valid 2008R2 backup and it seems that this is a reasonable request.

eps123

 

---

eps123

Answer 95

Hello Eli,

Forget about SQL Server 2008 R2, since your ISP provided you SQL Server 2008. SQL Server 2008 and SQL Server 2008 R2 are two different releases of SQL Server 2008, and in terms of backup/restore consider them like two different versions. A SQL Server 2008 R2 backup cannot be restored on a SQL Server 2008 instance because it is considered a downgrade.

You can also verify if the ISP can offer you SQL Server 2008 R2 instead of SQL Server 2008.They should since SQL Server 2008 is 4 years old. If this is not possible, uninstall SQL Server 2008 R2 and install SQL Server 2008. Ask the ISP about what service packs and updates have the SQL Server instance of your Web Hosting and install same updates (same only) on your computer.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 96

Thank you Alberto.

I managed a successful restore to SQLSERVER 2008R2 which was available to me on the ISP's Server.

I have tried a manual edit of the famous "web.config" file several times using the information that was available from the ISP's control panel and what was pieced together by me.  ["Data Source=tcp:sql2k805.discountasp.net;Initial Catalog=SQL2008R2_835653_sqlexpress;User ID=SQL2008R2_835653_sqlexpress_user;Password=******;"]

At first I got a rejection because the file was badly formed (probably a stupid error on my part).  Subsequent tries resulted in allowing the file but not making a successful connection.  I will attach the last failing version of the config file in case you can spot something obvious.  In case you cannot, please give me a course of action, or ask me for whatever else you may require.

<configuration><connectionstrings><add connectionstring="data source=tcp:sql2k805.discountasp.net;Initial Catalog=SQL2008R2_835653_sqlexpress;User ID=SQL2008R2_835653_sqlexpress_user;Password=******;" name="ApplicationServices"><add connectionstring="Data Source=tcp:sql2k805.discountasp.net;AttachDbFilename=SQL2008R2_835653_sqlexpress\OPG.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" name="OPGConnectionString1" providername="System.Data.SqlClient"></add></add></connectionstrings> <system.web><compilation debug="true" explicit="true" strict="false" targetframework="4.0"><authentication mode="Forms"><forms loginurl="~/Account/Login.aspx" timeout="2880"></forms></authentication> <membership><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" enablepasswordreset="true" enablepasswordretrieval="false" maxinvalidpasswordattempts="5" minrequirednonalphanumericcharacters="0" minrequiredpasswordlength="6" name="AspNetSqlMembershipProvider" passwordattemptwindow="10" requiresquestionandanswer="false" requiresuniqueemail="false" type="System.Web.Security.SqlMembershipProvider"></add></clear></providers> </membership> <profile><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider"></add></clear></providers> </profile> <rolemanager enabled="false"><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider"><add applicationname="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider"></add></add></clear></providers> </rolemanager> </compilation></system.web> <system.webserver><modules runallmanagedmodulesforallrequests="true"></modules></system.webserver> </configuration> Thank you, Eli (eps123)

---

eps123

Answer 97

Hello,

It seems to ne you cannot use “Integrated Security” because you are using a SQL login (SQL2008R2_835653_sqlexpress_user) with password.

You don’t need to use the AttachDBFilename because it is used to access databases local to your PC.

Hope this helps.
 
Regards,
Alberto Morillo
SQLCoffee.com

Answer 98

The following error was thrown: ______________________________ Server Error in '/' Application. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

_____________________________________

I was not sure on how I was to modify the web file from your last response, but below is the file as I modified it: Did I strip out too much? I am groping, but I have not found a method to get the information I need.

_______________________________ <configuration></configuration>

<configuration><connectionstrings><add connectionstring="data source=.\SQLEXPRESS;User Instance=true" name="ApplicationServices" providername="System.Data.SqlClient"><add connectionstring="Data Source=.\SQLEXPRESS;Connect Timeout=30;User Instance=True" name="OPGConnectionString1" providername="System.Data.SqlClient"></add></add></connectionstrings> <system.web><compilation debug="true" explicit="true" strict="false" targetframework="4.0"><authentication mode="Forms"><forms loginurl="~/Account/Login.aspx" timeout="2880"></forms></authentication> <membership><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" enablepasswordreset="true" enablepasswordretrieval="false" maxinvalidpasswordattempts="5" minrequirednonalphanumericcharacters="0" minrequiredpasswordlength="6" name="AspNetSqlMembershipProvider" passwordattemptwindow="10" requiresquestionandanswer="false" requiresuniqueemail="false" type="System.Web.Security.SqlMembershipProvider"></add></clear></providers> </membership> <profile><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider"></add></clear></providers> </profile> <rolemanager enabled="false"><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider"><add applicationname="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider"></add></add></clear></providers> </rolemanager> </compilation></system.web> <system.webserver><modules runallmanagedmodulesforallrequests="true"></modules></system.webserver> </configuration>

---

eps123

Answer 99

Hello,

No. the previous post was better. Now, you changed it for a local database.

The following resources may help you build connection strings.

http://blogs.msdn.com/b/aspnetue/archive/2012/08/14/sql-server-connection-strings-for-asp-net-web-applications.aspx

 http://decipherinfosys.wordpress.com/2009/04/30/different-connection-strings-sql-server/

http://www.connectionstrings.com/

http://weblogs.asp.net/owscott/archive/2005/08/26/Using-connection-strings-from-web.config-in-ASP.NET-v2.0.aspx

Use the previous post and remove the AttachDBFilename. Remove the “User Instance=True” reference because the database is now attached to a database server on your ISP.

Hope this helps.
 
Regards,
Alberto Morillo
SQLCoffee.com

Answer 100

I am trying Alberto. I have tried some links that have been provided before with little success.  I need one example of a config file that works and cannot seem to get there.  I did not have a clean copy of the previous post that you said I should revert to, so I pieced it together from the post itself.  I then followed your suggestions and figured that I messed up the editing when I kept getting the badly formed error message.  As shown below.

Server Error Internet Information Services 7.5 Error Summary HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information Module IIS Web Core Notification Unknown Handler Not yet determined Error Code 0x80070032 Config Error The configuration section 'connectionstrings' cannot be read because it is missing a section declaration Config File \\?\E:\web\leads2009ne\htdocs\web.config Requested URL http://leads2012.net:80/ Physical Path Logon Method Not yet determined Logon User Not yet determined Config Source 7: <configuration>8: <connectionstrings>9: </connectionstrings></configuration>

_____________

My last web.config file

______

<configuration><connectionstrings><add 1.0"?="" connectionstring="data source=tcp:sql2k805.discountasp.net;Initial Catalog=SQL2008R2_835653_sqlexpress; Links and More Information This error occurs when there is a problem reading the configuration file for the Web server or Web application. In some cases, the event logs may contain more information about what caused this error. View more information » _______________________________________________________________ _______________________________________________________________ <?xml version="> <configuration><connectionstrings><add connectionstring="data source=tcp:sql2k805.discountasp.net;Initial Catalog=SQL2008R2_835653_sqlexpress; User ID=SQL2008R2_835653_sqlexpress_user;Password=******;" name="ApplicationServices"><add connectionstring="Data Source=tcp:sql2k805.discountasp.net;Connect Timeout=30" name="OPGConnectionString1" providername="System.Data.SqlClient"></add></add> </connectionstrings> <system.web><compilation debug="true" explicit="true" strict="false" targetframework="4.0"><authentication mode="Forms"><forms loginurl="~/Account/Login.aspx" timeout="2880"></forms></authentication> <membership><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" enablepasswordreset="true" enablepasswordretrieval="false" maxinvalidpasswordattempts="5" minrequirednonalphanumericcharacters="0" minrequiredpasswordlength="6" name="AspNetSqlMembershipProvider" passwordattemptwindow="10" requiresquestionandanswer="false" requiresuniqueemail="false" type="System.Web.Security.SqlMembershipProvider"></add></clear> </providers> </membership> <profile><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider"></add></clear></providers> </profile> <rolemanager enabled="false"><providers><clear><add applicationname="/" connectionstringname="ApplicationServices" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider"><add applicationname="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider"></add></add></clear></providers> </rolemanager> </compilation></system.web> <system.webserver><modules runallmanagedmodulesforallrequests="true"></modules></system.webserver> </configuration> </add></connectionstrings></configuration>

---

eps123

PS.  I tried removing "Integrated security ="true"" as you had suggested before, first changing true to false and then removing the whole phrase.  Neither seemed to make a difference.

Answer 101

Hello Eli,

Allow me some time to get someone related with IIS involved  about Error.500.19.

Thank you for your patience.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 102

I am patient but I need to ask you if you have everything u need from me.  I did do the manual editing according to your suggestions and I wonder if I perhaps created some problems in doing so.  What makes me question is that when I revised one way u told me to do something else.  One rejection was for one reason and the other was a badly formed xml file.  When I tried to fix it via the xml editor, I got conflicting diagnostics and some did not make sense.  I am very happy with my local VS site and would love to demonstrate it to a prospective customer on a live website tomorrow.  Any possibility???

I really do appreciate your continuing effort.  Please ask for anything I can do to assist.

eps123

---

eps123

Answer 103

Hello,

I have emailed some friends about it but have not received a response yet. Please wait a little bit more.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 104

Hello Eli,

I cannot find somebody to help us with the Web.Config file. I am not receiving any response from the people I have requested help.

If you would like to try on other MSDN forums at the same time, please do.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 105

Thanks for your efforts, Alberto, I have already attempted to find other forums and the right answer.  With but one exception, you, I have found the environment quite hostile in trying to solve this problem for a year now.  To be fair, I might be part of the problem in that I have only been doing this web stuff for a couple of years whereas I have mastered everything else I have done for almost 50.  No matter, but I have one last to ask you.  In reading some of the references you sent me, I find myself at a loss sometimes because I am not sure of my own environment versus the ISP.  Can you confirm or correct the following assumptions I have made:

I am running SQLSERVER express  using a user instance in my Visual Studio environment on my computer.

Am I connecting to a Local Database instance on the ISP's Server?

I have probably missed this information somewhere but I do not know where. 

Thanks for this and all previous info.

eps123

---

eps123

Answer 106

Hello,

You have an Express instance installed, but in reality you are using a User Instance (a SQL Server instance created on demand from the Visual Studio). Please read the following:

"… A SQL Server instance is a SQL Server executable program running on a server. Each instance has a name, a sqlservr.exe process in memory, buffer memory, its own copies of the system databases, and its own set of user databases. By default, SQL Server Express installs as an instance named "SQLEXPRESS," for example. You connect to a named instance by specifying the instance name with the server name in the connection string. That is why you normally specify ".\SQLEXPRESS" as the server name when connecting to a local SQL Server Express database. The dot means the local server and \SQLEXPRESS specifies the SQLEXPRESS named instance. The SQL Server service (sqlservr.exe) runs as a Microsoft Windows service and executes in the user context of the user specified as the service account in the Windows service manager. For SQL Server Express, this account defaults to "NT AUTHORITY\NETWORK SERVICE" although a different account can be specified during setup.

SQL Server Express expands the concept of SQL Server instances by supporting user instances. A user instance is similar to a normal instance but it is created on demand while normal instances are created during setup. The service account for a user instance is the Windows user who opened the SQL Client connection to the database. In other words, if Sally opens a connection to a database file specifying the user instance option in the connection string, the user instance will have Sally as the service account.

User instances are created when the User Instance option is set in the SQL Client connection string."

http://technet.microsoft.com/en-US/library/bb264564(v=SQL.90).aspx

I would love to know more about Web development, but I don’t. I investigated a little bit to provide you the changes I suggested about the Web.Config. Please consider to get a training to provide you the basics about Web development. Please do not get discouraged. You can find some free training on the following link:

http://www.microsoftvirtualacademy.com/Home.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 107

Hello Eli,

I am really glad to know that you finally make it work. You never gave up and that made the difference.

Enjoy now SQL Server and your Web site. Have fun learning more.

By the way, I wish you a happy thanksgiving weekend.

Regards,

Alberto Morillo
SQLCoffee.com