No instance of SQL Server under MSDE installation

Hi all,
after successfully completing the installation of a
downloaded copy of MSDE for VS.Net things are
not working at all.
I was having trouble with my VS.Net installation so I
uninstalled VS.Net and MSDE.
I have installed MSDE several times today and each
time I can not see the instance name of the installation.
I have removed any existing directories, cleared the
obvious things from the registry, changed the instance
name and even chosen different target and data
directories to try and solve the problem. The service
seems to have started correctly, but I do not get
a green play icon in the system tray at the bottom of
the screen. When i open the server manager I
can not see the server running at all.
I do not know what to do next. Does anyone have any
ideas as to what what be causing this problem?
Many thanks for your assistance in helping me to
solve this problem.
Regards,
Jason.
Please ignore this post. I was just to impatient to wait
for all the services, etc to start.
All appears to be OK now.
Thanks.
On Thu, 29 Apr 2004 18:40:13 +0100, JJ <jason@.nospam.divemaster.org>
wrote:

>Hi all,
>after successfully completing the installation of a
>downloaded copy of MSDE for VS.Net things are
>not working at all.
>I was having trouble with my VS.Net installation so I
>uninstalled VS.Net and MSDE.
>I have installed MSDE several times today and each
>time I can not see the instance name of the installation.
>I have removed any existing directories, cleared the
>obvious things from the registry, changed the instance
>name and even chosen different target and data
>directories to try and solve the problem. The service
>seems to have started correctly, but I do not get
>a green play icon in the system tray at the bottom of
>the screen. When i open the server manager I
>can not see the server running at all.
>I do not know what to do next. Does anyone have any
>ideas as to what what be causing this problem?
>Many thanks for your assistance in helping me to
>solve this problem.
>Regards,
>Jason.

No Enterprise Manager after install

I've installed MSDE Release Candidate on XP Pro successfully and the server
starts. However, I can't find the Server Enterprise Manager anywhere. Help!
It does appear on the MMC and I don't have any SQL groups on my menu after
the install.
Hi
MSDE does not come with EM. All you have is OSQL, the command line tool.
Any reason you are using MSDE 2000 RC? That is no longer supported as it was
a beta.
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/
"cometlucky" <cometlucky@.discussions.microsoft.com> wrote in message
news:5898C5A7-2F5B-4AEB-AC33-DAE6A12FB1FE@.microsoft.com...
> I've installed MSDE Release Candidate on XP Pro successfully and the
> server
> starts. However, I can't find the Server Enterprise Manager anywhere.
> Help!
> It does appear on the MMC and I don't have any SQL groups on my menu after
> the install.

No connection limitation with SQL Express 2005?

MSDE had the limitation of 25 concurrent connections.
It seems that SQL Express 2005 doesn't have this limitation. Is that
correct? Does Express support as many connections as the "full" SQL 2005
server?"the friendly display name"
<thefriendlydisplayname@.discussions.microsoft.com> wrote in message
news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> MSDE had the limitation of 25 concurrent connections.
No it didn't. It had a query governor which throttled performance after 5
concurrent workloads.

> It seems that SQL Express 2005 doesn't have this limitation. Is that
> correct?
Yes.

>Does Express support as many connections as the "full" SQL 2005
> server?
Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and 1CPU
which will impose some limit on the number of users it can serve.
David|||Hi
And to add, there are no SQL Server limits, but if you run on Windows 2000
Pro or Windows XP, the OS has a limit of number of incoming network
connection it accepts, and that is 10.
On Server editions of the OS's, there are no limits.
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/
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uxhcKhs5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> "the friendly display name"
> <thefriendlydisplayname@.discussions.microsoft.com> wrote in message
> news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> No it didn't. It had a query governor which throttled performance after 5
> concurrent workloads.
>
> Yes.
>
> Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and
> 1CPU which will impose some limit on the number of users it can serve.
> David
>|||> And to add, there are no SQL Server limits, but if you run on Windows 2000
> Pro or Windows XP, the OS has a limit of number of incoming network
> connection it accepts, and that is 10.
IIRC, that is Redirector connections, not socket connections. Has anyone
tried more then 10 sql connections on XP?
William Stacey [MVP]sql

