Invalid Schema after restoration at MSDE Version

I took the back from Enterprise version of sql server and trying to restore
at MSDE Version... it restored successfully but after that when I try to see
the tables and procedures it gave an error and like the database is not the
valid schema.. can any one tell me what I have to do ?
Could you please paste the exact error message?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"msnews.microsoft.com" <Noor> wrote in message
news:uR$POQujFHA.1464@.TK2MSFTNGP14.phx.gbl...
>I took the back from Enterprise version of sql server and trying to restore
>at MSDE Version... it restored successfully but after that when I try to
>see the tables and procedures it gave an error and like the database is not
>the valid schema.. can any one tell me what I have to do ?
>

Invalid Instance Name while trying to install MSDE

I am running XP SP2. I have downloaded MSDE (SQL Sever 2000) to put on my
laptop for training purposes. When I try to load the setup program I get an
error message saying "The Instance Name Specified Is Invalid" and then when I
acknowledge the message the install exits. I have searched for and tried to
understand the post that seem to relate to my problem but I am just not
knowledgable enough to understand what to do. If someone would please tell me
(in baby steps) how to fix this problem so I can install MSDE then I would
really appreciate it. If you need ANY additional information please feel free
to contact me and I will respond immediately. Your time and attention is very
much appreciated.
Thank you for your help...premium001
Read into the readme file in your extracted folder.
If there is an instance of SQL Server already installed, the MSDE should be
named.
"premium001" wrote:

> I am running XP SP2. I have downloaded MSDE (SQL Sever 2000) to put on my
> laptop for training purposes. When I try to load the setup program I get an
> error message saying "The Instance Name Specified Is Invalid" and then when I
> acknowledge the message the install exits. I have searched for and tried to
> understand the post that seem to relate to my problem but I am just not
> knowledgable enough to understand what to do. If someone would please tell me
> (in baby steps) how to fix this problem so I can install MSDE then I would
> really appreciate it. If you need ANY additional information please feel free
> to contact me and I will respond immediately. Your time and attention is very
> much appreciated.
> --
> Thank you for your help...premium001
|||hi,
premium001 wrote:
> I am running XP SP2. I have downloaded MSDE (SQL Sever 2000) to put
> on my laptop for training purposes. When I try to load the setup
> program I get an error message saying "The Instance Name Specified Is
> Invalid" and then when I acknowledge the message the install exits. I
> have searched for and tried to understand the post that seem to
> relate to my problem but I am just not knowledgable enough to
> understand what to do. If someone would please tell me (in baby
> steps) how to fix this problem so I can install MSDE then I would
> really appreciate it. If you need ANY additional information please
> feel free to contact me and I will respond immediately. Your time and
> attention is very much appreciated.
as <zhaounknown> already wrote, please read the proviede ReadmeFile... it
explains you have to provide a set of parameters to the setup.exe boostrap
installer..
typically you have to provide the SAPWD="your strong password" as you are
forced to protect "sa" login ...
you can specify if you like to enable network connections
(DISABLENETWORKPROTOCOLS=0), if you like to permit standard SQL Server
authenticated connections (SECURITY MODE=SQL) as the default does not permit
them to be authenticated, or if you like to install a named instance
(INSTANCENAME="the name").. and please enable verbose logging of the
installation task providing the /L*v "c:\Msde.txt" parameter, which results
in an about 2Mb text file you can inspect for
RETURN VALUE 3
entries indicating troubles... about 10/20 lines before and/or after each
entry some (sometime cryptic) description of the problem will be logged..
so, if you like to install a named instance (named "MSDE") with enabled
networkprotocols and enabling SQL Server authenticated connections you have
to provide something similar to
C:\MSDERelaA\>setup.exe INSTANCENAME="MSDE" SECURITY MODE=SQL
DISABLENETWORKPROTOCOLS=0 SAPWD="your strong password" /L*v "c:\Msde.txt"
all on the same line from the command promt
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Invalid Descriptor Index

I have a Sql Server 2000 SP3 Publisher that performs merge replication with a group of MSDE 2000 SP3 subscribers.
Everything was working fine. I had to make changes to the publication and reinit the subscribers. Some subscribers are working fine. Others are getting an error. The error is
The process could not enumerate changes at the 'Subscriber'.
The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
------
Invalid Descriptor Index
(Source: XXXXXXXX(Data source); Error number: 0)
------
Anyone know what might cause this? And the solution for it?
90 % of the failure to enumerat changes errors can be cleared by restarting the agent.
In your case the invalid descriptor index is unusual and points to an ODBC error. SQL Server replication uses ODBC to communicate between servers.
There are some reports that you can clear this error by rearranging your columns returned in your results set.
It sounds like this might be a bug.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||"There are some reports that you can clear this error by rearranging your columns returned in your results set."
I can't rearrange anything since its setup from replication itself. Its wierd because some subscribers to go through fine, others are failing with the error.
|||Is this error a transient error for these subscribers? Are these subscribers at the same MDAC, sp, hot fix level for that the successful subscribers are at?
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Invalid Connection message

I have a database running under MSDE 2000 to which I can connect either
through MS Access or Coldfusion. However, I wanted to run a script at the
command prompt to try and have an automatic backup.
I typed OSQL -Usa -P at the command prompt and supplied a valid password but
after a few moments I got back:
[Shared Memory] Invalid connection.
[Shared Memory]ConnectionOpen (Invalid Instance()).
Can anyone point me in the right direction as to what might be wrong?
many thanks
june
hi June,
June Macleod wrote:
> I have a database running under MSDE 2000 to which I can connect
> either through MS Access or Coldfusion. However, I wanted to run a
> script at the command prompt to try and have an automatic backup.
> I typed OSQL -Usa -P at the command prompt and supplied a valid
> password but after a few moments I got back:
> [Shared Memory] Invalid connection.
> [Shared Memory]ConnectionOpen (Invalid Instance()).
>
did you provide the correct instance name in the form
osql -S(local)\InstanceName
?
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
|||Thank you, that was the problem. I will now attempt to run my script.
June
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3p0ba1F82e2mU1@.individual.net...
> hi June,
> June Macleod wrote:
> did you provide the correct instance name in the form
> osql -S(local)\InstanceName
> ?
> --
> 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
>

Internet-Provider for MSDE-Datebase?

Hi all,

does someone know an Internet Provider for MSDE database?

Regards

Leonid Pavlovhttp://oneandone.co.uk

do MSDE

Simon