Instance name specified is invalid

I am trying to apply the sql2kdesksp3a to a new
installation of SQL desktop. When I try and apple the SP
I recieve the error The instance name is invalid. I have
tried searching for the instance in the registry that is
reffered to on KB 311762 but I can not find any
references to the MSI file used for install. I am using a
select CD from Microsoft to install SQL Desktop. I dont
understand why this should be so hard I have not loaded
any 3rd part apps just XP and the SQL desktop and
Analysis services
no
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

installtion of analytics server

i downloaded proclarity desktop profesional from microsoft website and installed ..

but i am unable to connect to analytics server..does it need separate software or is it my databse..what is pas in that and which user id /password i must give..Is it databse serevr address or any other..

i tried by all means but failed..can u give me other versions of downloads..or help in installing desktop profesional...

its urgent...plzz help me out...

Hi,

You don't need anymore software, you should be able to connect to the ProClarity Server with out any problems. That is with the assumption you can access it via a URL. Normally something like http://SERVERNAME/PAS.

You did install the analytic server?

Hope that helps

Matt

installtion file for SQL CE 2.0 to install in Real PocketPC

HI,

i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.

Best Regards

Ihsan

Not having worked with SQL CE 2.0 (available here) for a while I would assume that it follows the same pattern as the current verion which is that the installer is to be run on the desktop NOT the device. After running the installer either the runtime dlls or a mobile installer will be available - you should also read the ReadMe and consider installing the books online (available locally after installing the main SQL CE 2.0 installer)

Hope this helps.

Installing SQL Server Express 2005 via Remote Desktop

Hi,

Does anyone know if it's at all possible to install SQL Server Express 2005 over a Remote Desktop on a Windows XP machine.

I know there are problems running SQL over Remote Desktop, in that it won't start up a User Instance, but I wasn't sure if we can install over Remote Desktop.

If it's not possible, can anyone point me to an official document stating this fact?

Thanks

Sam

Yes, this is most certainly possible. If you encounter an error during install, please share the logs (%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log)so we can take a look.|||

Hi Jeff,

I've just been able to confirm that installing SQL via Remote Desktop is possible.

Our application requires user instances, and so after installation I then tried running our application via Remote Desktop. However, it came up with an exception "Failed to generate a user instance of SQL Server..."

I then went directly onto the remote machine and ran our application, and it worked perfectly fine.

So remote installation was fine, but running remotely with user instances is a problem.

Thanks
Sam

Installing SQL Server Desktop Engine & Enterprise Manager

I downloaded and successfully installed SQL Server 2000 Desktop edition via
"MSDE2000A.exe".
Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
attempted to install that.
But, I got an error message: "SQL Server 2000 is not installed on this
machine. Setup will now exit".
So, obviously the error message is wrong, as I did install SQL Server 2000.
So, don't know what to do.
One thing that may be affecting this is that when doing the S.S. 2000
install, I had to do it via a DOS window in order to set a flag for what's
called an "SA" password. And I was thinking that maybe that's affecting the
subsequent attempt to install Enterprise Manager?
I'm running WinXP Professional with SP2 on my PC.
A thought...since I really don't have SQL Server 2000 installed, but instead
the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
Thanks.Hi,
Did you install MSDE SP3?
From the file name "sql2ksp3.exe", I think it's not the appropariate
release. The SP3 name for MSDE is sql2kdesksp3.exe.
You can download it from:
http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en
If you have any other questions or concerns, please feel free to let me
know.
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, a
nd confers no rights.
======================================================|||andyboy wrote on Thu, 3 Aug 2006 13:29:02 -0700:
> I downloaded and successfully installed SQL Server 2000 Desktop edition
> via "MSDE2000A.exe".
> Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
> attempted to install that.
That's Service Pack 3 for SQL Server 2000. Enterprise Manager comes on the
SQL Server CD.
> But, I got an error message: "SQL Server 2000 is not installed on this
> machine. Setup will now exit".
> So, obviously the error message is wrong, as I did install SQL Server
> 2000. So, don't know what to do.
You installed SQL Server 2000 Desktop (MSDE). That is not the same as the
"proper" SQL Server (Standard and Enterprise).
> One thing that may be affecting this is that when doing the S.S. 2000
> install, I had to do it via a DOS window in order to set a flag for what's
> called an "SA" password. And I was thinking that maybe that's affecting
> the subsequent attempt to install Enterprise Manager?
> I'm running WinXP Professional with SP2 on my PC.
> A thought...since I really don't have SQL Server 2000 installed, but
> instead the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
> Thanks.
If you want Enterprise Manager, you'll need to buy SQL Server. The
Desktop/MSDE version doesn't come with a GUI management tool. I'm not sure
if the SQL Server Express 2005 Management Studio GUI will work with Desktop
2000, if it does then you could use that.
Dan|||ok, thanks and 2 things:
1) the link you posted to get 'sql2kdesksp3.exe' isn't valid.
2) can I install Enterprise Manager with the desktop sql server?
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||and I did successfully install sql server version 8.00.760.
so, is that the desktop version of sql server, or is it the 'full' version?
and if it's the full version, I'd prefer to leave it installed, I guess, and
then install Enterprise Manager for it.
so, how do I do that?
thanks.
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||Hi,
Thanks for your post.
I tried the link again and can get access the web. The sql2kdesksp3.exe
package for downloading locates under the page below.
I recommend that you check wheter or not the url is devided into two lines.
If so, you need to combine the two lines into one line url.
You can install SQL Enterprise Mnager with MSDE2000, however, you need to
install it with named instance.
It's only allowed only one default instance installed on one server.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi ,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Installing SQL Server Desktop Engine & Enterprise Manager