No connection limitation with SQL Express 2005?

MSDE had the limitation of 25 concurrent connections.
It seems that SQL Express 2005 doesn't have this limitation. Is that
correct? Does Express support as many connections as the "full" SQL 2005
server?"the friendly display name"
<thefriendlydisplayname@.discussions.microsoft.com> wrote in message
news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> MSDE had the limitation of 25 concurrent connections.
No it didn't. It had a query governor which throttled performance after 5
concurrent workloads.
> It seems that SQL Express 2005 doesn't have this limitation. Is that
> correct?
Yes.
>Does Express support as many connections as the "full" SQL 2005
> server?
Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and 1CPU
which will impose some limit on the number of users it can serve.
David|||Hi
And to add, there are no SQL Server limits, but if you run on Windows 2000
Pro or Windows XP, the OS has a limit of number of incoming network
connection it accepts, and that is 10.
On Server editions of the OS's, there are no limits.
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/
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uxhcKhs5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> "the friendly display name"
> <thefriendlydisplayname@.discussions.microsoft.com> wrote in message
> news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
>> MSDE had the limitation of 25 concurrent connections.
> No it didn't. It had a query governor which throttled performance after 5
> concurrent workloads.
>> It seems that SQL Express 2005 doesn't have this limitation. Is that
>> correct?
> Yes.
>>Does Express support as many connections as the "full" SQL 2005
>> server?
> Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and
> 1CPU which will impose some limit on the number of users it can serve.
> David
>|||> And to add, there are no SQL Server limits, but if you run on Windows 2000
> Pro or Windows XP, the OS has a limit of number of incoming network
> connection it accepts, and that is 10.
IIRC, that is Redirector connections, not socket connections. Has anyone
tried more then 10 sql connections on XP?
--
William Stacey [MVP]

No connection limitation with SQL Express 2005?

MSDE had the limitation of 25 concurrent connections.
It seems that SQL Express 2005 doesn't have this limitation. Is that
correct? Does Express support as many connections as the "full" SQL 2005
server?
"the friendly display name"
<thefriendlydisplayname@.discussions.microsoft.com> wrote in message
news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> MSDE had the limitation of 25 concurrent connections.
No it didn't. It had a query governor which throttled performance after 5
concurrent workloads.

> It seems that SQL Express 2005 doesn't have this limitation. Is that
> correct?
Yes.

>Does Express support as many connections as the "full" SQL 2005
> server?
Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and 1CPU
which will impose some limit on the number of users it can serve.
David
|||Hi
And to add, there are no SQL Server limits, but if you run on Windows 2000
Pro or Windows XP, the OS has a limit of number of incoming network
connection it accepts, and that is 10.
On Server editions of the OS's, there are no limits.
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/
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uxhcKhs5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> "the friendly display name"
> <thefriendlydisplayname@.discussions.microsoft.com> wrote in message
> news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> No it didn't. It had a query governor which throttled performance after 5
> concurrent workloads.
> Yes.
>
> Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and
> 1CPU which will impose some limit on the number of users it can serve.
> David
>
|||> And to add, there are no SQL Server limits, but if you run on Windows 2000
> Pro or Windows XP, the OS has a limit of number of incoming network
> connection it accepts, and that is 10.
IIRC, that is Redirector connections, not socket connections. Has anyone
tried more then 10 sql connections on XP?
William Stacey [MVP]

newsgroup sqlserver.msde , but no sqlserver.sqlexpress?

Am I looking in the wrong newsgroups, there is msde newsgroup, but I cannot
find a sqlexpress . Should I post questions about sqlexpress in the msde
group or where?
Jan D''Hondt
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
SQL database and .NET solutions
hi Jan,
Jan D''Hondt wrote:
> Am I looking in the wrong newsgroups, there is msde newsgroup, but I
> cannot find a sqlexpress . Should I post questions about sqlexpress
> in the msde group or where?
http://forums.microsoft.com/msdn/def...id=19&siteid=1
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea, Thank you for your help.
One has to wonder : what is the distinction between forums and newsgroups?
does it depend on the season? Are forums more fashionable than newsgroup?
Where are my pills?!?
Jan D''Hondt
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
SQL database and .NET solutions
"Andrea Montanari" wrote:

