Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Install The Database To Any Sql Server From Cd


hi friends

can any body help me install the my database directly to the sql server without going to the sql server and running the script

 


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Database Services Install Fails When Install SQL Server 2005 SP2
The error I got is:
Hotfix.exe has encountered a problem and needs to close.  We are sorry for the inconvenience.
 
EventType : sqlsesetup     P1 : sysdbupg.sql     P2 : 0x7361    
P3 : odbcstatement__execute_batch@sysdbupg.sql@3     P4 : 0x7361    
P5 : lib_odbc_statement.h@91     P6 : unknown     P7 : sql9     P8 : hotfix@
P9 : x86     P10 : 3042
 
Log Location: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
MSP Error: 29537  SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
 
I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.
 
Thanks a lot,
 
Rex

View Replies !   View Related
SQL Server 2005 Express Adv. SP2 Setup Fails To Install SQL Server Database Serices Only.
I run setup using GUI. It upgrades all components of the existing installation w/out any problems except the last component.  That is, it proceeds with the installation of SQL Server Database Serices and at the end fails to shut down the SQL Server and aborts the installation reporting the following:

"Service 'Computer_NameSQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)".

I am running Windows XP SP2 with both .NET 2.0  and .NET 3.0 installed on it.  I am logged in as a system administrator.

The most puzzling to me things are:

- the setup starts AND STOPS w/out any problems SQL Server Reporting Services and SQL Server VSS Writer (thus finding enough privileges for both).

- the setup starts the SQL Server w/out any problems (thus it finds enough privileges to START A SYSTEM SERVICE) and then fails as described above 'lucking privileges".

During installation before failing the setup displays following:

"Run as Normal User. RANU instance Shutdwon in progress: MSSQL$SQLEXPRESS".  The "normal user" puzzles me too, unless the SQL Server itself is meant here.

Any suggestions would be appreciated.  I can provide the installation log file as well.

Thanks.

 

View Replies !   View Related
DO I Need Install SQL Server To Work With Database
I want make setup cd for my program and i use visualbasic 6 and SQL Server 2000 .
What i should make and include my setup file to make it work with any one install it in his computer and we assume he dont have SQL Server2000 in his computer .
Please help me on that
Should SQL Server 2000 must alreeady installed on his computer?
If its must be installed,Is there any way to make it easy through my setup file to make it install sql server automatic ?
Can i make my program in visual basic create database and tables and relations and so.
Please help me on that becuase its too Important.
Thanks.

View Replies !   View Related
Install Database Server Error (XP)..
Hi,

I'm having problem installing the Database Server on Windows XP (home).

It shows "Internal Error. Contact Microsoft Technical Support" when I clicked on the "Install Database Server". I'm using SQLServer 2000 Developer Edition. I have already enabled Named Pipes and TCP/IP.

But I can get through the setup screen of "Analysis Services" and "English Query" without any problem. I haven't install Analysis Services or English Query. Do I have to install other software (like the "Analysis Services" or "English Query") before installing the "Database Server"?

Please help..

Thank you.

View Replies !   View Related
Can I Use Osql To Known The Database Install On A Server Via 'guest' ?
Can I use osql to known the database install on a server via 'guest'account ?I had over 300 servers with sql server all around France (differentversion : 6.5, 7 and 8)I need to check all database on each servers from my place.Of course, also it would have been to easy, I don't have all 'sa'password...Is that possible to use the 'guest' account to execute a query likethis via osql :Extract.sqlexec sp_helpdbExtract.cmdfor /f "usebackq tokens=1 delims=" %%i IN (ListServer.txt) DOosql-S%%i -Uguest -P -dmaster -i"C:ExtractionExtract.sql"-o"C:Extraction\%%i.rpt"Could I query 'master' with the 'guest' account ?Or any other ideas how to do this by an other way ?Thanks

View Replies !   View Related
Cannot Install Northwind Database In SQL Server Express
Hi,

I tried to install the Northwind database into SQl Server Express via the instnwnd.sql script using the command line:

osql -E -i instnwnd.sql

after a time out though I get this message:

"[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
Server [2].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections."

I already granted access to the administrator account on my machine.

Anyone knows what I need to do more?

Thanks in advance

 

greetings from Belgium,

Anthony

 

View Replies !   View Related
Error To Install The SQL Server Database Services
Hay,

I have a problem to in stall my SQL database services.

I use the Microsoft SQL server 2005 on a Microsoft small business server 2003 system.

My system configuration check is oke  and i have no problems to install the other services(Analysis,Reporting,Notification and Intergration).

When i install the SQL database services i have this error:

(Error attempting to read from the source install database,

d:windowsinstall7b027f.msi).

 

thanks 

 

View Replies !   View Related
Trying To Install RS In A Server Wioth The Database On Another Machine.
Hello, I want to install only reporting services on one server, I already did, but i want RS databases to reside on another server.

 

I already gave me administrator permission on the other machie, and in the reporting services configuration i entered the server and clicked FIND and it Found the instance, but when I click connect, I got this error.

 

 

 

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Exception: *** INTERNAL *** The WMI Provider has returned an unspecified status
   at ReportServicesConfigUI.WMIProvider.ConfigurationItem.CreateConfigurationItem(String name, String description, String status, Int32 severity)
   at ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
   at ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames itemName)
   at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
   at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
   at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
   at ReportServicesConfigUI.ConfigurationManager.tsbConnect_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RSConfigTool
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Archivos%20de%20programa/Microsoft%20SQL%20Server/90/Tools/binn/RSConfigTool.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/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:/WINDOWS/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 !   View Related
How To Create A Setup File To Install Sql Server Database
Hi All,   I'am looking for a software (Installer) to create a setup file to install a SQL Server Database just like the one in the Reports Starter Kit, when you install it a dialog will guide you to instaal the database thats what i'am looking for.  Anybody knows how can i do that or is there a software that can help me doing that.Best Regards.Wafi Mohtaseb

View Replies !   View Related
SQL Server 2005 Database Installation Fails To Install
Hi,

I have been trying to install SQL Server 2005 developer version on my second laptop IBM Thinkpad Windows XP PRO,  for the first time. All other components installed successfully except the database. I 've tried selecting the named instance and default instance it didn't make any difference. I have a Admin role on the laptop and as a service id I selected my user id. password and domain. I am running the setup behind my company's firewall.

The error in the log is :

 

Doing Action: Do_UpdateETWMOFWithGUID
PerfTime Start: Do_UpdateETWMOFWithGUID : Wed May 09 11:07:46 2007
<Func Name='Do_UpdateETWMOFWithGUID'>
Calling installSqlEvent Trance
The arguments that are passed to InstallSqlEventTrace are InstanceName: SQLSERVER2005 , ProductCodeL: {2373A92B-1C1C-4E71-B494-5CA97F96AA19} , BinPath: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
INFO: Checking installed version
INFO: Writing MOF file
ERROR: Unable to open registry key: HRESULT = 0x80070005, Key = SYSTEMCurrentControlSetControlWMISecurity

The value returned is -2147024891
<EndFunc Name='Do_UpdateETWMOFWithGUID' Return='1603' GetLastError='0'>
PerfTime Stop: Do_UpdateETWMOFWithGUID : Wed May 09 11:07:46 2007
Gathering darwin properties for failure handling.
Error Code: 1603

MSI (s) (88!E0) [11:09:48:898]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.


Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.


I have tried to attach the log but I think it is too big. I cannot post this message.

Please let me know another way to send the log file.

 

Any help is appreciated.

View Replies !   View Related
New Install Of Sql Server Express Fails To Restore Master Database
Hello,

I have a fresh install of sqlExpress and Management Studio Express on my test server. I want to restore my master database from backup.

From the command prompt I set the Sqlservr -s SQLEXPRESS -m

Then I opened another comand prompt and ran my SQLCMD script to restore the Master Database.

here is the sql script:
RESTORE DATABASE [Master] FROM  DISK = N'E:COPLEYNEWSDATABASEBACKUPMaster.bak' WITH  FILE = 1,  MOVE N'mastlog' TO N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAMaster_1.ldf',  NOUNLOAD,  STATS = 10
GO

I recieve the following error.

Msg 3154, Level 16, State 4, Server COPLEYNEWSSQLEXPRESS, Line 1
The backup set holds a backup of a database other than the existing 'Master' dat
abase.
Msg 3013, Level 16, State 1, Server COPLEYNEWSSQLEXPRESS, Line 1

How do I restore a Master Database on SQL Express?

View Replies !   View Related
Unattended Re-install Of SQL Server 2005 Express Fails To Re-create Database!
Hi,

I have a script that performs an unattended installation of SQL Server and works fine. 

However, if I un-install via the control panel all the files are removed apart from the databases that are created by me when SQl server was installed.  This is good and ensures data is not deleted. 

The files left over are in the following directory:
    C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
and contains:
    MyDatabase.mdf
    MyDatabase_log.LDF

The problem I have is after performing the re-installtion of SQL server (unattended) I am unable to create a new database with the same name (in this instance called "myDatabase").

The actual files are physically there so this is the reason a new database with the same name cannot be creacted.

Again this is ok again because it ensures I cannot overwrite existing data.  However I am unable to re-attach this database to SQl server so I can continue to use it!

The question is:

How do I make this database usable again after an unattended install?  Is there a parameter I am missing?

Below are the commands I use that are passed to the installation of SQL Server as command line parameters:

#define SQL_SILENT                    "-q /passive /norebootchk /qn reboot=ReallySuppress"
#define SQL_USERNAME             "username=MyUserName"
#define SQL_COMPANYNAME      "companyname=MyCompanyName"
#define SQL_ADDLOCAL               "addlocal=ALL"
#define SQL_DISABLENETWORKPROTOCOLS   "disablenetworkprotocols=0"
#define SQL_INSTANCENAME       "instancename=MSSQLSERVER"
#define SQL_SQLAUTOSTART       "SQLAUTOSTART=1"
#define SQL_SECURITYMODE       "SECURITYMODE=SQL"
#define SQL_SAPWD                     "SAPWD=#Password#"
#define SQL_SAVESYSDB             "1"
#define SQL_USESYSDB               ""
#define SQL_INSTALLSQLDIR         ""
#define SQL_INSTALLDATADIR       ""

#define SQL_PARAMETERS    SQL_SILENT + " " + SQL_USERNAME + " " + SQL_COMPANYNAME + " " + SQL_ADDLOCAL + " " + SQL_DISABLENETWORKPROTOCOLS + " " + SQL_INSTANCENAME + " " + SQL_USESYSDB + " " + SQL_INSTALLSQLDIR + " " + SQL_INSTALLDATADIR + " " + SQL_SAVESYSDB + " " + SQL_SQLAUTOSTART + " " + SQL_SECURITYMODE + " " + SQL_SAPWD


The last four commands I have played around with but for some reason SQL Server service will not start when these are used! (This is a different issue though!).


Any advice would be gratefully accepted.

Thanks

Paul

View Replies !   View Related
Unable To Install Database Services For Sql Server 2005 Express Edition
i've tried to install sql server 2005 express edition several times but when it get to the 'database services' it gives the following error:

SQL Server Setup could not connect to the database service configuration. The error was:
[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

please help

View Replies !   View Related
SQL Server Developer Fails To Install (Database Engine Only)... Error 1603 &&amp; 1708
Please Help!!!.

 

I Installed everything but database Engine...

 

Error Log:

 

Property(S): SqlVerComBin.8E491190_3328_49D2_9FFE_2D036D847DE2 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.8E491190_3328_49D2_9FFE_2D036D847DE2 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlTarget.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstance.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlInstanceBin.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): sqlreps_dll.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnsqlrepss90.dll
Property(S): SqlInstance.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlTarget.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstanceInstall.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLInstall
Property(S): CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon Files
Property(S): MSShared.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft Shared
Property(S): DatabaseRepl.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase Replication
Property(S): DatabaseReplRes.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources
Property(S): DatabaseReplRes1033.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources1033
Property(S): WindowsFolder = C:WINNT
Property(S): Gac.A6DEDA64_4924_4EA9_84E5_DC507BA0794B = C:Program FilesMicrosoft SQL Server90GAC
Property(S): Ver.A6DEDA64_4924_4EA9_84E5_DC507BA0794B = C:Program FilesMicrosoft SQL Server90
Property(S): Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 = C:Program FilesMicrosoft SQL Server90GAC
Property(S): Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.889BED4C_E3F4_4943_956C_6FFD882F721F = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.889BED4C_E3F4_4943_956C_6FFD882F721F = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBinRes.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COMResources
Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COMResources1033
Property(S): SqlInstance.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlTarget.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstanceBin.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): Data.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL Server
Property(S): DataInstance.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): FTDataDir.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): DataInstanceTxt.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): DataInstanceFTData.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): ModuleID_FTSSV = 68C6D15C_77E0_11D5_8528_00C04F68155C
Property(S): SqlFullTextDefaultPath = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = B0019B91BCDB3SQLServer2005MSFTEUser$B0019B91BCDB3$SQL2005PDI1
Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQL2005PDI1
Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3
Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.3MSSearch
Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3MSSQL
Property(S): FTEStartupType = 0
Property(S): FTEStatus = 3
Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.3
Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQL2005PDI1
Property(S): SqlVerComFT.BB43EC2E_1D73_400F_AE2F_F370407BC222 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.BB43EC2E_1D73_400F_AE2F_F370407BC222 = C:Program FilesMicrosoft SQL Server90
Property(S): FTESqlInstanceBin.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): FTESqlInstanceDotNumber.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.1
Property(S): SqlVer.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server90
Property(S): FTESharedCompRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server90
Property(S): Sql.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server
Property(S): SqlTarget.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server
Property(S): ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program Files
Property(S): CAFTERemovePerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQL2005PDI1
Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQL2005PDI1:C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnSQL2005PDI1
Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYSYSTEM
Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQL2005PDI1
Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3
Property(S): FTEUPGRADE.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgrade30.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgradeMSSearchApp.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQL2005PDI1
Property(S): FTEUpgradeMSSearchStandalone.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): CostingComplete = 1
Property(S): FTEInstID.68C6D15C_77E0_11D5_8528_00C04F68155C = 1
Property(S): FTEAppID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}
Property(S): FTEAdminCLSID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D37C-77E0-11D5-8528-00C04F68155C}
Property(S): FTEIFTEAdmin.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bd6f-cc0d-11d6-9a15-505054503030}
Property(S): FTEMSFTEPXY.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bdd4-cc0d-11d6-9a15-505054503030}
Property(S): FTEDollarInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQL2005PDI1
Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQL2005PDI1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQL2005PDI1
Property(S): SqlStateManaged = 2
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): RSVirtualDirectoryManager = Reports$SQL2005PDI1
Property(S): SOURCEDIR = S:PDIPDI ToolsSQL 2005 DeveloperCD1Setup
Property(S): SourcedirProduct = {2373A92B-1C1C-4E71-B494-5CA97F96AA19}
Property(S): InstallNgenTicks = 20000
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {BF3C1964-6601-4DBB-A782-1848FD4A2109}
Property(S): SQLBROWSERACCOUNT = CORPNBDG3C3
Property(S): ProductToBeRegistered = 1
MSI (s) (F8:64) [14:22:43:217]: Note: 1: 1708
MSI (s) (F8:64) [14:22:43:217]: Product: Microsoft SQL Server 2005 -- Installation failed.

