MSDE 2000 shipped to the Republic of Czech

Are there any export restrictions, etc. for MSDE 2000 in
the Republic of Czech? In the EULA for MSDE 200 it states
that in most cases local laws applies. I went to the
Exporting page for Microsoft, but could not find anything
definitive. Thanks in advance for your assistance.
CCS
Our Czech firm wide uses MSDE 2000 in the Czech Republic and Poland.
I do not know about any local restriction for MSDE 2000 in the Czech
Republic. We
use it according to the Microsoft EULA.
IH
"CCSGrayTech" <anonymous@.discussions.microsoft.com> pse v diskusnm
prspevku news:2ce201c47e2a$7a9b2290$a401280a@.phx.gbl...
> Are there any export restrictions, etc. for MSDE 2000 in
> the Republic of Czech? In the EULA for MSDE 200 it states
> that in most cases local laws applies. I went to the
> Exporting page for Microsoft, but could not find anything
> definitive. Thanks in advance for your assistance.
> CCS

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 install on SQL 2000

Hello,
I have installed MSDE 2000 on Win Server 2003 with instance name brprof,
there SQL Server 2000 already installed as a local instance named SBGBHO.
Now, I registered my new MSDE 2000 on enterprise manager, registration done
successfully, but it display following error
LOGIN FAILED FOR USER SA : REASON NOT ASSOCIATED WITH TRUSTED SQL SERVER
CONNECTION
HARSHA.
hi Harsha,
Harsha Shah wrote:
> Hello,
> I have installed MSDE 2000 on Win Server 2003 with instance name
> brprof, there SQL Server 2000 already installed as a local instance
> named SBGBHO. Now, I registered my new MSDE 2000 on enterprise
> manager, registration done successfully, but it display following
> error
> LOGIN FAILED FOR USER SA : REASON NOT ASSOCIATED WITH TRUSTED SQL
> SERVER CONNECTION
MSDE installs by default only allowing trusted WinNT connections... you can
change this behavior, allowing standard SQL Server connection at install
time providing the
SECURITYMODE=SQL
parameter to the setup.exe boostrap installer, or later accessing the
windows registry, as described in
http://support.microsoft.com/default...b;en-us;285097
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.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

Greetings:

I am trying to install MSDE on a local machine on port 1433.
I can't get it to install using that port it only installs using shared memory according to the logs. can someone tell me how to install it using tcp port 1433 or how to change it in the registry.
so far here are a few of the settings i am passing to the setup program.

setup INSTANCENAME=something SAPWD=something_else SECURITYMODE=SQL

i have read some of the manual but i could not find how to make this change.

thanks
BrianRfer thru MSDE readme.html file to install.

MSDE + Restricted Accounts

I appologize if this is in the wrong place. I have MSDE 2000 installed on a
machine to be used only by the local user. It is using mixed-mode authentic
ation. The machine is running windows 2000. When I login as a Restricted Use
r that user can't start the
MQSQL Server service. An Error 5 (Access Denied) is reported. I read in the
KB before that MSDE and even accesss 2000 can not run on restricted user acc
ounts by design. I would just like a link to that KB article. I have searche
d all day for it and I can
't seem to find the right combination of keywords. Thanks so much. Most of t
he KB articles seem to be only for XP, .NET and Office 2003.The problem is that only local admins have permission to stop and start
services.
You should be able to configure the MSSQL service to start automatically,
using a limited user account.
But, as a limited user logging onto a machine, you won't have the ability
to stop and start services.
Here's a referenced to the startup account permissions.
http://www.microsoft.com/technet/pr...n/sp3sec02.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

MSDE - how do I connect?

Hello -
I downloaded everything and installed MSDE (I'm running Windows 2000
Professional). I can see the instance I installed on my local C drive.
When I click on the icon for Sql Server Service Manager, and click down on
the arrow, there is nothing in there; there also is nothing under Services.
What have I done wrong?
Sandy
hi Sandy,
Sandy wrote:
> Hello -
> I downloaded everything and installed MSDE (I'm running Windows 2000
> Professional). I can see the instance I installed on my local C
> drive.
> When I click on the icon for Sql Server Service Manager, and click
> down on the arrow, there is nothing in there; there also is nothing
> under Services.
> What have I done wrong?
http://support.microsoft.com/default...b;EN-US;814132
you can, if you like and get your sysadmin approval, enable network
protocols as well...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE

Dear all,
I am trying to connect to MSDE on a remote machine, on my local network
using enterprise manager using SQL authentication, the passwords are
correct as I can log in locally, however on trying to register the
remote SQL MSDE i get the following error message 'SQL Server does not
exist or access denied ConnectionOpen(Connect())'
Help, does anyone know any solutions.
Regards
Stuart
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!You probably have no network protocols enabled on the remote computer.
Try using SVRNETCN.exe on the remote computer to enable network protocols
(TCP/IP, named pipes). SVRNETCN.exe is located in folder 'C:\Program
Files\Microsoft SQL Server\80\Tools\Binn'.
Oskari
Stuart Seeley <sseeley@.btinternet.com> wrote in
news:ODIcdKTCEHA.712@.tk2msftngp13.phx.gbl:

>
> Dear all,
> I am trying to connect to MSDE on a remote machine, on my local network
> using enterprise manager using SQL authentication, the passwords are
> correct as I can log in locally, however on trying to register the
> remote SQL MSDE i get the following error message 'SQL Server does not
> exist or access denied ConnectionOpen(Connect())'
> Help, does anyone know any solutions.
> Regards
> Stuart
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Thanks, worked a treat, much appreciated
Stuart
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!