> hi Jan,
> Jan D''Hondt wrote:
> http://forums.microsoft.com/msdn/def...id=19&siteid=1
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Hi Jan,
go for that.
HTH, jens Suessmeyer.
|||On Wed, 16 Nov 2005 03:20:02 -0800, Jan D''Hondt wrote:

>Am I looking in the wrong newsgroups, there is msde newsgroup, but I cannot
>find a sqlexpress . Should I post questions about sqlexpress in the msde
>group or where?
Hi Jan,
I expect MS to open some new groups for the new features of SQL Server
2005 in the weeks to come; until they do, just pick the group that suits
the question best.
SQLExpress questions are fine here. They can also be posted in .server
or .programming.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||hi Jan,
Jan D''Hondt wrote:
> Andrea, Thank you for your help.
> One has to wonder : what is the distinction between forums and
> newsgroups? does it depend on the season? Are forums more fashionable
> than newsgroup?
Hugo already answered... Microsoft is quiet deprecating NG in favour of it's
own forum, but I do think they will add new SQL Server 2005 ng as well...
I've heard something about SQLExpress ng name, as someone suggested not to
name it "Express" in order to avoid user's confusion about "Express answers"
ROTFL
just a side note... I'd post SQLExpress questions on non MSDE ngs as it seem
Microsoft employees do not attend this one very much, so Setup problems and
the like are not very much probably answered..

> Where are my pills?!?
and where are mine? :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

newbies help 2 questions

There is 1 error when i tried to install msde into my window 2003 server web edition.
1. I use command prompt to enter c:\\sql2ksp3>setup SAPWD=aA1234567
the errors is "go to the control panel to install and configure system components"
How do i install ?

Sql client for 2003 server web edition
2. i tried to install sql client in window 2003 web edition but the msdn cd could not start after i double click on the setupsql.exe. I thought the sql client can be install but not the server on web edition ?I have solve Q1 above by using run the type in
Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD
It seems you cannot double click on the setup.exe in the extracted folder and you cannot use the ms-dos command prompt becuase both return errors like,
"A strong SA password is required for security reason. Please us SAPWD switch to supplyt he same. Refer to readme for more details. Setup will now exits."
or
"Go to the control panel to install and configure system components"

Hope some one can help on Q2|||I think you can not install sql clinet tools on 2003 WE

newbie: True and False 0 and 1?

Hi,
I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
writing a little basic web app. One of the fields I have set to bit
which I assumed I would use for True or False (1 or 0) - Using
Dreamweaver it seems that when I check a field in order to set it to
"true" it seems to have a value of -1 in the table? Why is this? Can
anyone shed some light for me
cheers
Baronne
On 11 Mar 2005 07:56:29 -0800, Baronne wrote:

>I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
>writing a little basic web app. One of the fields I have set to bit
>which I assumed I would use for True or False (1 or 0) - Using
>Dreamweaver it seems that when I check a field in order to set it to
>"true" it seems to have a value of -1 in the table? Why is this? Can
>anyone shed some light for me
Hi Baronne,
The BIT datatype is not boolean. It is numeric, with only the values 0
and 1 allowed. Some people use BIT to represent booleans, but you'll
have to convert true to 1 (or 0) and false to 0 (or 1), and back again,
when going to and from the database.
Since SQL Server has no boolean datatype, you can pick wahtever you
want. I usually use a CHAR(1) datatype, with a CHECK constraint to make
sure that only 'T' or 'F' are allowd (or 'Y' / 'N' - depending on the
specific case).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

Newbie: MSDE no longer listens to outside request. Event id 19011.