MSI (s) (F8:64) [14:22:43:233]: Cleaning up uninstalled install packages, if any exist
MSI (s) (F8:64) [14:22:43:233]: MainEngineThread is returning 1603
MSI (s) (F8:48) [14:22:43:342]: Destroying RemoteAPI object.
MSI (s) (F8:C0) [14:22:43:342]: Custom Action Manager thread ending.
=== Logging stopped: 5/16/2007  14:22:43 ===
MSI (c) (7C:84) [14:22:43:342]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (7C:84) [14:22:43:342]: MainEngineThread is returning 1603
=== Verbose logging stopped: 5/16/2007  14:22:43 ===

View Replies !   View Related
How Can I Re-install The Northwind Database In SQL Server Management Studio Express?Use SqlDataSet &&amp; The .Fill Method Properly?
Hi all,

In my VB 2005 Express, I created a Windowds Form application "shcDataSet" that used 1 SqlConnection, 1 SqlDataSet and 3 SqlDataAdapters associated with the Northwind Database in my SQL Server Management Studio Express. The SqlConnection had "User Instance" in the following ConnectionString: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataorthwnd.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True. The 3 SqlDataAdapters were for the Northwind files "Customers", "Orders" and "Order Details" used in the SQLDataSet "AllOrders" with a AllOrders.xsd file. I ran the "shcDataSet" applicatyion and it worked fine. After the execution of "shcDataSet", I checked the Northwind database in my SQL Server Management Studio Express and clicked on "+" in front of Northwind database-I did not see any file showed up and I got the following error message:  Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)  Additional information: one or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. (Microsoft SQL Server, Error:5173).  If I executed the "shcDataSet" application again, I got a new error: SqlException was unhandled - Cannot open user default database. Login failed. Login failed for user 'myPC##myName' ------->daCustomers.Fill(AllOrders11, "Customers").  I have 3 questions to ask: (1)  How can I re-install the Northwind database in SQL Server Management Studio Express? (2) When I use the .Fill Method,  do I have to tell the SQL Server Management Studio Express to load and/or unload the Northwind files "Customers", "Orders" and "Order Details"? (3) After I executed the "shcDataSet", should I Upload the 3 Northwind files back to the SQL Server Management Studio Express?  Please help and advise. Thanks, Scott Chang

View Replies !   View Related
SQL Server 2005 Install Keeps Failing To Install SQL Services (i.e. The Main Engine!).
I am currently running Windows XP Professional Service Pack2.  It already has MSDE & SQL Server 2000 installed (although I just uninstalled MSDE in the vain hope that it might present the installer with a more straightforward upgrade).

I have tried installing with the default instance & a new instance (I don't really care - I just need to install the darn thing).  I just want the basic database & Books On-line, nothing fancy.

Here is the Summary log, for what it's worth:


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time            : Tue Feb 06 16:45:14 2007
 
Machine         : ANTHONYY1
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_1.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_1.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_2.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BOL_1.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_2.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_2.log
--------------------------------------------------------------------------------
Machine         : ANTHONYY1
Product         : SQLXML4
Error           : Setup is preparing to continue with the installation.
--------------------------------------------------------------------------------

 

 

Here is the SQLSetup0011_ANTHONYY1_Core(Local).log

Microsoft SQL Server 2005 Setup beginning at Tue Feb 06 16:45:14 2007
Process ID      : 2560
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/1/6 16:45:14
Complete: LoadResourcesAction at: 2007/1/6 16:45:14, returned true
Running: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14, returned true
Running: ValidateWinNTAction at: 2007/1/6 16:45:14
Complete: ValidateWinNTAction at: 2007/1/6 16:45:14, returned true
Running: ValidateMinOSAction at: 2007/1/6 16:45:14
Complete: ValidateMinOSAction at: 2007/1/6 16:45:14, returned true
Running: PerformSCCAction at: 2007/1/6 16:45:14
Complete: PerformSCCAction at: 2007/1/6 16:45:14, returned true
Running: ActivateLoggingAction at: 2007/1/6 16:45:14
Complete: ActivateLoggingAction at: 2007/1/6 16:45:14, returned true
Running: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14
Complete: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2560" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2007/1/6 16:45:14
Complete: PerformDotNetCheck2 at: 2007/1/6 16:45:14, returned true
Running: InvokeSqlSetupDllAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [ANTHONYY1]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = ANTHONYY1, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = XMLDomDocument, Result = 0 (0x0)
Machine = ANTHONYY1, Article = Processor, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PhysicalMemory, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSServicePack, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSType, Result = 0 (0x0)
Machine = ANTHONYY1, Article = iisDep, Result = 0 (0x0)
Machine = ANTHONYY1, Article = AdminShare, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PendingReboot, Result = 70011 (0x1117b)
Machine = ANTHONYY1, Article = PerfMon, Result = 0 (0x0)
Machine = ANTHONYY1, Article = IEVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = ANTHONYY1, Article = COMPlus, Result = 0 (0x0)
Machine = ANTHONYY1, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = ANTHONYY1, Article = MDAC25Version, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: ANTHONYY1
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Failed to find help file for LCID :2057
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/1/6 16:49:35, returned true
Running: SetPackageInstallStateAction at: 2007/1/6 16:49:35
Complete: SetPackageInstallStateAction at: 2007/1/6 16:49:36, returned true
Running: DeterminePackageTransformsAction at: 2007/1/6 16:49:36
Complete: DeterminePackageTransformsAction at: 2007/1/6 16:49:47, returned true
Running: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47
Complete: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47, returned true
Running: OpenPipeAction at: 2007/1/6 16:49:47
Complete: OpenPipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/1/6 16:49:47
Complete: CreatePipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2007/1/6 16:49:47
Complete: PopulateMutatorDbAction at: 2007/1/6 16:49:47, returned true
Running: GenerateRequestsAction at: 2007/1/6 16:49:47
 SQL_Engine = 3
 SQL_Data_Files = 3
 SQL_Replication = 3
 SQL_FullText = 3
 SQL_SharedTools = 3
 SQL_BC_DEP = 3
 Analysis_Server = -1
 AnalysisDataFiles = -1
 AnalysisSharedTools = -1
 RS_Server = -1
 RS_Web_Interface = -1
 RS_SharedTools = -1
 Notification_Services = -1
 NS_Engine = -1
 NS_Client = -1
 SQL_DTS = -1
 Client_Components = 3
 Connectivity = 3
 SQL_Tools90 = 3
 SQL_WarehouseDevWorkbench = 3
 SDK = 3
 SQLXML = 3
 Tools_Legacy = 3
 TOOLS_BC_DEP = 3
 SQL_Documentation = 3
 SQL_BooksOnline = 3
 SQL_DatabaseSamples = -1
 SQL_AdventureWorksSamples = -1
 SQL_AdventureWorksDWSamples = -1
 SQL_AdventureWorksASSamples = -1
 SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/1/6 16:49:48, returned true
Running: CreateProgressWindowAction at: 2007/1/6 16:49:48
Complete: CreateProgressWindowAction at: 2007/1/6 16:49:48, returned true
Running: ScheduleActionAction at: 2007/1/6 16:49:48
Complete: ScheduleActionAction at: 2007/1/6 16:49:48, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run.  Information reported during analysis:
No install request found for package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run.  Information reported during analysis:
No install request found for package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2007/1/6 16:49:48
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallSqlAction.11 at: 2007/1/6 16:49:51, returned true
Running: InstallSqlAction.12 at: 2007/1/6 16:49:51
Installing: sqlncli on target: ANTHONYY1
Complete: InstallSqlAction.12 at: 2007/1/6 16:49:55, returned true
Running: InstallSqlAction.18 at: 2007/1/6 16:49:55
Installing: owc11 on target: ANTHONYY1
Complete: InstallSqlAction.18 at: 2007/1/6 16:49:56, returned true
Running: InstallSqlAction.21 at: 2007/1/6 16:49:56
Installing: sqlwriter on target: ANTHONYY1
Complete: InstallSqlAction.21 at: 2007/1/6 16:49:58, returned true
Running: InstallSqlAction.22 at: 2007/1/6 16:49:58
Installing: bcRedist on target: ANTHONYY1
Complete: InstallSqlAction.22 at: 2007/1/6 16:50:0, returned true
Running: InstallSqlAction.9 at: 2007/1/6 16:50:0
Installing: msxml6 on target: ANTHONYY1
Complete: InstallSqlAction.9 at: 2007/1/6 16:50:2, returned true
Running: InstallToolsAction.11 at: 2007/1/6 16:50:2
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallToolsAction.11 at: 2007/1/6 16:50:5, returned true
Running: InstallToolsAction.12 at: 2007/1/6 16:50:5
Installing: sqlncli on target: ANTHONYY1
Complete: InstallToolsAction.12 at: 2007/1/6 16:50:8, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run.  Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.18 at: 2007/1/6 16:50:8
Installing: owc11 on target: ANTHONYY1
Complete: InstallToolsAction.18 at: 2007/1/6 16:50:10, returned true
Running: InstallToolsAction.20 at: 2007/1/6 16:50:10
Installing: BOL on target: ANTHONYY1
Complete: InstallToolsAction.20 at: 2007/1/6 16:52:2, returned true
Running: InstallToolsAction.22 at: 2007/1/6 16:52:2
Installing: bcRedist on target: ANTHONYY1
Complete: InstallToolsAction.22 at: 2007/1/6 16:52:4, returned true
Running: InstallToolsAction.9 at: 2007/1/6 16:52:4
Installing: msxml6 on target: ANTHONYY1
Complete: InstallToolsAction.9 at: 2007/1/6 16:52:6, returned true
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Running: InstallSqlAction at: 2007/1/6 16:52:7
Installing: sql on target: ANTHONYY1
Error: MsiOpenDatabase failed with 110
Failed to install package
This installation package could not be opened.  Contact the application vendor to verify that this is a valid Windows Installer package.
Error: MsiOpenDatabase failed with 110 for MSI D:ServersSetupSqlRun_SQL.msi
Setting package return code to: 1620
Complete: InstallSqlAction at: 2007/1/6 16:52:27, returned false
Error: Action "InstallSqlAction" failed during execution.  Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Running: InstallToolsAction.10 at: 2007/1/6 16:52:27
Installing: sqlxml4 on target: ANTHONYY1
        Error Code: 0x8007006e (110)
Windows Error Text: The system cannot open the device or file specified.

  Source File Name: sqlchainingminorbuildactionbehavior.cpp
Compiler Timestamp: Mon Jun 13 14:30:04 2005
     Function Name: sqls::MinorBuildActionBehavior::modifyRequest
Source Line Number: 65

---- Context -----------------------------------------------
sqls::InstallPackageAction::perform

Complete: InstallToolsAction.10 at: 2007/1/6 16:55:59, returned false
Error: Action "InstallToolsAction.10" failed during execution.  Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Action "InstallToolsAction" will return false due to the following preconditions:
Condition "Action: InstallToolsAction.10 has finished and failed." returned true.
Installation of package: "tools"  failed due to a precondition.
Step "InstallToolsAction" was not able to run.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run.  Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run.  Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run.  Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution.  Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000"  failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution.  Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql"  failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run.  Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2007/1/6 16:55:59
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1620
        Error Code: 0x80070654 (1620)
Windows Error Text: This installation package could not be opened.  Contact the application vendor to verify that this is a valid Windows Installer package.

  Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep  1 22:23:05 2005
     Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097

---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
led due to cancel code received from cancel source: 29539

 

 

...and here is the SQLSetup0011_ANTHONYY1_SQL.log:

=== Verbose logging started: 06/02/2007  16:52:14  Build type: SHIP UNICODE 3.01.4000.2435  Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (00:54) [16:52:14:284]: Resetting cached policy values
MSI (c) (00:54) [16:52:14:284]: Machine policy value 'Debug' is 0
MSI (c) (00:54) [16:52:14:284]: ******* RunEngine:
           ******* Product: D:ServersSetupSqlRun_SQL.msi
           ******* Action:
           ******* CommandLine: **********
MSI (c) (00:54) [16:52:14:284]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (00:54) [16:52:14:284]: Grabbed execution mutex.
MSI (c) (00:54) [16:52:14:299]: Cloaking enabled.
MSI (c) (00:54) [16:52:14:299]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (00:54) [16:52:14:299]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A4:98) [16:52:14:299]: Grabbed execution mutex.
MSI (s) (A4:00) [16:52:14:299]: Resetting cached policy values
MSI (s) (A4:00) [16:52:14:299]: Machine policy value 'Debug' is 0
MSI (s) (A4:00) [16:52:14:299]: ******* RunEngine:
           ******* Product: D:ServersSetupSqlRun_SQL.msi
           ******* Action:
           ******* CommandLine: **********
