I get "Error 2245 while trying to do NetUserAdd operation"

Hi all,
I tried installing MSDE 1 and 2 on my system but whenever I try to install it, it come up with the error:
"Error 2245 while trying to perform operation NetUserAdd"
I don't understand why this happens. Can anyone help? I've used msde successfully before but this is a new problem recently. I have an AMD 2600+, with Windows XP Pro, 512 MB RAM.
Any help would be greatly appreciated
Thanks
hi,
"Indy" <Indy@.discussions.microsoft.com> ha scritto nel messaggio
news:C843C48D-936F-4BE8-8751-BB725FA47BF2@.microsoft.com...
> Hi all,
> I tried installing MSDE 1 and 2 on my system but whenever I try to install
it, it come up with the error:
> "Error 2245 while trying to perform operation NetUserAdd"
> I don't understand why this happens. Can anyone help? I've used msde
successfully before but this is a new problem recently. I have an AMD
2600+, with Windows XP Pro, 512 MB RAM.
> Any help would be greatly appreciated
> Thanks
>
perhaps it's an AD relate problem... please have a look at
http://tinyurl.com/5ewol
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for that suggestion.
I have read the link and tried using a longer password but it does not help and I still get the same error. Any other advice please?
Thanks
"Andrea Montanari" wrote:

> hi,
> "Indy" <Indy@.discussions.microsoft.com> ha scritto nel messaggio
> news:C843C48D-936F-4BE8-8751-BB725FA47BF2@.microsoft.com...
> it, it come up with the error:
> successfully before but this is a new problem recently. I have an AMD
> 2600+, with Windows XP Pro, 512 MB RAM.
> perhaps it's an AD relate problem... please have a look at
> http://tinyurl.com/5ewol
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

I Could not install SQL successfully, gave an error log

2007-03-22 09:36:52.39 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: )

2007-03-22 09:36:52.45 server Copyright (C) 1988-2000 Microsoft Corporation.
2007-03-22 09:36:52.45 server All rights reserved.
2007-03-22 09:36:52.45 server Server Process ID is 1516.
2007-03-22 09:36:52.45 server Logging SQL Server messages in file 'd:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-03-22 09:36:52.57 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2007-03-22 09:36:53.26 server SQL Server configured for thread mode processing.
2007-03-22 09:36:53.48 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-03-22 09:36:54.31 server Attempting to initialize Distributed Transaction Coordinator.
2007-03-22 09:36:56.46 spid3 Warning ******************
2007-03-22 09:36:56.46 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2007-03-22 09:36:56.60 spid3 Starting up database 'master'.
2007-03-22 09:36:57.26 spid3 Server name is 'PRECISE'.
2007-03-22 09:36:57.26 server Using 'SSNETLIB.DLL' version '8.0.194'.
2007-03-22 09:36:57.26 spid5 Starting up database 'model'.
2007-03-22 09:36:57.60 spid5 Clearing tempdb database.
2007-03-22 09:36:57.74 spid7 Starting up database 'msdb'.
2007-03-22 09:36:57.85 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:58.31 server SQL server listening on TCP, Shared Memory, Named Pipes.
2007-03-22 09:36:58.31 server SQL server listening on 195.195.195.2:1433, 127.0.0.1:1433.
2007-03-22 09:36:58.31 server SQL Server is ready for client connections
2007-03-22 09:36:58.35 spid7 Starting up database 'pubs'.
2007-03-22 09:36:58.64 spid7 Starting up database 'Northwind'.
2007-03-22 09:37:00.18 spid5 Starting up database 'tempdb'.
2007-03-22 09:37:00.32 spid3 Recovery complete.
2007-03-22 09:37:00.32 spid3 Warning: override, autoexec procedures skipped.
2007-03-22 09:37:07.95 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

be sure to read all the requirments

hardware and software.

I cant seem to install reporting and business intelligence services, is this disabled for expres

Setup gives me the option, I choose these services, it tells me they are already installed, but they are not?

does it then also give you the option to 'upgrade' them after you hit next?

if not, try going to add/remove programs and hit the change button for sql, it should prompt you for what items to remove, see if you can remove RS.

|||

What makes you think it is not installed?

Mike

I can't install SQL Server 2005 Developer Edition

I copied the error I received.

SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.