Hi
I've had a MSDE 2000 instance running a couple of months without any
problems. Now all of a sudden I can only connect to it from localhost.
When I restart the sql-server using the Service Manager it gives a
warning in the event log with event-ID 19011. Error code 1355.
Also I have a bunch of informational events with event-id 3 and
something about some missing file. I'm not sure if the two event-types
have something to do with each other, though.
I believe my problems started after installing a very simple program
called Dyndns Updater. Looking in the install-log I found that it only
installs the main exe, some txt-files and a normal run-parameter in the
registry. To me it seems unlikely that it should interfere with MSDE in
any way. Uninstalling doesn't help either.
All other services on my server are working normally from another computer.
I'm kind of stuck here, not wanting to uninstall/reinstall MSDE.
Any pointers?
Regards
dne Hovda
GTR AS
NORWAY
Michael C# wrote:
> How about firewalls? Are you running MSDE on Win XP and have you installed
> SP 2 recently? The Windows Firewall will, by default, prevent responses to
> inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If this is your
> problem, try opening up these two ports on your Windows Firewall.
Sorry, I forgot to specify.
We have a pretty simple network of 6 machines, no internal firewalls.
MSDE runs on W2KSP4. I've tried both with and without firewall on the
client-machines that all run XPSP2. It doesn't seem to be a
firewall-related problem. Also, I checked that IP-filtering is turned
off on the server.
Looking deeper into the logs, I found that the program I before
mentioned has definetely nothing to do with it, as I see the same error
(19011) at least two more times, exactly one and two weeks ago, to be
specific.
dne
|||Chris V. wrote:
> What is the size of the MDF file, or the LDF ?
> If I remember properly, the max size is 2Gb, and if I am still right, the
> 2Gb apply to the physical file, to the size of the active pages.
The total size of all databases in the instance is 58MB...
This is very strange: All of a sudden it just started working again! I
can now connect from all clients. I haven't changed anything.
Hm. This problem might not be MSDE related after all. Still I'm
wondering what those error messages mean, though.
Anyway, thanks for your help, guys.
dne

Newbie: MSDE no longer listens to outside request. Event id 19011.

Hi
I've had a MSDE 2000 instance running a couple of months without any
problems. Now all of a sudden I can only connect to it from localhost.
When I restart the sql-server using the Service Manager it gives a
warning in the event log with event-ID 19011. Error code 1355.
Also I have a bunch of informational events with event-id 3 and
something about some missing file. I'm not sure if the two event-types
have something to do with each other, though.
I believe my problems started after installing a very simple program
called Dyndns Updater. Looking in the install-log I found that it only
installs the main exe, some txt-files and a normal run-parameter in the
registry. To me it seems unlikely that it should interfere with MSDE in
any way. Uninstalling doesn't help either.
All other services on my server are working normally from another computer.
I'm kind of stuck here, not wanting to uninstall/reinstall MSDE.
Any pointers?
Regards
dne Hovda
GTR AS
NORWAYMichael C# wrote:
> How about firewalls? Are you running MSDE on Win XP and have you installe
d
> SP 2 recently? The Windows Firewall will, by default, prevent responses t
o
> inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If this is your
> problem, try opening up these two ports on your Windows Firewall.
Sorry, I forgot to specify.
We have a pretty simple network of 6 machines, no internal firewalls.
MSDE runs on W2KSP4. I've tried both with and without firewall on the
client-machines that all run XPSP2. It doesn't seem to be a
firewall-related problem. Also, I checked that IP-filtering is turned
off on the server.
Looking deeper into the logs, I found that the program I before
mentioned has definetely nothing to do with it, as I see the same error
(19011) at least two more times, exactly one and two weeks ago, to be
specific.
dne|||Chris V. wrote:
> What is the size of the MDF file, or the LDF ?
> If I remember properly, the max size is 2Gb, and if I am still right, the
> 2Gb apply to the physical file, to the size of the active pages.
The total size of all databases in the instance is 58MB...
This is very strange: All of a sudden it just started working again! I
can now connect from all clients. I haven't changed anything.
Hm. This problem might not be MSDE related after all. Still I'm
wondering what those error messages mean, though.
Anyway, thanks for your help, guys.
dne

Newbie: MSDE no longer listens to outside request. Event id 19011.