MSI (s) (A4:00) [16:52:21:080]: Note: 1: 2203 2: D:ServersSetupSqlRun_SQL.msi 3: -2147024873
MSI (s) (A4:00) [16:52:21:080]: MainEngineThread is returning 1620
MSI (c) (00:54) [16:52:21:080]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (00:54) [16:52:21:080]: MainEngineThread is returning 1620
=== Verbose logging stopped: 06/02/2007  16:52:21 ===

 

I suppose an error dialog  (or log message) that actually told you what is wrong and then what to do is too much to ask for. (Or an installer than just copied all the files into place). :(

 

 

View Replies !   View Related
Is Sql Server 2005 A Standalone Install? Or Do You Have To Install Windows Server
I have never installed sql server before and I didnt know if I just take the sql server 2005 standard edition media and boot off it and do a fresh install that way or do I have to install Windows server

View Replies !   View Related
Install Enterprise Manager Without Install Sql Server
Hi,Is it possible to install Enterprise Manager without to install theserver ?Thanks !--J-L M. (Alphomega)ICQ: 149635116Pour m'écrire, cliquer le lien ci-dessoushttp://cerbermail.com/?G5iYdBb2Ce

View Replies !   View Related
De-install And Re-install Problems SQL Server 2005
I never installed previous beta versions on my computer before. But now I have some serious problem after an incomplete de-install and a re-install of SQL server 2005 express advanced. I hope anybody can help me to solve this. Because the first installation eas not succesfull I had to do an de-install. I have tried to unstall through start/control panel/ add-remove programms and even there not all programs were removed. And that caused the problem. After that I wanted to re-install again but an msi file was missing. So I did a de-install agian. Tried to re-install again but with a lot of errors. After looking at the library I found a program: Windows Install CleanUp. I installed it and that even gives an error for all programs installed with SQL 2005.
After that I ran a program called MsiInv to clean but without any succes because this program reported a run-tim error.  I have all reports on my computer but don't know how to attach them. If you think you can help me I could send you all the reports.
Regards,
 
Jan J
 
 

View Replies !   View Related
How Do I Create A Database Wizard To Install My Database Anywhere
Hi.. i have created a project which uses SQL 7 as a database and have finished it. MY supervisor wants me
to create a wizard that will be able to install the database on any NT 4.0 machine. How do i start and go about doing
it

Please help
thanks

View Replies !   View Related
Cannot Install Database Diagrams On AdventureWorks Database
Error Message: Database diagram support objects cannot be installed because this database does not have a valid owner.

 

How do I create a valid owner for the database?

View Replies !   View Related
Trying To Install The An SQL Database
I have this CD that has a database called Contacts on it and everytime I try to insatll it I get the same errors.  I'm trying to install it from the D: driveThis is what is to be ran in Query Analyzer

/****** Object: 
Database Contacts    Script Date:
3/7/2002 1:52:44 PM ******/

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE
name = N'Contacts')

            DROP
DATABASE [Contacts]

GO

 

CREATE DATABASE [Contacts] 
ON (NAME = N'Contacts_Data', FILENAME = N'MCSDWebAppschapter05Contacts.MDF'
, SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Contacts_Log', FILENAME =
N'MCSDWebAppschapter05Contacts.LDF' , SIZE = 1, FILEGROWTH = 10%)

 COLLATE