C:\Program Files\Microsoft SQL Server\ is not an compressed or encrypted folder. I don't know what it is talking about. I just installed a fresh new copy of Windows XP Professional with Service Pack 2.

There are two things to check:

1) Open up Windows Explorer, right-click on the main drive (c:) and select properties. On the General tab near the bottom you'll see a check box labeled "Compress drive to save disk space" make sure this is unchecked. Note: if you have more than one drive you want to check the drive where "%Program Files%" lives. This may not be a the C drive.

2) Next, while still in Windows Explorer go to the root of where %Program Files% lives. This should probably be c:\. Right-click on "Program Files" and select Properties. Click the "Advanced..." button down in the Attributes section. Make sure the two check boxes in the "Compress or Encrypt attributes" group box are un-checked.

Dan|||Thanks a lot! It worked perfectly. |||I do not use any compression of encryption on the hard drive.

The 'C:\Program Files' directory is marked 'Read Only' ?

I have tried several times to install SQL Server 2005 Developer Edition

(most recently from MSDN Disk 3097.1) I have tried to complete an

uninstall before each attempt.

I have installed: IIS and .NET Framework 2.0

I have also used ..\aspnet_regiis -r to register ASP.NET

I am, successfully, running Visual Studio 2005.

I do get the warning about Minimum Hardware Requirement, but can find

nothing in the detail requirements to exclude my PCs configuration.

Any suggestions will be appreciated.

I can't install SQL Server 2005 Developer Edition

I copied the error I received.

SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.

C:\Program Files\Microsoft SQL Server\ is not an compressed or encrypted folder. I don't know what it is talking about. I just installed a fresh new copy of Windows XP Professional with Service Pack 2.

There are two things to check:

1) Open up Windows Explorer, right-click on the main drive (c:) and select properties. On the General tab near the bottom you'll see a check box labeled "Compress drive to save disk space" make sure this is unchecked. Note: if you have more than one drive you want to check the drive where "%Program Files%" lives. This may not be a the C drive.

2) Next, while still in Windows Explorer go to the root of where %Program Files% lives. This should probably be c:\. Right-click on "Program Files" and select Properties. Click the "Advanced..." button down in the Attributes section. Make sure the two check boxes in the "Compress or Encrypt attributes" group box are un-checked.

Dan|||Thanks a lot! It worked perfectly. |||I do not use any compression of encryption on the hard drive.

The 'C:\Program Files' directory is marked 'Read Only' ?

I have tried several times to install SQL Server 2005 Developer Edition

(most recently from MSDN Disk 3097.1) I have tried to complete an

uninstall before each attempt.

I have installed: IIS and .NET Framework 2.0

I have also used ..\aspnet_regiis -r to register ASP.NET

I am, successfully, running Visual Studio 2005.

I do get the warning about Minimum Hardware Requirement, but can find

nothing in the detail requirements to exclude my PCs configuration.

Any suggestions will be appreciated.

I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express Editi

Hi

I have download SQL Server 2005 evaluation 180 Days from Microsoft web site and install it fine without any problem in my machine

But when I try to install SQL Server Express edition on the same machine I lose many of start menu tools related to SQL Server 2005 Like.

Analysis Services -> Deployment Wizard

(All) Documentation and Tutorials

Performance Tools -> Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Business Intelligence Development Studio

SQL Server Management Studio

Why all that tools removed when I install SQL Server Express Edition .

And thanks with my regarding

Fraas

Hi Fraas,
SQL Server Express does not include the features you listed and so they are not available once you move away from the Trial edition.
Regards,

Mike Wachal

SQL Express team|||thanks for your reply

but how can I install SQL Server 2005 and SQL Server Express Edition on the same machine ?

thanks with my regarding
Fraas|||

In another word how can I install SQL Server 2005 and SQL Server Express Edition in the same machine ?

|||When you install SQL Server Express Edition only select to install the database engine - do not select to install the client components. If you have another edition installed which includes client components you already have everything that's included in the Express client component installation.

Dan
http://blogs.msdn.com/dtjones

I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express E

Hi

I have download SQL Server 2005 evaluation 180 Days from Microsoft web site and install it fine without any problem in my machine

But when I try to install SQL Server Express edition on the same machine I lose many of start menu tools related to SQL Server 2005 Like.

Analysis Services -> Deployment Wizard

(All) Documentation and Tutorials

Performance Tools -> Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Business Intelligence Development Studio

