I have Visual Studio Tools for Office (VSTO) and the SS 2005 Developer
that comes with it, all of which I can install on my local XP box.
1. Which one do I install first, VSTO or SS 2005 Developer??
2. Regardless of which one is installed first, what's the best way
after that to move or copy database objects like tables, queries,
reports, etc. from the XP/developer box to an SS 2005 Server??
Thank you, Tom
OK folks...
here is my deal. I have had the SQL 2005 Dev. Installed on my machine for 6 mos or so. I have had an issue with VS2003,2005 and attempting to get 2008 to use some Silverlight applications...
Long story short...Nothing is working for me and I know want to get my system back to ground zero (Prior to Silverlight desires) I have had to un-install several items. I am also trying to regain the VS2005 that came in my SQL2005 install.
Anyway - I can not un-install my SQL2005 stuff from my PC?
I've just installed SQL 2005 32-bit developer edition on my WinXP pro w/ SP2 machine. Previously, it had an instance of Sql 2000 with VS 2005.
I am looking to use the XML features of SQL 2005. However, a "FOR XML PATH" query gives me an error "Incorrect syntax near 'PATH'".
The properties for my local, upgraded instance show a version of 8.00.760. However, all that appears in the SQL Server Configuration Manager is Integration Services and Reporting Services - no database engine.
Finally, there does not appear to be any tables in the installed AdventureWorks2000 database.
Any suggestions?
Sid
I have read the system requirement readme file and found that we can install the SQL Server 2005 on Developer mode. I Have SQL Server 2005 Enterprise but inside the setup directory i found sqlrun_DTS.msi, is this installer for developer ? Well if so then here is the problem when i try to install.
View 2 Replies View RelatedI am trying to install SQL 2005 Developer but when I get to the setup screen for Components to Install, Reporting Services is greyed out. Does anyone know why?
Thank you,
David
I copied the error I received.
View 4 Replies View RelatedI'm trying to install SQL Server 2005 (Developer edition) on my Vista Ultimate machine.
I've got the IIS 7 features turned on; I've got the SP2 patch CD; and I've run every install as administrator. I've run the SQL Server setup before and after the SP2 patch
I'm doing a named instance using the built-in system account with windows authentication mode.
Is there any COMPLETE guide as to how to work through all these installation problems?
I've gotten same results after about six attempts.
These always install:
SQL Setup Support Files
SQL Native Client
SQL VSS Writer
SQL Server Backward Compatibility Files
SQLXML4
SQL Server Books Online
These always fail:
OCW11
SQL Server Database Services
Analysis Services
Reporting Services
Notification Services
Integration Services
Workstation Components; Books Online
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text: Source File Name: sqlcasqlmofca.cpp
Compiler Timestamp: Tue Aug 9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text: Source File Name: sqlcasqlmofca.cpp
Compiler Timestamp: Tue Aug 9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I am working on a automated install (simulated with a batch file first) and I am having issues when I trying to install SQL2005dev, then SP1 and then the hotfixes. The main issue is SP1 returns to the batch file while it is still running.
Does anyone know how to silently run SP1 and make it wait until after it is installed to continue (on to the hotfixes)?
Example batch file:
"SQLDEVSELSQL Server x86Serverssetup.exe" LOGNAME=C:setupsetup.cab /settings %temp%sqldevsel_1.ini /qb
"sp1SQLServer2005SP1-KB913090-x86-ENU.exe" /quiet /allinstances /norestart
"HotfixesSQL Server x86sql2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86as2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86dts2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86s2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86
s2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86sqltools2005-kb918222-x86-enu.exe" /quiet
I have SQL Server 2005 Developer Edition installed on XP Pro sp2 and have not been able to get OLE DB Provider for DB2 Version 1.0 with Service Pack 1 to install. After getting a notice that the install has failed, I get these log files:
=== Logging started at: 2:12:35 PM Monday, August 20, 2007 Build: 7.0.3038.0 Calling process: H:SQL2005DB2OLEDB7Setup.exe === The current user is NORTHGRUMdinsest. Computer name: DICA2ESITE13005 OS Version: 5.1 Build: 2600 Service Pack: 2.0 Suite: 256 Product Type: 1
[2:12:35 PM Info] Command Line: H:SQL2005DB2OLEDB7Setup.exe
[2:12:35 PM Info] Language: 1033
[2:12:59 PM Info] Raw module path: H:SQL2005DB2OLEDB7Setup.exe
[2:12:59 PM Info] Universal module path: H:SQL2005DB2OLEDB7Setup.exe
[2:12:59 PM Info] Current version of msi.dll is: 3.1 build: 4000 platform: 2
[2:12:59 PM Info] Raw module path: H:SQL2005DB2OLEDB7Setup.exe
[2:12:59 PM Info] Universal module path: H:SQL2005DB2OLEDB7Setup.exe === Logging stopped: 2:12:59 PM Monday, August 20, 2007 === === Logging started at: 2:13:00 PM Monday, August 20, 2007 Build: 7.0.3038.0 Calling process: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe === The current user is NORTHGRUMdinsest. Computer name: DICA2ESITE13005 OS Version: 5.1 Build: 2600 Service Pack: 2.0 Suite: 256 Product Type: 1
[2:13:00 PM Info] Command Line: H:SQL2005DB2OLEDB7Setup.exe /Relaunch /RunningFromTemp /SetupXML C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpHISDB2_x86.xml
[2:13:00 PM Info] Language: 1033
[2:13:00 PM Info]
[2:13:00 PM Info] Running prehook init function
[2:13:00 PM Info] Entering PreInitHook
[2:13:00 PM Info] Detecting Sql Server 2005 (32bit)
[2:13:00 PM Info] Enumerating Sql Server 2005 instances from SoftwareMicrosoftMicrosoft SQL ServerInstance NamesSQL
[2:13:00 PM Info] Checking SQL version and edition for: SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1Setup
[2:13:00 PM Info] Got Version 9.2.3042.00
[2:13:00 PM Info] Got edition Developer Edition
[2:13:00 PM Info] Done enumerating Sql Server 2005 instances, original hr = 00000000
[2:13:00 PM Info] Done enumerating Sql Server 2005 instances, hr = 00000000
[2:13:00 PM Info] Done detecting Sql Server 2005, hr = 00000000
[2:13:00 PM Info] Detecting existing integration server installations
[2:13:00 PM Info] Integration server is not installed
[2:13:00 PM Info] Done detecting existing integration server installations, hr = 00000000
[2:13:00 PM Info] Leaving PreInitHook (hr = 00000000)
[2:13:00 PM Info] Prehook Init function returned: 0.
[2:13:00 PM Info] Prehook Init function returned the following mode: 0
[2:13:01 PM Info] Product code: {722CAF00-DE6E-4438-82DE-E664B8B6222B}
[2:13:01 PM Info] Product name: Microsoft OLE DB Provider for DB2
[2:13:01 PM Info] Product PIDSKU: BI6-00082
[2:13:01 PM Info] Product Code (MPC): 91197
[2:13:01 PM Info] OEMID:
[2:13:01 PM Info] Product is not already installed.
[2:13:01 PM Info] Successfully opened Msi package: H:SQL2005DB2OLEDB7Msix86HISDB2.msi
[2:13:01 PM Info] Raw module path: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe
[2:13:01 PM Info] Universal module path: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe
[2:13:10 PM Info] Initializing Component Updater ...
[2:13:10 PM Info] Initialized Component Updater
[2:13:10 PM Info] No updates were found on the SUS server to download.
[2:13:14 PM Info] Required platform components:
[2:13:20 PM Info] Initializing Component Updater ...
[2:13:20 PM Info] Initialized Component Updater
[2:13:20 PM Info] No updates were found on the SUS server to download.
[2:13:20 PM Info] Required platform components: (none)
[2:13:20 PM Info] MSI command line: ADDLOCAL=REQUIRED_FEATURE,OLE_DB_PROVIDER_FOR_DB2 INSTALLDIR="C:Program FilesMicrosoft OLE DB Provider for DB2" PIDKEY="R2D433DHG9DQ79WW3DXQ929DY" USERNAME="Northrop Grumman Corporation" COMPANYNAME="NGGN" FILESINUSEERROR=""
[2:13:20 PM Info] MSI command line is ADDLOCAL=REQUIRED_FEATURE,OLE_DB_PROVIDER_FOR_DB2 INSTALLDIR="C:Program FilesMicrosoft OLE DB Provider for DB2" PIDKEY="R2D433DHG9DQ79WW3DXQ929DY" USERNAME="Northrop Grumman Corporation" COMPANYNAME="NGGN" FILESINUSEERROR=""
[2:13:20 PM Info] Detailed Log information for product H:SQL2005DB2OLEDB7Msix86HISDB2.msi is available at DetailedLog
[2:13:20 PM Info] MSI installation returned 2 - The system cannot find the file specified.
[2:13:20 PM Error] Error 0 occurred during MSI installation.
[2:13:20 PM Error]
[2:13:20 PM Error] === Logging stopped: 2:13:25 PM Monday, August 20, 2007 ===
Detailed Log
=== Verbose logging started: 8/20/2007 14:13:20 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe ===
MSI (c) (E4C) [14:13:20:343]: Resetting cached policy values
MSI (c) (E4C) [14:13:20:343]: Machine policy value 'Debug' is 0
MSI (c) (E4C) [14:13:20:343]: ******* RunEngine:
******* Product: H:SQL2005DB2OLEDB7Msix86HISDB2.msi
******* Action:
******* CommandLine: **********
MSI (c) (E4C) [14:13:20:343]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (E4C) [14:13:20:343]: Grabbed execution mutex.
MSI (c) (E4C) [14:13:20:359]: Cloaking enabled.
MSI (c) (E4C) [14:13:20:359]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (E4C) [14:13:20:359]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (B88) [14:13:20:374]: Grabbed execution mutex.
MSI (s) (B8:90) [14:13:20:374]: Resetting cached policy values
MSI (s) (B8:90) [14:13:20:374]: Machine policy value 'Debug' is 0
MSI (s) (B8:90) [14:13:20:374]: ******* RunEngine:
******* Product: H:SQL2005DB2OLEDB7Msix86HISDB2.msi
******* Action:
******* CommandLine: **********
MSI (s) (B8:90) [14:13:20:374]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (B8:90) [14:13:20:406]: MainEngineThread is returning 2
MSI (c) (E4C) [14:13:20:421]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (E4C) [14:13:20:421]: MainEngineThread is returning 2
=== Verbose logging stopped: 8/20/2007 14:13:20 ===
Does anyone have an idea as to why the installation is failing?
TIA,
Steve
P.S. Those aren't really smileys, they're actually semicolon Ds but I can't seem to get rid of the cartoon translation, even after checking the "This post contains a code sample" checkbox.
I have tried several times to install
SQL Server 2005 Developer Edition (most recently from MSDN Disk
3097.1) I have tried to complete an uninstall before each
attempt.
I do get the warning about Minimum Hardware Requirement, but can find
nothing in the detail requirements to exclude my PCs configuration.
I have installed: IIS and .NET Framework 2.0
I have also used ..aspnet_regiis -r to register ASP.NET
I am, successfully, running Visual Studio 2005.
Why does the installation process stop there and what can I do next?
I do get the warning about Minimum Hardware Requirement, but can
find nothing in the detail requirements to exclude my PCs configuration.
I have installed:
IE 6.0 sp1
IIS as a part of Win 2000 Professional Edition SP4
I have also used ..aspnet_regiis -r to register ASP.NET 2.0
.NET Framework 2.0
SQL Server Native Client
SQL Server Setup support files
PC includes:
Pentium III 800 MHz
512 MB memory
HardDrive C: 5.92 GB (1.37 GB free)
HardDrive D: 13.1 GB (9.11 GB free)
I have tried several times to install SQL Server 2005 Developer Edition
(most recently from MSDN Disk 3097.1) I have tried to
complete an uninstall before each attempt.
I am, successfully, running Visual Studio 2005.
Any suggestions will be appreciated.
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition.
I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel.
I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005.
1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over?
I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working...
2) What should I be doing to install SQLServer 2005 Developer Edition successfully?
I have been a strong supporter of Microsoft, but this is getting me very frustrated.
Please help,
- Chaz
I want to install SQL Server 2005 Developer Edition on a computer with Vista Business. It looks like a lot of issues. (1) Can I do this? (2) Does anyone have any instrucions?
Thanks for your help
During the install, I receive this message:
"Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online."
So, I went to the following and did everything documented about installing IIS 7.0.
http://msdn2.microsoft.com/en-us/library/aa964620.aspx
After installing IIS and verifying that it is serving pages just fine, when I try to install again, I still get the quoted error message above.
I am beginning to think that I cannot install SQL Server Developer on Vista Home Premium.
Does anyone know?
Thanks
Has microsoft issued an update so I can install SQL 2005 DE on Windows Vista? Thank You!
View 3 Replies View RelatedI have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!
View 11 Replies View Related(1) I have already installed of SQL Server 2005 Developer Edition first.
(1) Can I install visual studio 2008 without the 2005 express edition of SQL server? Will be any problems because I don't have express edition of SQL server? Do I need to install the express edition of SQL server as well?
(3) How to use SQL Server 2005 Developer Edition instance on visual studio 2008?
Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?
I
was about to order SQL Server Developer Edition 2005 on Amazon, to use
with Visual Web Developer 2005 Express, when I read a user comment that
the two are incompatible with each other. Does anyone know for sure if
that is true?
What I'm wanting to do is develop an ASP.NET web
application on a web host using a SQL Server database. I use VS2003 and SQL
Server Enterprise 2000 at work, but I'd like to learn the 2005 editions
for this side project. I don't own any of the developer tools/IDEs
personally, so I'm trying to find the most affordable way to do this
for my home business.
Thanks for any advice,
Keith
There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
Hi,
We've just completed a migration to SQL Server 2005, and I'm wondering what needs to be installed on our developer workstations and whether it requires a licence or not. Sorry, i know this is a dumb newbie question!
Many thanks,
Kev
Hi, folks.
I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to simultaneously learning ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-)
Advice?
TIA,
Bob
I'm trying to install a default instance of Developer edition on alaptop. I'm getting the following promblems shown in sqltp log. Thelaptop has previously had the SQL Developer installed but has sincehad OS installed.I've tested named pipes to another server (net view, net use) and itseems to be working.any ideas ?Starting Service ...Latin1_General_CI_AS-m -Q -T4022 -T3659Connecting to Server ...driver={sql server};server=J6Y741J;UID=sa;PWD=;database=master [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead(GetOverLappedResult()).driver={sql server};server=J6Y741J;UID=sa;PWD=;database=master [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead(GetOverLappedResult()).driver={sql server};server=J6Y741J;UID=sa;PWD=;database=master [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead(GetOverLappedResult()).SQL Server configuration failed.
View 1 Replies View RelatedDeveloper Edition was purchased for $50, will not install, during installation process got warnings for IIS and minimum hardware requirement. My site/DB developer talked me through the steps to completely uninstall SQL on supportmiscrosoft only to get this error notice: "Setup has encountered an unexpected error in datastore." I called MS only to be told it would cost $245 to talk to a tech or $99 to email one. Any suggestions? I had SQL Express for a few days and it worked fine but my developer felt I needed the Developer Edition so his company purchased that for me. I uninstalled Express before trying to install Dev Ed - my first attempt to install ended up in a flash of a blue screen then a reboot. Thanks in advance for any help.
View 1 Replies View Related
Hi there everybody
I am a novice in using MSSQL and Windows 2003 solutions so I am having some problems.
I have made an excel addon in VSTO that connects to a MSSQL2005 server running on Windows 2003 on our internal domain, and it works great. Connection when I specify the domain adress is flawless. The thought is though that the addin is supposed to been used also outside our domain, so I have opened up our router and redirects all traffic to and from port 1433 to our MSSQL-server. This part should be ok.
I can then not connect to this server with our external ip specified. The error message Visual Studio produces is "An error has occured 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. (provider: TCP Provider, error: 0 -A connection attempt failed because the connected party did not properly respond after a period of time, or established connecteion failed because connected host has failed to respond.)"
I have read around and tried to fix this myself. I've specified to accept "Locale and remote connections" in the Surface Area Configuration Tool that shipped with MSSQL on both TCP/IP and named pipes. In the SQL Server Configuration Manager is the protocols Shared Memory and TCP/IP enabled. I have enabled all the IP-adresses under TCP/IP and specified 1433 as the port to use for all of them.
As for possible other problems I can see:
I have read a couple of places that people have tried to connect with the MSSQL server through telnet when specifying the port 1433 (telnet mydomain.net 1433). I have tried this but telnet is not getting a connection. Dont I have to open/forward more ports on the router to get telnet through?
I cant ping our external ip. Isnt this also a problem that is related to that I have not opened/forwarded ports on the router to our MSSQL server?
Do anyone of you have any tips or steps to take to narrow the problem down? This is not the forum for VSTO but thats not really where the problem is either, I think. It is probably somewhere in the configuration of MSSQL or Windows 2003. The server machine is set up as domain controller and DNS server for our local net.
I will appreciate all input, I am stuck at the moment...
Stein Agnar Sannes
Programmer (c, php, perl, java)
** Error in msgbox : “Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information. �
** Cut From: C:WINDOWSsqlstp.log – ( previous exit codes look OK) ---
(previous text removed) …
21:54:29 C:Program FilesMicrosoft SQL Server80ToolsBinncnfgsvr.exe -F "C:WINDOWSsqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66364 -U sa -P
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=cn91909-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=cn91909-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=cn91909-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
SQL Server configuration failed.
###############################################################################
21:54:55 Process Exit Code: (-1)
21:57:07 Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information.
21:57:07 Action CleanUpInstall:
21:57:07 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
21:57:07 Process Exit Code: (1060) The specified service does not exist as an installed service.
21:57:07 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
21:57:07 Process Exit Code: (0)
21:57:07 StatsGenerate returned: 2
21:57:07 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
21:57:07 StatsGenerate -1,debbie)
21:57:07 Installation Failed.
Can I have both of them installed ? I work on applications sometimes on two different machines. One has Visual studio w/ sql 2005 developer edition, the other with express editions of both. Can I install sql express on my workstation that already has developer edition ?
View 3 Replies View RelatedHi,
I'm installing SQL developer edition using commandline options. Below is the command line I'm using.
setup.exe" /qn INSTANCENAME=MSSQLSERVER ADDLOCAL=All SQLACCOUNT=<my domain account> SQLPASSWORD=<my domain account password> AGTACCOUNT=<my domain account> AGTPASSWORD=<my domain account password> SQLBROWSERACCOUNT=<my domain account> SQLBROWSERPASSWORD=<my domain account password> ASACCOUNT=<my domain account> ASPASSWORD=<my domain account password>
I'm not sure if this is correct but this installs all the components properly except "Microsoft SQL Server 2005". This component failes with the below error.
----------------------------------------------------------------------------------------------------
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 4/8/2008
Time: 3:33:03 PM
User: NT AUTHORITYSYSTEM
Computer: HYDTEST15
Description:
Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
----------------------------------------------------------------------------------------------------
Actually I didn''t know how to install SQL to run the services with Syatem account. I read through some forums and found that I should use domain account for this purpose. If I dont give any account details Installation will fail saying the account details for service are not specified.
I thought of running the installation with any domain account and then use a script to chage the sevice to run with system account so that user can use it.
I have the log file but its a 12 mb file. I couldn't find an option to install attach the file.
Thanks,
Prakash
Hi: I have installed SQL 2005 Developer Edition and VS 2005. Do I need to also install SQL 2005 Express edition too?????
My version of VS2005 is proffesional. I cannot seem to find SQL 2005 Developer Edition in the Server Explorer of VS2005. So I am wondering if I need to install SQL 2005 Express. Before I had SQL 2000 and MSDE installed with VS2003 and there was no problem.
Thanks
I know people have put up this question before but I wanted some updated feedback.
I just bought Visual Studio Tools for MS Office and it comes with SQL Developer Edition. I am currently using VS.net 2003 and using MSDE with MS SQL Web Data Administrator to build my dbs then export the sql script.
I was wondering if I should uninstall the MSDE and install the DEv Ed so I can develop all the triggers, constraints etc through Enterprise Manager, therefore having a better setup DB. I know you can do all that through code but why reinvent the wheel.
One last question, with the Dev Ed you just export the schema and scripts to a machine with SQL Server installed once the DB is ready for deployment ? Is this correct?
I lied one more question, does the uninstall of MSDE leave much of a mess, what is the best way to get rid of it.
Thanks in advance
Pete
Newbie:
May I ask you a question:
It is Ok to install sql server 2000 developer edition on winxp?
thanks
When come to Create Instances screen and click next it prompt error message
although i had restart my computer.
A previous program Installation created pending file operations on the installation machine. You must restart the computer before running setup.
How can I install SQL Server 2000 Developer edition from the CD's of Visual Studio.Net 2000 Enterprise Architect ?
When I install VS.Net Enterprise Architect I do not see any install option for SQL Server 2000 Developer, though the MSDE option does appear during the installation. However, I was not interested in MSDE.