MSDE Password

I have a MSDE database running with my sharepoint portal and now i want to customize the portal with some pages built in webmatrix, but i am getting a huge problem. i just don't know what he MSDE password is. how may i find it out, change it or even break it?well, if it's set up with default options, the machine's administrator account should be able to access it without needing the sa password.|||Hi Atrax,

thxs for the support. I've tryied that but didn't work. I type "osql -U sa" and set the password for blank and got the wrong password message, then i tried with the administrator's username and password with the same results. What should i do now? To just uninstall and reinstall it isn't an option because it's the firm's intranet and it can't stop working.|||Problem solved by reinstalation, :(.sql

MSDE on a Dedicated Webserver

Hi, our company is running a couple of java based applications on a dedicated webserver. We are interested in running the Rainbow Portal on this server as well (as a public website), but the actual owner of the server doesn't want to outlay the cash for S
QL Server at the moment. Would it be legal for us to install MSDE on this webserver to use as the database engine for the Rainbow Portal? (bearing in mind that it's a dedicated webserver, and that there would only be one instance of MSDE, and probably onl
y one database)
Sounds like it would be ok, but check the information at this link.
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Jim
"Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> Hi, our company is running a couple of java based applications on a
dedicated webserver. We are interested in running the Rainbow Portal on this
server as well (as a public website), but the actual owner of the server
doesn't want to outlay the cash for SQL Server at the moment. Would it be
legal for us to install MSDE on this webserver to use as the database engine
for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
and that there would only be one instance of MSDE, and probably only one
database)
|||Thanks Jim, but I'm still a bit hazy on the details. The "Appropriate Uses of MSDE FAQ" page says it's appropriate to use it as a database for a website, but the EULA says: "NO RENTAL/COMMERCIAL HOSTING". Seems a bit contradictory, and I need to be absolu
tely sure. I guess it'll be the owner of the dedicated webserver that'll be offering it to our company, but they won't be charging us to use it, and we'll be the only one's using it. It *sounds* like it should be ok, but can someone give me a definitive y
ea or nay?
|||IMHO u cant legally use MSDE in this situation
"Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> Hi, our company is running a couple of java based applications on a
dedicated webserver. We are interested in running the Rainbow Portal on this
server as well (as a public website), but the actual owner of the server
doesn't want to outlay the cash for SQL Server at the moment. Would it be
legal for us to install MSDE on this webserver to use as the database engine
for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
and that there would only be one instance of MSDE, and probably only one
database)
|||John,
MS changed licensing for MSDE a while ago. Nowadays, it is "free". As far as I can read below URL, using MSDE
in the scenario described would be OK...
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John Smith" <a__@.abv.bg> wrote in message news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...
> IMHO u cant legally use MSDE in this situation
>
> "Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
> news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> dedicated webserver. We are interested in running the Rainbow Portal on this
> server as well (as a public website), but the actual owner of the server
> doesn't want to outlay the cash for SQL Server at the moment. Would it be
> legal for us to install MSDE on this webserver to use as the database engine
> for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
> and that there would only be one instance of MSDE, and probably only one
> database)
>
|||but what about this: "
Q. How do I acquire rights to deploy MSDE throughout my company?
A. The following products allow you to deploy MSDE throughout your
organization:
a.. MSDN Universal, Enterprise, and Professional subscriptions
b.. SQL Server 2000 Developer, Standard, and Enterprise Editions
c.. Visual Studio .NET Architect, Developer, and Professional
Editions
d.. Visual FoxPro 7.0 or 8.0
Note: Microsoft Access only provides rights to use MSDE on the device
on which Microsoft Access is installed.
"
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oxouso0NEHA.3264@.tk2msftngp13.phx.gbl...
> John,
> MS changed licensing for MSDE a while ago. Nowadays, it is "free". As far
as I can read below URL, using MSDE
> in the scenario described would be OK...
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "John Smith" <a__@.abv.bg> wrote in message
news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
this[vbcol=seagreen]
be[vbcol=seagreen]
engine[vbcol=seagreen]
webserver,
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Yes, I asked MS to clarify that point, something they apparently didn't do. My assumption is that it is either
a leftover or it refers to re-distributing within your own organization...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John Smith" <a__@.abv.bg> wrote in message news:eYfrXi%23NEHA.3348@.TK2MSFTNGP09.phx.gbl...
> but what about this: "
> Q. How do I acquire rights to deploy MSDE throughout my company?
> A. The following products allow you to deploy MSDE throughout your
> organization:
> a.. MSDN Universal, Enterprise, and Professional subscriptions
> b.. SQL Server 2000 Developer, Standard, and Enterprise Editions
> c.. Visual Studio .NET Architect, Developer, and Professional
> Editions
> d.. Visual FoxPro 7.0 or 8.0
> Note: Microsoft Access only provides rights to use MSDE on the device
> on which Microsoft Access is installed.
> "
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oxouso0NEHA.3264@.tk2msftngp13.phx.gbl...
> as I can read below URL, using MSDE
> news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...
> this
> be
> engine
> webserver,
>
>
|||if u get an answer post it here plz
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OB2Hqx%23NEHA.3012@.tk2msftngp13.phx.gbl...
> Yes, I asked MS to clarify that point, something they apparently didn't
do. My assumption is that it is either
> a leftover or it refers to re-distributing within your own organization...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
|||I asked again last week, but I didn't get a reply yet. Probably an MS representative or below is the best bet:
"To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Smith" <a__@.abv.bg> wrote in message news:%23aOzQ0%23NEHA.4036@.TK2MSFTNGP12.phx.gbl...
> if u get an answer post it here plz
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OB2Hqx%23NEHA.3012@.tk2msftngp13.phx.gbl...
> do. My assumption is that it is either
>