SQL Server Management Studio

Why all that tools removed when I install SQL Server Express Edition .

And thanks with my regarding

Fraas

Hi Fraas,
SQL Server Express does not include the features you listed and so they are not available once you move away from the Trial edition.
Regards,

Mike Wachal

SQL Express team|||thanks for your reply

but how can I install SQL Server 2005 and SQL Server Express Edition on the same machine ?

thanks with my regarding
Fraas|||

In another word how can I install SQL Server 2005 and SQL Server Express Edition in the same machine ?

|||When you install SQL Server Express Edition only select to install the database engine - do not select to install the client components. If you have another edition installed which includes client components you already have everything that's included in the Express client component installation.

Dan
http://blogs.msdn.com/dtjonessql

I CANT INSTAL a Virtual Server of SQL 2000 Enterprise in Win2k3 Enterprise

I have a Cluster of Windows 2003 Enterprise Edition, When I try to install a
SQL 2000 Enterprise Edition the setup option of Virtual Server appear
unavailable I only choose between Local Install or Remote.
Thanks for your help
Hi Alejandro,
Here are few things I would try:
1) Make sure that you are using SQL Server 2000 Enterprise Edition setup CD
2) Make sure that there are no mdf, ldf or ndf files on your local disks on both nodes
3) Make sure that you do not have another "default" instance of SQL Server/MSDE on the other node.
After taking care of the above things, try the upgrade. If it fails, then cut and paste the sqlstp.log to your post.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi,
1) Yes its SQL Server 2003 Enterprise Edition
2) There are not any MDF, NDF and LDF files (Just to be shure, this files
are SQL Files?)
3) I haven't any SQL Installed on the server
I follow this Steps but when I ran the setup the Virtual Server appear
dissable (Thanks for your help)
No.
Activity
Purpose
Expected Results
Results
1.
Reboot both nodes
They should come up with no error messages
2.
Check Event Viewer on each node and make sure there are no errors that
might interfere with the installation
3.
Check account permissions for the cluster account
Should be part of the Local Administrator group
4.
On each node, on the Start menu, click Run, and then type cmd in the
text box. Click OK.
Ping the Cluster IP Address from all nodes in the cluster; repeat for
each node
To verify that the private and public networks are communicating
properly
They should replay back
5.
Ping the cluster IP address from a computer not in the cluster
They should replay back
6.
Ping the Cluster Network Name from all nodes in the cluster
They should replay back
7.
Ping the Cluster Network Name from a computer not in the cluster
They should replay back
8.
Ping all Heartbead IP Addresses from all cluster nodes
They should replay back
9.
A domain account is available for SQL Server; check permissions for the
account; also the cluster administrator account must be created at the
domain level and must be an administrator of all nodes in the cluster
10.
All nodes have access to the installation path - we recommend to copy
the installation files locally on each node, especially for the services
pack and hotfix;
11.
In Cluster Administrator, for a two SQL Server instance installation,
create 4 groups and assign the correspondent resources to each group (such
as disk resources):
1.. MSDTC Group
2.. Cluster Group
3.. SQLServer Group1
4.. SQLServer Group2
12.
Using Cluster Administrator, test moving each group back and forth
between the two Nodes - check the owner
The owner should change
13.
While one Node owns all the groups, restart the other Node and check if
resource ownership was transferred to the other Node
The owner should change
14.
Check what resources belong to the Cluster Group
It should be: Cluster IP Address, Cluster Name, and Quorum Disk
15.
MSDTC Group
MS DTC should be in its own group; follow the following article to
configure MSDTC: 301600 - How to configure Microsoft Distributed Transaction
Coordinator on a Windows Server 2003 Cluster detailed in Appendix B
Regards, Alex
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:kOTjX3ZnEHA.2640@.cpmsftngxa06.phx.gbl...
> Hi Alejandro,
> Here are few things I would try:
> 1) Make sure that you are using SQL Server 2000 Enterprise Edition setup
> CD
> 2) Make sure that there are no mdf, ldf or ndf files on your local disks
> on both nodes
> 3) Make sure that you do not have another "default" instance of SQL
> Server/MSDE on the other node.
> After taking care of the above things, try the upgrade. If it fails, then
> cut and paste the sqlstp.log to your post.
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Hi Alejandro,
Please cut and paste sqlstp.log file (search for this file on the node where you ran sql server setup).
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||OK, I'm not in the office right now, but on monday I'm gona to attach this
log.
But first answere me something, If I never ran the setup completely, because
I never found the option of virtual Server available, which log I'm going to
cut an paste here? or If you just run the setup program click in the first
NEXT and then Cancel It (because the option virtual server is unavailable is
in gray) the sqlstp.log is generated?
Regards, Alex
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:nGonUGdnEHA.2932@.cpmsftngxa06.phx.gbl...
> Hi Alejandro,
> Please cut and paste sqlstp.log file (search for this file on the node
> where you ran sql server setup).
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Yes, it will create sqlstp.log file.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||please correct me if i'm wrong. I believe you have to create a name pipe, in
order for you to install sql on a virtual address. go to run and type in
cliconfg, click on alias and create.
Calvin
"Alejandro Garreta" <alejandro_garreta@.hotmail.com> wrote in message
news:eCmFPRbnEHA.392@.tk2msftngp13.phx.gbl...
> Hi,
> 1) Yes its SQL Server 2003 Enterprise Edition
> 2) There are not any MDF, NDF and LDF files (Just to be shure, this files
> are SQL Files?)
> 3) I haven't any SQL Installed on the server
> I follow this Steps but when I ran the setup the Virtual Server appear
> dissable (Thanks for your help)
>
> No.
> Activity
> Purpose
> Expected Results
> Results
> 1.
> Reboot both nodes
> They should come up with no error messages
>
> 2.
> Check Event Viewer on each node and make sure there are no errors
that
> might interfere with the installation
>
>
> 3.
> Check account permissions for the cluster account
> Should be part of the Local Administrator group
>
> 4.
> On each node, on the Start menu, click Run, and then type cmd in the
> text box. Click OK.
> Ping the Cluster IP Address from all nodes in the cluster; repeat
for
> each node
> To verify that the private and public networks are communicating
> properly
> They should replay back
>
> 5.
> Ping the cluster IP address from a computer not in the cluster
> They should replay back
>
> 6.
> Ping the Cluster Network Name from all nodes in the cluster
> They should replay back
>
> 7.
> Ping the Cluster Network Name from a computer not in the cluster
> They should replay back
>
> 8.
> Ping all Heartbead IP Addresses from all cluster nodes
> They should replay back
>
> 9.
> A domain account is available for SQL Server; check permissions for
the
> account; also the cluster administrator account must be created at the
> domain level and must be an administrator of all nodes in the cluster
>
>
> 10.
> All nodes have access to the installation path - we recommend to copy
> the installation files locally on each node, especially for the services
> pack and hotfix;
>
>
> 11.
> In Cluster Administrator, for a two SQL Server instance installation,
> create 4 groups and assign the correspondent resources to each group (such
> as disk resources):
> 1.. MSDTC Group
> 2.. Cluster Group
> 3.. SQLServer Group1
> 4.. SQLServer Group2
>
>
> 12.
> Using Cluster Administrator, test moving each group back and forth
> between the two Nodes - check the owner
>
> The owner should change
>
> 13.
> While one Node owns all the groups, restart the other Node and check
if
> resource ownership was transferred to the other Node
> The owner should change
>
> 14.
> Check what resources belong to the Cluster Group
> It should be: Cluster IP Address, Cluster Name, and Quorum Disk
>
> 15.
> MSDTC Group
> MS DTC should be in its own group; follow the following article to
> configure MSDTC: 301600 - How to configure Microsoft Distributed
Transaction[vbcol=seagreen]
> Coordinator on a Windows Server 2003 Cluster detailed in Appendix B
>
>
> Regards, Alex
> "Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
> news:kOTjX3ZnEHA.2640@.cpmsftngxa06.phx.gbl...
then[vbcol=seagreen]
Protection
>
|||Hello Calvin,
You need to create the named pipe alias only if you are installing a Named instance of SQL Server 2000 virtual server on Windows 2000 MSCS. For default instance, you
do not need to create the alias.
Here is the related Microsoft KB
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Here is the LOG !!
10:52:09 Begin Setup
10:52:09 8.00.194
10:52:09 Mode = Normal
10:52:09 ModeType = NORMAL
10:52:09 GetDefinitionEx returned: 0, Extended: 0x0
10:52:09 ValueFTS returned: 1
10:52:09 ValuePID returned: 1
10:52:09 ValueLic returned: 0
10:52:09 System: Windows NT Enterprise Server
10:52:09 SQL Server ProductType: Personal Edition [0x2]
10:52:09 IsNTCluster returned: 1
10:52:09 Begin Action: SetupInitialize
10:52:09 End Action SetupInitialize
10:52:09 Begin Action: SetupInstall
10:52:09 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
...
10:52:09 CommonFilesDir=C:\Program Files\Common Files
10:52:09 Windows Directory=C:\WINDOWS\
10:52:09 Program Files=C:\Program Files\
10:52:09 TEMPDIR=C:\DOCUME~1\219701\LOCALS~1\Temp\2\
10:52:09 Begin Action: SetupInstall
10:52:09 digpid size : 256
10:52:09 digpid size : 164
10:52:09 Begin Action: CheckFixedRequirements
10:52:09 Platform ID: 0xf00000
10:52:09 Version: 5.2.3790
10:52:09 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.118
10:52:09 End Action: CheckFixedRequirements
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:6xtrCOfnEHA.3312@.cpmsftngxa06.phx.gbl...
> Yes, it will create sqlstp.log file.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||I'm not installing a named instance !!!
"Calvin Do" <calvin@.spinsonic.com> wrote in message
news:OeQAZH1nEHA.536@.TK2MSFTNGP11.phx.gbl...
> please correct me if i'm wrong. I believe you have to create a name pipe,
> in
> order for you to install sql on a virtual address. go to run and type in
> cliconfg, click on alias and create.
> Calvin
>
> "Alejandro Garreta" <alejandro_garreta@.hotmail.com> wrote in message
> news:eCmFPRbnEHA.392@.tk2msftngp13.phx.gbl...
> that
> for
> the
> if
> Transaction
> then
> Protection
>

I can't access cubes from excel

I try to register the dll in a remote machine but I couldn't.
Do I need to install something else in the remote machine?whats the message / error u r gett5ing. what exactly have u done?"|||The error is Load Library "C:\........................." failed
GetLastError returns 0x00000485
In the client I haven't installed anything. I only copied the dll and try to register it. Should I install something else?
Thanks in advance|||Does anyone has connected with Excel from other computer than the server?
From the server I can connect.
What whould I install in the computer to connect to the server with Excel?
Thanks in advance.|||

Before you can connect from Excel to the Olap 2005 server, you need to install Microsoft OLEDB for Olap 9.0.

The file you need to install is: pts9.msi - Located in
"En_SQL_DEV_x86_ctp_JUNE2005\Redist\Analysis Services\pts9.msi".

Best regards,

Jakobsgaard

|||Yes I have tried this with no luck.
I think is a version problem, my server is April CTP.
I'll try to install client tools in remote client.sql

I cannot install SQL 2005 on my computer

Hello everybody,

I had installed vs 2005 beta 2 and I wanted to install SQL 2005, so I removed all the components which were installed and were beta edition by control panel and by the tool microsoft supply.

I downloaded sql 2005 but when I wanted to install it, the installation showed me an error that I need to remove all the components that are beta and exited.