Hi
I've had a MSDE 2000 instance running a couple of months without any
problems. Now all of a sudden I can only connect to it from localhost.
When I restart the sql-server using the Service Manager it gives a
warning in the event log with event-ID 19011. Error code 1355.
Also I have a bunch of informational events with event-id 3 and
something about some missing file. I'm not sure if the two event-types
have something to do with each other, though.
I believe my problems started after installing a very simple program
called Dyndns Updater. Looking in the install-log I found that it only
installs the main exe, some txt-files and a normal run-parameter in the
registry. To me it seems unlikely that it should interfere with MSDE in
any way. Uninstalling doesn't help either.
All other services on my server are working normally from another computer.
I'm kind of stuck here, not wanting to uninstall/reinstall MSDE.
Any pointers?
Regards
Ådne Hovda
GTR AS
NORWAYHow about firewalls? Are you running MSDE on Win XP and have you installed
SP 2 recently? The Windows Firewall will, by default, prevent responses to
inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If this is your
problem, try opening up these two ports on your Windows Firewall.
Thx
"Ådne Hovda" <aadne@.hovda.no> wrote in message
news:eK4kSdRFFHA.392@.TK2MSFTNGP14.phx.gbl...
> Hi
> I've had a MSDE 2000 instance running a couple of months without any
> problems. Now all of a sudden I can only connect to it from localhost.
> When I restart the sql-server using the Service Manager it gives a warning
> in the event log with event-ID 19011. Error code 1355.
> Also I have a bunch of informational events with event-id 3 and something
> about some missing file. I'm not sure if the two event-types have
> something to do with each other, though.
> I believe my problems started after installing a very simple program
> called Dyndns Updater. Looking in the install-log I found that it only
> installs the main exe, some txt-files and a normal run-parameter in the
> registry. To me it seems unlikely that it should interfere with MSDE in
> any way. Uninstalling doesn't help either.
> All other services on my server are working normally from another
> computer.
> I'm kind of stuck here, not wanting to uninstall/reinstall MSDE.
> Any pointers?
> Regards
> Ådne Hovda
> GTR AS
> NORWAY|||Michael C# wrote:
> How about firewalls? Are you running MSDE on Win XP and have you installed
> SP 2 recently? The Windows Firewall will, by default, prevent responses to
> inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If this is your
> problem, try opening up these two ports on your Windows Firewall.
Sorry, I forgot to specify.
We have a pretty simple network of 6 machines, no internal firewalls.
MSDE runs on W2KSP4. I've tried both with and without firewall on the
client-machines that all run XPSP2. It doesn't seem to be a
firewall-related problem. Also, I checked that IP-filtering is turned
off on the server.
Looking deeper into the logs, I found that the program I before
mentioned has definetely nothing to do with it, as I see the same error
(19011) at least two more times, exactly one and two weeks ago, to be
specific.
Ådne|||What is the size of the MDF file, or the LDF ?
If I remember properly, the max size is 2Gb, and if I am still right, the
2Gb apply to the physical file, to the size of the active pages.
Chris
"Ådne Hovda" <aadne@.hovda.no> a écrit dans le message de news:
eFSW7zRFFHA.1564@.TK2MSFTNGP09.phx.gbl...
> Michael C# wrote:
>> How about firewalls? Are you running MSDE on Win XP and have you
>> installed SP 2 recently? The Windows Firewall will, by default, prevent
>> responses to inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If
>> this is your problem, try opening up these two ports on your Windows
>> Firewall.
> Sorry, I forgot to specify.
> We have a pretty simple network of 6 machines, no internal firewalls.
> MSDE runs on W2KSP4. I've tried both with and without firewall on the
> client-machines that all run XPSP2. It doesn't seem to be a
> firewall-related problem. Also, I checked that IP-filtering is turned off
> on the server.
> Looking deeper into the logs, I found that the program I before mentioned
> has definetely nothing to do with it, as I see the same error (19011) at
> least two more times, exactly one and two weeks ago, to be specific.
> Ådne|||Chris V. wrote:
> What is the size of the MDF file, or the LDF ?
> If I remember properly, the max size is 2Gb, and if I am still right, the
> 2Gb apply to the physical file, to the size of the active pages.
The total size of all databases in the instance is 58MB...
This is very strange: All of a sudden it just started working again! I
can now connect from all clients. I haven't changed anything.
Hm. This problem might not be MSDE related after all. Still I'm
wondering what those error messages mean, though.
Anyway, thanks for your help, guys.
Ådne