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