I downloaded and successfully installed SQL Server 2000 Desktop edition via
"MSDE2000A.exe".
Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
attempted to install that.
But, I got an error message: "SQL Server 2000 is not installed on this
machine. Setup will now exit".
So, obviously the error message is wrong, as I did install SQL Server 2000.
So, don't know what to do.
One thing that may be affecting this is that when doing the S.S. 2000
install, I had to do it via a DOS window in order to set a flag for what's
called an "SA" password. And I was thinking that maybe that's affecting the
subsequent attempt to install Enterprise Manager?
I'm running WinXP Professional with SP2 on my PC.
A thought...since I really don't have SQL Server 2000 installed, but instead
the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
Thanks.Hi,
Did you install MSDE SP3?
From the file name "sql2ksp3.exe", I think it's not the appropariate
release. The SP3 name for MSDE is sql2kdesksp3.exe.
You can download it from:
http://www.microsoft.com/downloads/...D52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en
If you have any other questions or concerns, please feel free to let me
know.
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, a
nd confers no rights.
========================================
==============|||andyboy wrote on Thu, 3 Aug 2006 13:29:02 -0700:

> I downloaded and successfully installed SQL Server 2000 Desktop edition
> via "MSDE2000A.exe".
> Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
> attempted to install that.
That's Service Pack 3 for SQL Server 2000. Enterprise Manager comes on the
SQL Server CD.

> But, I got an error message: "SQL Server 2000 is not installed on this
> machine. Setup will now exit".
> So, obviously the error message is wrong, as I did install SQL Server
> 2000. So, don't know what to do.
You installed SQL Server 2000 Desktop (MSDE). That is not the same as the
"proper" SQL Server (Standard and Enterprise).

> One thing that may be affecting this is that when doing the S.S. 2000
> install, I had to do it via a DOS window in order to set a flag for what's
> called an "SA" password. And I was thinking that maybe that's affecting
> the subsequent attempt to install Enterprise Manager?
> I'm running WinXP Professional with SP2 on my PC.
> A thought...since I really don't have SQL Server 2000 installed, but
> instead the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
> Thanks.
If you want Enterprise Manager, you'll need to buy SQL Server. The
Desktop/MSDE version doesn't come with a GUI management tool. I'm not sure
if the SQL Server Express 2005 Management Studio GUI will work with Desktop
2000, if it does then you could use that.
Dan|||ok, thanks and 2 things:
1) the link you posted to get 'sql2kdesksp3.exe' isn't valid.
2) can I install Enterprise Manager with the desktop sql server?
"Charles Wang[MSFT]" wrote:

> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ========================================
==============
>|||and I did successfully install sql server version 8.00.760.
so, is that the desktop version of sql server, or is it the 'full' version?
and if it's the full version, I'd prefer to leave it installed, I guess, and
then install Enterprise Manager for it.
so, how do I do that?
thanks.
"Charles Wang[MSFT]" wrote:

> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ========================================
==============
>|||Hi,
Thanks for your post.
I tried the link again and can get access the web. The sql2kdesksp3.exe
package for downloading locates under the page below.
I recommend that you check wheter or not the url is devided into two lines.
If so, you need to combine the two lines into one line url.
You can install SQL Enterprise Mnager with MSDE2000, however, you need to
install it with named instance.
It's only allowed only one default instance installed on one server.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi ,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Installing SQL Mobile 2005

It is possible to install the .NET Compact Framework from the desktop with a .msi file.

However, SQL Mobile 2005 seems to require you to know the processor which your mobile device uses - there are only CAB files available to do the install.

Have Microsoft made an MSI file available to make this process easier?

matt.
All Windows Mobile (5 and 6) devices use the same processor architecture - ARM, so the problem is minimal.

Installing SQL Desktop Engine

Is there any particular way that Desktop Engine should be installed? I have
both SQLServer 2000 Developer and Desktop Enigine. I was told to install Dev
eloper before Destop. When I did this I got an error message stating "The na
med instance is invalid."
IS Develooper to be installed before or after Desktop? Also, do the server n
eed to be named differently?I have found that with installing multiple SQL Servers to a computer that
explicitly naming each instance, even the first one, works best. That has
even worked for Yukon aside 2000 on machines I've seen. But I've never
installed desktop engine so sorry I don't have that exact piece of info.
hth
Eric
Mary Moon wrote:
> Is there any particular way that Desktop Engine should be installed?
> I have both SQLServer 2000 Developer and Desktop Enigine. I was told
> to install Developer before Destop. When I did this I got an error
> message stating "The named instance is invalid." IS Develooper to be
> installed before or after Desktop? Also, do the server need to be
> named differently?

Installing SQL Desktop Engine

Is there any particular way that Desktop Engine should be installed? I have both SQLServer 2000 Developer and Desktop Enigine. I was told to install Developer before Destop. When I did this I got an error message stating "The named instance is invalid."
IS Develooper to be installed before or after Desktop? Also, do the server need to be named differently?
I have found that with installing multiple SQL Servers to a computer that
explicitly naming each instance, even the first one, works best. That has
even worked for Yukon aside 2000 on machines I've seen. But I've never
installed desktop engine so sorry I don't have that exact piece of info.
hth
Eric
Mary Moon wrote:
> Is there any particular way that Desktop Engine should be installed?
> I have both SQLServer 2000 Developer and Desktop Enigine. I was told
> to install Developer before Destop. When I did this I got an error
> message stating "The named instance is invalid." IS Develooper to be
> installed before or after Desktop? Also, do the server need to be
> named differently?

Installing Sql CE 2.0

Hi All,

I'm facing a problem while installing SQL CE 2.0 on my Desktop PC. It tells that the system must be installed with service pack 1 or higher for SQL Server 2000. I have installed service pack 3a and tried again. But then also i'm getting the same error message. Can anybody help me on this problem.

thanks in advance.

SQL CE 2.0 is for devices and is not supported on DESKTOP! (and was never even designed). If you want to have a DESKTOP version of it, please use this:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=898913&SiteID=1

Thanks,

Laxmi

Installing Sql CE 2.0

Hi All,

I'm facing a problem while installing SQL CE 2.0 on my Desktop PC. It tells that the system must be installed with service pack 1 or higher for SQL Server 2000. I have installed service pack 3a and tried again. But then also i'm getting the same error message. Can anybody help me on this problem.

thanks in advance.

SQL CE 2.0 is for devices and is not supported on DESKTOP! (and was never even designed). If you want to have a DESKTOP version of it, please use this:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=898913&SiteID=1

Thanks,

Laxmi

Installing sql 2005 using RDP.

Are there any known issues (problems, etc.) with installing sql 2005 on a remote server using Remote Desktop? Any problems installing Sql 2005 SP1 via RDP?

TIA,

Barkingdog

We (the SQL Server setup test team) heavily rely on remote desktop in our testing and I've never run into any issues.

Thanks,
Sam Lester (MSFT)