f) Got to the Sharepoint site and change Database Connection by accessing the "Microsoft SharePoint Administrator" in Administrative Tools and selecting "Administration" for the site and then "Change database connection" Another correspondent said that the DB restore within Enterprise Manager didn't work for him and he had to write a RESTORE DATABASE WITH MOVE query to get the job done.

SQL Server Express is an evolution of MSDE that continues to make the features and functionality of SQL Server technology widely available. SQL Server Express includes enhancements to setup and manageability to make it easier to use than MSDE. SQL Server Express also utilizes simpler and more scalable performance limits as compared with MSDE which managed throughput with a workload governor.

The name MSDE was confusing to customers and partners because many did not realize that it was associated with SQL Server. By changing the name from MSDE to SQL Server Express there will be less confusion among customers and partners.

WSS uses as default WMSDE which is a special version of MSDE 2K and ONLY works with SQL Server 2K (and variants) not 7.0. Note that in order for SQL Server 2K to work on a Windows 2003 Server it (SQL Server) must use Service Pack 3 or later. (Ed: in fact SP3a) Note: A little known fact is that the version of MSDE used with WSS (called "WMSDE") is not the same version of MSDE as that used by SPS v2.

STS 1.0 stored documents in the File system while the database contained information on the location of the documents. In WSS the search function is no longer available for sites with MSDE 2K unless they also have SPS 2.0 (SharePoint Portal Server 2.0) installed. The options are SQL Server searching or SPS 2.0 searching. SPS 2.0 searching works where the WSS database is either SQL Server 2K or MSDE 2K; SQL Server searching works only where the WSS database is SQL Server 2K. MS recommend SPS 2.

MSDE is included in the e-FAQ installation file and is free of charge to e-FAQ purchasers. SQL Server cannot be purchased from Interactive Intelligence directly.

Yes. You can use any relational database that is accessible by JDBC and satisfies the SPECjAppServer2004 Run and Reporting Rules.

e-FAQ can be installed on the same machine as your SQL Server database and this is recommended in environments where a SQL Server database can be dedicated solely to e-FAQ. If the database server is used for other production purposes, it is recommended that e-FAQ be installed on a separate server in order to avoid processing bottlenecks between e-FAQ and the database environment.

I am trying to upgrade MSDE to full SQL Server and getting an error 'You cannot install a version which is older (7.00.623) than the version on your machine (7.00.677)

You may use MS ACCESS, MS SQL, MSDE, Oracle, ODBC as backend database. The default database Track4win uses is MS ACCESS. If you want to monitor more than 50 users at a time, we recommend you use other databases such as MS SQL or MSDE. You may configurate the database setting in "DB Connection Config" (You may find it in Start Menu's Track4Win Server program group) There is no functionality limitation except the free trial version is for 15-day and 5-user evaluation.

If you intend to have more than 5 simultaneous/concurrent users you will be required to purchase SQL Server. For 5 concurrent users or less, CompuPharma will install MSDE, a freely available database engine from Microsoft.

A.10 Yes. MSDE can be installed and run together with a "full version" of SQL without any modification or issues.

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server (and it is shipped with Timetabler 6). MSDE contains a workload governor designed to limit performance if the database engine receives more work than is typical of a small number of users. Installation of MSDE or SQLServer depends on your anticipated use of Timetabler.

Yes. During the installation you will be prompted to choose between using the MSDE (included with LiveAgent) or use your own existing SQL server.

Make complete backup of the SQL Database (in Enterprise Manager), and restore the database to the new server. Once you have done this, you will need to point the SPii installation to the new server location. This is done by modifying the file ceosoft.udl (C:\Program Files\Common Files\CEO Software Inc) on the web server.

Number of ODBC connections depends on the hosting plan. You can have additional ODBC's. Please see Web Hosting Extras for customizing your plan.

Yes of course. The editor downloads images from the server by it's link and uploads them by requesting a server-side script, so a particular image location at your server depends on your scripts only. The script are free to keep images anywhere, for example as files, as database records, or send them via email.

There are many different databases available (e.g. Access, SQL Server) and the reliability and scalability of them varies considerably. Booking Pro has been designed to be a very reliability solution and as such needed a reliable database. SQL Server offers high degrees of reliability and hence are natural choices for storing your valuable data. The Express edition is a scaled down version of SQL Server and only supports a small number of concurrent users.

From the login screen at the URL above, first choose for the Authentication Method: SQL Login. For Server enter Apollo1. Now enter the Username and Password you have chosen in the HELM CP and login to the SQL Web Administrator. Here you can manage all your Tables, Users, etc.

Microsoft has created the SQL Desktop Engine, a small subset of their flagship SQL server product. It can be used for both web development and applications. It is available for FREE at Microsoft's SQL Desktop Engine website.

MSDE can be installed manually. Users of ASSET should follow these directions only if they have been directed to by ASSET support personnel. Yes there are interoperability issues; please download the following document which provides guidance on how to resolve the interoperability issues.

You can use either backup / restore or detach / attach. Note that you also will have to transfer the logins and passwords. How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server How to resolve permission issues when you move a database between servers that are running SQL Server Yes, as long as both servers run SQL 2005, this is no problem at all.

For a donation, we are able to host your MS SQL Server database solution. We also have a mySQL database available on a backend Linux server for those interested in the open-source alternative.

Most 3rd Party SQL Server based applications provide instructions for the installation of the database. Send us a copy of the installation instructions and we will create the database based on those instructions. Most instructions tell you to create the database, create the DB User Account for the database, apply the password and then run a .sql script. Upload the script to your server and we will run the .sql script for you after creating the database.

The Oracle Migration technology web site provides tools and documentation on moving your database to Oracle.

Yes. First back up your SQL 2000 database, and then move it to the SQL 2005 server you want to use. Restore your database, and then run the Orion Configuration wizard on the Orion server and specify the new SQL Server instance. For more information, see the Orion NPM Migration Technical Reference.