Click here to Skip to main content
15,888,527 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi again. Previously I asked a question about deploying.

Now I am having problems with the website.

It was a simple ASP.NET Dynamic Data Linq to SQL Web Application. I followed the Dynamic Data tutorials. I did the scaffold thing for my data. In my App_Data, I just created a SQL server Database. I feel like this may the problem. I believe it has to do with the SQL server on my local drive instead of the server, but I don't know how to change it or where to put it. Do I put the database in the IIS7 website area or the same place as the website?

When I published my site using IIS7, when I run the site in the browser, it shows everything except the back arrow picture and it doesn't update and insert things. So any advice for this problem?

^_^ Thanks for the help! Code Project helps a bunch when trying to self-learn stuff.

Update:
I found the connection strings in my site in the IIS manager. It shows that the connection string for my database entry type is Local. How do I change my Database server? Or How do I make a proper Database server?
Posted
Updated 21-Jun-11 13:42pm
v2

How do I change my Database server? Or How do I make a proper Database server?

Install Sql server. Attach the App_Data database in Sql Server.
Change the connection string in the IIS7 Website's web.config file.
 
Share this answer
 
Comments
Member 8015046 22-Jun-11 11:21am    
Sorry I am new to SQL server. So how do I create an SQL server?
Following links might help you to go through the installation process,

[1] How to: Install SQL Server 2008 R2 (Setup)[^]

[2] How to Install SQL Server 2005 - A Quick Guide [^]

[3] HOW TO: Install SQL Server 2000 - Basic Local Installation[^]

Hope it helps :)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900