Fixed memory size on MSDE

I would like to limit memory (RAM) usage for MSDE.
Since there is no Enterprise manager - is there another way how to do it?
(-> SQL command?!)
Thank You
PetrHi Petr
Please read about sp_configure in the Books Online.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Petr Stejskal" <petr.stejskal@.txn.cz> wrote in message
news:uoi1VuKnDHA.1884@.TK2MSFTNGP09.phx.gbl...
> I would like to limit memory (RAM) usage for MSDE.
> Since there is no Enterprise manager - is there another way how to do it?
> (-> SQL command?!)
> Thank You
> Petr
>

five connection limit

Hi!
Everybody know that MSDE (based on SQL Server 2000) has five-connection
limit after which its performance degrades. Do SQL server 2005 Express
edition also has five-connection limit? Or this limit was dropped?Hi
No connection limit in Express though a performance throttle, but it is
limited to use only 1 CPU, 1GB RAM and a database can have a maximum data
size of 4GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
message news:op.s2ltu9n6n8ihmu@.iw2k.helpmicro.local...
> Hi!
> Everybody know that MSDE (based on SQL Server 2000) has five-connection
> limit after which its performance degrades. Do SQL server 2005 Express
> edition also has five-connection limit? Or this limit was dropped?|||The limit was removed in SQL 2005 Express. See
http://msdn2.microsoft.com/en-us/library/ms165672.aspx.
Happy Holidays
Dan Guzman
SQL Server MVP
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
message news:op.s2ltu9n6n8ihmu@.iw2k.helpmicro.local...
> Hi!
> Everybody know that MSDE (based on SQL Server 2000) has five-connection
> limit after which its performance degrades. Do SQL server 2005 Express
> edition also has five-connection limit? Or this limit was dropped?

First time setting up SQL MSDE, trouble loggin in...

I just installed MSDE and I am getting errors when trying to install the Time Tracker application: "Unable to connect" and my only option is to cancel the installation.

I also get an error when trying to connect using Web Data Administrator: "Invalid username and/or password, or server does not exist. Also, please ensure that SQL Server Authentication is enabled on the server. " I am using the "sa" account with the correct password. I have also tried no password (just in case) and that doesn't work either.

I cannot confirm that I have SQL Server Authentication enabled. I have no idea how to check for this using SQL MSDE. This may be part of the problem...any thoughts on this issue?

My OS: Windows XP Professional Service Pack 1 (Build 2600)

My Web Server: Internet Information Services Version 5.1.2600.0

My .NET Framework: .NET Framework Version 1.1.4322.573

My SQL Server: Microsoft SQL Server Desktop Engine (SQL Server Version 8.00.760)

Other Info: .NET is fine and linked to IIS, all other .NET apps compile/run fine. SQL Server Service Manager is giving me the green arrow. My OS is MS WinXP Pro, all SP's and hot fixes and updates applied.

I will be monitoring this post and trying any suggestions right away & posting my success/failure right back here.

If anyone would like to see a screen shot of the error generated by the Time Tracker install, use the following link:

http://www.versyss.com/mike/shot.gif

Thanks in advance!First, to determine with authentication mode you are using, go to the Windows command prompt and type this command:

osql -d Master -Q "xp_loginconfig" -E

Terri|||Results of: osql -d Master -Q "xp_loginconfig" -E

Name: Config_Value
--------
login mode:Windows NT Authentication
default login:guest
default domain:Null
audit level:none
set hostname:false
map _ :domain separator
map $:Null
map #:-

So it looks like I am using Win. NT Auth. mode. Now how do I switch this to SQL Server Auth. or Mixed Mode? Remember this is a MSDE installation so I have no Enterprise Manager...

Thanks sof the help so far....Mike|||Without Enterprise Manager, you could edit the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

Change LoginMode to 1 for "Windows Only", 2 for "SQL Server and Windows"

As always, use care when editing the registry. It should be backed up first. If you've never edited the registry, you should read up on it first. I claim no responsibility!

Terri|||Terri, you RULE!

It worked. I edited the reg value you indicated, rebooted, ran "osql -d Master -Q "xp_loginconfig" -E" and verified my mode (which now reads "mixed") and was able to log into my server using Web Data Admin! Thanks so much! I hope this posts helps some other people as well!

P.S. The use of "localhost" didn't work for the server. I think I read somewhere that the "localhost" option has been disabled in MSDE. I don't know for sure but all I know is that "localhost" didn't work for me but the server name and IP address do...

Thanks again Terri...

Firewall settings for msde

hi all,
i'm testing some of my applications w/c runs on MSDE on the new Windows XP Service Pack2, which actually entails newer & more secure firewall settings.
my application run on both the server & workstations only w/ the firewall switched off.
but the problem comes w/n i have the firewall settings switched on. the applications runs on the server but the workstation applications cannot.
how do i configure my workstations to be in the exception list on the firewall so they can access the server?
i'll already added the workstation's IP address & subnet but still i can't get it connect.
how do i configure my network to use TCP/IP protocol w/ a static port so i can add the workstations to the firewall's exceptions list.
thanks.
herbert
hi Herbert,
"herbert" <praetorean.tech@.graffiti.net> ha scritto nel messaggio
news:EAE41221-4DE2-458E-84D7-B24A0531F1A1@.microsoft.com...
> hi all,
> i'm testing some of my applications w/c runs on MSDE on the new Windows XP
Service Pack2, which actually entails newer & more secure firewall settings.
> my application run on both the server & workstations only w/ the firewall
switched off.
> but the problem comes w/n i have the firewall settings switched on. the
applications runs on the server but the workstation applications cannot.
> how do i configure my workstations to be in the exception list on the
firewall so they can access the server?
> i'll already added the workstation's IP address & subnet but still i can't
get it connect.
> how do i configure my network to use TCP/IP protocol w/ a static port so i
can add the workstations to the firewall's exceptions list.
>
you have to manually open TCP/IP port 1433, if MSDE instance you are running
is listening on the default port.. or the port you are using to connect to
it...
as regards multi instance support, Windows XP SP2 firewall will actually
disable the benefit of dynamic port detection by SQL Server... that's to say
you have to manually statically set a designed port for each instance, open
all the required ports on the Firewall and close UDP 1434 port, which is no
longer needed when dynamic detection is "disabled"..
Microsoft is developing a script for customers who need an automated
solution. If you need the script, contact msdewxp2@.microsoft.com, asking for
"script for customers who need an automated solution to enable MSDE network
connections" , as required by PSS email "Guidance for using MSDE on Windows
XP Service Pack 2"
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply