msde and iis

Hi
If I get data from msde remotely
(from another computer)
should I have iis installed on computer
with sql server.?
Does connection should have
static IP?
Thanks
Konrad
"Konrad" <konrad007@.poczta.onet.pl> wrote in message
news:OdFN8F7TEHA.1048@.tk2msftngp13.phx.gbl...
> If I get data from msde remotely
> (from another computer)
> should I have iis installed on computer
> with sql server.?
If you are accessing the data via a web page, then that would work, or
install IIS on another server.

> Does connection should have
> static IP?
I'm not sure what you are asking here... Typically the host server, running
IIS would need a static address, and be registered in DNS. The connection
from the client side, could be the netbios name or the IP addess of the
host.
Steve

MSDE and Computer Name Change

Hi!
I know that the default instance of MSDE is the computer name. If the
computer's name is subsequently changed, will the default instance’s name
change to the new computer name as well.
Thanks for your thoughts.
Actually the default instance name is not the computer name. All instances
are addressed in connections strings as <computer name>\<instance name>. If
you leave off the instance name then SQL Server assumes you are talking
about the default instance. So yes, if you change the computer name, all
your connection strings will break, probably including some that you aren't
aware of so changing the computer name is a risky thing to do. At a minimum
you will nee to use sp_addserver and restart MSDE to change SQL Server's
local server name.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Gene" <Gene@.discussions.microsoft.com> wrote in message
news:85740AA2-9F4B-4CF8-B304-E27782458703@.microsoft.com...
> Hi!
> I know that the default instance of MSDE is the computer name. If the
> computer's name is subsequently changed, will the default instance's name
> change to the new computer name as well.
> Thanks for your thoughts.
|||Thanks for the input Roger. I don't know much about SQL, but my guess would
have been pretty close to your response. I'm concerned about breaking
something I'm not aware of and not knowing where to go from there.
Regards,
Gene
"Roger Wolter[MSFT]" wrote:

> Actually the default instance name is not the computer name. All instances
> are addressed in connections strings as <computer name>\<instance name>. If
> you leave off the instance name then SQL Server assumes you are talking
> about the default instance. So yes, if you change the computer name, all
> your connection strings will break, probably including some that you aren't
> aware of so changing the computer name is a risky thing to do. At a minimum
> you will nee to use sp_addserver and restart MSDE to change SQL Server's
> local server name.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Gene" <Gene@.discussions.microsoft.com> wrote in message
> news:85740AA2-9F4B-4CF8-B304-E27782458703@.microsoft.com...
>
>
sql

msde 7

I need to change a computer name on a computer running
msde 7, But i need to do this without doing a reinstall or
update of the software. Any ideas?
With SQL Server 7.0 you cannot rename the computer it is running on without
reinstalling SQL Server. Your best course of action is to install MSDE 2000
on a the same box (or new system) create the logins you need for the
database, restore the database to the new instance of SQL Server and synch
the logins with the database users with sp_change_users_login
Jim
"dhaven" <dhaven@.stny.rr.com> wrote in message
news:2b67601c4683e$7aa10310$a401280a@.phx.gbl...
> I need to change a computer name on a computer running
> msde 7, But i need to do this without doing a reinstall or
> update of the software. Any ideas?

MSDE 2000 Set-up: Invalid instance name

Thanks in advance.

I installed SQL 2000 Client Portion in my local computer: No server functionality. I selected my computer name as an instance name. Installation went OK.

Now, I am trying to install MSDE in my computer. Error comes in early part of installation: It says, "The instance name specified is not valid"

Please, any advise and suggestion.

