SQL Server :: Deploying A Database On A MS Server?
Aug 5, 2010
I have a question regarding deploying a database on a MS SQL Server. I am planing to build a website using ASP.NET technology. I want to implement some administration functionality for the website such as updating images, changing logo, update text information on the website. I am going to build a database that I should deploy on a MS SQL Server. As I understand if I want to keep a database on a MS SQL Server I should pay for it.
i've written a small application using asp.net and sql server express.
my question is after checking the application in the visual studio environment how can i get it to work in a way that
users that are working on the same network as me could use it to?
i've changed the user instances option in the web.config file to false, and from the info i found so far i understand that security measures are to be applied, but i just couldn't get it to work...
I have created "DotNetNuke SQL Database Application" from the WebMatrix Gallery. Now I want to deploy it on the remote server using Web Deploy method. Without selecting SQL database, application is deployed successfully but when I select SQL database it gives following error: Publish : Error - Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy provider is dbFullSql).
I'm currently developing a web application using SQL Server 2005, ASP.Net MVC, ASP.Net SQL Membership Provider (for authentication and authorisation), and Linq to SQL. Everything works great and is running as planned in the development environment.However, the production environment has a SQL Server 2000 installation, and we are unable to obtain a copy of SQL Server 2000 to use in development.Upon deploying the web application to the the production environment, what options do I have for migrating the database (schema + data) from 2005 to 2000?
I was trying to deploy an asp web app over to a different server and when I ran the .msi setup I got the error:
Setup requires Internet Information Server 4.0 or higher and Windows NT 4.0, Windows 2000 or higher...
Now its obvious that it has version 6.0 since windows server 2003 is installed, do you have why this is happening or should I just move my entire application with code over? My database has already successfully been installed on this server and just need the app to be deployed to this server.
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
This issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
I'm taking the database that I created with SQL server express and putting it on a server in a datacenter. There are 2 database files in AppData folder: the aspnetdb.mdf file and the file I created for my site MySite.mdf. I'm using the ASP login control and that works with the ASPNETDB.mdf file and it's working. If I log in without the correct username/pwd, it'll display a bad login message.
However, as soon as I login and the site goes to make a request to MySite.mdf, I get an error "Invalid object name 'dbo.Users'." which is the name of the first table the site looks into after the login.
I've attached the MySite.mdf file to the server and copied the connection string the hosting company is generating into the web.config file and left the rest as is.
Could it be that I can't attach a sql express file?
I'm trying to deploy a LightSwitch App and it tells me my "targetFramework" attribute in my web.config file is wrong and it is saying 4.0 so I don't know what to do. Here is the error message. If you like, you can visit my site [URL] .... and click on "Access EApps" to see the message as well.
Code: Server Error in '/Eapps' Application.
The value for the 'compilerVersion' attribute in the provider options must be 'v4.0' or later if you are compiling for version 4.0 or later of the .NET Framework. To compile this Web application for version 3.5 or earlier of the .NET Framework, remove the 'targetFramework' attribute from the <compilation> element of the Web.config file.
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.Configuration.ConfigurationErrorsException: The value for the 'compilerVersion' attribute in the provider options must be 'v4.0' or later if you are compiling for version 4.0 or later of the .NET Framework. To compile this Web application for version 3.5 or earlier of the .NET Framework, remove the 'targetFramework' attribute from the <compilation> element of the Web.config file.
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.
Stack Trace:
[ConfigurationErrorsException: The value for the 'compilerVersion' attribute in the provider options must be 'v4.0' or later if you are compiling for version 4.0 or later of the .NET Framework. To compile this Web application for version 3.5 or earlier of the .NET Framework, remove the 'targetFramework' attribute from the <compilation> element of the Web.config file.] System.Web.Compilation.MultiTargetingUtil.ValidateCompilerVersionFor40AndAbove(String compilerVersion) +235 System.Web.Compilation.MultiTargetingUtil.ValidateCompilerVersionFor40AndAbove() +139
I've added a web reference locally which looks up post codes. All works ok locally. Now I just want to deploy this to my web space. There is a app_WebResources folder with various files that were created when I added this. Basically what I want to know is How do I get all this to work online?
I have written a couple methods that encrypt and decrypt the appSettings section of my web.config file using the WebConfigurationManager. I just hooked up the methods to the page_load event to test that it works, which it does. Now I need to deploy to a web farm and need advice. What is the best way to make it so I can encrypt, but more importantly decrypt the web.config when I need to? I thought about putting a hidden page with "encrypt" and "decrypt" buttons, but that seems risky. What is the "accepted" method for rolling out something like this?
I've been given a virtual dev environment being windows server 2003 and I need to publish a web app to it. I've deployed apps quite easily using the publishing wizard but I'm not sure how to do deploy to a windows server.. can someone please provide a link or a guide on how to do this as I need to set it all up and I really don't know where to start.
I have a website designed using .net 1.1 and upgraded to 2.0. It works fine on Win NT. However, the same application is not working on Win 2003 64 bit server. I read some article on web. Everyone recommends that IIS should run on 32bit mode in win 2003 server if the app was orginated from 32bit. So, I made IIS to run on 32bit mode. The problem is now asp.net config tab is missing in IIS. Is it recommended to convert IIS to run on 32bit in Win 2003 64 bit edition? If so, how do I keep the asp.net configuration tab? Why cant the 32 bit app unable to run on 64bit? Any conversion tool available to upgrade from 32bit to 64bit?
I first time tying deploy ASP.NET MVC3 Web App and after upload files and made database I had problems with diplaying sites...I was redirected to "page not found'. After add to web config I get following error:
Server Error 500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed. What I need to do now?
I first time tying deploy ASP.NET MVC3 Web App and after upload files and made database I had problems with diplaying sites...I was redirected to "page not found'. After add <customErrors mode="Off"/> to web config I get following error:
I first time tying deploy ASP.NET MVC3 Web App and after upload files and made database I had problems with diplaying sites...I was redirected to "page not found'. After add <customErrors mode="Off"/> to web config I get following error:
I have deployed simple application on production server it just update sql server table via update query.
The problem is That when I run that app on development machine it updates table on remote server but after deploying it on production server and accesing the url on production server/and development machine my code doesn't execute and thus it don't update table.
I have created virtual direcotry and configured app with specific application pool which is custom based Asp.net account.
I am using LocalReport class to render reports locally and then converting reports to pdf format and displaying to user. This works fine on my local machine but gettting error 'Object reference not set to an instance of an object' when deployed to the development site. Do we need to install anything on the host server for localreports to work correctly?
I've called their tech support 3 times this morning and spent over $50 in long distance and have had no results. I was wondering if anybody here has deployed an ASP.NET website with DomainHut.com's hosting services. I've set up my database on their server correctly, all tables, stored procedures and aspnet schema are there just like on my local machine, and I have changed the connection string to point to the correct server, but when I publish the website using the publisher tool to upload the website to www.mhn.co/mhnprofessionalservices but I'm only getting an 500 Internal server error. They have advised me to set <CustomError Mode="on"/> in the Web.Config file, and I have <Compilation debug="false"/> as well.
I am publishing my website on server, using publish feature in VS 2010 Ultimate. but, how can i stop uploading images folder everytime i publish website.
I am getting the error -- Error 1723. There is a problem with this Windows Installer package. A DLL required for this install to complete could not be run. Contact your support personnel or package vendor. Action WEBCA_FillComboBox, entry: FillComboBox, library: C:DOCUME~1ADMINI~1.XYZLOCALS~1TempMSI15B.tmp -- when I try to deploy a ASP.NET application on the server.I am using "Enablehostheaders.js" to select the website where I need to install the files..I am using visual studio.net 2003/framework 1.1
I have built my site using VS.Net 2010 on my XP machine. I would like to deploy it to my server which is a Windows 2003 Server. I have tried to do it with FTP, but it keeps failing with the error that "Front Page Extensions are not installed on the web server". When I check the server the extensions were installed and I also checked IIS and the service for the extension is allowed.