SQL_Latin1_General_CP1_CI_AS

GO

 

exec sp_dboption N'Contacts', N'autoclose', N'false'

GO

 

exec sp_dboption N'Contacts', N'bulkcopy', N'false'

GO

 

exec sp_dboption N'Contacts', N'trunc. log', N'false'

GO

 

exec sp_dboption N'Contacts', N'torn page detection',
N'true'

GO

 

exec sp_dboption N'Contacts', N'read only', N'false'

GO

 

exec sp_dboption N'Contacts', N'dbo use', N'false'

GO

 

exec sp_dboption N'Contacts', N'single', N'false'

GO

 

exec sp_dboption N'Contacts', N'autoshrink', N'false'

GO

 

exec sp_dboption N'Contacts', N'ANSI null default', N'false'

GO

 

exec sp_dboption N'Contacts', N'recursive triggers',
N'false'

GO

 

exec sp_dboption N'Contacts', N'ANSI nulls', N'false'

GO

 

exec sp_dboption N'Contacts', N'concat null yields null',
N'false'

GO

 

exec sp_dboption N'Contacts', N'cursor close on commit',
N'false'

GO

 

exec sp_dboption N'Contacts', N'default to local cursor',
N'false'

GO

 

exec sp_dboption N'Contacts', N'quoted identifier', N'false'

GO

 

exec sp_dboption N'Contacts', N'ANSI warnings', N'false'

GO

 

exec sp_dboption N'Contacts', N'auto create statistics',
N'true'

GO

 

exec sp_dboption N'Contacts', N'auto update statistics',
N'true'

GO

 

use [Contacts]

GO

 

/****** Object:  Table
[dbo].[Calls]    Script Date: 3/7/2002
1:52:49 PM ******/

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Calls]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Calls]

GO

 

/****** Object:  Table
[dbo].[Contact Types]    Script Date:
3/7/2002 1:52:49 PM ******/

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contact Types]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Contact Types]

GO

 

/****** Object:  Table
[dbo].[Contacts]    Script Date: 3/7/2002
1:52:49 PM ******/

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contacts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Contacts]

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

if not exists (select * from dbo.sysusers where name =
N'ASPNET' and uid < 16382)

            EXEC
sp_grantdbaccess N'ASPNET', N'ASPNET'

GO

 

/****** Object:  User
dbo    Script Date: 3/7/2002 1:52:45 PM
******/

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_accessadmin', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_backupoperator', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_datareader', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_datawriter', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_ddladmin', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45 PM
******/

exec sp_addrolemember N'db_denydatareader', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_denydatawriter', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_owner', N'ASPNET'

GO

 

/****** Object:  User
ASPNET    Script Date: 3/7/2002 1:52:45
PM ******/

exec sp_addrolemember N'db_securityadmin', N'ASPNET'

GO

 

/****** Object:  Table
[dbo].[Calls]    Script Date: 3/7/2002
1:52:51 PM ******/

