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’re in luck, as Microsoft has now published a whitepaper describing how the governor in MSDE works.

http://www.microsoft.com/sql/msde/techinfo/workloadgov.asp

In summary the paper describes how the governor stalls connections for a few milliseconds on each logical read or write, once the limit of more than eight concurrent operations has been reached. The connection limit for MSDE is the same as for a standard SQL Server instance (32,767), but obviously the more concurrent connections, the more likely you are to reach the limit of 8 concurrent operations that triggers the workload governor.

 

[Nerseus]

I'd 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]

It's 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... it's a program that works great...gives a nice little interface for you too add tables, databases, etc. If you can't 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, it'll 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 there's 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, I'm 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 Microsoft's 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