Hello, This question has been asked in regards to 2005, but did not see anything with 2000. We have a new application that needs to run on 2005 or better but everything else we have is geared towards 2000. We could upgrade, but that is not within budget at this time. We were thinking we could run SQL Server 2008 Express on the same...
anyone have script or procedures to install SQL Server 2008 Express, set up the database for the app and finally install a client .NET WinForm application? ...
I have a WinForm application built with VS 2008 (C#) and SQL Server Express 2008 that is currently deployed on test users PC. I have modifications to do on the database structure (add fields, tables, etc.) and I wonder what's the best method to distribute the changes on the users PC (without loosing the users data). From what I've lear...
Has anyone successfully installed SQL Server Express 2008 with Advanced Services? I've tried several times and half way through the installation I always get the error 'The downloaded file appears to be corrupt'. I found this thread on MSDN but it seems that noone there could get it to work. They were only successful in installing th...
I've just installed Microsoft SQL Server Express 2008 (with Reporting Services). My installation is side by side with SQL Server 2005. So far creating reports and testing them in the development environment has worked fine, however I can't get the web server or report manager working. In the Reporting Services Configuration Manager, i...
Hi, Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it? i.e. it won't work with sql express ...
I have recently had some problems that I think might be helped by debugging my ASP.NET MVC application in IIS instead of with the default ASP.NET Development Server. However, when I try this the application can't access the database server (MS SQL Server 2008 Express) - it works fine on the Development Server though. The error I get is ...
Is there a way to enable the “My Reports” feature in SQL Server Reporting Services 2008 when I am using SQL Server 2008 Express edition with Advanced Services? As I am using Express edition, I cannot connect SQL Server Management Studio to Reporting Services: - "SQL Server Management Studio Express cannot be used to administer a ...
I have just installed VS C# Express 2008 which includes SQL Server Express 2008. It all went ok and I can see VS C# and SQL Server in the list of installed products. When I start VS C# it looks fine but in the DB Explorer / Data Connection context menu the option 'Create new SQL Server Database' is disabled. I have uninstalled all VS p...
I want to install sql server 2008 express on my laptop that has 1 GB memory, but my database contains lots of binary data that I don't want spending all my RAM. I would much rather sacrifice sql performance (make it page) in favor of other applications. Is it possible to limit the memory footprint of sql server? ...
The title says it all. I just setup a new Windows Server 2008 machine with an instance of SQL Server 2008 Express. The SQL Browser service does not appear to be working correctly. In Management Studio, browsing for servers shows the hostname of the new server, but not the instance name. When you choose the hostname form the list it d...
Good morning, all. This is my first question on stackoverflow, so hopefully this isn't something that's been beaten to death and I haven't been able to find it. I'm developing an application that is going to be distributed shrinkwrapped. We have gotten the rights to distribute SQL Server 2008 Express Edition with our application, but ex...
hi, i had installed sql server 2008 express edition with tools but i need to use full text search which i understand is missing in the edition that i have. how do i go about upgrading to get full text search feature?? as it was an online installation i dont have any installation media stored on my computer can i use something else??? ...
I have a DB I created with SQL Server 2005 and created a backup (*.bak) now I want to restore it with 2008 but ouch, I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'SHIMMY-PC\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.mic...
A while back, I installed SQL Server 2008 Express with Advanced Services, which installed SQL Server 2008 Management Studio (SSMS) Express as well. Now that we have SQL 2008 Standard on the network some months later, I want to confirm that I don't have to reinstall SSMS 2008 on my desktop. This blog post I found seems to suggest that I'm...
Hello all I tried to set-up the SQL tables for ASP .net 2.0 membership provider by clicking on ASP.net Configuration under Project. I have completely uninstalled SQL 2005 Express and installed SQL 2008 Express instead. It seems like that it can not connect to the database. Does anybody know how to get this fixed so I can use 2008 in...
Hi all, I'm wondering if anybody has had any experience in trying to install SQL Server 2008 Express along side with SQL Server 2000. We have a production server running 2000 which all of our current stuff is running on. However, something new is in the pipeline that uses SQL Server 2008 Express. Hitting Google thus far has given m...
I visited a few forums and tried everything short of wiping out and reinstalling OS while trying to install SQL Server 2008 Express; uninstalled failed installation everytime, cleaned up registry and install folder, disabled UAC, cleaned up WMI repository, rebooted whenever required etc.. Any solution will be greatly appriciated. One o...
Question: How can we connect a SQL Server CE DB to a SQL Server Express DB? We can't use Merge replication because you can only be a Subscriber in SQL Server Express, not a Publisher. More background information: We have an application structured as follows: 1) Our headquarters, running SQL Server 2008 2) Branches, running SQL Server ...
I'm looking for advices and suggestions on how to synchronise data between two databases. The first database is a SQL Server 2008 Express that run on disconnected laptops (no network or internet access). The second database (main) is a VFP 9.0 that run on a server. When the user connect their laptop on the network, I want the synchroni...