The control panel show that there is nothing from vs 2005 beta but the tool try to remove 2 things and has errors. With Everest I see that the components of vs 2005 beta are still in my computer and I cannot remove them.

Someone can help me? I have been searching for an answer for 3 months without any success.

When I try to uninstall the components from Everst it doesn't do anything or start to uninstall and then stop with the error that it cannot write to cache and cannot read property "InstallIds" {"MachineConfiguration","","BAR"} from cache.

It succeed to uninstall programs which I can see at control panel.

|||

Start with http://msdn.microsoft.com/vstudio/express/support/uninstall/ and see where that get you. There are a number of components installed by VS 2005 Beta 2 that must be uninstalled manually, this link will help.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Any update on this? Did the information at the site resolve the problem for you?

Mike

I cannot get the SQL server compnent to install

I have tried to get the server component to install (SQL server instance) and it will not - what should I do?

What operating system and how many megs of ram?|||I am using XP Pro - and SQL Server 2005 Enterprise Edition

thank you for replying -
|||

You cannot install Enterprise on XP but you can install the developer which is like the Enterprise without deployment restrictions. Hope this helps.

http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx

I can′t install SQL Server 2005 Express

Hi, there!

I tried to install SSE 2005 and I got the following message:

SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in...

The log file has the content below. Can someone help me to fix this problem, please?

I have no idea about what is going on!

Thank you for the help!

Microsoft SQL Server 2005 Setup beginning at Sun Jul 23 12:52:54 2006
Process ID : 2420
c:\97830b63babac24aedb48a81be43976a\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/6/23 12:52:53
Complete: LoadResourcesAction at: 2006/6/23 12:52:53, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/23 12:52:53
Loaded DLL:c:\97830b63babac24aedb48a81be43976a\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/6/23 12:52:54, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/6/23 12:52:54
Complete: ValidateWinNTAction at: 2006/6/23 12:52:54, returned true
Running: ValidateMinOSAction at: 2006/6/23 12:52:54
Complete: ValidateMinOSAction at: 2006/6/23 12:52:54, returned true
Running: PerformSCCAction at: 2006/6/23 12:52:54
Complete: PerformSCCAction at: 2006/6/23 12:52:54, returned true
Running: ActivateLoggingAction at: 2006/6/23 12:52:54
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00E2CFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Redirecting to the setup forum.

Mike

I can´t install SQL Server 2005 Express

Hi, there!

I tried to install SSE 2005 and I got the following message:

SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in...

The log file has the content below. Can someone help me to fix this problem, please?

I have no idea about what is going on!

Thank you for the help!

Microsoft SQL Server 2005 Setup beginning at Sun Jul 23 12:52:54 2006
Process ID : 2420
c:\97830b63babac24aedb48a81be43976a\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/6/23 12:52:53
Complete: LoadResourcesAction at: 2006/6/23 12:52:53, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/23 12:52:53
Loaded DLL:c:\97830b63babac24aedb48a81be43976a\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/6/23 12:52:54, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/6/23 12:52:54
Complete: ValidateWinNTAction at: 2006/6/23 12:52:54, returned true
Running: ValidateMinOSAction at: 2006/6/23 12:52:54
Complete: ValidateMinOSAction at: 2006/6/23 12:52:54, returned true
Running: PerformSCCAction at: 2006/6/23 12:52:54
Complete: PerformSCCAction at: 2006/6/23 12:52:54, returned true
Running: ActivateLoggingAction at: 2006/6/23 12:52:54
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00E2CFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Redirecting to the setup forum.

Mike

i can not install MSQL server 20005 TCP Express April Edition

hello all
during the instaletion i get an error message that SQL server can not start the service, after that the programm rolls instalation back.
do someone knows what's going on?
i use win xp pro.
thank u for ur help.Try the link below to download the June CTP, it could make a difference. Hope this helps.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA|||thanks Caddre but it does not change the situation.
but i have found one blog that describe that, if someone have the same problem this topic can help:
http://blogs.msdn.com/sqlexpress/archive/2005/05/24/421563.aspx
regards

I am unable to install updates for SQL Server 2005 Express Edition

Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack
2 (KB 921896)
Hi Brent
What error message say and what does the installation log say?
John
"Brent Wilson" wrote:

> Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack
> 2 (KB 921896)

I am unable to install updates for SQL Server 2005 Express Edition

Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack
2 (KB 921896)Hi Brent
What error message say and what does the installation log say?
John
"Brent Wilson" wrote:
> Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack
> 2 (KB 921896)

I am unable to install SQL Server 2005 on Win XP SP2 box

I get to the point of starting the services and receive the following message after about 4 minutes of trying to start. I tried in Mixed Mode and Windows Authentication Mode. Message:

TITLE: Microsoft SQL Server 2005 Setup

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aWaitForServiceState%40x41d

BUTTONS:

&Retry
Cancel

YOu need do have a look in the WIndows event log or in the log files of SQL Server mentioned. There is a problem starting the service, the message that you provided is just a generic one which doesn′t tell the specific error.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||I can find nothing useful in the Windows event log and I guess I do not understand where the sql server log files are.|||For me its located in here:

C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG

Could be something different for you depending on your installation.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

here is the log contents of the last attempted installation and of course it timed out while trying to start the service:

2006-05-28 07:37:06.92 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)

Apr 14 2006 01:12:25

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

2006-05-28 07:37:06.92 Server (c) 2005 Microsoft Corporation.

2006-05-28 07:37:06.92 Server All rights reserved.

2006-05-28 07:37:06.92 Server Server process ID is 4776.

2006-05-28 07:37:06.92 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2006-05-28 07:37:06.94 Server Registry startup parameters:

2006-05-28 07:37:06.94 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf

2006-05-28 07:37:06.94 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

2006-05-28 07:37:06.94 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

2006-05-28 07:37:06.94 Server Command Line Startup Parameters:

2006-05-28 07:37:06.95 Server -m SqlSetup

2006-05-28 07:37:06.95 Server SqlSetup

2006-05-28 07:37:06.95 Server -Q

2006-05-28 07:37:06.95 Server -q SQL_Latin1_General_CP1_CI_AS

2006-05-28 07:37:06.95 Server -T 4022

2006-05-28 07:37:06.95 Server -T 3659

2006-05-28 07:37:06.95 Server -T 3610

2006-05-28 07:37:06.95 Server -T 4010

2006-05-28 07:37:06.98 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2006-05-28 07:37:06.98 Server Detected 1 CPUs. This is an informational message; no user action is required.

2006-05-28 07:40:49.72 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2006-05-28 07:40:50.88 Server Database Mirroring Transport is disabled in the endpoint configuration.

2006-05-28 07:59:24.50 Server Service control: stop before startup

|||

Thanks.....

Property(S): DatabaseReplRes.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\
Property(S): DatabaseReplRes1033.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\1033\
Property(S): SqlVerComBin.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:\Program Files\Microsoft SQL Server\90\COM\
Property(S): Ver.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:\Program Files\Microsoft SQL Server\90\
Property(S): SqlVerComBin.889BED4C_E3F4_4943_956C_6FFD882F721F = C:\Program Files\Microsoft SQL Server\90\COM\
Property(S): Ver.889BED4C_E3F4_4943_956C_6FFD882F721F = C:\Program Files\Microsoft SQL Server\90\
Property(S): SqlVerComBin.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\
Property(S): Ver.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\
Property(S): SqlVerComBinRes.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\Resources\
Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\Resources\1033\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): SqlStateManaged = 2
Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS
Property(S): SOURCEDIR = d:\69a81902561ca8c7a8df\Setup\
Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Property(S): InstallNgenTicks = 110000
Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITY\NetworkService
Property(S): SQLSCMACCOUNT = NT AUTHORITY\NetworkService
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {84AFA01D-0112-4F29-990C-7A3EECC00498}
Property(S): ProductToBeRegistered = 1
MSI (s) (EC:1C) [08:37:27:207]: Note: 1: 1708
MSI (s) (EC:1C) [08:37:27:207]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.

MSI (s) (EC:1C) [08:37:27:227]: Cleaning up uninstalled install packages, if any exist
MSI (s) (EC:1C) [08:37:27:227]: MainEngineThread is returning 1603
MSI (s) (EC:5C) [08:37:27:337]: Destroying RemoteAPI object.
MSI (s) (EC:D8) [08:37:27:337]: Custom Action Manager thread ending.
=== Logging stopped: 5/28/2006 8:37:27 ===
MSI (c) (78:AC) [08:37:27:377]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (78:AC) [08:37:27:377]: MainEngineThread is returning 1603
=== Verbose logging stopped: 5/28/2006 8:37:27 ===

|||What service account are you using for the service. It could be that the service account used doesn′t have the appropiate permissions to start up SQL Server. Change that (e.g. to Local System) and see if a manual startup comes up successfull.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

I am trying to install and config MySQL ... if there is a FAQ I will read ...

Hello,

My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.

1) When I run the Config Wizard, I get the following message:

"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Suggestions please.

Kind regards, Vasya"Vasya" <vigalchin@.gmail.comwrote in message
news:1193890280.276080.101840@.d55g2000hsg.googlegr oups.com...

Quote:

Originally Posted by

Hello,

There probably is a FAQ, but this newsgroup is dedicated to Microsoft SQL
Server, so any help here will be limited.

(though I'll recommend looking at SQL Server Express 2005).

Quote:

Originally Posted by

>
My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.
>
1) When I run the Config Wizard, I get the following message:
>
"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

Yes, there is an event log. I don't have Vista so not sure if they've moved
it but on XP you can go to My Computer, right click, click on MANAGE and
drill down from there.

Quote:

Originally Posted by

>
>
2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Search and replace / with \ ?

Quote:

Originally Posted by

>
Suggestions please.
>
Kind regards, Vasya
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html