I just want to know, can we use sql 2005/2008 express edition for web hosting.
let say if i have a hosting company can i use those versions.if not what will be the cheap version for simple web site. same as express editions.
I would like to build a site and use SQL Express database. Ny question is that is there a difference in perforamcne betweeen Express edition and Web edition?
View 2 RepliesI built a website using SQL 2008 Express. I want to deploy it to a hosting company (shared server). If I change the SQL 2008 Express database on my local machine (further development of the website), how can i synchronize the local SQL database with the one on the server without loosing data?
View 3 Repliesi have create My WebSite in asp.net 3.5 and SQL SERVER Managment Studio 2005 EXPRESS , every thing Work GREAT with out any problem when i run it on LOCALHOST,
but my Big Problem Idont Know What The Steps RUN it On Server Specially:
1- i Have Create My OWN SQL Data Base file with its own Stored Procedures, and its in the Same Folder of My Project.
2-whats about WebConfig? what i should write in it?
have made a complete website with a db with many table and fields........i have to make a database server where only the database will reside
i have read many links, and many answers here,this is what i got installed sql server 2005!
okay on one pc which had only win xp, i installed dotnetframework 3, then installed sql server 2005 and sql server management studio express.when i open the studio express i use windows authentication and server is the default computer nameit starts and show these folder with already present dbs now what should i do, how can i ask this software to host my database file 'abc.mdf' so that i can benefit from the integrity and consistency features offered by the software for databases?
if importing this db is not possible how to make a new one?, i mean there are four folders where to make the new db in?
"how can i ask my webserver (IIS) to connect to this 'SQL Server Management Studio Express'?"
"how can i ask the debugger to connect to SQL Server Management Studio Express on the other computer"
I have just finished developing a website in ASP.NET 3.5 with database as SQL SERVER Express edition (Free one).
I am looking for a hosting provider who supports SQL SERVER Express Edition.
Most of the hosting provide RESTRICTS THE SIZE OF SQL SERVER DATABASE UPTO 200MB ONLY.
However I know that SQL SERVER Express edition can save data upto 2GB size.
tell me about a web-hosting provider who allows SQL SERVER Express edition of size 2GB ?
I am fine with shared hosting.
I have created a web site in Visual Web Developer 2008 Express Edition. I have created database using SQL Server Express. The web site works good. I have hosted the web site, then getting error in connecting to database.
The connection string is
<
add
name="QkINDUSConnectionString"
connectionString="Data
Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|QkINDUS.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient"/>
know what is the correction i need to make in ConnectionString ?
After I installed Visual Studio 2008 Standard edition, then I upgrade "SQL Server Express 2005" to "SQL Server Express 2008 SP2". Process upgrading SQL Server Express 2008 was going succesfully (none of the process was fail).
But when I create a New Website I could not add a new item "SQL Server Database" into my website file. Because Visual Studio always rejected any new "SQL Server Database" by giving message below (underline):
This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.
i have installed SQL server 2005 Server & Clicent in My PC. now i want to install SQL server 2008 Express Edition.
when i try to install it it gives an Error as below.
Rule "SQL Server 2005 Express tools" failed.
The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.
I'd like to learn more about MS Business Intelligence Development Studio. I'm doing this on my own, so I'd like to keep my software costs down. It's my understanding that BIDS comes with the download for SQL Server, but is used in Visual Studio (by creatign a BIDS project). Is this accurate? My question is - Is it possible to get a working copy of BIDS by downloading SQL Server Express and Visual Studio Express?
View 2 RepliesThis is probably an easy one, but can I use SQL Server Management Studio Express to work on a regular SQL Server database?
View 2 RepliesI just published my web site, and the problem is, that table can't be found. I'm using SQL Server 2008. I created new user, which is not sa, that I se to work with Sql Server 2008 Express manager. I tried to create sa user ass well on hosting server, but it is not possible, because it's already exists.
I think the problem is, that newuser, can't find dbo. tables, which are created by sa user. If that is problem, how can I solve it? I can't create sa user on hosting machine. Is there maybe some solution in right connectionString?
I'm using this kind of ConnectionString on hosting server:
[Code]....
I just installed SQL Server 2008 Management studio Express on my Vista machine.i tried connecting to local machine using :
.sqlexpress, (local)sqlexpress, or .SQLExpress, MyPCNAMESQLExpress
nothing is working, getting this error:
-----------------------------
Cannot connect to PC-NAMESQLEXPRESS. 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)
----------------------------
In machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
View 2 RepliesI hope, the post is posted where it should be posted.I want to host my website on my IIS webserver so that I can access it on Internet. Could someone provide links for it.
View 13 RepliesOne thing that has always deterred me about using ASP.NET is the cost for hosting was generally is a bit higher then the LAMP environment equivalent (and also a small little thing called WebForms). Now that I can getting back into C# programming, I think I am going to take another look at ASP.NET. ASP.NET MVC seems to have grown since I last look at it (version 1 was still in beta) and it seems like ASP.NET MVC might be the best of both worlds of ASP.NET and PHP. That being I can use C# as my language and template system (like I can with PHP) and not have to deal with the ultra super fantastically craptastical WebForms (can you tell I don't like them? ).
Now I need to find a good hosting provider and have a few requirements to be able to successfully replace my current LAMP hosting. I am going to want a hosting provider that allows me to have both PHP and ASP.NET running on the same IIS server so that I can host both type of projects from my web server (assume it is possible to run both PHP and ASP.NET on the same IIS server at the same time). I am also going to want to use MySQL instead of MSSQL. I am also going to want to be able to install subversion and/or git to host my own repositories. Figuring with all these requirements a shared provider won't cut it and I am probably going to need a virtual dedicated provider and if so I assume that would come with access for remote desktop into the server to allow to be manage it, right? I also want to make sure that it is easy to upgrade (or downgrade) the plan so that I can start off with the cheapest option and upgrade easily if my usage demands it.
Can anyone recommend a reliable and affordable windows server hosting provider that meets these requirements?
How to host MVC 2 application in IIS 5.1 server ?
I am not getting even after doing all the settings in iis server...
I have SQL server management studio express install on one machine.
I am able to connect to that machine or able to ping that machine from my computer.
I have code which return me the SQL server instances on same network. Using that I am able to get that SQL server instance. I have configured SQL express to access remote connection. i.e.
Configured SQL express to accept named / TCP IP instance connection. Started Browser service.
My machine settings My machine has been configured to set dynamic IP address using DHCP protocol
When I am trying to connect to above mentioned SQL server I am getting error that "Failed to connect SERVER NAME\SQLEXPRESS".
But if I configured my machine with manual IP address and default gateway I am able to connect to same SQL server.
I got the solution to connect to that server but I don't know why I am facing such problem. And also let me know that is the solution I am using is correct or not?
Iam using web developer express 2010. I was wondering if the web developer 2010 express supports SQL Server 2000. I know i could connectSQL server 2005 and up but is it possible i could connect sql server 2000 to web developer 2010 express?
View 4 RepliesI am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express.It gives following error message:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)
i'm the first servers using sql2005 i connect to the this server from the localhost and host free ok
but when the rent is up to the host failed connect
I need some good hosting. recommend me some.
View 1 RepliesI need to get the MAC address of the machine which will be hosting web application. Web Application will be hosted locally (just for LAN in small environment). We will provide server which will host the application and the other machines will access the application through the system which we will provide.
We want to hard code the MAC address in ASP.NET application and check it if the application is still being hosted by the same server.
We don't want the client to clone the Hard Drive and use the application somewhere else.
We don't want any information about client machine which will request the web application.
X = SERVER (will host application )
X1,X2,X3......XN = machine on local LAN
We are interested only in X's MAC Address.
I want to move all the website (developed in ASP.NET) images to another server. The image hosting server should be dedicated only image processing like image resizing and etc.
Which server is best suitable for this? Taking another IIS server would require more investment again. Instead can I go for Apache or Lighttpd?
Also the server should be capable to process / resize images even though there is heavy load.
I am working on an Asp.Net MVC project.I had a doubt and please someone clarify it fast.Do we need the MVC framework installed in the Hosting server from where the application is installed.I have installed the MVC framework on my developer machine but do we need the framework installed in the hosting server also.
View 3 Replies