Can't Start Sql Server 2000, Error: &&"use Sql 2005 Management Tools&&" !!!!

Management Tools In SQL SERVER 2005
Hi Team,
Is there any management tools in SQL SERVER 2005? I just installed my standard edition and also developer version in different computer, but seems that both versions doesn't support management tools such as query analyzer.
Can anyone explain to me...
Thanks.

View Replies !

---

How To Stop / Start Sql Server 2000 Using Management Studio
Hi
I have upgraded my local to sql server 2005, but still need to access the remote instance which is still at version 2008/8.0.
Enterprise Manager has been removed (by the SQL server 2005 installation)
Does anyone know how I can restart older version of SQL server instance (ie 2000/8.0) using SQL server Management Studio? 
 
I don't have admin access on the server which the sql remote instance is hosted.  Can get around it by asking the sys admin guy to do it for now but would prefer to continue to be able to do it myself.
SQL Server Configuration Manager can only manage SQL server 2005 versions - a nice little caveat!
 
Is there a way to stop/start remote services using 'net stop/start'? - without having to write code....
I'll continue to search for a solution, but if someon can point me in the right direction, I'd be most greatful.
 
hien
 
 
 

View Replies !

---

SQL Server 2005 Client Tools Not Shown Up In Start Menu On Windows 2003 Server
Hello,

 

I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.

 

I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.

 

The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).

 

One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.

 

I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?

 

Thanks

View Replies !

---

Installing SQL Server 2005 Management Tools - Setup Crashing Repeatedly
I'm having many many issues installing sql server management tools. i had visual studio 2005 installed first, but uninstalled and sql related things before trying to install sql server management tools again - i also deleted the program files/microsoft sql server/ folder so there are no references.

Firstly the system configuration check gives me a warning that the system doesn't meet the recommended hardware requirements - this is wrong... i've got 2.33Ghz dual core + 1gb of ram...

I select just management tools + client connectivity to install and click next -> the setup support files/native client/owc11 etc all install fine but workstation components etc fail and the setup log appears to either be empty and not available
and MSXML6 fails... after clicking finish the installer appears to crash - : "Microsoft SQL Server 2005 Setup has encountered a problem and needs to close.  We are sorry for the inconvenience"... I have tried all sorts of variations on this install and have had no problems in the past - please help!

The setup log from the MSXML6 failure -
=== Verbose logging started: 18/03/2008  12:34:09  Build type: SHIP UNICODE 3.01.4000.4039  Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (5C:78) [12:34:09:067]: Resetting cached policy values
MSI (c) (5C:78) [12:34:09:067]: Machine policy value 'Debug' is 0
MSI (c) (5C:78) [12:34:09:067]: ******* RunEngine:
           ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
           ******* Action:
           ******* CommandLine: **********
MSI (c) (5C:78) [12:34:09:067]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (5C:78) [12:34:09:067]: Grabbed execution mutex.
MSI (c) (5C:78) [12:34:09:067]: Cloaking enabled.
MSI (c) (5C:78) [12:34:09:067]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (5C:78) [12:34:09:067]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (28:E4) [12:34:09:113]: Grabbed execution mutex.
MSI (s) (28:74) [12:34:09:113]: Resetting cached policy values
MSI (s) (28:74) [12:34:09:113]: Machine policy value 'Debug' is 0
MSI (s) (28:74) [12:34:09:113]: ******* RunEngine:
           ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
           ******* Action:
           ******* CommandLine: **********
MSI (s) (28:74) [12:34:09:113]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (28:74) [12:34:09:113]: MainEngineThread is returning 1605
MSI (c) (5C:78) [12:34:09:113]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (5C:78) [12:34:09:113]: MainEngineThread is returning 1605
=== Verbose logging stopped: 18/03/2008  12:34:09 ===

The log summary:

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time            : Tue Mar 18 12:05:06 2008
 
EOC429 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine         : EOC429
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : EOC429
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : EOC429
Product         : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log
--------------------------------------------------------------------------------
Machine         : EOC429
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log
--------------------------------------------------------------------------------

 SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time            : Tue Mar 18 12:19:20 2008


List of log files:
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core(Local).log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_MSXML6_1.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Datastore.xml
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0 LangPack.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor LangPack.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer LangPack.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SNAC.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Support.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SCC.log
    C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_WI.log

View Replies !

---

You Must Use SQL Server 2005 Management Tools To Connect To This Server
Hello,
After installing SQL Server 2005, I get a message stating "You must use SQL Server 2005 management tools to connect to this server", while trying to connect to my localhost using SQL Server 2000 Enterprise Manager.
Regards,
junior

View Replies !

---

SQL Server 8 And SQL Server 2005 Management Tools In Consistencies
 I have been investigating this issue and here is what I have found, when using SQL Server 8 Query Analyzer the results show that for example xp_regread has Execute permissions granted to €˜public€™ role. When checking the Same using the SQL Server 2005 Management Studio the results show that there are no Execute permissions granted to €˜Public€™ Role.

 

So the following Query doesn't return any results on Management Studio SQL Server 2005:

SELECT sysusers.name
, Status =
CASE protecttype

             WHEN 204 THEN 'GRANT_W_GRANT'

             WHEN 205 THEN 'GRANT'

             WHEN 206 THEN 'REVOKE'

 ELSE 'Unknown'

END

, Permission =

CASE action

             WHEN 193 THEN 'SELECT'

             WHEN 195 THEN 'INSERT'

             WHEN 196 THEN 'DELETE'

             WHEN 197 THEN 'UPDATE'

             WHEN 26 THEN 'REFERENCE'

             WHEN 224 THEN 'EXECUTE'

 ELSE 'Unknown'

END

, sysobjects.name

FROM sysprotects, sysobjects, sysusers

WHERE sysobjects.id = sysprotects.id

AND sysprotects.action IN (193, 195, 196, 197, 224, 26)

AND sysprotects.uid = sysusers.uid

AND sysusers.name = 'public'

AND (sysobjects.name like '%xp_%' OR sysobjects.name like '%sp_OA%')

 

Where as running the Same Query in SQL Server 8.0 Query Analyzer will return results, saying there are a few extended procs available to Public for Execute.

Do you know whats going on here?

Thanks!

View Replies !

---

[SQL-DMO]You Must Use SQL Server 2005 Management Tools To Connect To This Server
 We have just moved from 2000 to 2005 and ever time I try to open store procedure or function I was getting this error message...
[Microsoft][ODBC SQL Server Drive] To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)
So I installed "Microsoft SQL Server 2005 Backward Compatibility Components" from "Feature Pack for Microsoft SQL Server 2005 - April 2006" on the client machine and this resolved the issue. Specifically i installed the "SQL Distributed Management Objects (SQL-DMO) feature .....,
how I am getting following error message
 
 
[SQL-DMO]You must use SQL Server 2005 management tools to connect to this server
 

How can I disabled all other features.
 
Thanks,
 

View Replies !

---

SQL Server Management Express Studio Management Tools
 

I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.

View Replies !

---

SQL 2005 Management Tools
Hi, I installed sql 2005 dev for testing sharepoint, and the management studio was not installed. Now, i am afraid to try to install it because i am thinking it may uninstall or re-install all sql components (and probably erase existing instances and sharepoint data may be lost. I have installed on an other pc the client tools, but i cannot connect to that instance, and i cannot attach the user databases (i get the 5123 error)

Can anyone help me how i can install management services without messing up the sharepoint instance?

View Replies !

---

&&"The Feature(s) Specified Are Not Valid For This Edition Of SQL Server&&" Error When Installing Management Tools On Win 2003 X64
I've successfully installed SQL Server 2005 Standard Edition on an Enterprise edition of Windows Server 2003 x64.    I'm now (and also tried & failed during the install of the database engine) attempting to install the "Management Tools" component on the same server.  However, in all my attempts to do so, I receive the following error:

---

The feature(s) specified are not valid for this edition of SQL Server

---

The message box does not list the features that are not valid but since the only item I've selected to install is the "Management Tools" option under "Client Components" it obviously points to something with that.

 

Am I missing something or are the Management Tools not supported in my config - most notably SQL Server 2005 Standard edition running on Windows Server 2003 x64?

 

Thanks.

 

- Lance

 Colorado State University

 

 

View Replies !

---

Install Of 2005 Management Tools Fails
 

I have VS2008 installed. Now, I need to install the SQL server Management Tools, because of tasks I have on SQL server instances which are installed on other servers. I guess a lot of developers are in such a situation. You develop on your own machine, but deploy the final database on a production machine.And you happen to be the manager of those databases too (well, I am)
 
Now, it seems impossible to install the neccesary tools as I get messages;
The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on details (Workstation components, Books Online and development tools 9.2.3042.00)  
 
Then on the Details, it says the following,


Name: Microsoft SQL Server 2005 Tools Express Edition

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Build version check:

Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.

 
Now, I have no clue of what can be safely removed to allow the installation of the Management Tools. I am afraid that I will end up with a non-working SQL server Express installation which is required for VS2008
 
What should I do to get these Managment Tools installed on my develop machine?
 

View Replies !

---

Error When Trying To Start Management Studio
Hello Guys,

I am getting the following error when I try to start SQL 2005 Management Studio to manage my SQL Server :
Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
 
Any ideas ?
 
Thanks,

View Replies !

---

Error - Installing Client Tools - Sql Server 2005
Hello

I am trying to install client tools on my desktop and I am getting the following error :

Edition Change Check (Warning)

Messages
Edition Change Check


To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005,
you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

This error , I am have seen in the logs.

The installation wizard is closing down with the above log error.

Thanks

View Replies !

---

Error - Installing SQL Server 2005 Client Tools
Hello

I am trying to install sql server 2005 client tools and I get the following error:

 

Error code 2356 : Could not locate cabinet in stream : sql.cab

How can I go about this

Thanks

View Replies !

---

SQL Server Express Management Tools
Can anyone tell me where to download the management tools for SQL Server 2005 Express?

Thank you,

View Replies !

---

SQL Server Management Tools Not Installed
>> I was able to solve this.  Read the bottom of the post.

I just installed SQL Server 2005 Standard Edition and none of the management tools seem to be there.  At least they do not show up in Start>>All Programs>>Microsoft SQL Server 2005.  All that shows up is the Configuration Tools menu item.

I have been searching through the forum and I have found dozens of other threads about this, but none that seem to actually answer the question or give a solution.  Some say to delete everything and start over, others say to review Visual Studio 2005 (which takes something like 4 hours to install, and then you still have to install all of the 3rd party tools, so I don't want to do that unless I just have to), and a few others say to uninstall SQL Server Express and then reinstall SQL Server.  However, I believe that I selected to install them both at the same time.

Anyway, I just looking for some ideas here to get all of this installed.  There seems to be some problem here that a lot of people are having to deal with. 

Are the Managment Tools disabled by default?  It seems that in 2005 a lot of the services are turned off by default so I'm wondering if I have to do something to turn on the Management Tools.

Best regards,

Greg Rothlander

 

I just uninstalled and reinstalled per some threads on the forum and it all showed up.  Apperently if anyone runs into this, just uninstall everything that has to do with Microsoft SQL Server and reinstall.

 

 

View Replies !

---

Installing SQL Server Management Tools
I have been trying for 2 days now to get the SQL Server management tools installed on client machines.  I'm starting to think it is not possible to do that the way we used to be able to with previous versions of SQL Server.  I have installed 3rd party open source software on my own machine so that I can query the database without logging onto the server directly and would like for my co-workers to be able to do the same.  As I mentioned we tried the SQL Server Management studio and all we get is a message saying to uninstall all the beta and Visual Studio *** on our machines.  We stripped one machine all the way down to the OS and still kept getting that message so I'm guessing it is some new Windows Vista issue that makes SQL Server 2005 client tools completely incompatible with XP.  However, we are not going to bow to Microsoft's evil ways and upgrade to their new OS just to use the SQL Server Studio.  If need be I will write my own software to workaround this problem.  In the meantime, can anyone recommend some good 3rd party tools that will allow us to query the SQL Server 2005 database on a server and preferably one that does not require all other software be removed first?

View Replies !

---

SQL Server Management Tools - Service Pack?
I've got the following installed on my local machine (XP Pro, sp 4, SQL 2000 tools)
Microsoft SQL Server Management Studio                                                                       9.00.1399.00
Microsoft Analysis Services Client Tools                                                               2005.090.1399.00
Microsoft Data Access Components (MDAC)                                                                  2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML                                                                 2.6 3.0 5.0 6.0
Microsoft Internet Explorer                                                               6.0.2900.2180
Microsoft .NET Framework                                                              2.0.50727.42
Operating System                                                                 5.1.2600

It keeps bomging and giving errors.

I can't find a specific service pack for the tools...maybe there isn't one?  Do I need to install the regular sp2 server service pack?

I'm confused.

View Replies !

---

SQL Server Management Tools Standard And Express
Can the SQL Server 2005 Management Studio interact with local SQL 2005 Express databases.  So can we use one management tool for both our server (non-local) SQL 2005 Databases and our local SQL 2005 Express databases (That the developers have free reign over). 
 
Any tips and tricks for this kind of setup? 
 
 

View Replies !

---

Can I Use SQL 2005 Management Studio To Connect To SQL 2000 Server?
Hi,Can I use SQL 2005 Management studio to connect to SQL 2000 server? 

View Replies !

---

SQL Server Management Studio Can't 'see' The 2005 Engine?? But Can See 2000 ?!?
Hello,I had SQL2000 server running fine on the windows 2003 box. I then installedSQL 2005 Express. They both worked together fine. I then uninstalled SQL2005 Express and installed SQL 2005 Server. But when I open SQL ServerManagement Studio, I can only connect to the SQL 2000 engine. In the Objectexplorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I cansee the existing SQL 2000 databases).How can I get SQL Server Management Studio to 'see' the SQL 2005 databaseengine so I can create tables? I *think* its running because there is the'sqlservr.exe' process running, and during installation there is no issues.When I open SQL Server Management Studio, I choose 'Database Engine', thenmy local Servername with Windows Authentication. How do I connect to the SQL2005 instance?Thanks,Jack.

View Replies !

---

SQL 2005 Management Studio Express And SQL Server 2000
Can I use SQL 2005 Management Studio Express to manage my SQL Server 2000 dbs? Currently I have SQL Enterprise Manager Version 8.0 installed and was thinking I'd like to install and use SQL 2005 Management Studio Express instead. This doable?

View Replies !

---

SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.

Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC.  Any expected
    problems when running both 2000 and 2005 SQL Server at the same database server?
3.  What is the best configuration for running SQL Server 2005 when we have old 2000 databases?  Upgade or not upgrade?  

TIA,
Jeffrey

View Replies !

---

How To Create A Data Diagram In SQL Server 2005 Management Studio For A SQL Server 2000 Database
Hello:
I have an old database created in SQL Server 2000,
now I can open, access it in SQL Server 2005 Management Studio, but I can't create Data Diagrams.
Please advise on how to make it work....
Thank you

View Replies !

---

Is SQL Server 2005 Management Studio (client Components Only) Is Compatible With Windows Server 2000?
Hi,
 
Pls let me know if SQL Server 2005 Management Studio (client tools only) is compatible with Windows Server 2000 or not?
 
Thanks in advance.
 
Regards,
Bhuvana

View Replies !

---

Using SQL Server Management Studio Tools To Manage Dbs On SQL Server Express Edition
Hopefully a simple question:  Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services?  I don't need directions, just whether or not it is permitted.
 
I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out.  I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition.
 
Thank you in advance for your help.

View Replies !

---

SQL Server 2005 And Management Studio Driving Me CRAZY -Im UPGRADING To 2000
Is it just me, or are features missing in Management Studio? I mean, where is the "Export Objects" option when exporting data? Why is it so difficult to register a remote server? Why do the object views suck? And most important, why is the documentation  the worst software documentation I have EVER SEEN?!
Things that were easy in Enterprise Manager with Client Network Utility and Query Analyzer seem impossible, difficult, or maybe just hidden in Management Studio. If it is there, the documentation sure doesnt tell you how to find it.
Please someone tell me that it's just me. Tell me that the features are there but Im not doing something right. I feel like putting my head in between my door opening and banging the door against it.

View Replies !

---

When I Try To Start SQL SERVER 2005 Its Give Me This ERROR MESSAGE:
when i try to start SQL SERVER 2005 its give me this ERROR MESSAGE:

"The service did not respond to the start or control  request in atimely fashion ,you need administrator privileges to be able to start/stop this servic.(SQLSAC)"

Notes: am login in as system administrator with full previligies,

its was work normally ,but after i made update for windows then this error hapen after windwos repair.

View Replies !

---

When I Try To Start SQL SERVER 2005 Its Give Me This ERROR MESSAGE:
 

when i try to start SQL SERVER 2005 its give me this ERROR MESSAGE:

"The service did not respond to the start or control  request in atimely fashion ,you need administrator privileges to be able to start/stop this servic.(SQLSAC)"

Notes: am login in as system administrator with full previligies,

its was work normally ,but after i made update for windows then this error hapen after windwos repair.

View Replies !

---

SQL Server Express 2008 - Missing Client Tools / Management Studio / Profiler
 

I downloaded and performed a full install of SQL Server Express 2008 Nov CTP. It was installed on a fresh installation of Windows Vista Enterprise x64.
 
During setup, I checked the 'Client Tools' box which has the description:
"Includes management and development tools: SQL Server Management Studio, SQL Server Configuration Manager, SQL Server Profiler, and Database Engine Tuning Advisor"
 
The installation ran fine with no errors. After install I looked for the Management Studio but couldnt find it anywhere. No SQL Server Profiler or Database Tuning Advisor either. The only tool that appears to have installed is the SQL Server Configuration Manager.
 
If I check my Start Menu, the only 2008 items that exist are
Microsoft SQL Server 2008 >

Configuration Tools >

SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Installation Center
 
I checked the summary log and everythign PASSED:
Package results:
  Passed
Execution statistics:
  Exit code:                     0x00000000
  Exit message:                  Passed
  Package start time:            12/13/2007 14:05:39
  Package end time:              12/13/2007 14:09:06
  Package install location:      c:Program Files (x86)Microsoft SQL Server100Setup Bootstrap
  Package initial action:        Install
  Media source location:         Install
  Media version:                 10.0.1075.23
Machine properties:
  Machine name:                  xxx
  Machine processor count:       2
  OS version:                    Windows Vista
  OS service pack:              
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          32 Bit
Properties provided in package.xml file:
  LegalProductName:              SQL Server Database Services 2008
  Description:                   SQL Server Database Services 2008
  Details:                       Install for SQL Server Database Services 2008
  ProductName:                   SQL2008
  Version:                       10
  SPLevel:                       0
  KBArticle:                     KB876234
  KBArticleHyperlink:            http://support.microsoft.com/?kbid=876234
Command line arguments provided:
  ACTION:                        Install
  INSTANCEIDSUFFIX:             
Product features discovered:
  Product:                       SQL2005
  Product:                       SQL2008
Feature status after execution:
  Database Engine Services: Passed
  Replication: Passed
  Client Tools: Passed
Windows Installer logs generated during execution:
  C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Snac_Cpu64_1.log
  C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Msxml6_Cpu64_1.log
  C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Tools_Cpu32_1.log
  C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_SqlWriter_Cpu64_1.log
  C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_SqlBrowser_Cpu32_1.log
  C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Sql_Cpu32_1.log

 

What is the issue here?
 

View Replies !

---

Error Installation SQL Server Management Studio 2005
Could anyone please help me out. I have tried to install the file SQLServer2005_SSMSEE.msi. Everything goes fine untill right at the end I get this error message:
 

An error occured during the installation of assembly 'Microsoft.VisualStudio.VSHelp80,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a", FileVersion="8.0.50727.42". Please refer to Help and Support for more information. HRESULT: 0x80070020.
 
Then the installation is rolled back.
Thanks for your help in advance.
Paik

View Replies !

---

SQL Server Management Studio Express Will No Longer Start
I used to have both SQL Server 2005 Express and SQL Server Management Studio Express up  running just fine until I installed (removed SQL 2005 Express) SQL Server 2005 for Developers and re-installed SQL Server Management Studio Express - now, SQL Server 2005 for Developers works, but I can not start SQL Server Management Studio Express? No error messages, simply nothing happens when I execute ssmsee.exe.  Should I be using a different version of Studio?

Thanks, Tor

 

View Replies !

---

2000 DTS Packages Corrupted By 2005 Client Tools?
Hi,

I have many sql 2000 DTS packages that I support from my development workstation  running v2000 sp4. Packages are altered on the development machine and then go through a normal release mechanisms to production via testing servers etc.

I have recently installed the client tools for SQL Server 2005 on my desktop to evaluate the product.  The 2005 DB instance is running on a seperate server.

So, I have dev edition of sql 2000 and 2005 client tools (including BI Dev studio etc) on my workstation.

I have recently had to make changes to a 2000 DTS package and used my 2000 enterprise manager to do so. No Problem- saved and tested fine on my workstation. 

But when I try and release it to another server, or open the package using enterprise manager from another machine that does not have sql 2005 installed - I get an error message 'Unspecified error'.  This I've seen before when trying to open packages created in v2000 , using v7 or where the service packs are different between machines.

Digging around my workstation and comparing some of the DLLs I know to be required to distribute DTS  packages (from RDIST.txt) it seems that some of the SQL 2000 dll files have been updated by my 2005 installation. 

E.g

DTSFFILE.DLL on my machine is 2000.85.1054.0 whilst on any 'clean' 2000 machine is at version v2000.80.760.0

Surely it cant be right that SQL 2005 has newer versions of components for SQL 2000 than is available with the latest SP for the actual product! Especially considering that the installation of 2005 does not even allow you to edit 2000 DTS packages through the management studio without a 'special' download' of the feature pack,(whihc by the way does not work very well either)

So am I to conclude that you can not run side by side installations of SQL 2000 and 2005 on a single machine and expect 2000 to run as it did previously

View Replies !

---

Error 9004 On Start. SQl Server Fails To Start
Hi

I have a SQL Server 2000 instance that has been running fine for months, but this morning it refuses to start. The event log shows error messages "Error 9004, Severity 21, State 1". I've tried starting SQL Server in minimal server mode, but this doesn't help either.

It looks to me like the master database is corrupt. Can anyone tell me if that's a fair assessment and if there is a quick recovery from this one.

Thanks

Malcolm

BTW: The error log file shows the following...

2004-06-14 10:16:24.49 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: Service Pack 3)

2004-06-14 10:16:24.50 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-06-14 10:16:24.50 server All rights reserved.
2004-06-14 10:16:24.50 server Server Process ID is 2384.
2004-06-14 10:16:24.52 server Logging SQL Server messages in file 'e:mssqlMSSQLlogERRORLOG'.
2004-06-14 10:16:24.52 server Warning: -f command line flag used...minimal server configured.
2004-06-14 10:16:24.53 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2004-06-14 10:16:24.69 server SQL Server configured for fiber mode processing.
2004-06-14 10:16:24.71 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2004-06-14 10:16:24.80 server MS DTC initialization skipped because of start up option.
2004-06-14 10:16:24.80 spid3 Warning ******************
2004-06-14 10:16:24.82 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-06-14 10:16:24.83 spid3 Starting up database 'master'.
2004-06-14 10:16:24.85 spid3 Error: 9004, Severity: 21, State: 1.
2004-06-14 10:16:24.86 spid3 06/14/04 10:16:24 Stack Overflow Dump not possible - Exception c00000fd E at 0x00444B1F
2004-06-14 10:16:24.86 spid3 Address=444b1f Exception Code = c00000fd
2004-06-14 10:16:24.88 spid3 eax=00000000 ebx=00000000

View Replies !

---

Reporting Services 2005 And SQL Server Management Studio Connection Error
I have installed multiple instances of SSRS on same server with different database. I can go to the report server URL for both SSRS and run reports. But I cannot connect to the 2nd instance through "SQL Server Management Studio". Also
I am getting following error when I try to connect to the "Reporting services configuration" tool from a remote machine

 



Code Block
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Management.ManagementException: Not found
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.PropertyData.RefreshPropertyInfo()
   at System.Management.PropertyDataCollection.get_Item(String propertyName)
   at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName)
   at System.Management.ManagementBaseObject.get_Item(String propertyName)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.get_IsSharePointIntegrated()
   at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
   at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
   at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
   at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
   at System.Windows.Forms.Form.set_Active(Boolean value)
   at System.Windows.Forms.Form.WmActivate(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RSConfigTool
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.ServiceProcess
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
 
 

View Replies !

---

Updates To SQLServer 2000 DLL's When 2005 Client Tools Installed
Hi,

I have many sql 2000 DTS packages that I support from my development workstation  running v2000 sp4. Packages are altered on the development machine and then go through a normal release mechanisms to production via testing servers etc.

I have recently installed the client tools for SQL Server 2005 on my desktop to evaluate the product.  The 2005 DB instance is running on a seperate server.

So, I have dev edition of sql 2000 and 2005 client tools (including BI Dev studio etc) on my workstation.

I have recently had to make changes to a 2000 DTS package and used my 2000 enterprise manager to do so. No Problem- saved and tested fine on my workstation. 

But when I try and release it to another server, or open the package using enterprise manager from another machine that does not have sql 2005 installed - I get an error message 'Unspecified error'.  This I've seen before when trying to open packages created in v2000 , using v7 or where the service packs are different between machines.

Digging around my workstation and comparing some of the DLLs I know to be required to distribute DTS  packages (from RDIST.txt) it seems that some of the SQL 2000 dll files have been updated by my 2005 installation. 

E.g

DTSFFILE.DLL on my machine is 2000.85.1054.0 whilst on any 'clean' 2000 machine is at version v2000.80.760.0

Surely it cant be right that SQL 2005 has newer versions of components for SQL 2000 than is available with the latest SP for the actual product! Especially considering that the installation of 2005 does not even allow you to edit 2000 DTS packages through the management studio without a 'special' download' of the feature pack,(whihc by the way does not work very well either)

So am I to conclude that you can not run side by side installations of SQL 2000 and 2005 on a single machine and expect 2000 to run as it did previously !!!

View Replies !

---

Error Running Script: 80sp4-tools.sql Installing Sql 2000 SP4
Hello there,

 

I hope someone can help me with an annoying failure.

 

While installing sp4, the last running script is going very wrong.

 

"Error running script: 80sp4-tools.sql"

 

in the sqlsp.log, there is only an item with Process Exit Code: (1) after 80sp4-tools.sql

 

this is the log file.

 

14:15:05 Begin Setup
14:15:05 Version on Media: 8.00.2039
14:15:05 Mode = Normal
14:15:05 ModeType = NORMAL
14:15:06 Loading library - sqlsut.dll (#L1)
14:15:06 Begin: SetupInitialize()
14:15:06 End: SetupInitialize()
14:15:06 Begin:  CheckFixedRequirements()
14:15:06 Platform ID: 0xf000
14:15:06 Version: 5.2.3790
14:15:06 File Version - C:WINDOWSsystem32shdocvw.dll: 6.0.3790.2858
14:15:06 End:  CheckFixedRequirements()
14:15:06 Begin Action:  CheckRequirements
14:15:06 Processor Architecture: x86 (Pentium)
14:15:06 Service Pack:  256
14:15:06 ComputerName: SERVER01
14:15:06 User Name: administrator
14:15:06 IsAllAccessAllowed returned: 1
14:15:06 OS Language: 0x409
14:15:06 End Action CheckRequirements
14:15:06 CreateSetupTopology(SERVER01), Handle : 0x14d46c8, returned : 0
14:15:06 CreateSetupTopology returned : 0, Handle : 0x14d46c8
14:15:06 Topology Type : 1, Return Value : 0
14:15:06 ST_GetPhysicalNode returned : 0, PNHandle : 0x14d4708
14:15:06 PN_EnumerateEx returned : 0
14:15:06 PN_GetSQLStates returned : 0, SqlStates : 0x88020024
14:15:06 PN_StartScan [0x14d4708] returned : 0
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d55c0]
14:15:06 SQLI_GetPackageId [0x14d55c0] returned : 0, PackageId = 0x2
14:15:06 SQLI_GetVersion [0x14d55c0] returned : 0, Version = 8.00.194
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d5f48]
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d6878]
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d7180]
14:15:06 PN_GetNext [0x14d4708] returned : 18, Handle: [0x0]
14:15:06 ReleaseSetupTopology
14:15:06 This combination of Package and Operating System allows a full product install.
14:15:06 Begin:  SetupInstall()
14:15:06 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir ...
14:15:06 CommonFilesDir=C:Program FilesCommon Files
14:15:06 Windows Directory=C:WINDOWS
14:15:06 Program Files=C:Program Files
14:15:06 TEMPDIR=C:DOCUME~1ADMINI~1LOCALS~1Temp
14:15:06 End:  SetupInstall()
14:15:06 Begin:  ShowDialogs()
14:15:06 Initial Dialog Mask: 0x8300037, Disable Back=0x1
14:15:06 Begin Action ShowDialogsHlpr: 0x1
14:15:06 Begin Action:  DialogShowSdWelcome
14:15:07 End Action  DialogShowSdWelcome
14:15:07 Dialog 0x1 returned: 1
14:15:07 End Action ShowDialogsHlpr
14:15:07 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
14:15:07 Begin Action ShowDialogsHlpr: 0x2
14:15:07 Begin Action:  DialogShowSdMachineName
14:15:07 ShowDlgMachine returned: 1
14:15:07 Name = SERVER01, Type = 0x1
14:15:07 End Action  DialogShowSdMachineName
14:15:07 begin ShowDialogsUpdateMask
14:15:07 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 0
14:15:07 Updated Dialog Mask: 0xbf00035, Disable Back = 0x1
14:15:07 Dialog 0x2 returned: 0
14:15:07 End Action ShowDialogsHlpr
14:15:07 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
14:15:07 Begin Action ShowDialogsHlpr: 0x4
14:15:07 Begin Action:  DialogShowSdInstallMode
14:15:07 ShowDlgInstallMode returned: 1
14:15:07 InstallMode : 0x2
14:15:07 End Action  DialogShowSdInstallMode
14:15:07 begin ShowDialogsUpdateMask
14:15:07 nFullMask = 0xbf00035, nCurrent = 0x4, nDirection = 1
14:15:07 Updated Dialog Mask: 0xb000627, Disable Back = 0x1
14:15:07 Dialog 0x4 returned: 1
14:15:07 End Action ShowDialogsHlpr
14:15:07 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
14:15:07 Begin Action ShowDialogsHlpr: 0x20
14:15:07 Begin Action:  DialogShowSdLicense
14:15:08 End Action DialogShowSdLicense
14:15:08 Dialog 0x20 returned: 1
14:15:08 End Action ShowDialogsHlpr
14:15:08 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
14:15:08 Begin Action ShowDialogsHlpr: 0x200
14:15:08 Begin Action:  DialogShowSdInstanceName
14:15:08 Begin Action: ShowDlgInstanceName
14:15:09 This machine has SQL Server 2000 SP3 already installed
14:15:09 Version of installed Service Pack: 8.00.761
14:15:09 The language on the CD is 1033 and installed is 1033
14:15:09 End Action : Verify Language
14:15:09 SKU is : Standard Edition
14:15:09 End Action: ShowDlgInstanceName
14:15:09 ShowDlgInstanceName returned : 0
14:15:09 InstanceName : INSTNAME
14:15:09 End Action  DialogShowSdInstanceName
14:15:09 begin ShowDialogsUpdateMask
14:15:09 nFullMask = 0xb000627, nCurrent = 0x200, nDirection = 0
14:15:09 Updated Dialog Mask: 0xbc00627, Disable Back = 0x1
14:15:09 Dialog 0x200 returned: 0
14:15:09 End Action ShowDialogsHlpr
14:15:09 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
14:15:09 Begin Action ShowDialogsHlpr: 0x400
14:15:09 Begin Action:  DialogShowSdMaintain
14:15:09 ShowDlgMaintainInstall returned : 1
14:15:09 Type : 0xc
14:15:09 CreateSetupTopology(SERVER01), Handle : 0x14d5f08, returned : 0
14:15:09 CreateSetupTopology returned : 0, Handle : 0x14d5f08
14:15:09 Topology Type : 1, Return Value : 0
14:15:09 ST_GetPhysicalNode returned : 0, PNHandle : 0x14d46c8
14:15:09 PN_EnumerateEx returned : 0
14:15:09 PN_GetSQLStates returned : 0, SqlStates : 0x88020024
14:15:09 PN_GetInstance for INSTNAME [0x14d46c8] returned : 0
14:15:09 SQLI_GetPackageId [0x14d55c0] returned : 0, PackageId = 0x2
14:15:09 SQLI_GetVersion [0x14d55c0] returned : 0, Version = 8.00.194
14:15:09 SQLI_GetSQLStates for INSTNAME [0x14d55c0] returned : 0, SQLStates: 0xc20804
14:15:09 SQLI_GetInstallPath [0x14d55c0] returned : 0, Path = C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 SQLI_GetDataPath [0x14d55c0] returned : 0, DataPath = C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 SQLI_GetVersion [0x14d55c0] returned : 0, Version = 8.00.194
14:15:09 SQLI_GetRegKeyRoot [0x14d55c0] returned : 0, RegKeyRoot = SoftwareMicrosoftMicrosoft SQL ServerINSTNAME
14:15:09 SQLI_GetPackageName [0x14d55c0] returned : 0, szPackage = Standard Edition
14:15:09 SQLI_GetPackageId [0x14d55c0] returned : 0, PackageId = 0x2
14:15:09 Previous Install Path:    C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 Previous Install Data:    C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 Previous Install Version: 8.00.194
14:15:09 ReleaseSetupTopology
14:15:09 End Action  DialogShowSdMaintain
14:15:09 begin ShowDialogsUpdateMask
14:15:09 nFullMask = 0xbc00627, nCurrent = 0x400, nDirection = 1
14:15:09 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:15:09 Dialog 0x400 returned: 1
14:15:10 End Action ShowDialogsHlpr
14:15:10 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
14:15:10 Begin Action ShowDialogsHlpr: 0x2000
14:15:10 Begin Action:  DialogShowSdUpgrade
14:15:10 ShowDlgUpgrade returned : 1
14:15:10 Checking databases on instance 'INSTNAME'
14:15:10 Authenticate access
14:15:10 Begin SDPassword Dialog
14:15:13 End SDPassword Dialog
14:15:13 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Service MSSQL$INSTNAME 
14:15:13 Process Exit Code: (0)
14:15:13 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 1 -Service MSSQL$INSTNAME   -StartupOptions -T4022
14:16:03 Process Exit Code: (0)
14:16:03 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -n -d master -Q "exit" -o "C:DOCUME~1ADMINI~1LOCALS~1Tempsqlsp.out"  -Usa  -P"
14:16:04 Process Exit Code: (0)
14:16:04 Begin: CheckSAPassword
14:16:04 Begin: LogOnUsingBlankSA
14:16:04 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -n -d master -o "C:DOCUME~1ADMINI~1LOCALS~1Tempsqlsp.out" -Q"Exit(declare @ret int if (select count(*) from master..syslogins where name='sa' AND ( (1 = pwdcompare(N'', password)) OR password IS NULL )) = 0 Set @ret=0 else Set @ret=9000 Select @ret)"  -Usa  -P"
14:16:04 Process Exit Code: (0)
14:16:04 End: LogOnUsingBlankSA
14:16:04 Begin: SdBlankPwd
14:16:04 End: SdBlankPwd
14:16:04 End: CheckSAPassword
14:16:04 Begin : SdErrorReportingDlg
14:16:14 End: SdErrorReportingDlg
14:16:14 Access authenticated
14:16:14 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -n -b -d master -o "C:DOCUME~1ADMINI~1LOCALS~1Temp~sqldb0.txt" -i "C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBindbverify.sql" -Usa  -P"
14:16:37 Process Exit Code: (0)
14:16:37 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Service MSSQL$INSTNAME 
14:17:17 Process Exit Code: (0)
14:17:17 Setup Type: Custom (303)
14:17:18 Processing: SQLProg
14:17:18 Processing: SQLProgSQLServr
14:17:18 Processing: SQLProgUpgTools
14:17:18 Processing: SQLProgReplSupp
14:17:18 Processing: SQLProgInstall
14:17:18 Processing: SQLProgSystem
14:17:18 Processing: SQLProgSvrExt
14:17:18 Processing: SQLProgDat
14:17:18 Processing: SQLProgDatSmpl
14:17:18 Processing: SQLProgBaseSys
14:17:18 Processing: SQLProgBaseBinn
14:17:18 Processing: SQLProgMSSearch
14:17:18 Processing: SQLProgBaseInst
14:17:18 Processing: SQLProgUI
14:17:18 Processing: SQLProgSymbols
14:17:18 Processing: SQLProgPerfmon
14:17:18 Processing: SQLProgRoot
14:17:18 Processing: SQLProgEXE
14:17:18 Processing: SQLProgDLL
14:17:18 Processing: MgtTool
14:17:18 Processing: MgtToolSEM
14:17:18 Processing: MgtToolProfiler
14:17:18 Processing: MgtToolQryanlz
14:17:18 Processing: MgtToolDTCCLi
14:17:18 Processing: MgtToolWzcnflct
14:17:18 Processing: MgtToolUtilSys
14:17:18 Processing: MgtToolUtilBinn
14:17:18 Processing: Connect
14:17:18 Processing: ConnectConnSys
14:17:18 Processing: Books
14:17:18 Processing: BooksBookso
14:17:18 Processing: DevTools
14:17:18 Processing: DevToolsHeaders and Libraries
14:17:18 Processing: DevToolsMDAC SDKs
14:17:18 Processing: DevToolsVDI
14:17:18 Processing: DevToolsDbg Int
14:17:18 Processing: Samples
14:17:18 Processing: SamplesADO
14:17:18 Processing: SamplesDBLIB
14:17:18 Processing: SamplesDesktop
14:17:18 Processing: SamplesDTS
14:17:18 Processing: SamplesESQLC
14:17:18 Processing: SamplesMisc
14:17:18 Processing: SamplesMSDTC
14:17:18 Processing: SamplesODBC
14:17:18 Processing: SamplesODS
14:17:18 Processing: SamplesOLEAut
14:17:18 Processing: SamplesRepl
14:17:18 Processing: SamplesSilverstoneDB
14:17:18 Processing: SamplesSQLDMO
14:17:18 Processing: SamplesSQLNS
14:17:18 Processing: SamplesUtils
14:17:18 Processing: SamplesXML
14:17:18 Processing: CoreRepl
14:17:18 Processing: CoreReplRes1033
14:17:18 Processing: CoreReplResIntl
14:17:18 Processing: Core
14:17:18 Processing: CoreRes1033
14:17:18 Processing: CoreResOther
14:17:18 Processing: Repostry
14:17:18 Processing: RepostryRepstSys
14:17:18 Processing: RepostryRes1033
14:17:18 Processing: RepostryResIntl
14:17:18 Processing: CoreMisc
14:17:18 Processing: CoreMiscActiveX
14:17:18 Processing: CoreMiscRes1033
14:17:18 Processing: Monarch
14:17:18 Processing: MonarchMonr1033
14:17:18 Processing: MonarchMonrIntl
14:17:18 Processing: Jet
14:17:18 Processing: CoreInst
14:17:18 Processing: CoreCOM
14:17:18 Processing: CoreCOMRes1033
14:17:18 Processing: CoreCOMResIntl
14:17:18 Processing: CoreTool
14:17:18 Processing: CoreToolRes1033
14:17:18 Processing: CoreToolResOther
14:17:18 Processing: DBLibCli
14:17:18 Processing: SFExt
14:17:18 Processing: SFExtActiveX
14:17:18 Processing: SFExtRes1033
14:17:18 Processing: SFExtResIntl
14:17:18 Processing: Trace
14:17:18 Processing: TraceRes1033
14:17:18 Processing: TraceResOther
14:17:18 Processing: CnctBinn
14:17:18 Processing: MiscCore
14:17:18 Processing: MC
14:17:18 Processing: MCMC1033
14:17:18 Processing: MCMCIntl
14:17:18 Processing: MCHelp
14:17:18 Processing: UI
14:17:18 Processing: UIUIHlp
14:17:18 Processing: UIUI1033
14:17:18 Processing: UIUIIntl
14:17:18 Processing: ClstSys
14:17:18 Processing: SQLMgr
14:17:18 Processing: SQLMgrRes1033
14:17:18 Processing: SQLMgrResIntl
14:17:18 Processing: SvrTool
14:17:18 Processing: SvrToolRes1033
14:17:18 Processing: SvrToolResIntl
14:17:18 Processing: DTSUI
14:17:18 Processing: DTSUIRes1033
14:17:18 Processing: DTSUIResIntl
14:17:18 Processing: ClFTSys
14:17:18 Processing: ClFtdata
14:17:18 Processing: MSOlap
14:17:18 Processing: MSOlapRes1033
14:17:18 Processing: MSOlapResIntl
14:17:18 Processing: ATL
14:17:18 Processing: ATLwinnt
14:17:18 Processing: ATLwin9x
14:17:18 Processing: MFC42U
14:17:18 Processing: VC
14:17:18 Processing: VB
14:17:18 Processing: OCX1
14:17:18 Processing: SQLAdHlp
14:17:18 Processing: SQLAdHlpRes1033
14:17:18 Processing: SQLAdHlpResOther
14:17:18 Setup type: Custom
14:17:18 End Action DialogShowSdUpgrade
14:17:18 begin ShowDialogsUpdateMask
14:17:18 nFullMask = 0xb002627, nCurrent = 0x2000, nDirection = 1
14:17:18 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:18 Dialog 0x2000 returned: 1
14:17:18 End Action ShowDialogsHlpr
14:17:18 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
14:17:18 Begin Action ShowDialogsHlpr: 0x1000000
14:17:18 Begin Action:  DlgCollation
14:17:18 ShowDlgCollation returned: 1
14:17:18 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
14:17:18 End Action DlgCollation
14:17:18 begin ShowDialogsUpdateMask
14:17:18 nFullMask = 0xb002627, nCurrent = 0x1000000, nDirection = 1
14:17:18 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:18 Dialog 0x1000000 returned: 1
14:17:18 End Action ShowDialogsHlpr
14:17:18 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
14:17:18 Begin Action ShowDialogsHlpr: 0x2000000
14:17:18 Begin Action:  DlgNetwork
14:17:18 ShowDlgNetwork returned: 1
14:17:18 [DlgServerNetwork]
14:17:18 NetworkLibs = 255
14:17:18 TCPPort = 0
14:17:18 TCPPrxy = Default
14:17:18 NMPPipeName = \.pipeMSSQL$INSTNAMEsqlquery
14:17:18 Result = 1
14:17:18 End Action DlgNetwork
14:17:18 begin ShowDialogsUpdateMask
14:17:18 nFullMask = 0xb002627, nCurrent = 0x2000000, nDirection = 1
14:17:18 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:18 Dialog 0x2000000 returned: 1
14:17:18 End Action ShowDialogsHlpr
14:17:18 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
14:17:18 Begin Action ShowDialogsHlpr: 0x8000000
14:17:18 Begin Action:  DialogShowSdStartCopy
14:17:34 End Action DialogShowSdStartCopy
14:17:34 begin ShowDialogsUpdateMask
14:17:34 nFullMask = 0xb002627, nCurrent = 0x8000000, nDirection = 1
14:17:34 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:34 Dialog 0x8000000 returned: 1
14:17:34 End Action ShowDialogsHlpr
14:17:34 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
14:17:34 End: ShowDialogs()
14:17:34 Initializing Event Log
14:17:34 Begin Action : LogEvent
14:17:34 End Action : LogEvent
14:17:34 Begin:  ProcessBeforeDataMove()
14:17:35 DeinstallStart returned (C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME): 0
14:17:35 End:  ProcessBeforeDataMove()
14:17:35 Begin:  SetToolsComponentSelection()
14:17:35 CreateSetupTopology(SERVER01), Handle : 0x14d5ee8, returned : 0
14:17:35 CreateSetupTopology returned : 0, Handle : 0x14d5ee8
14:17:35 Topology Type : 1, Return Value : 0
14:17:35 ST_GetPhysicalNode returned : 0, PNHandle : 0x14d46c8
14:17:35 PN_EnumerateEx returned : 0
14:17:35 PN_GetSQLStates returned : 0, SqlStates : 0x88020024
14:17:35 PN_StartScan [0x14d46c8] returned : 0
14:17:35 PN_GetNext [0x14d46c8] returned : 18, Handle: [0x0]
14:17:35 No more items in enumeration.
14:17:35 ReleaseSetupTopology
14:17:35 End:  SetToolsComponentSelection()
14:17:35 Begin:  ProcessComponentSelection()
14:17:35 End:  ProcessComponentSelection()
14:17:35 Begin:  LogSelectedComponents()
14:17:35 Processing: SQLProg
14:17:35 Selected: SQLProg
14:17:35 Processing: SQLProgSQLServr
14:17:35 Selected: SQLProgSQLServr
14:17:35 Processing: SQLProgSQLServrHelp
14:17:35 Selected: SQLProgSQLServrHelp
14:17:35 Processing: SQLProgSQLServrSCMDev
14:17:35 Selected: SQLProgSQLServrSCMDev
14:17:35 Processing: SQLProgSQLServrSCMDevSCMh
14:17:35 Selected: SQLProgSQLServrSCMDevSCMh
14:17:35 Processing: SQLProgSQLServrSCMDevSCMX86Lb
14:17:35 Selected: SQLProgSQLServrSCMDevSCMX86Lb
14:17:35 Processing: SQLProgSQLServrSCMDevSCMALb
14:17:35 Selected: SQLProgSQLServrSCMDevSCMALb
14:17:35 Processing: SQLProgSQLServrRs1033
14:17:35 Selected: SQLProgSQLServrRs1033
14:17:35 Processing: SQLProgSQLServrRsIntl
14:17:35 Selected: SQLProgSQLServrRsIntl
14:17:35 Processing: SQLProgSQLServrActiveX
14:17:35 Selected: SQLProgSQLServrActiveX
14:17:35 Processing: SQLProgSQLServrSystem
14:17:35 Selected: SQLProgSQLServrSystem
14:17:35 Processing: SQLProgSQLServrWatson
14:17:35 Selected: SQLProgSQLServrWatson
14:17:35 Processing: SQLProgSQLServrWatsonWatson1033
14:17:35 Selected: SQLProgSQLServrWatsonWatson1033
14:17:35 Processing: SQLProgSQLServrWatsonWatsonOther
14:17:35 Selected: SQLProgSQLServrWatsonWatsonOther
14:17:35 Processing: SQLProgSQLServrMSXMLSQL
14:17:35 Selected: SQLProgSQLServrMSXMLSQL
14:17:35 Processing: SQLProgSQLServrMSXMLSQLRes1033
14:17:35 Selected: SQLProgSQLServrMSXMLSQLRes1033
14:17:35 Processing: SQLProgSQLServrMSXMLSQLResIntl
14:17:35 Selected: SQLProgSQLServrMSXMLSQLResIntl
14:17:35 Processing: SQLProgUpgTools
14:17:35 Processing: SQLProgUpgToolsUpgSys
14:17:35 Processing: SQLProgUpgToolsActiveX
14:17:35 Processing: SQLProgUpgToolsRes1033
14:17:35 Processing: SQLProgUpgToolsResOther
14:17:35 Processing: SQLProgUpgToolsResld
14:17:35 Processing: SQLProgReplSupp
14:17:35 Selected: SQLProgReplSupp
14:17:35 Processing: SQLProgReplSuppReplDat
14:17:35 Selected: SQLProgReplSuppReplDat
14:17:35 Processing: SQLProgReplSuppRepComm
14:17:35 Selected: SQLProgReplSuppRepComm
14:17:35 Processing: SQLProgReplSuppRepNoDk
14:17:35 Selected: SQLProgReplSuppRepNoDk
14:17:35 Processing: SQLProgReplSuppActiveX
14:17:35 Selected: SQLProgReplSuppActiveX
14:17:35 Processing: SQLProgInstall
14:17:35 Selected: SQLProgInstall
14:17:35 Processing: SQLProgSystem
14:17:35 Selected: SQLProgSystem
14:17:35 Processing: SQLProgSvrExt
14:17:35 Selected: SQLProgSvrExt
14:17:35 Processing: SQLProgSvrExtHelp
14:17:35 Selected: SQLProgSvrExtHelp
14:17:35 Processing: SQLProgSvrExtSvrExtRs
14:17:35 Selected: SQLProgSvrExtSvrExtRs
14:17:35 Processing: SQLProgSvrExtResIntl
14:17:35 Selected: SQLProgSvrExtResIntl
14:17:35 Processing: SQLProgDat
14:17:35 Processing: SQLProgDatSmpl
14:17:35 Processing: SQLProgBaseSys
14:17:35 Selected: SQLProgBaseSys
14:17:35 Processing: SQLProgBaseBinn
14:17:35 Selected: SQLProgBaseBinn
14:17:35 Processing: SQLProgMSSearch
14:17:35 Selected: SQLProgMSSearch
14:17:35 Processing: SQLProgMSSearchHelp
14:17:35 Selected: SQLProgMSSearchHelp
14:17:35 Processing: SQLProgMSSearchActiveX
14:17:35 Selected: SQLProgMSSearchActiveX
14:17:35 Processing: SQLProgBaseInst
14:17:35 Selected: SQLProgBaseInst
14:17:35 Processing: SQLProgUI
14:17:35 Processing: SQLProgSymbols
14:17:35 Selected: SQLProgSymbols
14:17:35 Processing: SQLProgSymbolsEXE
14:17:35 Selected: SQLProgSymbolsEXE
14:17:35 Processing: SQLProgSymbolsDLL
14:17:35 Selected: SQLProgSymbolsDLL
14:17:35 Processing: SQLProgPerfmon
14:17:35 Selected: SQLProgPerfmon
14:17:35 Processing: SQLProgPerfmonSystem
14:17:35 Selected: SQLProgPerfmonSystem
14:17:35 Processing: SQLProgRoot
14:17:35 Processing: SQLProgEXE
14:17:35 Processing: SQLProgDLL
14:17:35 Processing: MgtTool
14:17:35 Selected: MgtTool
14:17:35 Processing: MgtToolSEM
14:17:35 Selected: MgtToolSEM
14:17:35 Processing: MgtToolSEMHTML
14:17:35 Selected: MgtToolSEMHTML
14:17:35 Processing: MgtToolSEMMSD98
14:17:35 Selected: MgtToolSEMMSD98
14:17:35 Processing: MgtToolSEMMSD98SYS
14:17:35 Selected: MgtToolSEMMSD98SYS
14:17:35 Processing: MgtToolSEMMSD98Res
14:17:35 Selected: MgtToolSEMMSD98Res
14:17:35 Processing: MgtToolSEMMSD98Hlp
14:17:35 Selected: MgtToolSEMMSD98Hlp
14:17:35 Processing: MgtToolSEMHelp
14:17:35 Selected: MgtToolSEMHelp
14:17:35 Processing: MgtToolSEMRes1033
14:17:35 Selected: MgtToolSEMRes1033
14:17:35 Processing: MgtToolSEMResIntl
14:17:35 Selected: MgtToolSEMResIntl
14:17:35 Processing: MgtToolSEMMSD98RsI
14:17:35 Selected: MgtToolSEMMSD98RsI
14:17:35 Processing: MgtToolSEMActiveX
14:17:35 Selected: MgtToolSEMActiveX
14:17:35 Processing: MgtToolSEMActiveXRes1033
14:17:35 Selected: MgtToolSEMActiveXRes1033
14:17:35 Processing: MgtToolSEMActiveXResIntl
14:17:35 Selected: MgtToolSEMActiveXResIntl
14:17:35 Processing: MgtToolSEMScripts
14:17:35 Selected: MgtToolSEMScripts
14:17:35 Processing: MgtToolSEMOLEDB
14:17:35 Selected: MgtToolSEMOLEDB
14:17:35 Processing: MgtToolSEMOLEDBRes1033
14:17:35 Selected: MgtToolSEMOLEDBRes1033
14:17:35 Processing: MgtToolSEMOLEDBResIntl
14:17:35 Selected: MgtToolSEMOLEDBResIntl
14:17:35 Processing: MgtToolSEMMSD7
14:17:35 Selected: MgtToolSEMMSD7
14:17:35 Processing: MgtToolSEMMSD7Res
14:17:35 Selected: MgtToolSEMMSD7Res
14:17:35 Processing: MgtToolSEMMSD7RsI
14:17:35 Selected: MgtToolSEMMSD7RsI
14:17:35 Processing: MgtToolProfiler
14:17:35 Selected: MgtToolProfiler
14:17:35 Processing: MgtToolProfilerHelp
14:17:35 Selected: MgtToolProfilerHelp
14:17:35 Processing: MgtToolProfilerRes1033
14:17:35 Selected: MgtToolProfilerRes1033
14:17:35 Processing: MgtToolProfilerResIntl
14:17:35 Selected: MgtToolProfilerResIntl
14:17:35 Processing: MgtToolQryanlz
14:17:35 Selected: MgtToolQryanlz
14:17:35 Processing: MgtToolQryanlzHelp
14:17:35 Selected: MgtToolQryanlzHelp
14:17:35 Processing: MgtToolQryanlzRes1033
14:17:35 Selected: MgtToolQryanlzRes1033
14:17:35 Processing: MgtToolQryanlzResIntl
14:17:35 Selected: MgtToolQryanlzResIntl
14:17:35 Processing: MgtToolDTCCLi
14:17:35 Selected: MgtToolDTCCLi
14:17:35 Processing: MgtToolWzcnflct
14:17:35 Selected: MgtToolWzcnflct
14:17:35 Processing: MgtToolWzcnflctWzcnHlp
14:17:35 Selected: MgtToolWzcnflctWzcnHlp
14:17:35 Processing: MgtToolWzcnflctWzcn1033
14:17:35 Selected: MgtToolWzcnflctWzcn1033
14:17:35 Processing: MgtToolWzcnflctWzcnOthr
14:17:35 Selected: MgtToolWzcnflctWzcnOthr
14:17:35 Processing: MgtToolWzcnflctWzcnCmn
14:17:35 Selected: MgtToolWzcnflctWzcnCmn
14:17:35 Processing: MgtToolUtilSys
14:17:35 Selected: MgtToolUtilSys
14:17:35 Processing: MgtToolUtilBinn
14:17:35 Selected: MgtToolUtilBinn
14:17:35 Processing: Connect
14:17:35 Selected: Connect
14:17:35 Processing: ConnectConnSys
14:17:35 Selected: ConnectConnSys
14:17:35 Processing: Books
14:17:35 Selected: Books
14:17:35 Processing: BooksBookso
14:17:35 Selected: BooksBookso
14:17:35 Processing: BooksBooksoUtils
14:17:35 Selected: BooksBooksoUtils
14:17:35 Processing: DevTools
14:17:35 Selected: DevTools
14:17:35 Processing: DevToolsHeaders and Libraries
14:17:35 Processing: DevToolsHeaders and LibrariesInclude
14:17:35 Processing: DevToolsHeaders and LibrariesLibx86
14:17:35 Processing: DevToolsHeaders and LibrariesLibAlpha
14:17:35 Processing: DevToolsHeaders and LibrariesESQLC
14:17:35 Processing: DevToolsMDAC SDKs
14:17:35 Processing: DevToolsVDI
14:17:35 Processing: DevToolsVDIInc
14:17:35 Processing: DevToolsVDISamples
14:17:35 Processing: DevToolsDbg Int
14:17:35 Selected: DevToolsDbg Int
14:17:35 Processing: DevToolsDbg IntDbg Int Common
14:17:35 Selected: DevToolsDbg IntDbg Int Common
14:17:35 Processing: DevToolsDbg IntEXE
14:17:35 Selected: DevToolsDbg IntEXE
14:17:35 Processing: Samples
14:17:35 Processing: SamplesADO
14:17:35 Processing: SamplesDBLIB
14:17:35 Processing: SamplesDesktop
14:17:35 Processing: SamplesDTS
14:17:35 Processing: SamplesESQLC
14:17:35 Processing: SamplesMisc
14:17:35 Processing: SamplesMSDTC
14:17:35 Processing: SamplesODBC
14:17:35 Processing: SamplesODS
14:17:35 Processing: SamplesOLEAut
14:17:35 Processing: SamplesRepl
14:17:35 Processing: SamplesSilverstoneDB
14:17:35 Processing: SamplesSQLDMO
14:17:35 Processing: SamplesSQLNS
14:17:35 Processing: SamplesUtils
14:17:35 Processing: SamplesXML
14:17:35 Processing: CoreRepl
14:17:35 Selected: CoreRepl
14:17:35 Processing: CoreReplRes1033
14:17:35 Selected: CoreReplRes1033
14:17:35 Processing: CoreReplResIntl
14:17:35 Selected: CoreReplResIntl
14:17:35 Processing: Core
14:17:35 Selected: Core
14:17:35 Processing: CoreRes1033
14:17:35 Selected: CoreRes1033
14:17:35 Processing: CoreResOther
14:17:35 Selected: CoreResOther
14:17:35 Processing: Repostry
14:17:35 Selected: Repostry
14:17:35 Processing: RepostryRepstSys
14:17:35 Selected: RepostryRepstSys
14:17:35 Processing: RepostryRes1033
14:17:35 Selected: RepostryRes1033
14:17:35 Processing: RepostryResIntl
14:17:35 Selected: RepostryResIntl
14:17:35 Processing: CoreMisc
14:17:35 Selected: CoreMisc
14:17:35 Processing: CoreMiscActiveX
14:17:35 Selected: CoreMiscActiveX
14:17:35 Processing: CoreMiscActiveXRes1033
14:17:35 Selected: CoreMiscActiveXRes1033
14:17:35 Processing: CoreMiscActiveXResIntl
14:17:35 Selected: CoreMiscActiveXResIntl
14:17:35 Processing: CoreMiscRes1033
14:17:35 Selected: CoreMiscRes1033
14:17:35 Processing: Monarch
14:17:35 Selected: Monarch
14:17:35 Processing: MonarchMonr1033
14:17:35 Selected: MonarchMonr1033
14:17:35 Processing: MonarchMonrIntl
14:17:35 Selected: MonarchMonrIntl
14:17:35 Processing: Jet
14:17:35 Selected: Jet
14:17:35 Processing: CoreInst
14:17:35 Selected: CoreInst
14:17:35 Processing: CoreCOM
14:17:35 Selected: CoreCOM
14:17:35 Processing: CoreCOMRes1033
14:17:35 Selected: CoreCOMRes1033
14:17:35 Processing: CoreCOMResIntl
14:17:35 Selected: CoreCOMResIntl
14:17:35 Processing: CoreTool
14:17:35 Selected: CoreTool
14:17:35 Processing: CoreToolRes1033
14:17:35 Selected: CoreToolRes1033
14:17:35 Processing: CoreToolResOther
14:17:35 Selected: CoreToolResOther
14:17:35 Processing: DBLibCli
14:17:35 Selected: DBLibCli
14:17:35 Processing: SFExt
14:17:35 Selected: SFExt
14:17:35 Processing: SFExtActiveX
14:17:35 Selected: SFExtActiveX
14:17:35 Processing: SFExtActiveXRes1033
14:17:35 Selected: SFExtActiveXRes1033
14:17:35 Processing: SFExtActiveXResIntl
14:17:35 Selected: SFExtActiveXResIntl
14:17:35 Processing: SFExtRes1033
14:17:35 Selected: SFExtRes1033
14:17:35 Processing: SFExtResIntl
14:17:35 Selected: SFExtResIntl
14:17:35 Processing: Trace
14:17:35 Selected: Trace
14:17:35 Processing: TraceRes1033
14:17:35 Selected: TraceRes1033
14:17:35 Processing: TraceResOther
14:17:35 Selected: TraceResOther
14:17:35 Processing: CnctBinn
14:17:35 Processing: MiscCore
14:17:35 Selected: MiscCore
14:17:35 Processing: MC
14:17:35 Selected: MC
14:17:35 Processing: MCMC1033
14:17:35 Selected: MCMC1033
14:17:35 Processing: MCMCIntl
14:17:35 Selected: MCMCIntl
14:17:35 Processing: MCHelp
14:17:35 Selected: MCHelp
14:17:35 Processing: UI
14:17:35 Processing: UIUIHlp
14:17:35 Processing: UIUI1033
14:17:35 Processing: UIUIIntl
14:17:35 Processing: ClstSys
14:17:35 Processing: SQLMgr
14:17:35 Selected: SQLMgr
14:17:35 Processing: SQLMgrRes1033
14:17:35 Selected: SQLMgrRes1033
14:17:35 Processing: SQLMgrResIntl
14:17:35 Selected: SQLMgrResIntl
14:17:35 Processing: SvrTool
14:17:35 Selected: SvrTool
14:17:35 Processing: SvrToolRes1033
14:17:35 Selected: SvrToolRes1033
14:17:35 Processing: SvrToolResIntl
14:17:35 Selected: SvrToolResIntl
14:17:35 Processing: DTSUI
14:17:35 Selected: DTSUI
14:17:35 Processing: DTSUIRes1033
14:17:35 Selected: DTSUIRes1033
14:17:35 Processing: DTSUIResIntl
14:17:35 Selected: DTSUIResIntl
14:17:35 Processing: ClFTSys
14:17:35 Processing: ClFtdata
14:17:35 Processing: MSOlap
14:17:35 Selected: MSOlap
14:17:35 Processing: MSOlapRes1033
14:17:35 Selected: MSOlapRes1033
14:17:35 Processing: MSOlapResIntl
14:17:35 Selected: MSOlapResIntl
14:17:35 Processing: ATL
14:17:35 Selected: ATL
14:17:35 Processing: ATLwinnt
14:17:35 Selected: ATLwinnt
14:17:35 Processing: ATLwin9x
14:17:35 Selected: ATLwin9x
14:17:35 Processing: MFC42U
14:17:35 Selected: MFC42U
14:17:35 Processing: VC
14:17:35 Selected: VC
14:17:35 Processing: VB
14:17:35 Selected: VB
14:17:35 Processing: OCX1
14:17:35 Processing: SQLAdHlp
14:17:35 Selected: SQLAdHlp
14:17:35 Processing: SQLAdHlpRes1033
14:17:35 Selected: SQLAdHlpRes1033
14:17:35 Processing: SQLAdHlpResOther
14:17:35 Selected: SQLAdHlpResOther
14:17:35 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:17:35 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:17:35 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:17:35 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:17:35 End:  LogSelectedComponents()
14:17:35 Processing: SQLProg
14:17:35 Processing: SQLProgSQLServr
14:17:35 Processing: SQLProgSQLServrHelp
14:17:35 Processing: SQLProgSQLServrSCMDev
14:17:35 Processing: SQLProgSQLServrSCMDevSCMh
14:17:35 Processing: SQLProgSQLServrSCMDevSCMX86Lb
14:17:35 Processing: SQLProgSQLServrSCMDevSCMALb
14:17:35 Processing: SQLProgSQLServrRs1033
14:17:35 Processing: SQLProgSQLServrRsIntl
14:17:35 Processing: SQLProgSQLServrActiveX
14:17:35 Processing: SQLProgSQLServrSystem
14:17:35 Processing: SQLProgSQLServrWatson
14:17:35 Processing: SQLProgSQLServrWatsonWatson1033
14:17:35 Processing: SQLProgSQLServrWatsonWatsonOther
14:17:35 Processing: SQLProgSQLServrMSXMLSQL
14:17:35 Processing: SQLProgSQLServrMSXMLSQLRes1033
14:17:35 Processing: SQLProgSQLServrMSXMLSQLResIntl
14:17:35 Processing: SQLProgUpgTools
14:17:35 Processing: SQLProgUpgToolsUpgSys
14:17:35 Processing: SQLProgUpgToolsActiveX
14:17:35 Processing: SQLProgUpgToolsRes1033
14:17:35 Processing: SQLProgUpgToolsResOther
14:17:35 Processing: SQLProgUpgToolsResld
14:17:35 Processing: SQLProgReplSupp
14:17:35 Processing: SQLProgReplSuppReplDat
14:17:35 Processing: SQLProgReplSuppRepComm
14:17:35 Processing: SQLProgReplSuppRepNoDk
14:17:35 Processing: SQLProgReplSuppActiveX
14:17:35 Processing: SQLProgInstall
14:17:35 Processing: SQLProgSystem
14:17:35 Processing: SQLProgSvrExt
14:17:35 Processing: SQLProgSvrExtHelp
14:17:35 Processing: SQLProgSvrExtSvrExtRs
14:17:35 Processing: SQLProgSvrExtResIntl
14:17:35 Processing: SQLProgDat
14:17:35 Processing: SQLProgDatSmpl
14:17:35 Processing: SQLProgBaseSys
14:17:35 Processing: SQLProgBaseBinn
14:17:35 Processing: SQLProgMSSearch
14:17:35 Processing: SQLProgMSSearchHelp
14:17:35 Processing: SQLProgMSSearchActiveX
14:17:35 Processing: SQLProgBaseInst
14:17:35 Processing: SQLProgUI
14:17:35 Processing: SQLProgSymbols
14:17:35 Processing: SQLProgSymbolsEXE
14:17:35 Processing: SQLProgSymbolsDLL
14:17:35 Processing: SQLProgPerfmon
14:17:35 Processing: SQLProgPerfmonSystem
14:17:35 Processing: SQLProgRoot
14:17:35 Processing: SQLProgEXE
14:17:35 Processing: SQLProgDLL
14:17:35 Processing: MgtTool
14:17:35 Processing: MgtToolSEM
14:17:35 Processing: MgtToolSEMHTML
14:17:35 Processing: MgtToolSEMMSD98
14:17:35 Processing: MgtToolSEMMSD98SYS
14:17:35 Processing: MgtToolSEMMSD98Res
14:17:35 Processing: MgtToolSEMMSD98Hlp
14:17:35 Processing: MgtToolSEMHelp
14:17:35 Processing: MgtToolSEMRes1033
14:17:35 Processing: MgtToolSEMResIntl
14:17:35 Processing: MgtToolSEMMSD98RsI
14:17:35 Processing: MgtToolSEMActiveX
14:17:35 Processing: MgtToolSEMActiveXRes1033
14:17:35 Processing: MgtToolSEMActiveXResIntl
14:17:35 Processing: MgtToolSEMScripts
14:17:35 Processing: MgtToolSEMOLEDB
14:17:35 Processing: MgtToolSEMOLEDBRes1033
14:17:35 Processing: MgtToolSEMOLEDBResIntl
14:17:35 Processing: MgtToolSEMMSD7
14:17:35 Processing: MgtToolSEMMSD7Res
14:17:35 Processing: MgtToolSEMMSD7RsI
14:17:35 Processing: MgtToolProfiler
14:17:35 Processing: MgtToolProfilerHelp
14:17:35 Processing: MgtToolProfilerRes1033
14:17:35 Processing: MgtToolProfilerResIntl
14:17:35 Processing: MgtToolQryanlz
14:17:35 Processing: MgtToolQryanlzHelp
14:17:35 Processing: MgtToolQryanlzRes1033
14:17:35 Processing: MgtToolQryanlzResIntl
14:17:35 Processing: MgtToolDTCCLi
14:17:35 Processing: MgtToolWzcnflct
14:17:35 Processing: MgtToolWzcnflctWzcnHlp
14:17:35 Processing: MgtToolWzcnflctWzcn1033
14:17:35 Processing: MgtToolWzcnflctWzcnOthr
14:17:35 Processing: MgtToolWzcnflctWzcnCmn
14:17:35 Processing: MgtToolUtilSys
14:17:35 Processing: MgtToolUtilBinn
14:17:35 Processing: Connect
14:17:35 Processing: ConnectConnSys
14:17:35 Processing: Books
14:17:35 Processing: BooksBookso
14:17:35 Processing: BooksBooksoUtils
14:17:35 Processing: DevTools
14:17:35 Processing: DevToolsHeaders and Libraries
14:17:35 Processing: DevToolsHeaders and LibrariesInclude
14:17:35 Processing: DevToolsHeaders and LibrariesLibx86
14:17:35 Processing: DevToolsHeaders and LibrariesLibAlpha
14:17:35 Processing: DevToolsHeaders and LibrariesESQLC
14:17:35 Processing: DevToolsMDAC SDKs
14:17:35 Processing: DevToolsVDI
14:17:35 Processing: DevToolsVDIInc
14:17:35 Processing: DevToolsVDISamples
14:17:35 Processing: DevToolsDbg Int
14:17:35 Processing: DevToolsDbg IntDbg Int Common
14:17:35 Processing: DevToolsDbg IntEXE
14:17:35 Processing: Samples
14:17:35 Processing: SamplesADO
14:17:35 Processing: SamplesDBLIB
14:17:35 Processing: SamplesDesktop
14:17:35 Processing: SamplesDTS
14:17:35 Processing: SamplesESQLC
14:17:35 Processing: SamplesMisc
14:17:35 Processing: SamplesMSDTC
14:17:35 Processing: SamplesODBC
14:17:35 Processing: SamplesODS
14:17:35 Processing: SamplesOLEAut
14:17:35 Processing: SamplesRepl
14:17:35 Processing: SamplesSilverstoneDB
14:17:35 Processing: SamplesSQLDMO
14:17:35 Processing: SamplesSQLNS
14:17:35 Processing: SamplesUtils
14:17:35 Processing: SamplesXML
14:17:35 Processing: CoreRepl
14:17:35 Processing: CoreReplRes1033
14:17:35 Processing: CoreReplResIntl
14:17:35 Processing: Core
14:17:35 Processing: CoreRes1033
14:17:35 Processing: CoreResOther
14:17:35 Processing: Repostry
14:17:35 Processing: RepostryRepstSys
14:17:35 Processing: RepostryRes1033
14:17:35 Processing: RepostryResIntl
14:17:35 Processing: CoreMisc
14:17:35 Processing: CoreMiscActiveX
14:17:35 Processing: CoreMiscActiveXRes1033
14:17:35 Processing: CoreMiscActiveXResIntl
14:17:35 Processing: CoreMiscRes1033
14:17:35 Processing: Monarch
14:17:35 Processing: MonarchMonr1033
14:17:35 Processing: MonarchMonrIntl
14:17:35 Processing: Jet
14:17:35 Processing: CoreInst
14:17:35 Processing: CoreCOM
14:17:35 Processing: CoreCOMRes1033
14:17:35 Processing: CoreCOMResIntl
14:17:35 Processing: CoreTool
14:17:35 Processing: CoreToolRes1033
14:17:35 Processing: CoreToolResOther
14:17:35 Processing: DBLibCli
14:17:35 Processing: SFExt
14:17:35 Processing: SFExtActiveX
14:17:35 Processing: SFExtActiveXRes1033
14:17:35 Processing: SFExtActiveXResIntl
14:17:35 Processing: SFExtRes1033
14:17:35 Processing: SFExtResIntl
14:17:35 Processing: Trace
14:17:35 Processing: TraceRes1033
14:17:35 Processing: TraceResOther
14:17:35 Processing: CnctBinn
14:17:35 Processing: MiscCore
14:17:35 Processing: MC
14:17:35 Processing: MCMC1033
14:17:35 Processing: MCMCIntl
14:17:35 Processing: MCHelp
14:17:35 Processing: UI
14:17:35 Processing: UIUIHlp
14:17:35 Processing: UIUI1033
14:17:35 Processing: UIUIIntl
14:17:35 Processing: ClstSys
14:17:35 Processing: SQLMgr
14:17:35 Processing: SQLMgrRes1033
14:17:35 Processing: SQLMgrResIntl
14:17:35 Processing: SvrTool
14:17:35 Processing: SvrToolRes1033
14:17:35 Processing: SvrToolResIntl
14:17:35 Processing: DTSUI
14:17:35 Processing: DTSUIRes1033
14:17:35 Processing: DTSUIResIntl
14:17:35 Processing: ClFTSys
14:17:35 Processing: ClFtdata
14:17:35 Processing: MSOlap
14:17:35 Processing: MSOlapRes1033
14:17:35 Processing: MSOlapResIntl
14:17:35 Processing: ATL
14:17:35 Processing: ATLwinnt
14:17:35 Processing: ATLwin9x
14:17:35 Processing: MFC42U
14:17:35 Processing: VC
14:17:35 Processing: VB
14:17:35 Processing: OCX1
14:17:35 Processing: SQLAdHlp
14:17:35 Processing: SQLAdHlpRes1033
14:17:35 Processing: SQLAdHlpResOther
14:17:35 SQL program folder: C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:17:35 SQL data folder: C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:17:35 Windows system folder: C:WINDOWSsystem32
14:17:35 Prog req: 61137, Data req: 3072, Sys req: 50573
14:17:35 Prog avail: 1573556, Data avail: 1573556, Sys avail: 1573556
14:17:35 Prog req vs. avail, 114782, 1573556
14:17:35 Data req vs. avail, 3072, 1573556
14:17:35 Sys req vs. avail, 53645, 1573556
14:17:35 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Timeout 5000 -Service SQLAgent$INSTNAME
14:17:35 Process Exit Code: (0)
14:17:35 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Timeout 5000 -Service MSSQL$INSTNAME
14:17:35 Process Exit Code: (0)
14:17:35 Begin:  InstallPkgs(ID_INSTALLMDAC)
14:17:35 Begin Action: Locked Connectivity Files Check
14:17:35 ConnectivityLocked returned: 0
14:17:35 The operation completed successfully.

14:17:35 End Action: Locked Connectivity Files Check
14:17:35 Setup is installing Microsoft Data Access Components (MDAC) ...
14:17:35 D:SQL2KSP42x86Othersqlredis.exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS"
14:17:35 Unloading library - sqlsut.dll (#U2)
14:17:43 Loading library - sqlsut.dll (#L2)
14:17:43 ExitCode: 0
14:17:43 End:  InstallPkgs(ID_INSTALLMDAC)
14:17:43 **** STARTING OPEN OP IN WRITE MODE ****
14:17:43 **** CLOSED OPEN OP IN WRITE MODE ****
14:17:43 Begin:  MoveFileData()
14:17:43 Enabled SELFREGISTERBATCH
14:17:43 Enabled CORECOMPONENTHANDLING
14:17:49 Begin Action:  MoveFileDataSpecial
14:17:49 End Action:  MoveFileDataSpecial
14:17:49 End:  MoveFileData()
14:17:49 Begin:  ProcessAfterDataMove()
14:17:49 Begin Action : Installing Server Net
14:17:49 Server Instance : INSTNAME
14:17:49 Server Net Will only be installed on server only in Enterprise Editions
14:17:49 End:  ProcessAfterDataMove()
14:17:49 Begin:  BuildServer()
14:17:49 Begin Action: CreateRegistrySetSQL
14:17:49 End Action: CreateRegistrySetSQL
14:17:49 Begin Action: RegWriteSetupEntry
14:17:49 End Action: RegWriteSetupEntry
14:17:49 *** Unable to get RegisteredOwner to apply to Serial number
14:17:49 Begin Action: CreateSer
14:17:49 End Action: CreateSer
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsetup.iss returned: 0, 0
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsqlsp.log returned: 0, 0
14:17:49 SetFileSecuritySQLAndAdmin for  returned: 3, 3
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsqlsp.log returned: 0, 0
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsqlstp.log returned: 0, 0
14:17:49 SetFileSecPerfAndLogUsers for C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEBinnSQLCTR80.DLL returned: 0, 0
14:17:49 Begin ServPriv (INSTNAME)
14:17:49 End ServPriv()
14:17:50 Upgrading databases
14:17:50 Upgrading databases on instance 'INSTNAME'
14:17:50 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Service MSSQL$INSTNAME 
14:17:50 Process Exit Code: (0)
14:17:50 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Service MSSQL$INSTNAME 
14:17:50 Process Exit Code: (0)
14:17:50 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 1 -Service MSSQL$INSTNAME   -StartupOptions -T4022 -T4010 -m
14:18:41 Process Exit Code: (0)
14:18:41 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplsys.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplsys.sql" -Usa  -P"
14:19:18 Process Exit Code: (0)
14:19:18 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplcom.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplcom.sql" -Usa  -P"
14:19:35 Process Exit Code: (0)
14:19:35 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
epltran.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
epltran.sql" -Usa  -P"
14:19:57 Process Exit Code: (0)
14:19:57 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplmerg.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplmerg.sql" -Usa  -P"
14:20:25 Process Exit Code: (0)
14:20:25 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
emove_old_msx_accounts.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
emove_old_msx_accounts.sql" -Usa  -P"
14:20:25 Process Exit Code: (0)
14:20:25 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstallsp4_serv_uni.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstallsp4_serv_uni.sql" -Usa  -P"
14:20:27 Process Exit Code: (0)
14:20:27 D:SQL2KS~1x86BINNosql.exe  -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall80sp4-tools.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall80sp4-tools.sql" -Usa  -P"
14:20:28 Process Exit Code: (1)
14:20:33 Error running script: 80sp4-tools.sql (1)
14:20:33 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Service MSSQL$INSTNAME 
14:21:08 Process Exit Code: (0)
14:21:08 Action CleanUpInstall:
14:21:08 Installation Failed.


 

I hope for any help, because re-installing is not an option.There are 250 db's on it.

 

thanks so far.

 

rb

View Replies !

---

Language Error When Creating FULLTEXT INDEX By Using SQL Server 2005 Management Express!
Hello..
When I used Microsoft SQL Server 2005 Management Studio Express to Create FULL TEXT INDEX by this code:
 
CREATE FULLTEXT INDEX ON txtfilestbl(txtfile) KEY INDEX PK_txtfilestbl ON ForumsArchiveLibCtlg WITH CHANGE_TRACKING AUTO
 
It returns this ERR MSG:
 
Informational: No full-text supported languages found.
Informational: No full-text supported languages found.
Msg 7680, Level 16, State 1, Line 1
Default full-text index language is not a language supported by full-text search.
 
I Use same this code to create FULL TEXT INDEX by using Microsoft SQL Server 2005 Management Studio, and it was working properly.
 What I have to do?

View Replies !

---

SSIS Doesn`t Start After Applying SQL Server 2005 SP1 Error Message 7000 Service Control Manager
SSIS doesn`t start after applying SQL Server 2005 SP1

 

I get an error Message in event log

 event id 7000 source: Service Control Manager Type: Error

Message:

The SQL Server Integration Services service failed to start due to the following error:

The service did not respond to the start or control request in a timely fashion.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

regards

Lothar Belle

View Replies !

---

Security Rights Needed To Start And Stop Services From SQL Server Management Studio
Hello everyone.

I have a question about granting enough rights to allow a non admin user to start and stop a sql server service via the SQL Server Management Studio by right clicking on the server node.

 

I have changed the acl's of the SQL Server service security and gave the user rights to start and stop the service. This does allow them to connect remotly to the server using computer manager and they successifully start and stop the service. But, in SQL Server Management Studio the option still does not show up, unless he is a admin of the server.

 

Does anyone know what other security settings I need to address for the start and stop to show up when I right click on the server node?

Thanks for any help

View Replies !

---

Upgrading 2000 Cluster To 2005...applying Sp, Tools And SSIS On Node2
We are planning a 2000 to 2005 upgrade on Win03.  The question is in regards to applying service pack1 and a hotfix on the nodes.  We are planning to add the Tools and SSIS to the second node.  The question is the SP and hotfix aware enough about the Tools and SSIS on the second node OR do we need to apply it to the second node separately?

View Replies !

---

Error When SQL 2000 Start
When starting my SQL Server 2000 generate error and stop. This is the log:
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

2004-01-20 11:05:36.59 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-01-20 11:05:36.59 server All rights reserved.
2004-01-20 11:05:36.59 server Server Process ID is 115.
2004-01-20 11:05:36.59 server Logging SQL Server messages in file 'C:MSSQL7logERRORLOG'.
2004-01-20 11:05:36.63 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-01-20 11:05:36.66 server SQL Server configured for thread mode processing.
2004-01-20 11:05:36.66 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2004-01-20 11:05:36.67 server Attempting to initialize Distributed Transaction Coordinator.
2004-01-20 11:05:38.69 spid3 Starting up database 'master'.
2004-01-20 11:05:38.85 spid3 Server name is 'DB_SERVER'.
2004-01-20 11:05:38.85 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-01-20 11:05:38.87 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-01-20 11:05:38.87 server SQL server listening on 192.168.1.29:1433, 172.16.48.10:1433, 127.0.0.1:1433.
2004-01-20 11:05:38.87 server SQL Server is ready for client connections
2004-01-20 11:05:38.87 spid5 Starting up database 'model'.
2004-01-20 11:05:38.87 spid8 Starting up database 'msdb'.
2004-01-20 11:05:38.87 spid9 Starting up database 'pubs'.
2004-01-20 11:05:38.87 spid10 Starting up database 'Northwind'.
2004-01-20 11:05:38.87 spid11 Starting up database 'SIM'.
2004-01-20 11:05:39.21 spid5 Error: 9003, Severity: 20, State: 1
2004-01-20 11:05:39.21 spid5 The LSN (5:377:1) passed to log scan in database 'model' is invalid..
2004-01-20 11:05:39.31 spid8 Bypassing recovery for database 'msdb' because it is marked SUSPECT.
2004-01-20 11:05:39.39 spid11 Starting up database 'GMS'.
2004-01-20 11:05:39.39 spid8 Starting up database 'euro'.
2004-01-20 11:05:40.14 spid10 Starting up database 'TigrisDB'.

View Replies !

---

Restoring A Sql 2000 Db In Sql 2005 Express Db With Sql Server Management Studio Express
As I said in the subject I've a problem trying to restore a backup of a previous db created in sql 2000 server

When I try to do it I recive the following message:

____________________________________________________________________________________
System.Data.SqlClient.SqlError: Il set di backup include il backup di un database diverso dal database 'musica2007' esistente. (Microsoft.SqlServer.Express.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
Program Location:

   in Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
   in Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
   in Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
____________________________________________________________________________________

What should I do? What's the probem? I've already tried to look for the solution in other messages but I didn't find anything..... Thanks for help,,, by Luke

View Replies !

---

SQL Server 2000/05 Tools??
I am looking for best blogs/articles on Debugging, performance for SQL server 2000/2005.

Please provide me links

View Replies !

---

HAndle Error After Setup And Trying To Start SQL 2000
Hi Guys

 

I am getting a error after installing SQL 2000 64bit edt with Service pack 4 on a Windows 2003 Compute Cluster

 

The SQL Icon at the bottom of the crseen has no start  in it and when I open the SQL manager I am unable to connect to the instance name and start the service manually it then gives me this error

 

"AN Error 6 :The handle is invalid ccured while performing this service operation on the MSSQL Server Service"

 

The event viewer doesnt have much as well

 

Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date:  03/04/2007
Time:  13:14:21
User:  N/A
Computer: UKHQCSSQL01
Description:
'0' is an invalid number of start up parameters. This service takes two start up parameters.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


 

Any help on this would be great

 

Thanks

View Replies !

---

Where Are The SQL Management Tools???
I just finished installing SQL Server 2005 Developer Beta 2.

View Replies !

---

SQL Server 2000 Client Tools
According to MS Knowledge Base Article 269824, "[SQL Server 2000 ClientTools] ... must be installed ... on any computer on which someone may makedesign changes in an Access project to a SQL Server 2000 database".This is the situation I'm facing. Can I download these Client Tools andinstall them for free, or are they only available on the SQL Server 2000Installation CD?Thanks for any help!

View Replies !

---

SQL Server 2000 DTS Tools Web Download
Is the Web Download to install SQL Server 2000 DTS tools available yet? If so where?

View Replies !

---