Microsoft SQL Server Desktop Engine (MSDE)

[samsmithnz]

Sick of all those MSDE questions that are all the same? Ever wanted the definitive answer on just exactly how MSDE limits performance and scalability? Well, you

 

[Nerseus]

Id prefer a simple (one printable page) doc that explains how to install MSDE and configure it for the "simple" users. That way I can refer people to that page when they ask that question.

How they actually USE MSDE would be another great 2 or 3 page doc. Meaning, how to create a DB, a table, etc. since MSDE comes with no UI.

-ner

 

[jwHerm]

That would be very helpful Nerseus. Anyone found a page/document that would be able to explain this to someone like me with no experience in MSDE?

 

[Derek Stone]

Its all on MSDN.

http://msdn.microsoft.com/library/en-us/distsql/distsql_84xl.asp

 

[bri189a]

That would be very helpful Nerseus. Anyone found a page/document that would be able to explain this to someone like me with no experience in MSDE?

Look on MSDN for SqlWebAdmin... its a program that works great...gives a nice little interface for you too add tables, databases, etc. If you cant find it I have it saved somewhere.

 

[ThePentiumGuy]

i read somewhere(on this forum), that there was a good GUI for MSDE,
www.msde.biz

 

[ThePentiumGuy]

Having trouble installing MSDE?

Check this article out, itll really save time when you install MSDE
http://www.informit.com/articles/article.asp?p=26863&seqNum=4
Apparently, MSDE comes with vs.net, and theres no need to download anything, all you gotta do is follow the instructions on the site to "Activate" it

 

[Mykre]

Just a Quicky...

When Installing MSDE bu Default the System is installed with Windows Authentication Only.

I have Seen on many forums that people are haveing problems connecting to that database with an error of not Associated with a trusted connection.

On way to fix this is to change the Setup.ini file that is deployed with the download from MS of MSDE. Below is what I use.

-> Change the Text in the Setup.ini to the following, making sure that you change the <password> tag to the password you what for the SA Account.

-Setup.ini-
[Options]
SECURITYMODE=SQL
SAPWD=<password>
-End of Setup.ini-

 

[Derek Stone]

"Hands on how to configure the Microsoft MSDE"

 

[joe_pool_is]

The last post here was done by Derek Stone in 2004 (4 years ago). SQL CE is out now, and is supposed to be the successor to MSDE, from what I hear.

Does anyone have good information on SQL CE? Particularly, Im looking how to include it in my installers so that the applications I distribute can use it (My customers typically are not intelligent enough to install SQL themselves).

 

[joe_pool_is]

Personally, I use this site for reference quite often, so I wanted to update this with some SQL CE links:

Walkthrough: Using SQL Server Compact Edition in an Application:
http://msdn.microsoft.com/en-us/library/aa983340(VS.80,printer).aspx

How to: Add a SQL Server Compact Edition Database to a Project
http://msdn.microsoft.com/en-us/library/aa983322(VS.80,printer).aspx

How to: Deploy a SQL Server Compact Edition Database with an Application:
http://msdn.microsoft.com/en-us/library/aa983326(VS.80,printer).aspx

(The links could be dead at any moment, knowing Microsoft, hence why I included the titles.)

Other helpful files to search by on Microsofts Download Center:

Microsoft SQL Server 2005 Compact Edition:
File Name: SQLServerCE31-EN.msi
Version: 1
KB Article: KB920700
Size: 1.7 MB

Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit
File Name: SSEC31SDK-ENU.msi
Version: 1
KB Article: KB920700
Size: 35.5 MB

Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1
File Name: SSCE31VSTools-ENU.exe
KB Article: N/A
Size: 27.6 MB
​

I hope some of you get some good use out of my research!
~Joe