MSDE limitations

I'd like to use MSDE since it's free instead of SQL Server for my database. I will be hosting a portal type site. If all goes well and my site is wildly successful are there any limitations in MSDE that I need to worry about?

For instance, I thought there was a limit to the number of connections. I thought I remember seeing 5 or 50 on the microsoft download site.

If there is a connection limit of say 10, what happens when connection 11 comes in? Does it just wait for a free connection or does it fail?

Is anyone using is as the database on a large portal site? How many users are there in total? How many connected at the same time?

I am under the assumption that it is SQL Server underneath, so I assume the performance and abilities are very good. Is this a fair assumption?

Thanks for the inputSome of the limitations of MSDE:

25 concurrent users
2 GB max Database size
No Enterprsie manager|||::For instance, I thought there was a limit to the number of connections.

Less thinking and more reading helps against this. I haved no clue why everyone thinks there is a 10 connection limit on MSDE, when the documentation provided, the readme and the FAW to msde pretty clearly say what is there and how it is there.

::If there is a connection limit of say 10, what happens when connection 11 comes in?

TRIED reading the documentation?

You know the one you find at:
http://www.microsoft.com/sql/msde/

more concrete the document you find at:
http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true

::Does it just wait for a free connection or does it fail?

I will quote - I hope you understand it:
::Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and MSDE 2000
::allow 32,767 connections to an instance of the database engine. There is no limit for the
::number of connections that can be executing operations at the same time. The only effect
::of the workload governor is that it starts slowing down the database engine when more
::than eight operations are actively running at the same time.

Clearn enough? More info on the document provided.

::Is anyone using is as the database on a large portal site?

Define large.

::How many users are there in total? How many connected at the same time?

Irrelevant. No user connects at the same time. THink how web applications work. MSDE can handle 8 concurrentoperations - this is at least 8 concurrent pages being served. If you manage to hammer out a page in 0.1 seconds, this means per second you can serve 80 requests. If a user requests a page every 10 seconds average, this means you can serve 800 users WITHOUT ANY CACHING. If you are a little smart in your use of output caching, you can run this number up to some thousand (4000-5000) without any sweat. It all depends how dynamic your portal really is - and how smart or dump your usage of various caching levels is. Remmeber: cache as early as possible (output cache), as you get the most gain there.

::I am under the assumption that it is SQL Server underneath,

No. They share the same codebase, but SQL Server is not "underneath" it (whatever this is supposed to mean in IT).|||I'm sorry I failed to remember everything I read on their site. I was looking for information on how useful MSDE is in production environments. I was looking to run a .Text blog or some other such portal that used MSDE as the database. From reading on Microsoft.com I find the following:

"Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server that's ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users."

This tells me that I should *not* be using MSDE for production type sites. I was just wondering if anyone had any first hand experience using it on a web site serving up to more than "25 concurrent users". I was also wondering how many visitors a day would equal "25 concurrent users" since site visitors are generally spread out over the day. I was wondering how many users *the site* had (not the database) and how many of the *site* users are typically using the site at the same time (not neccessarily the database).

Now that I've gone back to read the documentation on their site, I see that my initial questions are not answered by Microsoft. I thought the number was somewhere between 5 and 50, it's 25. They do not define what "25 concurrent users" are or how it affects scaling of the database. They indicate that one can "migrated to SQL Server 2000 technology if the customer or end user wants to scale the solution up to thousands of users or terabytes of data." but there is a lot of ground between this and the 25 concurrent users quote above with no documentation provided as to what happens to msde when you go over 25 concurrent users.|||Wow, what an arrogant guy. My first time here, and i see this kind of junk right off the bat? I thought i'd help out, but it seems none is needed. I do find it interesting that someone who goes out of their way to peddle their own wares (link under username, MVP banner, and sales-begging tagline) wouldn't be such an ass. I look forward to catching one of your questions in the future. No matter how good at something you think you are, there's always someone better.|||ps.

from: http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs

"What does Microsoft expect of its MVPs?
Because the MVP Award is an award-based program whose criteria are based on past contributions, Microsoft has no expectations of MVPs beyond the expectations of courtesy, professionalism, and adherence to the community rules that we ask of all Microsoft community members."

Sounds like you forgot to read that. See professionalism, courtesy, etc.