Try deinstalling the SQL Client (why did that ask for an instance name when you didn't install the server - are you sure about deselecting the server?)

Install MSDE after the SQL Client was deinstalled. MSDE 2000 comes with a readme which explains the command line options for the setup. Read it carefully.

--
SvenC

|||

Thanks.

By the way, I have SQL 2005 Server in my computer.

Maybe, this is why.

|||

Yes, presumably MSDE tries to use the same instance name already in use by SQL 2005. Why would you want both versions on one machine?

Well, you can do it, but check the MSDE readme how to configure a different instance name. In the connection string you will use servername\instancename to access the named instance.

--
SvenC

MSDE 2000 Release A won't talk

MSDE 2000 Release A installed under windows 2000 pro will not
communicate with SQL Server Manager nor MS Access on peer computer.
Can someone help?
Have set DISABLENETWORKPROTOCOLS=0 at install time.
Install log shows installation successful..
Control Panel> Admin Tools> Services section shows SQL server instance
running.
Disabling firewall has no effect.
SQL Server Manager (icon at bottom right in task tray - this
starts/stops Server instances), on same computer as SQL Server
instance, shows only instance "H" which is the same as the computer
name. (This instance was uninstalled before new instance was
installed.) Typing new instance name ("H\ABC" and variations) into
top combo box produces error messages such as "wrong format for name",
"Network path not found" "RPC service not running". What is the
correct computer/name format? Key problem is clearly that Service
Manager can't communicate with this local MSDE instance.
All Windows 2000 updates from MS web site have been installed.
Objective is to operate MS Access on computer X (also running Win 2000
Pro) with computer H as a peer that hosts MSDE.
Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system?
Have you installed SP3a?
Steve
<noname@.noname.com> wrote in message
news:40d55341.11850570@.nntp.flfrd.phub.net.cable.r ogers.com...
> MSDE 2000 Release A installed under windows 2000 pro will not
> communicate with SQL Server Manager nor MS Access on peer computer.
> Can someone help?
> Have set DISABLENETWORKPROTOCOLS=0 at install time.
> Install log shows installation successful..
> Control Panel> Admin Tools> Services section shows SQL server instance
> running.
> Disabling firewall has no effect.
> SQL Server Manager (icon at bottom right in task tray - this
> starts/stops Server instances), on same computer as SQL Server
> instance, shows only instance "H" which is the same as the computer
> name. (This instance was uninstalled before new instance was
> installed.) Typing new instance name ("H\ABC" and variations) into
> top combo box produces error messages such as "wrong format for name",
> "Network path not found" "RPC service not running". What is the
> correct computer/name format? Key problem is clearly that Service
> Manager can't communicate with this local MSDE instance.
> All Windows 2000 updates from MS web site have been installed.
> Objective is to operate MS Access on computer X (also running Win 2000
> Pro) with computer H as a peer that hosts MSDE.
> Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system?
|||Hi Steve,
MSDE 2000A already contains SQL Server SP3a updates.
Mark
Ottawa, Canada
On Tue, 22 Jun 2004 15:25:07 -0400, "Steve Thompson"
<stevethompson@.nomail.please> wrote:

>Have you installed SP3a?
>Steve

MSDE 2000 Release A won't talk

MSDE 2000 Release A installed under Windows 2000 pro will not
communicate with SQL Server Manager nor MS Access on peer computer.
Can someone help?
Have set DISABLENETWORKPROTOCOLS=0 at install time.
Install log shows installation successful..
Control Panel> Admin Tools> Services section shows SQL server instance
running.
Disabling firewall has no effect.
SQL Server Manager (icon at bottom right in task tray - this
starts/stops Server instances), on same computer as SQL Server
instance, shows only instance "H" which is the same as the computer
name. (This instance was uninstalled before new instance was
installed.) Typing new instance name ("H\ABC" and variations) into
top combo box produces error messages such as "wrong format for name",
"Network path not found" "RPC service not running". What is the
correct computer/name format' Key problem is clearly that Service
Manager can't communicate with this local MSDE instance.
All Windows 2000 updates from MS web site have been installed.
Objective is to operate MS Access on computer X (also running Win 2000
Pro) with computer H as a peer that hosts MSDE.
Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system'Have you installed SP3a?
Steve
<noname@.noname.com> wrote in message
news:40d55341.11850570@.nntp.flfrd.phub.net.cable.rogers.com...
> MSDE 2000 Release A installed under Windows 2000 pro will not
> communicate with SQL Server Manager nor MS Access on peer computer.
> Can someone help?
> Have set DISABLENETWORKPROTOCOLS=0 at install time.
> Install log shows installation successful..
> Control Panel> Admin Tools> Services section shows SQL server instance
> running.
> Disabling firewall has no effect.
> SQL Server Manager (icon at bottom right in task tray - this
> starts/stops Server instances), on same computer as SQL Server
> instance, shows only instance "H" which is the same as the computer
> name. (This instance was uninstalled before new instance was
> installed.) Typing new instance name ("H\ABC" and variations) into
> top combo box produces error messages such as "wrong format for name",
> "Network path not found" "RPC service not running". What is the
> correct computer/name format' Key problem is clearly that Service
> Manager can't communicate with this local MSDE instance.
> All Windows 2000 updates from MS web site have been installed.
> Objective is to operate MS Access on computer X (also running Win 2000
> Pro) with computer H as a peer that hosts MSDE.
> Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system'|||Hi Steve,
MSDE 2000A already contains SQL Server SP3a updates.
Mark
Ottawa, Canada
On Tue, 22 Jun 2004 15:25:07 -0400, "Steve Thompson"
<stevethompson@.nomail.please> wrote:

>Have you installed SP3a?
>Steve

MSDE 2000 Release A wont talk

MSDE 2000 Release A installed under windows 2000 pro will not
communicate with SQL Server Manager nor MS Access on peer computer.
Can someone help?

Have set DISABLENETWORKPROTOCOLS=0 at install time.

Install log shows installation successful..

Control Panel> Admin Tools> Services section shows SQL server instance
running.

Disabling firewall has no effect.

SQL Server Manager (icon at bottom right in task tray - this
starts/stops Server instances), on same computer as SQL Server
instance, shows only instance "H" which is the same as the computer
name. (This instance was uninstalled before new instance was
installed.) Typing new instance name ("H\ABC" and variations) into
top combo box produces error messages such as "wrong format for name",
"Network path not found" "RPC service not running". What is the
correct computer/name format?? Key problem is clearly that Service
Manager can't communicate with this local MSDE instance.

All Windows 2000 updates from MS web site have been installed.

Objective is to operate MS Access on computer X (also running Win 2000
Pro) with computer H as a peer that hosts MSDE.

Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??
--
Mark Ferguson<noname@.noname.com> wrote in message
news:40d53097.2976249@.nntp.flfrd.phub.net.cable.ro gers.com...
> MSDE 2000 Release A installed under windows 2000 pro will not
> communicate with SQL Server Manager nor MS Access on peer computer.
> Can someone help?
> Have set DISABLENETWORKPROTOCOLS=0 at install time.
> Install log shows installation successful..
> Control Panel> Admin Tools> Services section shows SQL server instance
> running.
> Disabling firewall has no effect.
> SQL Server Manager (icon at bottom right in task tray - this
> starts/stops Server instances), on same computer as SQL Server
> instance, shows only instance "H" which is the same as the computer
> name. (This instance was uninstalled before new instance was
> installed.) Typing new instance name ("H\ABC" and variations) into
> top combo box produces error messages such as "wrong format for name",
> "Network path not found" "RPC service not running". What is the
> correct computer/name format?? Key problem is clearly that Service
> Manager can't communicate with this local MSDE instance.
> All Windows 2000 updates from MS web site have been installed.
> Objective is to operate MS Access on computer X (also running Win 2000
> Pro) with computer H as a peer that hosts MSDE.
> Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??
> --
> Mark Ferguson

I must admit that I don't know the difference between MSDE Release A and
MSDE SP3a. There is no clear information on the MS site (or at least I
couldn't find it), but the download sizes are different, so the obvious
conclusion is that they are different versions. If this assumption is
correct, then you might be seeing this issue:

http://support.microsoft.com/defaul...010&Product=sql

However, I could be wrong, so perhaps you can check some more things. Can
you actually connect to the instance on H using a local osql.exe command
also on H? If you're logged on to Windows as an administrator, then this
should be enough:

osql -S H\ABC -E

If that works, then presumably the problem is the Service Manager itself
(possibly as described in the article above). If you can connect, you can
then check the version with this query:

1> select @.@.version
2> go

If you don't see version 8.00.760, then you don't have SP3a, so I would
completely remove MSDE and then install MSDE SP3a. See "Remove all known
instances of SQL Server" in this article:

http://support.microsoft.com/defaul...991&Product=sql

If you cannot connect with osql.exe, then what error message do you get? In
the final analysis, however, I would suggest that Server Manager is a small,
unimportant component which probably is not worth worrying about. As long as
MSDE is running and you can connect from client applications with no
problems, then I would not spend too much time trying to make it work.

Regarding connecting from a different PC (with Access or any other tool),
there are a number of possible connection issues:

http://support.microsoft.com/defaul...306&Product=sql

I guess when you say "peer" you mean that the PCs are in a workgroup, not a
domain. If this is the case, then trusted connections can be awkward - the
article above has a link to another KB article which describes a possible
workaround. Mixed security using SQL logins should work fine, but is not
generally recommended unless there is no other alternative.

Simon|||Hi

You may get more help in the microsoft.public.sqlserver.msde newsgroup.

John
<noname@.noname.com> wrote in message
news:40d53097.2976249@.nntp.flfrd.phub.net.cable.ro gers.com...
> MSDE 2000 Release A installed under windows 2000 pro will not
> communicate with SQL Server Manager nor MS Access on peer computer.
> Can someone help?
> Have set DISABLENETWORKPROTOCOLS=0 at install time.
> Install log shows installation successful..
> Control Panel> Admin Tools> Services section shows SQL server instance
> running.
> Disabling firewall has no effect.
> SQL Server Manager (icon at bottom right in task tray - this
> starts/stops Server instances), on same computer as SQL Server
> instance, shows only instance "H" which is the same as the computer
> name. (This instance was uninstalled before new instance was
> installed.) Typing new instance name ("H\ABC" and variations) into
> top combo box produces error messages such as "wrong format for name",
> "Network path not found" "RPC service not running". What is the
> correct computer/name format?? Key problem is clearly that Service
> Manager can't communicate with this local MSDE instance.
> All Windows 2000 updates from MS web site have been installed.
> Objective is to operate MS Access on computer X (also running Win 2000
> Pro) with computer H as a peer that hosts MSDE.
> Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??
> --
> Mark Ferguson|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:40d5ade5$1_2@.news.bluewin.ch...
|
| <noname@.noname.com> wrote in message
| news:40d53097.2976249@.nntp.flfrd.phub.net.cable.ro gers.com...
| > MSDE 2000 Release A installed under windows 2000 pro will not
| > communicate with SQL Server Manager nor MS Access on peer computer.
| > Can someone help?
| >
| > Have set DISABLENETWORKPROTOCOLS=0 at install time.
| >
| > Install log shows installation successful..
| >
| > Control Panel> Admin Tools> Services section shows SQL server instance
| > running.
| >
| > Disabling firewall has no effect.
| >
| > SQL Server Manager (icon at bottom right in task tray - this
| > starts/stops Server instances), on same computer as SQL Server
| > instance, shows only instance "H" which is the same as the computer
| > name. (This instance was uninstalled before new instance was
| > installed.) Typing new instance name ("H\ABC" and variations) into
| > top combo box produces error messages such as "wrong format for name",
| > "Network path not found" "RPC service not running". What is the
| > correct computer/name format?? Key problem is clearly that Service
| > Manager can't communicate with this local MSDE instance.
| >
| > All Windows 2000 updates from MS web site have been installed.
| >
| > Objective is to operate MS Access on computer X (also running Win 2000
| > Pro) with computer H as a peer that hosts MSDE.
| >
| > Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??
| > --
| > Mark Ferguson
|
| I must admit that I don't know the difference between MSDE Release A and
| MSDE SP3a. There is no clear information on the MS site (or at least I
| couldn't find it), but the download sizes are different, so the obvious
| conclusion is that they are different versions. If this assumption is
| correct, then you might be seeing this issue:
|
| http://support.microsoft.com/defaul...010&Product=sql
|
| However, I could be wrong, so perhaps you can check some more things. Can
| you actually connect to the instance on H using a local osql.exe command
| also on H? If you're logged on to Windows as an administrator, then this
| should be enough:
|
| osql -S H\ABC -E
|
| If that works, then presumably the problem is the Service Manager itself
| (possibly as described in the article above). If you can connect, you can
| then check the version with this query:
|
| 1> select @.@.version
| 2> go
|
| If you don't see version 8.00.760, then you don't have SP3a, so I would
| completely remove MSDE and then install MSDE SP3a. See "Remove all known
| instances of SQL Server" in this article:
|
| http://support.microsoft.com/defaul...991&Product=sql
|
| If you cannot connect with osql.exe, then what error message do you get? In
| the final analysis, however, I would suggest that Server Manager is a small,
| unimportant component which probably is not worth worrying about. As long as
| MSDE is running and you can connect from client applications with no
| problems, then I would not spend too much time trying to make it work.
|
| Regarding connecting from a different PC (with Access or any other tool),
| there are a number of possible connection issues:
|
| http://support.microsoft.com/defaul...306&Product=sql
|
| I guess when you say "peer" you mean that the PCs are in a workgroup, not a
| domain. If this is the case, then trusted connections can be awkward - the
| article above has a link to another KB article which describes a possible
| workaround. Mixed security using SQL logins should work fine, but is not
| generally recommended unless there is no other alternative.
|
| Simon
|
|

MSDE 2000 Release A is a developer version (SDK) of Microsoft SQL Server 2000
Desktop Engine SP3a. SELECT @.@.VERSION returns the same version info for both.

This brief description of Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A is quoted from the download page -
<
MSDE 2000 Release A is functionally equivalent to SQL Server 2000 Desktop
Engine SP3a except for the following:

New licensing agreement

Removal of the merge modules that can be used to embed MSDE 2000 Release A
with applications

New ReadMeMSDE2000A.htm that contains information specific to this release.

This new version of MSDE contains all the fixes that are included with SQL
Server 2000 SP3a version of MSDE.

http://www.microsoft.com/downloads/...&DisplayLang=en
Additional information can be found in the Microsoft SQL Server 2000 Desktop
Engine
(MSDE 2000) Release A ReadMe

http://download.microsoft.com/downl...meMSDE2000A.htm

Additions to the SQL Server 2000 Desktop Engine (MSDE) Release A
ReadmeMSDE2000A.htm File
http://support.microsoft.com/?kbid=829925

Dan|||<noname@.noname.com> wrote in message
news:40d53097.2976249@.nntp.flfrd.phub.net.cable.ro gers.com...
| MSDE 2000 Release A installed under windows 2000 pro will not
| communicate with SQL Server Manager nor MS Access on peer computer.
| Can someone help?
|
| Have set DISABLENETWORKPROTOCOLS=0 at install time.
|
| Install log shows installation successful..
|
| Control Panel> Admin Tools> Services section shows SQL server instance
| running.
|
| Disabling firewall has no effect.
|
| SQL Server Manager (icon at bottom right in task tray - this
| starts/stops Server instances), on same computer as SQL Server
| instance, shows only instance "H" which is the same as the computer
| name. (This instance was uninstalled before new instance was
| installed.) Typing new instance name ("H\ABC" and variations) into
| top combo box produces error messages such as "wrong format for name",
| "Network path not found" "RPC service not running". What is the
| correct computer/name format?? Key problem is clearly that Service
| Manager can't communicate with this local MSDE instance.
|
| All Windows 2000 updates from MS web site have been installed.
|
| Objective is to operate MS Access on computer X (also running Win 2000
| Pro) with computer H as a peer that hosts MSDE.
|
| Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??
| --
| Mark Ferguson

Hi Mark,

There is known bug when reinstalling with same instance name.
Follow the instructions for editing the registry keys given in
the article at:
http://support.microsoft.com/defaul...kb;en-us;823467

If that fails then you will have to uninstall MSDE 2000 Release A
and follow the instructions for editing the registry keys given in
the article at:
http://support.microsoft.com/defaul...kb;en-us;320873
Then reinstall MSDE 2000 Release A

Hope this helps.

Dan|||Thanks John, but I dont see a newsgroup named
microsoft.public.sqlserver.msde. I just checked for new groups and
that one doesn't show up there either. Not sure where i might find
this group.

On Sun, 20 Jun 2004 16:07:34 GMT, "John Bell"
<jbellnewsposts@.hotmail.com> wrote:

>Hi
>You may get more help in the microsoft.public.sqlserver.msde newsgroup.
>John
><noname@.noname.com> wrote in message
>news:40d53097.2976249@.nntp.flfrd.phub.net.cable.ro gers.com...
>> MSDE 2000 Release A installed under windows 2000 pro will not
>> communicate with SQL Server Manager nor MS Access on peer computer.
>> Can someone help?
>>
>> Have set DISABLENETWORKPROTOCOLS=0 at install time.
>>
>> Install log shows installation successful..
>>
>> Control Panel> Admin Tools> Services section shows SQL server instance
>> running.
>>
>> Disabling firewall has no effect.
>>
>> SQL Server Manager (icon at bottom right in task tray - this
>> starts/stops Server instances), on same computer as SQL Server
>> instance, shows only instance "H" which is the same as the computer
>> name. (This instance was uninstalled before new instance was
>> installed.) Typing new instance name ("H\ABC" and variations) into
>> top combo box produces error messages such as "wrong format for name",
>> "Network path not found" "RPC service not running". What is the
>> correct computer/name format?? Key problem is clearly that Service
>> Manager can't communicate with this local MSDE instance.
>>
>> All Windows 2000 updates from MS web site have been installed.
>>
>> Objective is to operate MS Access on computer X (also running Win 2000
>> Pro) with computer H as a peer that hosts MSDE.
>>
>> Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??
>> --
>> Mark Ferguson|||Hi

Try the news.microsoft.com news server or
http://groups.google.com/groups?hl=...sqlserver.msde

John

<Mark_Ferguson@.noname.com> wrote in message
news:40d736bf.12602391@.nntp.flfrd.phub.net.cable.r ogers.com...
> Thanks John, but I dont see a newsgroup named
> microsoft.public.sqlserver.msde. I just checked for new groups and
> that one doesn't show up there either. Not sure where i might find
> this group.
> On Sun, 20 Jun 2004 16:07:34 GMT, "John Bell"
> <jbellnewsposts@.hotmail.com> wrote:
> >Hi
> >You may get more help in the microsoft.public.sqlserver.msde newsgroup.
> >John
> ><noname@.noname.com> wrote in message
> >news:40d53097.2976249@.nntp.flfrd.phub.net.cable.ro gers.com...
> >> MSDE 2000 Release A installed under windows 2000 pro will not
> >> communicate with SQL Server Manager nor MS Access on peer computer.
> >> Can someone help?
> >>
> >> Have set DISABLENETWORKPROTOCOLS=0 at install time.
> >>
> >> Install log shows installation successful..
> >>
> >> Control Panel> Admin Tools> Services section shows SQL server instance
> >> running.
> >>
> >> Disabling firewall has no effect.
> >>
> >> SQL Server Manager (icon at bottom right in task tray - this
> >> starts/stops Server instances), on same computer as SQL Server
> >> instance, shows only instance "H" which is the same as the computer
> >> name. (This instance was uninstalled before new instance was
> >> installed.) Typing new instance name ("H\ABC" and variations) into
> >> top combo box produces error messages such as "wrong format for name",
> >> "Network path not found" "RPC service not running". What is the
> >> correct computer/name format?? Key problem is clearly that Service
> >> Manager can't communicate with this local MSDE instance.
> >>
> >> All Windows 2000 updates from MS web site have been installed.
> >>
> >> Objective is to operate MS Access on computer X (also running Win 2000
> >> Pro) with computer H as a peer that hosts MSDE.
> >>
> >> Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??
> >> --
> >> Mark Ferguson|||>I must admit that I don't know the difference between MSDE Release A and
>MSDE SP3a. There is no clear information on the MS site (or at least I
>couldn't find it), but the download sizes are different, so the obvious
>conclusion is that they are different versions. If this assumption is
>correct, then you might be seeing this issue:
>http://support.microsoft.com/defaul...010&Product=sql
This article applies to MSDE Service pack . I have installed MSDE
2000A which includes Service Pack 3. The symptoms don't and conditions
don't apply, nor do the workaround instructions make sense.
>However, I could be wrong, so perhaps you can check some more things. Can
>you actually connect to the instance on H using a local osql.exe command
>also on H? If you're logged on to Windows as an administrator, then this
>should be enough:
>osql -S H\ABC -E
This works. But the SQL Server *is* running - we knew that.

>If that works, then presumably the problem is the Service Manager itself
>(possibly as described in the article above). If you can connect, you can
>then check the version with this query:
>1> select @.@.version
>2> go
Result is:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copy
right (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT
5.0 (Build 2195: Service Pack 4)

>If you don't see version 8.00.760, then you don't have SP3a, so I would
>completely remove MSDE and then install MSDE SP3a. See "Remove all known
>instances of SQL Server" in this article:
>http://support.microsoft.com/defaul...991&Product=sql

Thank you... This may be very useful indeed.
>If you cannot connect with osql.exe, then what error message do you get? In
>the final analysis, however, I would suggest that Server Manager is a small,
>unimportant component which probably is not worth worrying about. As long as
>MSDE is running and you can connect from client applications with no
>problems, then I would not spend too much time trying to make it work.
>Regarding connecting from a different PC (with Access or any other tool),
>there are a number of possible connection issues:
>http://support.microsoft.com/defaul...306&Product=sql
>I guess when you say "peer" you mean that the PCs are in a workgroup, not a
>domain. If this is the case, then trusted connections can be awkward - the
>article above has a link to another KB article which describes a possible
>workaround. Mixed security using SQL logins should work fine, but is not
>generally recommended unless there is no other alternative.

You are correct, the two computers are not in a domain and so there is
no user authentication provided by a domain server. Thanks for the
link I will look it up.

The Server Manager is only important in that its a good first
indication that everything is working at the local computer - an
encouraging first sign, insofar as the client computer cannot connect
to the server.
>Simon
>
I am also working on the problem of fixing ports used by the SQL
Server. The instance now installed is named and so uses dynamic ports
rather than the fixed 1433 and 1434 ports. The question is: what does
the SQL Server Manager use?|||I think you are correct. I need to uninstall MSDE2000A and then fix up
the registry or re-install windows 2000. I have already uninstalled
the old default version that came with MS office. I have also
installed the MSDE2000A version several times.

I have never checked the MDAC version (don't know how), but that may
also be a problem.

I need to try these and then request more help.

Many thanks.
Mark.

On Mon, 21 Jun 2004 05:22:56 -0400, "Daniel A. Thomas"
<dathomas@.--spam--istar.ca> wrote:

>Hi Mark,
>There is known bug when reinstalling with same instance name.
>Follow the instructions for editing the registry keys given in
>the article at:
>http://support.microsoft.com/defaul...kb;en-us;823467
>If that fails then you will have to uninstall MSDE 2000 Release A
>and follow the instructions for editing the registry keys given in
>the article at:
>http://support.microsoft.com/defaul...kb;en-us;320873
>Then reinstall MSDE 2000 Release A
>Hope this helps.
>Dan|||OK, John. The google web page is the same as the MS Discussion forum
for SQL Server. I posted a similar article there, but no help came
there.

Mark.

On Mon, 21 Jun 2004 19:56:20 GMT, "John Bell"
<jbellnewsposts@.hotmail.com> wrote:

>Hi
>Try the news.microsoft.com news server or
>http://groups.google.com/groups?hl=...sqlserver.msde
>John|||I'm grateful for the help from you all, but the one real symptom of
the problem with the Service Manager is its error message:
"The format of the computer name is inavlid."

This is the response to asking it to find the instance ABC on the
computer named "H" - (H\ABC). Recall that running osql.exe against the
name H\ABC works fine.

Mark.

MSDE 2000 Release A

I am having problems installing the MSDE 2000 Release A on my Computer. I am
not able to find the Microsoft SQL Server Program when I go to Start-Program.
Can you please tell me a Simple Installation Process for MSDE 2000 Release A.
Thanks.
Hi,
MSDE does not install any shotcuts as it is just the engine and has no tools
that ship with it.
"TAP" <TAP@.discussions.microsoft.com> wrote in message
news:C29639C0-3911-4867-A88B-6EE988445A02@.microsoft.com...
>I am having problems installing the MSDE 2000 Release A on my Computer. I
>am
> not able to find the Microsoft SQL Server Program when I go to
> Start-Program.
> Can you please tell me a Simple Installation Process for MSDE 2000 Release
> A.
> Thanks.

MSDE 2000 mulituser on a single computer

The installation works fine, when I restarted the machine and login as an
administrator it works fine...
But when I logon as a normal user (whitout administravie rights) its no fun
anymore.
The "SQL Server Service Manager" is blank (no server or services), but I can
fill the fields with values and the service is started but they disappear
when i restart the machine, and the MSSQLSERVER service IS started!?!
But when I enable NetworkProtocols (with "Svrnetcn.exe") it works fine for
all...
Is there any other way to solve the problem?
Where can I find Microsofts documentation about this?
/Erik Fahlstrm
hi Erik,
"Erik Fahlstrm" <erik(dot)fahlstrom(at-sign)intentia(dot)se> ha scritto nel
messaggio news:%23mA1CJ3MEHA.684@.TK2MSFTNGP09.phx.gbl...
> The installation works fine, when I restarted the machine and login as an
> administrator it works fine...
> But when I logon as a normal user (whitout administravie rights) its no
fun
> anymore.
> The "SQL Server Service Manager" is blank (no server or services), but I
can
> fill the fields with values and the service is started but they disappear
> when i restart the machine, and the MSSQLSERVER service IS started!?!
> But when I enable NetworkProtocols (with "Svrnetcn.exe") it works fine for
> all...
> Is there any other way to solve the problem?
> Where can I find Microsofts documentation about this?
> /Erik Fahlstrm
this is a known issue as
http://support.microsoft.com/default...b;EN-US;814132 reports..
hth
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

MSDE 2000 and SQL 2005 Express on the same machine

Hi I would like to ask If its possible to have installed MSDE 2000 and SQL 2005 Express on the same machine. My computer uses MSDE 2000 for one application and I would like to install SQL 2005 Express for my own application. I would like to ask it will be a problem before I install it.
thanks a lot
Martin Molnar

No, there should be no interoperability problems. You should be able to install them side-by-side.

Jens K. Suessmeyer

http://www.sqlserver2005.de

MSDE 2000 Administration tool

Hi all,

I have installed MSDE on my computer but it's missing, as all you already
know, a serious (well, osql IS TOO serious but not very newbie friendly)
admin tool.

I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
it but was wondering if there's something better or that may complete what
DbaMgr2k is missing... and preferably is as free as DbaMgr2k.

Thank You,
LorenzoHi

There is a list at:
http://www.aspfaq.com/show.asp?id=2442

John

"Lorenzo Bolognini" <lorenzo@.mysurname.net> wrote in message
news:pkd_a.43324$an6.1479482@.news1.tin.it...
> Hi all,
> I have installed MSDE on my computer but it's missing, as all you already
> know, a serious (well, osql IS TOO serious but not very newbie friendly)
> admin tool.
> I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
> it but was wondering if there's something better or that may complete what
> DbaMgr2k is missing... and preferably is as free as DbaMgr2k.
> Thank You,
> Lorenzo|||Thank you very much John.

Lorenzo

MSDE 1.0 and SQL Server

Apparently since I downloaded SQL Server SP3 and tried to install it on a computer without SQL Server in the first place, it's a bad thing.

I'm trying to get SQL Server Desktop Engine to install and I do the cmd.exe thing and it works, then 1 second before it finishes it rolls back.

All the files are still there, just missing the ones you need to run the SQL Server.

I used to have it on my 98, before I upgraded. Now I have the ASP.NET WebMatrix on my XP Home.

Is there a way to get SQL to install correctly?

JohnAre you sure you want to install MSDE 1.0?? That is a SQL Server 7-compatible data engine.

There seems to be a good walkthrough on installing MSDE 2000 in the ASP.NET Web Matrix Guided Tour:Install MSDE 2000.

Terri|||I tried that, perfectly and by all the things it said, and it still backed out at the last few seconds.

I have no idea. I've only herd that XP Home dosn't support IIS but this thing had XP (General) as in Home and Pro for the supported OS's. I really don't now whats wrong.

John

MSDE + Static IP Address ?

Hello, could someone please tell me if the following scenario would work with MSDE:
1) A central computer with a static IP address exposed to the internet would be used to store a small database.
2) A couple of computers located around the country would access this database through the internet. THe client they would use would be in EXE form, ( a custom built application) , which would use the Static IP as the database server name. Basically eac
h locatoin would have their own software install, and instead of comunicating on their local LAN to the db-server, they would use the static IP to connect to the remote database.
Would the above work? or is there a special requirement for the above that i've missed?
Thanks.
Hi,
You can connect MSDE to the internet and the remote apps should be able to
talk to the MSDE.
just make sure that you enable the required Protocols for the SQL Server
and make sure that the port is available.
Configure Firewall etc.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi, Thanks for the info,
So basically i just configure the internet protocols, and use the IP as my database server "Setting" in my client-exe along with the database name... wow that would be cool.

>Hi,

>You can connect MSDE to the internet and the remote apps should be able to
>talk to the MSDE.

>just make sure that you enable the required Protocols for the SQL Server
>and make sure that the port is available.

>Configure Firewall etc.
|||Hi,
In addition, we sometimes find increasing the connection timeout in the
connectionstring of your application might be necessary in this scenario.
Otherwise, works ok.
I'd strongly suggest moving the MSDE to a high non-standard port (ie 47857)
instead of 1433 and employing some form of port-sniffing detection on the
system it's running on, if it's directly connected.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SQL-Warrior" <anonymous@.discussions.microsoft.com> wrote in message
news:9FBD8FAA-1080-482A-B55A-4411792F3AFF@.microsoft.com...
> Hi, Thanks for the info,
> So basically i just configure the internet protocols, and use the IP as my
database server "Setting" in my client-exe along with the database name...
wow that would be cool.[vbcol=seagreen]
>
to
>
>
|||Ok, thanks for the info,
i can't wait to try it out.
|||I forgot to ask, is there any special setup required on the server? Or is it one of those install MSDE and make sure the machine has a static IP and is connected to the internet installs?
|||You need to make sure the network protocols are enabled. You can do this
after installation (and applying any patches, etc.) by running svrnetcn.exe
(ie the server network utility). Use it to both enable tcp and to set it to
a different port.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SQL-Warrior" <anonymous@.discussions.microsoft.com> wrote in message
news:D74B7469-B7EF-4EBC-9955-082183E9B464@.microsoft.com...
> I forgot to ask, is there any special setup required on the server? Or is
it one of those install MSDE and make sure the machine has a static IP and
is connected to the internet installs?
|||Ahhh, ok thanks !
this is soo cool.
sql

MSDE & Business Contact Manager

I have a computer (XP PRO) that I attempted to install MSDE on for a database
application we use, not realizing that the Outlook Business Contact Manager
has some sort of SQL server already installed. The installation failed. In
looking through the services I noticed the MicrosoftBCM instance and realized
that must be my problem.
I attempted to connect to this instance via odbc and not knowing the
connection method was unable to connect (server does not exist or access
denied...) but the computer name and (local) were listed in the SQL servers
list.
So I installed a new instance of MSDE SP3. The installation went fine. The
new instance appeared in the services. I started the new service and
everything looked OK, but in trying to connect via ODBC, now SQL servers list
was empty and typing in the computer name did not help.
I restarted the computer and had the same symptoms. I started the SQL server
agent and none of the services were listed here either.
I looked in the reg key HKLM\SOFTWARE\MICROSOFT\Microsoft SQL
Server\InstalledInstances, and both were listed there.
The services were started and there were not any errors in the event log.
I uninstalled and re-installed MSDE, but that did not help either. So I
uninstalled the Business contact manager, since we were not yet using it and
the MSDE, then reinstalled MSDE and that is now working just fine with the
database application.
Does anyone have any idea what my problem may have been, if I am just unable
to have the Business contact manager and MSDE on the same comptuer or if
there is a fix or workaround for the problem I am experiencing?
Thanks so much,
ST
hi,
ST wrote:
> I have a computer (XP PRO) that I attempted to install MSDE on for a
> database application we use, not realizing that the Outlook Business
> Contact Manager has some sort of SQL server already installed. The
> installation failed. In looking through the services I noticed the
> MicrosoftBCM instance and realized that must be my problem.
> I attempted to connect to this instance via odbc and not knowing the
> connection method was unable to connect (server does not exist or
> access denied...) but the computer name and (local) were listed in
> the SQL servers list.
> So I installed a new instance of MSDE SP3. The installation went
> fine. The new instance appeared in the services. I started the new
> service and everything looked OK, but in trying to connect via ODBC,
> now SQL servers list was empty and typing in the computer name did
> not help.
> I restarted the computer and had the same symptoms. I started the SQL
> server agent and none of the services were listed here either.
> I looked in the reg key HKLM\SOFTWARE\MICROSOFT\Microsoft SQL
> Server\InstalledInstances, and both were listed there.
> The services were started and there were not any errors in the event
> log.
> I uninstalled and re-installed MSDE, but that did not help either. So
> I uninstalled the Business contact manager, since we were not yet
> using it and the MSDE, then reinstalled MSDE and that is now working
> just fine with the database application.
> Does anyone have any idea what my problem may have been, if I am just
> unable to have the Business contact manager and MSDE on the same
> comptuer or if there is a fix or workaround for the problem I am
> experiencing?
> Thanks so much,
> ST
I do not know about Outlook Business Contact Manager, but as regard the
empty SQL Server list in the SQL Server Service Manager, it probably depends
on network protocols setting for the installed MSDE instance, as reported in
http://support.microsoft.com/default...b;EN-US;814132
to modify this behaviour, run the Server Network Utility (svrnetcn.exe) and
enable the desired networkprotocol, if this is a viable solution..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msde - uses too much memory and is getting very slow!

Juergen,
What else is this computer used for?
If only MSDE, then the system page file can be reduced to a minimum (or even
eliminated) -thereby reducing the memory 'pressure' on SQL Server (MSDE).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eOxWF3zAHHA.996@.TK2MSFTNGP02.phx.gbl...
> hi newsgroup!
> we have already some msde databases installed and we didn't had any
> troubles until now!
> the OS is a Windows XP prof. SP2 with MSDE Version; msde desktop engine
> 8.00.7630SP3
> now our trouble is that the sqlserver.exe process is using more and more
> ram and the pagefile grows and grows!
> The PC (server) HP DL385 has 2 GB RAM so this shuldn't be the problem! So
> when the sqlserver.exe process is running about 2-3 days the amout of
> memory usages grows to 1,3GB and about this size the PC is realy getting
> slow, so you can't work anymore!
> The problem is solved when i start and stop the sqlserver, but this isn't
> how i will solve the problem!
> So does anyone have the some troubles, and does anybody now how to solve
> this problem?
> kind regards
> Juergen Strutzenberger
>
What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>

msde

Can MSDE be used on computer in different cities? Say the server in Dallas
and the client computer in Houston. Or is the full SQL Server required?In article <a1vWc.504738$Gx4.25752@.bgtnsc04-news.ops.worldnet.att.net>,
kpsklab@.worldnet.att.net says...
> Can MSDE be used on computer in different cities? Say the server in Dallas
> and the client computer in Houston. Or is the full SQL Server required?

MSDE is the desktop database, where it runs in not a question, it can
run were you install it based on the license restrictions. The real
question should be "How do I securely access a MSDE database running in
another city?"

As long as you properly follow the license restrictions you can install
MSDE anywhere.

As for connecting, use a VPN tunnel - do not directly expose the MSDE
(or any other service) to the internet unless you know security inside
and out. A VPN from one location to the other is painless to setup and
means that all of your data/connection is secure and not directly
exposed to the internet.

--
--
spamfree999@.rrohio.com
(Remove 999 to reply to me)