CREATE TABLE [dbo].[Calls] (

            [CallID]
[int] NOT NULL ,

            [ContactID]
[int] NOT NULL ,

            [CallDate]
[datetime] NULL ,

            [CallTime]
[datetime] NULL ,

            [Subject]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

 

/****** Object:  Table
[dbo].[Contact Types]    Script Date:
3/7/2002 1:52:55 PM ******/

CREATE TABLE [dbo].[Contact Types] (

            [ContactTypeID]
[int] NOT NULL ,

            [ContactType]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

 

/****** Object:  Table
[dbo].[Contacts]    Script Date: 3/7/2002
1:52:55 PM ******/

CREATE TABLE [dbo].[Contacts] (

            [ContactID]
[int] NOT NULL ,

            [FirstName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [LastName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Dear]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Address]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [City]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [StateOrProvince]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [PostalCode]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Region]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Country]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [CompanyName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Title]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [WorkPhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [WorkExtension]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [HomePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [MobilePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [FaxNumber]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [EmailName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Birthdate]
[smalldatetime] NULL ,

            [LastMeetingDate]
[smalldatetime] NULL ,

            [ContactTypeID]
[int] NULL ,

            [ReferredBy]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

            [ContactsInterests]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

 

ALTER TABLE [dbo].[Calls] WITH NOCHECK ADD

            CONSTRAINT
[PK__Calls__59063A47] PRIMARY KEY 
CLUSTERED

            (

                        [CallID]

            )  ON [PRIMARY]

GO

 

ALTER TABLE [dbo].[Contact Types] WITH NOCHECK ADD

            CONSTRAINT
[PK__Contact Types__5AEE82B9] PRIMARY KEY 
CLUSTERED

            (

                        [ContactTypeID]

            )  ON [PRIMARY]

GO

 

ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD

            CONSTRAINT
[PK__Contacts__5CD6CB2B] PRIMARY KEY 
CLUSTERED

            (

                        [ContactID]

            )  ON [PRIMARY]

GO

 

GRANT  REFERENCES
,  SELECT ,  UPDATE , 
INSERT ,  DELETE  ON [dbo].[Calls]  TO [ASPNET]

GO

 

GRANT  REFERENCES
,  SELECT ,  UPDATE , 
INSERT ,  DELETE  ON [dbo].[Contact Types]  TO [ASPNET]

GO

 

GRANT  SELECT  ON [dbo].[Contacts]  TO [public]

GO

 

GRANT  REFERENCES
,  SELECT ,  UPDATE , 
INSERT ,  DELETE  ON [dbo].[Contacts]  TO [ASPNET]

GO

 

 

INSERT Contacts VALUES (1, 'Kim', 'Abercrombie', 'Ms.',
'1234 Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1111', '999', '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '8/3/1961', NULL, 1, NULL, NULL, 'Parasailing')

INSERT Contacts VALUES (2, 'Jay', 'Adams', 'Mr.', '631 Eagle
Rd.', 'Watertown', 'PA', '999999', NULL, 'USA', 'Fabrikam', NULL, '(111)
555-1112', '888', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'4/1/1942', NULL, 3, NULL, NULL, NULL)

INSERT Contacts VALUES (3, 'Adam', 'Bar', 'Mr.', '55
Passaway Ave.', 'Boston', 'MA', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1113', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '2/3/1965', NULL, 4, NULL, NULL, 'Fly fishing')

INSERT Contacts VALUES (4, 'Ido', 'Ben-Sachar', 'Mr.', '602A
Leeward Dr.', 'Sarasota', 'FL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1114', '777', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '1/22/1960', NULL, 1, NULL, NULL, NULL)

INSERT Contacts VALUES (5, 'Bradley', 'Beck', 'Mr.', '44
Adams St.', 'Parkaway', 'NJ', '999999', NULL, 'USA', 'Adventure Works', NULL,
'(111) 555-1115', '333', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'9/30/1959', NULL, 2, NULL, NULL, NULL)

INSERT Contacts VALUES (6, 'Karen', 'Berge', 'Mrs.', '205
Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers', NULL,
'(111) 555-1116', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'6/7/1960', NULL, 3, NULL, NULL, 'Windsurfing')

INSERT Contacts VALUES (7, 'Scott', 'Bishop', 'Dr.', '8898
Lipshaw Blvd.', 'Paradise', 'OR', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1117', '555', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '11/23/1961', NULL, 1, NULL, NULL, NULL)

INSERT Contacts VALUES (8, 'Pat', 'Coleman', 'Ms.', 'Rte 3
Highway 99', 'Circle City', 'AZ', '999999', NULL, 'USA', 'Fabrikam', NULL,
'(111) 555-1118', '87', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'10/13/1970', NULL, 2, NULL, NULL, 'Skiing')

INSERT Contacts VALUES (9, 'Jane', 'Clayton', 'Ms.', '2
Wyldflower Ln.', 'Boulder', 'CO', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1119', '22', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '5/4/1961', NULL, 3, NULL, NULL, 'Hunting')

INSERT Contacts VALUES (10, 'Kari', 'Hensien', 'Ms.', '43
Stormwater Cr.', 'Indialantic', 'FL', '999999', NULL, 'USA', 'Adventure Works',
NULL, '(111) 555-1110', '0988', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '7/7/1959', NULL, 1, NULL, NULL, NULL)

INSERT Contacts VALUES (11, 'Don', 'Funk', 'Mr.', '55
Moccasin Wallow Dr.', 'Ernst', 'FL', '999999', NULL, 'USA', 'Fourth Coffee',
NULL, '(111) 555-1120', '111', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '3/15/1966', NULL, 1, NULL, NULL, NULL)



 

INSERT "Contact Types" VALUES(1, 'Business')

INSERT "Contact Types" VALUES(2, 'Social')

INSERT "Contact Types" VALUES(3, 'Friend')

INSERT "Contact Types" VALUES(4, 'Fishing buddy')

 

INSERT Calls VALUES(1,1,'3/3/2002', '12:00PM', 'Hosting
services', 'Return call with estimates')

INSERT Calls VALUES(2,3,'3/3/2002', '1:00PM', 'Trip to
Azores', 'Got lost on way. Needs directions.')

INSERT Calls VALUES(3,2,'2/1/2002', '10:00AM', 'Long call',
'A very, very long call.')

 

 

THIS IS THE ERRORS I KEEP GETTING

Server: Msg 5105, Level 16, State 2, Line 2

Device activation error. The physical file name
'MCSDWebAppschapter05Contacts.MDF' may be incorrect.

Server: Msg 1802, Level 16, State 1, Line 2

CREATE DATABASE failed. Some file names listed could not be
created. Check previous errors.

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70

The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.

 

 

Server: Msg 911, Level 16, State 1, Line 2

Could not locate entry in sysdatabases for database
'Contacts'. No entry found with that name. Make sure that the name is entered
correctly.

Server: Msg 15007, Level 16, State 1, Procedure
sp_grantdbaccess, Line 97

The login 'ASPNET' does not exist.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66

User or role 'ASPNET' does not exist in this database.

Server: Msg 4604, Level 16, State 1, Line 2

There is no such user or group 'ASPNET'.

Server: Msg 4604, Level 16, State 1, Line 2

There is no such user or group 'ASPNET'.

Server: Msg 4604, Level 16, State 1, Line 2

There is no such user or group 'ASPNET'.

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

 

(1 row(s) affected)

 

I JUST WANT TO KNOW WHAT I NEED TO DO STEP FOR STEPTHIS IS MY FIRST TIME ON THIS FORUMCAN ANYONE HELP ME  OUT

View Replies !   View Related
After The Install--Where Is The Database?
I installed SQL Server Express on Windows Vista with no errors.  In the Program Group, the only 'choice' is the 'Microsoft SQL Server Management Studio Express' and when opened the 'Connect to Server' window appears.  There are two choices:
 
Database Engine--but in the  Server name field, the only choice is <Browse for More>
SQL Server Compact Edition--there is a choice for <New Database> but is the Compact Edition really SQL Server Express?
 
I want to upsize an Access 2007 backend to use the SQL Server Express database engine but...................
 
How do I create a database?
 
There is a step missing here.  I've read several docs posted on the SQL Server Express webpage but just can't find this missing step.
 
I've installed and uninstalled SQL Server 5 Express several times to make sure there wasn't some step in the install where a 'first' database is installed.
 
I'm lost.
 

View Replies !   View Related
Install AdventureWorks Database
I'm not sure that I installed the AdventureWorks database when I originally installed SQL Server 2005 on my pc, but I thought I'd better go thru the tutorial and it uses AdventureWorks, so I put my CD in to install it and started the install.

When I got to the screen where you choose your components, I only checked the Sample Database selections at the bottom. Then I got a screen saying the components had already been installed. So I thought I must have installed AdventureWorks when I did the original install, but the tutorial says to go to Registered Servers and do a new Server Registration choosing the AdventureWorks database on the Connection Properties tab. But it isn't listed there when I browse the server's databases.

How can I get it installed?

NOTE: I had SQL Server installed on my C: drive, but had a major corruption issue, so I added a second hard drive to my system and installed XP on it. So my boot drive is now by G: drive, not C:. SQL Server and most of the other programs I use have been re-installed on G:. I DO have northwind.mdb & ldb files on my C: drive. Would it be easiest to just restore them to G:? Are they the AdventureWorks database?
Thanks.

View Replies !   View Related
Cannot Install AdventureWorks Database.
I downloaded AdventureWorksDB from the CodePlex website and tried to install it.  When the install program tried to attach it to SQLEXPRESS, it gave the error (below).  I've also tried attaching the database directly using the SQL Management Studio and got exactly the same error.
 
I'd never heard of having incompatible database versions for SQL Server before.  Am I missing a patch for SQLEXPRESS or ????.  Thanks.
 
=================================================================
 
The database 'AdventureWorks' cannot be opened because it is version 631. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)
------------------------------
Server Name: HP-MEDIACENTERSQLEXPRESS
Error Number: 948
Severity: 20
State: 1
Line Number: 1

View Replies !   View Related
Can't Attach A Database During An Install
I have a Wise for Windows Installer package that will install SQL Express 2005 and then attach a database. In order to keep consistent I am placing the new .MDF file in C:Program FilesMicrosoft SQL ServerMSSQL$INSTANCEdata. If the folders don't exists I create them. Well, on one test machine I create the folder and copy the MDF to the directory and then use 'osql' to attach the database but I am getting this error:

Msg 5173, Level 16, State 1, Server SREXROAT2FHMOBILE, Line 1 One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. Msg 1813, Level 16, State 2, Server [COMPUTERNAME], Line 1 Could not open new database '[DATABASE NAME]'. CREATE DATABASE is aborted. Log file '[LOG FILE NAME]' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.

Does anyone know how to get around this? It works on our other test machines with the same database.

View Replies !   View Related
Recommended Way To Install Database Driven App.
I was wondering what everyones preferred way to install a database in an automated fashion is.. IE:

You have a webapp. It sdriven by SQL Server. You need to prompt the user for a server, username, password, and database. Once you have those, you execute thge scripts against the DB.

I've been using osql.exe. but heres the situation. The installer may be run from a system, which does not have the sql server client tools installed. Which will be a problem.

So, given the situation that the machine the application is being installed on, does not have the client tools installed. How would YOU execute the provided SQL script against a remote server.

View Replies !   View Related
Best Way To Install A Database At A Remote Site
Greetings,I am in the process of installing a SQL database at a customerlocation. I have determined that there are 3 ways to do this, and Iwanted to know which is the best of the 3.1 Install From Script.In this method I create the database and its objects in scripts thatare run via osql utility on the SQL server machine. For loading anyinitial data that I need in the database I also run bcp commands.2 Install from a backupIn this method I created an empty database on the SQL server, and thenrestore over it the database from a backup of the database that I needto deploy. Then I add or re-attach the users for the database. Iperform all of these operations using osql as well.3 Install by attaching the data files.In this method I created an empty database on the SQL server, and thenI attach the data files to the database using the sp_attach procedure.Then I add or re-attach the users for the database. I perform all ofthese operations using osql as well.Although it is no problem for me to use any of these methods, I wantedto know from you veterans out there what the best practices are. Andalso if there are any unseen hazards for each method above. Or if Iam totally off-the-target, and there is another method that is thepreferred way.Thanks in Advance,roger

View Replies !   View Related
SQL-2000 Can&#39;t Install Database, Only Clienttools
I have a new win2000 and a new sql2000. Can anyone please tell me why the SQL 2000 setup-CD prompt me an error, telling me that i can't install the database, only clienttools?

Michael

View Replies !   View Related
SP1 Database Services Failed To Install
Database services upgrade installation keeps failing when I try to install SP1 on a SQL 2005 Developer edition.

This is the log: 

04/28/2006 10:35:44.081 Failed to read registry key: PendingFileRenameOperations
04/28/2006 10:35:44.097 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll
04/28/2006 10:35:44.144 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll
04/28/2006 10:35:44.160 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll
04/28/2006 10:35:44.191 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll
04/28/2006 10:35:44.222 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnlhtml.dll
04/28/2006 10:35:44.254 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsir5jp.dll
04/28/2006 10:35:44.285 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftesql.exe
04/28/2006 10:35:44.316 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftepxy.dll
04/28/2006 10:35:44.348 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftefd.exe
04/28/2006 10:35:44.379 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsfte.dll
04/28/2006 10:35:44.410 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLangWrbk.dll
04/28/2006 10:35:44.426 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnkorwbrkr.dll
04/28/2006 10:35:44.457 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinninfosoft.dll
04/28/2006 10:35:44.488 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERefFTERef.dll
04/28/2006 10:35:44.520 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnCHTBRKR.DLL
04/28/2006 10:35:44.551 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnChsBrkr.dll
04/28/2006 10:35:44.582 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMResources1033REPLRES.rll
04/28/2006 10:35:44.614 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplrec.dll
04/28/2006 10:35:44.645 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
plisapi.dll
04/28/2006 10:35:44.692 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:WINDOWSassemblyGAC_32Microsoft.SqlServer.Replication9.0.242.0__89845dcd8080cc91Repl.dll
04/28/2006 10:35:44.723 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll
04/28/2006 10:35:44.755 Failed to read version information for the following file: C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
plhtfin.sql
04/28/2006 10:35:44.786 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
C:Program FilesMicrosoft SQL Server90COMqrdrsvc.exe
04/28/2006 10:35:44.817 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMsnapshot.exe
04/28/2006 10:35:44.848 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplmerg.exe
04/28/2006 10:35:44.864 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90COM ablediff.exe
04/28/2006 10:35:44.911 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMDISTRIB.exe
04/28/2006 10:35:44.927 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnDatabaseMail90.exe
04/28/2006 10:35:44.989 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources30822005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources2052sqlevn70.rll
04/28/2006 10:35:45.021 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10422005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1041sqlevn70.rll
04/28/2006 10:35:45.052 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10402005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1036sqlevn70.rll
04/28/2006 10:35:45.083 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1031sqlevn70.rll
04/28/2006 10:35:45.115 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10282005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033XPStar90.RLL
04/28/2006 10:35:45.146 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/28/2006 10:35:45.177 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/28/2006 10:35:45.209 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/28/2006 10:35:45.256 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn6.6.3.5
C:Program FilesMicrosoft SQL Server90Sharedmsxmlsql.dll
04/28/2006 10:35:45.287 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2.0.3609.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlrw.dll
04/28/2006 10:35:45.302 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/28/2006 10:35:45.349 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/28/2006 10:35:45.381 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/28/2006 10:35:45.412 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLBOOT.dll
04/28/2006 10:35:45.443 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxplog70.dll
04/28/2006 10:35:45.475 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnatchp~1.dll
04/28/2006 10:35:45.506 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/28/2006 10:35:45.537 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/28/2006 10:35:45.569 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/28/2006 10:35:45.616 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/28/2006 10:35:45.647 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/28/2006 10:35:45.678 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/28/2006 10:35:45.709 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/28/2006 10:35:45.741 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/28/2006 10:35:45.772 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/28/2006 10:35:45.803 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/28/2006 10:35:45.850 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/28/2006 10:35:45.882 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/28/2006 10:35:45.913 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90SharedResources10339.0.2047.0
C:Program FilesMicrosoft SQL Server90Sharedmsmdrdir.dll
04/28/2006 10:35:45.960 Failed to read version information for the following file: C:Program FilesCommon FilesSystemole db2.0.3609.0
C:Program FilesCommon FilesSystemole dbxmlrw.dll
04/28/2006 10:35:45.991 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/28/2006 10:35:46.038 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/28/2006 10:35:46.070 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/28/2006 10:35:46.101 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/28/2006 10:35:46.132 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/28/2006 10:35:46.163 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/28/2006 10:35:46.195 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/28/2006 10:35:46.226 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/28/2006 10:35:46.257 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/28/2006 10:35:46.304 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml
04/28/2006 10:35:46.320 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll
04/28/2006 10:35:46.367 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
04/28/2006 10:35:46.398 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033
C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml
04/28/2006 10:35:46.430 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/28/2006 10:35:46.461 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/28/2006 10:35:46.492 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/28/2006 10:35:46.523 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/28/2006 10:35:46.555 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/28/2006 10:35:46.602 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/28/2006 10:35:46.633 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/28/2006 10:35:46.680 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/28/2006 10:35:46.696 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/28/2006 10:35:46.727 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql
04/28/2006 10:35:46.758 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/28/2006 10:35:46.774 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/28/2006 10:35:46.805 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/28/2006 10:35:46.837 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2.0.3609.0
C:Program FilesMicrosoft SQL Server90ToolsBinnSQLdiag.exe
04/28/2006 10:35:46.852 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsvc~1.dll
04/28/2006 10:35:46.884 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/28/2006 10:35:46.899 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/28/2006 10:35:46.930 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/28/2006 10:35:46.977 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/28/2006 10:35:47.009 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/28/2006 10:35:47.040 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/28/2006 10:35:47.056 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/28/2006 10:35:47.087 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/28/2006 10:35:47.118 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/28/2006 10:35:47.134 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/28/2006 10:35:47.165 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/28/2006 10:35:47.181 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/28/2006 10:35:47.212 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe
04/28/2006 10:35:47.244 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0
C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll
04/28/2006 10:35:47.275 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/28/2006 10:35:47.291 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/28/2006 10:35:47.322 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/28/2006 10:35:47.337 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Rmo.dll
04/28/2006 10:35:47.369 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL
04/28/2006 10:35:47.400 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL
04/28/2006 10:35:47.416 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll
04/28/2006 10:35:47.447 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/28/2006 10:35:47.463 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/28/2006 10:35:47.494 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/28/2006 10:35:47.525 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll
04/28/2006 10:35:47.541 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll
04/28/2006 10:35:47.572 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll
04/28/2006 10:35:47.604 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll
04/28/2006 10:35:47.635 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll
04/28/2006 10:35:47.651 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlSAC.exe
04/28/2006 10:35:47.682 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedMicrosoft.SqlSac.Public.dll
04/28/2006 10:35:47.932 Attempting to install file: sqlrun_sql.msp
04/28/2006 10:35:47.995 Attempting to install file: \LGTECHNET-2c$3b84918ca5a77d70db62f8c0HotFixSQLFilessqlrun_sql.msp
04/28/2006 10:35:48.026 Creating MSP install log file at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log
04/28/2006 10:35:48.058 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/28/2006 10:35:48.073 Failed to read registry key: Debug
04/28/2006 10:37:31.594 MSP returned 1603: A fatal error occurred during installation.
04/28/2006 10:37:31.813 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/28/2006 10:37:31.844 Failed to read registry key: Debug
04/28/2006 10:37:31.891 Unable to install MSP file: \LGTECHNET-2c$3b84918ca5a77d70db62f8c0HotFixSQLFilessqlrun_sql.msp
04/28/2006 10:37:31.907 The following exception occurred: Unable to install Windows Installer MSP file  Date: 04/28/2006 10:37:31.907  File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp  Line: 856

View Replies !   View Related
SQL 2005 Cluster, Can Not Install New Database
I am trying to install a new database onto a SQL 2005 cluster with installshield and am getting an error that I can not find any info on. The error is as follows.
 
"Cannot use program file ... for cluster server. Only 4 metafiles on which the cluster resources of the server has a dependency can be used."
 
I will confess to knowing very little about clustering so any help would be greatly appreciated.
 
-John
 
 

View Replies !   View Related
Install The Pubs Sample Database Problem
Need help.After I installed MSDE. I opened a command prompt and navigate to C:Program FilesMicrosoft Visual studio .NET 2003SDKv1.1SamplesSetupAnd then I typed in: oSpl -S(local)VSdotNET -E -i instpubs.sqlI got the message:[DBNETLIB]SQL Server does not exist or acdcess denied.[DENETLIB]ConnectionOpen (Connect()).How can I fix it?The server 2000 is running and it's mixed login authentication.OS: windows server 2003Thank you,William

View Replies !   View Related
How Can I Create An Install Script Using An Existing Database?
I have a database full of tables but no install script. Is there a way
I can use EM or QA to create a create database with all the tables
script?

What I am trying to avoid is going through by hand to all these tables and writing out the sql to create the tables...

I know you can do it one table at a time in QA by clicking on the table
and choosing 'Script object as new', but I was wondering if there was a
way to do this for an entire database at once, instead of one table at
a time...


Thanks!

View Replies !   View Related
How To Install MSDE To Work With QuickStart Database
Hi

I have just tried to install MSDE and tried to make that work with Quickstart, however after several tries, I gave up, because everytime I installed MSDE it still does not want to work with Quickstart, can anyone please tell me how to do just that ?

I wonder some people in this forum complained about it as well. I wonder why it is so hard. And do I have to employ a DBA to do just that ^_^

I realized that MSDE that comes with VS.net 2002 CD was a lot easier to install and configure than the MSDE sp3

I am using Windows XP, VS.net 2003, ASP.net V1.1 and MSDE Sp3

Please help me all

Thank you

View Replies !   View Related
How Can I Useing SQL6.5 Database After Install SQL7
Hi:
After I am install SQL7.0 clent tools in my WINDOWS95,
The SQL7.0 database can access very well,
but I am access SQL6.5 database object(tables) then the select data is bad,
why ? help me please.

View Replies !   View Related
Cannot Determine How To Set Owner To Install Database Design
My compatibility settings are fine. Anyone know how to to this?

View Replies !   View Related
Connecting To Local Database After Application Install
 

I have created an application which uses a SQL Express database.  The program runs fine on the the computer where I built the app, however when I install the app on another computer I get an error telling me that under default SQL Express does not allow remote connections.  The problem is that I dont want a remote connection I want a local connection, the database file is on the commputer.  How can do get my application to look for the database on the local machine.

My connection string is:

Data Source=(local)SQLEXPRESS;Initial Catalog="C:DOCUMENTS AND SETTINGSADMINISTRATORPLDAQ.MDF";Integrated Security=True

I have made sure that the file is in the correct directory.

Any help would be greatly appretiated

View Replies !   View Related
Can't Seem To Install SQL Server 2005? Install Completes, But Where Is SQL Server 2005
I went to one of the Microsoft "Ready To Launch" events over a year ago. Microsoft was gracious and gave everyone who attended a free copy of Visual Studio 2005 and SQL Server 2005. I have installed the Visual Studio and use it all of the time. I also installed the SQL server 2005 but I can not find the application on my computer. After the install the only items that appear to have been installed are the following:
SQL Server Configuration tools(SQL Server Configuration manager,SQL Server  Error and usage reporting, SQL Server surface area confiuration, Reporting Services configuration). There is also a menu icon labeled "Microsoft SQL server upgrade advisor" and SQL server upgraded wizard.
That is all. I can't find anything that is analogus to the Enterprise manager that was in SQL server 2000 or anything that is analogous to Query Analyzer of 2005.
 
Can someone help me out? We use SQL server 2005 so I know how it looks. I just can't see where it insalled. I don't think it did?
 
 

View Replies !   View Related
(Changing Provider) Need Scripts To Install Database For ASP.NET Services
I have my web application using SQL Express database that works fine on my machine. After uploading to my shared host, it had an error saying that it can't connect to the remote server. After a few back and forth conversations with my host tech supports, I guess that they don't have SQL Express enabled on their server.
So I decided to change my provider to SQL Server 2000 but need to populate all the tables needed for ASP.NET application services (membership, profiles, role management, etc..). I read Scott's log (http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx) but his instruction is to use aspnet_regsql which I can't do that on my shared host environment. But he said there are raw .sql scripts that actually run behind the scene. Do any of you here know where I can download those scripts?
Thanks in advance
Tran

View Replies !   View Related
Error, Unable To Open Database After Install On XP Computer
 

Hi all,
I'm new to .NET and VB2008 and trying to write my first database application.  It runs fine on my development PC (Vista) but I decided to publish/install an early beta to my daughters XP computer and am getting an error reading: Unable to open database.
 
The CD drive on that pc has been giving us trouble so I deployed to a subdirectory on the dev pc and moved those files to a thumbdrive, copied to the same subdirectory on client pc and installed from there.  I've installed it more than once, trying different paths for the installed version hoping that was the issue but have hit a wall.  Can anybody help?
 
Thanks,
 
Dominic

 
 

View Replies !   View Related
Why No Config.exe File In Book ASPnet 2.0 SBS By George Shepherd, To Install ASPNETDB Database?
For MS Press Book, ADO.NET 2.0 Step by Step, 2005 Edition by Rebecco Riordan, installing the code samples created a ConfigDB.exe file
under SampleDBs folder. Running this exe file created a AdoStepByStep into the Database
folder in SQL Server 2005 Express. 

However, for ASP.NET 2.0 Step by Step, 2005 Edition, by George Shepherd, there is no Config.exe to install the ASPNETDB SQL Server
2005 Express database. I right clicked the Database folder to 'Attach' the database.  But,
the database just showed a 'c: ASPNETDB.MDF filfe path as a name. Further, running
the aspx files in Chapters 7 and 12 showed a 'Timeout Expired' error msg, indicating
something wrong with accessing the SQL Server database.

How can I run the aspx files in Chapters 7 and 12?  How can I install the ASPNETDB?

TIA,
Jeffrey

View Replies !   View Related
Unable To Install SQL Server CE Server Tool On SQL Server 2000 SP 4
Hi,
 

I have installed "SQL Server 2000 SP 4" to SQL server and it is running fine.
 
But when i install the "SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4", i get below error:
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.
When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
 
I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but  still fail.
 
By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file.
 
Appreciate if anyone tell me the solution.
 
Thanks in advance.
 
Best regards,
Plane.

View Replies !   View Related
Unable To Install SQL Server CE Server Tool On SQL Server 2000 SP 4
Hi
I am facing problem with installing SQL Server CE Server Tool,

I have installed SQL Server 2000 SP 4 which is working fine.

While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."

I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.

I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue.
Help me please.

Thanks in advance.

Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)

View Replies !   View Related
Unable To Install SQL Server CE Server Tool On SQL Server 2000 SP 4
Hi
I am facing problem with installing SQL Server CE Server Tool,

I have installed SQL Server 2000 SP 4 which is working fine.

While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."

I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.

I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue.
Help me please.

Thanks in advance.

Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)

View Replies !   View Related
Sql Express Install - Does Not Install Manager If Full Text Search Is Selected
I downloaded SQLEXPR_ADV.EXE on 25/04/2006  01:26 PM ET.
If I don't choose to install full text search, then all is fine.

If I choose to install full text search, then it does not install the manager.

Has anyone else come across this problem and if so what was the solution.

View Replies !   View Related
Fail To Install SQL Server 2005 (Clustering): SQL Server Setup Was Unable Add User
Hello all,

I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back.
 
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
 
SQL Server Setup was unable add user domain1xyz to local group domain1IT Security Admin-Group.
 
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x6ba
 
I have refered to PostI=1659185 posted by Fly and it still won't be able to fix my problem.
 
I have added LOCAL SERVICE into the local group (SQLServer2005MSFTEUser$AAA$MSSQLSERVER), but it still can't work.
 
Please can someone help me on this. Thank a lot....

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved