Accessing SQL Server 2005 Through Vista
May 10, 2007
I just bought a new HP laptop that has Vista installed. Not happy about the OS but it is what it is...
I need to use Enterprise Manager, or an equivalent, to access a remote server, running SQL 2005.
With XP, I always installed and used SQL Server 2000 Client features.
Vista does not play well with SQL 2000 so I am looking for an alternative to simply be able to access, and perform DTS functions, a remote SQL 2005 system.
Does SQL Server 2005 Express offer client alias features?
Can anyone recommend another approach or product?
Thank you,
Steve
View 7 Replies
ADVERTISEMENT
Jan 17, 2008
We receive the error below when attempting to access our newly installed reporting service under Windows Vista. We can't seem to fix to this error. While we can view reports deployed to my report server at http://ServerName/ReportServer, we cannot access the Report Manager that comes with SSRS via http://ServerName/Reports. When we do we get the error below.
According to the error it cannot find the 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll. The missing dll is located in our C:$WINDOWS.~QDATAWindowsMicrosoft.NETFrameworkv2.0.50727System.EnterpriseServices.dll. We do not have a GAC_32 directory in our Assembly directory and we cannot manually add any thing to the Assembly folder.
Does anyone have any idea how to resolve this error?
Any assistance is greatly appreciated.
Server Error in '/Reports' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
c:windowssystem32inetsrv> "C:WindowsMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl350805c34 0086ba6_164dc701ReportingServicesNativeClient.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl357073932 092ba95_164dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34957153c 0086ba6_164dc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.RegularExpressions2.0.0.0__b03f5f7f11d50a3aSystem.Web.RegularExpressions.dll" /R:"C:WindowsassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl36a74e136 0086ba6_164dc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Windows.Forms2.0.0.0__b77a5c561934e089System.Windows.Forms.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl39a6712b7 092ba95_164dc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WindowsassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34c4caac7 0359ca7_164dc701ReportingServicesWebUserInterface.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl326b107a1 0e258c3_b4d0c501ReportingServicesCDOInterop.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceProcess2.0.0.0__b03f5f7f11d50a3aSystem.ServiceProcess.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Design2.0.0.0__b03f5f7f11d50a3aSystem.Design.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices.Protocols2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.Protocols.dll" /R:"C:WindowsassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /out:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.0.cs" "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.312
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
error CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found
Version Information: Microsoft .NET Framework Version:2.0.50727.312; ASP.NET Version:2.0.50727.833
View 2 Replies
View Related
Jul 11, 2007
Hello everybody!
I hope that someone could help me.
I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem...
I configure the connection to use the IUSR.
The source code that i use:
repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll";
repl.Publisher = @"laptop";
repl.PublisherDatabase = @"database";
repl.PublisherSecurityMode = SecurityType.NTAuthentication;
repl.Publication = @"Pubdatabase";
repl.Subscriber = @"SQLMobile";
repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'";
The error that returns is:
"Failure to connect to SQLServer with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect"
Does anybody knows what i can do?
HELP I NEED SOMEBODY TO HELP!
Thanks!
View 1 Replies
View Related
Feb 10, 2008
Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2.
Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed?
Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it.
Thanks in advance to anyone who can help,
Abel
View 3 Replies
View Related
May 7, 2008
I installed sql server 2005 sp2 including business intelligence development suite , however I got a message
some client components not compablitable .This morning I searched my programs and found that I have new
visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence
developer (which does not work) It seems I I would like to get rid of vs 2005 also
fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista
and I would only like to keep tools meant for sql standard 2005 reporting services etc
here is a list of my sql sp2 install package
By the way I doubled clicked sql_tools.msi and did not run as administrator
Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005......
Time: 05/06/2008 20:49:23.437
KB Number: KB921896
Machine: BILLPREC690
OS Version: Professional (Build 6000)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD
Notification Services ENU RTM 9.00.1399.00 x86 STANDARD
Integration Services ENU RTM 9.00.1399.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
SQLXML4 ENU 9.00.1399.06 x86
Backward Compatibility ENU 8.05.1054 x86
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
SQLWriter Microsoft SQL Server VSS Writer Service 2700
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
Success, Reboot Required
Exit Code Returned: 3010
View 2 Replies
View Related
Feb 15, 2007
I recently downloaded SQL Server 2005 Express Edition. Everything was installed correctly without any problems. However, when I went to my Program list, the only thing listed for Microsoft SQL Server 2005, was Configuration tool.
Where is the actual program where I can write and run queries? How do I access the server?
View 3 Replies
View Related
Aug 20, 2006
I'm considering shifting my database server to 64-bit MS SQL Server 2005 for improved scalability and performance. I'm concerned, however, that my classic ASP website (which sits on a separate server) may have problems communicating via ADO/OLEDB because of communication problems between 32-bit IIS on the web server and 64-bit MS SQL Server on the database server.
My current set up (which works fine) is:
Web Server: Windows Server 2003, Standard Edition, SP1 - running IIS with a set of ASP websites
Database Server: Windows 2000 SP4, running MS SQL Server 2000
Connection String:
MyConnection="Provider=SQLOLEDB;Network Library=DBMSSOCN;SERVER=192.168.0.1;INITIAL CATALOG=MyDatabase;UID=MyUserID;PWD=MyPassword"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open MyConnection
My core question is:
If I change my database server to new machine with 64-bit Windows Server 2003 running 64-bit MS SQL Server 2005, will my (32-bit) web server be able to connect from ASP as it does now?
Thanks for your help!
Jed
View 2 Replies
View Related
May 26, 2007
Hello everyone and thanks in advance for any help. After converting to Vista Ultimate I confess I haven't been able to get sql running right period. The sp just released doesn't update the actual msqlserver file. Any help would be appreciated. I also have VS 2005 installed. I would like this to work as I am learning VB and lots of new stuff about web design. Again, thanks in advance for any help...
Jed
View 1 Replies
View Related
Jul 3, 2007
I am having real problems connecting to SQL Server (Express) 2005 when running Visual Studio 2005. I keep getting the following error:
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).
I have checked through serveral forums and have done the following to no avail.
SQLBrowser server is running.
In Surface area config, remote & Local connections are enabled for TCPIP/and named pipes.
To rule out firewall issues I turned off my firewall (Norton 360) and windows defender - I checked that the windows firewall was off too.
Both VS05 and SQL Server Management studio are both run using admin priviledges.
Visual Studio and SQL Server are on the same laptop.
I can connect to SQL Server Express via VS05 Server Explorer, I only get this error while running my ASP.Net program.
My connection string is as follows:
<add key="Main.OracleConnectionString" value="data source=FENASD;user id=fenas;password=xxxx;persist security info=false;"/>
I have used to logon details to confirm that I can log into the DB using the Management Studio.
Any ideas for what else I can try??
Thanks Ash...
View 8 Replies
View Related
Jan 16, 2007
Hi guys!
This is sort of an SQL Server question...
I have an opportunity to install Vista on my machine and I'm wondering which version I should install if I plan on doing development on SQL Server 2005 and VS 2005.
Should I install Vista x64 or x86? Is there a significant performance increase when running x64 (I have an Intel E6400 and 2 GB RAM).
Thanks in advance guys!!!
View 3 Replies
View Related
Mar 26, 2007
hi all, does the SQL Server 2005 SP2 install work for Vista? I'm running Business Edition and
I have a Geographic Information systems (GIS) application from ESRI (ArcGIS) that installed
SQL Server 2005 express on my desktop to manage geodatabases, so theoretically SP2 should
install OK? Anyone else out there using SQL Server on Vista with similar issues?
thanks in advance
Z
View 1 Replies
View Related
May 27, 2007
I have a strange problem that I think deals with security on SQL 2005.I have a scheduled task that runs on a Windows 2000 machine. It callsa vb script which creates a connection to SQL Server.We migrated a database from SQL 2000 to 2005 which is on a differentbox. I changed the connection in the vb script to use the new sqlserver. The original connection to SQL 2000 used the 'sa' accountcoded into the connection string , which we don't want to use on thenew server, so I changed the connection string in the script to usethe below login information.Const strConnection = "Provider=SQLOLEDB;DataSource=SQLServer;Integrated Security=SSPI;Persist SecurityInfo=False;Initial Catalog=database;I created a domain user and gave it dbo rights on the new database onSQL 2005 as well as administrative rights on the local machine and thenetwork. The task runs fine for a while and then it will fail tostart. I have looked in the event log as well as the SQL log and havenot found anything else that ran when my task failed. Once it hasfailed, if I manually run the vb script on the 2000 machine, it runsjust fine, but the schedule won't work. If I change the name of theuser that is running the scheduled task, it will begin working again.I have run the profiler on SQL 2005 and watched the scheduled tasklogin as the correct user and update the database. There is nopattern to when the scheduled task will stop running. This has beenhappening for a few days now.This script and scheduled task worked fine for over a year on themachine when it logged into SQL 2000 and nothing else has changed,which makes me think it is related to the SQL 2005 server. Any ideas?
View 1 Replies
View Related
Feb 20, 2008
HI,
I need some help regarding the data access.
I needs to access some data from tables which are in oracle and load it into sql server tables.
Please let me know the process for this.
Thanks in advance.
View 2 Replies
View Related
Feb 28, 2007
In SQL Server 2000 we had a view that would show the user credentials and the password hash. The reason we need this is that we use SQL Server authentication on the database. To test users, we have a login with little access, and it should be able to see the view and compare the password supplied against what is in the database, and then let the code handle a graceful exit if the password is invalid. I am trying to do this with SQL Server 2005, and I am running into trouble. I am trying to do this with a function, since there I can set the EXECUTE AS clause (in theory) and leverage the privlidges of a specific user in the database. Here is an example function:
CREATE FUNCTION check_acct.fn_allusers (@test int)
RETURNS @users table (username varchar(50), passwd varbinary(256))
WITH EXECUTE AS caller
AS
BEGIN
INSERT @users
select name, password_hash from sys.sql_logins
RETURN
END
GO
GRANT SELECT ON fn_allusers TO user_acct
I cannot get to all rows in the sys.sql_logins table unless I first:
GRANT VIEW ANY DEFINITION TO CHECK_ACCT
then when I call this function from CHECK_ACCT, I am able to see the data. If I change the WITH EXECUTE AS 'CHECK_ACCT' and execute thsi function from USER_ACCT, I do not get the same results. Do functions not inherit VIEW DEFINITION proivlidges? Any suggestions on how to do this but limit access to these secure objects to this one function?
View 4 Replies
View Related
Apr 18, 2007
I have a C# program that access SQL Server 2005. The program have 4 threads that performs the same method and are used only to improve performance of the system
The C# accesses the SQL Server using OleDbConnection and
OleDbCommand classes. Sometimes (very rare) I get exception to method ExecuteNonQuery() with message: "Table does not exist.".
The command text for the query is a constant string in the format: "insert into my_table€¦".
Can any one tell me what could be the problem?
View 6 Replies
View Related
Dec 6, 2007
Hi,
I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like
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.
But my SQL Server allows remote connection, and I am able to do a select statement.
But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
View 1 Replies
View Related
Apr 19, 2008
I am unable to make SQL Server 2005 work under Vista. As soon as I try to register a server I get a message saying error 40. It does not seem as straightforward as SQL 2000. Under Registered servers I can see a green arrow and a local instance called paul-pc....
I have no idea what credentials to put into the login properties. I am from an Access background so this is new to me.
I would appreciate it if someone can talk me through the process
View 5 Replies
View Related
Mar 6, 2008
Hi,
I'm about to purchase a new development laptop and want to ensure I won't have any issues installing SQL Server 2005 on Windows Vista.
I can see from http://technet.microsoft.com/en-us/library/ms143506.aspx that it is possible but states that SQL Server 2005 SP2 must be installed.
My install CD is for SQL Server Developer Edition without SP1 or SP2. Will I be able to install off this and then install SP2 afterwards or will I encounter problems because I need SP2 present on the install media?
Any advice would be greatly appreciated.
Cheers,
Gavin.
www.gavinharriss.com
View 3 Replies
View Related
May 13, 2007
Hello members
I tried to install sql server 2005 on the vista.
But It give error message that one of the installation package is not available on the system.
what does it mean?
then I download the SP2 of sql 2005 from the microsoft website.
But when I tried to install this service pack
their is again an error message that this pack has not compatible with this version of vista.
what to do now?
There were three downloads available on website.
should I go for another down load.
Also tell me is there any other option of sql server for example express edition.
can express edition be installed on vista?
Also when I tried to indtall oracle on my system.
Again installation failed.
Vista has no compatibilty with most of the softwares.
Should I Uninstall the vista?
The last question is how to uninstall the vista?
I am facing many problems with this
Thanks in advance and have a nice time
View 1 Replies
View Related
Nov 27, 2006
I've just done a clean install of Vista Ultimate (release). SQL Server 2005 will only install the client tools - it refuses to install any of the server components (including the default instance).
I get the "SQL Server Edition Operating System Compatibility (Warning). " I installed the missing IIS 7.0 which got rid of the IIS warning message.
Any suggestions please?
Thanks
Jeremy Holt
View 7 Replies
View Related
Apr 9, 2008
Hi,
I have all updates for Vista, tried to install SQL Server 2005 SP2, the following log file:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Professional (Build 6000)
Time : Wed Mar 26 12:20:54 2008
USER-PC : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
Machine : USER-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : USER-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : USER-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : USER-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : USER-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : USER-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQL.log
--------------------------------------------------------------------------------
Machine : USER-PC
Product : Workstation Components, Books Online and Development Tools
Warning : Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : USER-PC
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_Tools.log
--------------------------------------------------------------------------------
Setup succeeded with the installation, inspect the log file completely for status on all the components.
Time : Wed Mar 26 12:23:51 2008
When I try to start SQL Server it times out. SQL Server Express is running ok.
Can you help me get this started?
Thank you,
Lucy
View 2 Replies
View Related
Feb 10, 2008
Hi
I have a VB project in VS 2005 Express that uses SQL 2005. I use Click Once to deploy the project. The s/w installs and installs the SQL 2005 prerequisit on XP and Vista machines without problem.
Problem: As soon as the apps tries to use SQL 2005 on a Vista machine it says sqlservr.exe has stopped working and has to close. XP machines work like a dream.
Any ideas please? Any help would be welcomed.
Dim sql As String = "CREATE DATABASE " + dataBaseName + " ON (NAME = " + dataBaseName + ", FILENAME = '" _
+ UKHRdataFolder + "" + dataBaseName + ".mdf')"
Dim myCommand As New SqlCommand
Dim myAdapter As New SqlDataAdapter
Dim myData As New System.Data.DataTable
Dim conn As New SqlConnection
conn.ConnectionString = _
"Data Source=.SQLEXPRESS;AttachDbFilename=;Integrated Security=True;Connect Timeout=30;User Instance=True"
myCommand.Connection = conn
Try
conn.Open()
Try
myCommand.Connection = conn
myCommand.CommandText = sql
myCommand.ExecuteNonQuery()
Catch myerror As SqlException
End Try
Catch myerror As SqlException
Finally
If conn.State <> ConnectionState.Closed Then conn.Close()
End Try
conn.Close()
conn.Dispose()
View 13 Replies
View Related
Feb 20, 2007
Ok ive tried looking everywhere for a solution but i just cant find one... please help me
I need to install SQL Server 2005 (for reporting services mainly) on Vista, but i have issues.
I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected.
The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..."
Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point.
A walkthrough or something would really help...
Thanks!
Robert Macnair
View 1 Replies
View Related
May 21, 2007
I'm loading the dev version of sql 2005 on vista ultmate. I'm not seeing the manager tools. I've installed sp2. In the services it says sql express but not sql server. I read the requirments for the dev version and it didn't list vista. Any ideas?
View 4 Replies
View Related
Jun 18, 2006
Greetings!
I tried installing SQL Server 2005 Express on my VISTA Beta 2 Box but before doing so, I checked if IIS is already installed and running. During the assesment of my current configuration, SQL Server 2005 Express is still looking for IIS. Are the conflicts regarding IIS 7.0 to SQL Server Express or the feature is not yet available. I will be continuing to do experiments with this one and hope there will be people who can share their experiences too.
Thanks!
View 9 Replies
View Related
May 22, 2008
Hi,
I have got error 40 : could not connect to sql server ets while trying to work with vs 2008( so i suppose i have sql server 2005 sp2 preinsatled. I 've tested sql server works in services and tcp/ip enabled. I cann't do anything. aspnet_regsql.exe doesn't works, nor in vs2008 i can't even connect to Northwind.
I have got vista sp1, vs2008, sqlserver seems to work, according to services.
Help, please!
ps sorry for bad english
View 1 Replies
View Related
Aug 23, 2007
Hey All,
I have a notbook with vista ultimate and i am trying to install sql server 2005 (developers edition ) on it. The setup fails during the installation giving the message thaht the database service didnot start succesfully. I ahve tried a number of solutions for the issue but all in vain. The user i am using to install the server is an admin user.Plus i am very sure taht there are no h/w dependencies taht are causing the problem.
Can some one please help me . I have been banging my head withteh issue for the past 4-5 days and some some will be reallyy appreciated
========================A section of the SQL.Log file==============================
<EndFunc Name='Do_sqlServiceSDDL' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlServiceSDDL : Thu Aug 23 16:25:37 2007
MSI (s) (8C:14) [16:25:37:484]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:37:486]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof)
MSI (s) (8C:70) [16:25:37:491]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7517.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:37 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007
MSI (s) (8C:14) [16:25:39:605]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:39:607]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl)
MSI (s) (8C:2C) [16:25:39:612]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7D61.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl
<EndFunc Name='InstallMOF' Return='0' GetLastError='14007'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007
MSI (s) (8C:14) [16:25:40:091]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'>
MSI (s) (8C:14) [16:25:40:093]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof)
MSI (s) (8C:CC) [16:25:40:098]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7F46.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007
MSI (s) (8C:14) [16:25:42:371]: Executing op: ActionStart(Name=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:42:373]: Executing op: CustomActionSchedule(Action=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_sqlMofcomp,CustomActionData=010Installing WMI registration50000\.
ootMicrosoftSqlServerServerEventsMSSQLSERVERC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof)
MSI (s) (8C:14) [16:25:42:374]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
MSI (s) (8C:14) [16:25:42:375]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof)
MSI (s) (8C:2C) [16:25:42:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSI882D.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='14007'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:173]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'>
MSI (s) (8C:14) [16:25:47:230]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerServerEvents(A;CI;CCDCLCSWRPWPRCWD;;;BA))
MSI (s) (8C:A4) [16:25:47:236]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B21.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerServerEvents
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:286]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:47:288]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerServerEventsMSSQLSERVER(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;[SQLServer2005SQLAgentUser$ADNAN-PC$MSSQLSERVER]))
MSI (s) (8C:4C) [16:25:47:292]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B61.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerServerEventsMSSQLSERVER
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;S-1-5-21-3043782012-3745310101-388358720-1076)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:348]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:47:349]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerComputerManagement(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD))
MSI (s) (8C:40) [16:25:47:354]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BA0.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
No need to protect the namespace security
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:387]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:47:389]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn)
MSI (s) (8C:54) [16:25:47:394]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BD0.tmp, Entrypoint: AddCertificate
FTECa.DLL: INFO: FTE: AddCertificate(), Entering...
FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn
MSI (s) (8C:14) [16:25:47:452]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll
MSI (s) (8C:14) [16:25:47:453]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn
MSI (s) (8C:14) [16:25:47:458]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9C0F.tmp, Entrypoint: InstallPerfCounters
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering...
FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn:
FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained:
FTECa.DLL: INFO: InstallPerfCounters: Instance home path: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn
FTECa.DLL: INFO: Setting acls on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll
FTECa.DLL: INFO: successfully allowed access to PerfLoggingUsers and PerfMonitoringUser on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll
FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnfdcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnftecntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnidxcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini have been installed.
MSI (s) (8C:14) [16:25:51:273]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting...
MSI (s) (8C:14) [16:25:51:274]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYSYSTEM)
MSI (s) (8C:78) [16:25:51:279]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAAFE.tmp, Entrypoint: SetLaunchPermissions
MSI (s) (8C:14) [16:25:51:327]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
MSI (s) (8C:14) [16:25:51:329]: Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000)
MSI (s) (8C:14) [16:25:51:329]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:330]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00)
MSI (s) (8C:14) [16:25:51:332]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:333]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00)
MSI (s) (8C:C4) [16:25:51:338]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB2E.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:370]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:371]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00)
MSI (s) (8C:14) [16:25:51:373]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:375]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00)
MSI (s) (8C:28) [16:25:51:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB5E.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:426]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:427]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00)
MSI (s) (8C:14) [16:25:51:429]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:430]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00)
MSI (s) (8C:04) [16:25:51:435]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB9D.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:477]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:478]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00)
MSI (s) (8C:14) [16:25:51:480]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:502]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00)
MSI (s) (8C:C0) [16:25:51:508]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABDD.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:526]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:527]: Executing op: CustomActionSchedule(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server30329600lpc:ADNAN-PC)
MSI (s) (8C:14) [16:25:51:528]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
MSI (s) (8C:14) [16:25:51:532]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (8C:C8) [16:25:51:537]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABFD.tmp, Entrypoint: Do_sqlScript
<Func Name='LaunchFunction'>
Function=Do_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Aug 23 16:25:51 2007
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:25:51 2007
Service failed unexpectedly (1067)
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQLSERVER
Error Code: 1067
MSI (s) (8C!B0) [16:28:16:318]: 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.
.
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.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Aug 23 16:28:16 2007
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:28:16 2007
Service failed unexpectedly (1067)
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQLSERVER
Do_sqlScript
SqlScriptHlpr
Start service MSSQLSERVER
Error Code: 1067
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5520 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 4116 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 2800 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5220 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 532 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5320 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5836 could not be cancelled. Error: 1168
MSI (s) (8C!B0) [16:28:22:408]: 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.
.
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.
.
View 1 Replies
View Related
Aug 1, 2007
Trying to set up a syn connection with my ipaq travel companion but
it syncs to sql server instead of to outlook.
If I uninstall sql server 2005, will it be missed by any other processes, etc.
on Vista and have it again do something ugly.
Thanks,
Bob
View 1 Replies
View Related
Dec 27, 2007
I am trying to run SQL Server 2005 on VISTA. When I install I am informed I must run SP2. Which of the following is the correct servic pack?
SQLServer2005SP2-KB921896-IA64-ENU.exe
392.4 MB
DownloadDownload
SQLServer2005SP2-KB921896-x64-ENU.exe
339.4 MB
DownloadDownload
SQLServer2005SP2-KB921896-x86-ENU.exe
282.4 MB
DownloadDownload
When I install I get a warning that IIS is not running. IIS IS running. Is this why I need the service pack?
I am not getting anything added to program files that allows me to manage SQL Server. I am looking for Enterprise Manager, MMC, or some such thing. How can I get it to install? Is this related to Vista and SP2?
Thanks for your help...Marv
View 4 Replies
View Related
Mar 6, 2008
Hi,
I'm about to purchase a new development laptop and want to ensure I won't have any issues installing SQL Server 2005 on Windows Vista.
I can see from http://technet.microsoft.com/en-us/library/ms143506.aspx that it is possible but states that SQL Server 2005 SP2 must be installed.
My install CD is for SQL Server Developer Edition without SP1 or SP2. Will I be able to install off this and then install SP2 afterwards or will I encounter problems because I need SP2 present on the install media?
Any advice would be greatly appreciated.
Cheers,
Gavin.
View 6 Replies
View Related
Dec 7, 2007
I have a Vista Business on my Laptop.
I tried to install SQL Server 2005, but failed.
I downloaded SQL Server 2005 Express Edition with Advenced SP2, it failes to install Database Server Service and returns an error that it cannot connect to ODBC driver
Please help
View 1 Replies
View Related
Aug 30, 2007
i can't install sql server express in vista, i 've downloaded sp2, and it's still not working... HELP!!!!
View 1 Replies
View Related
Mar 19, 2007
I am having the absolute worst luck installing SQL 2005 developers edition on my windows vista laptop. In class we have been using SQL 2000, but I bought a new laptop that has vista home premium preloaded so I need to use 2005 (says the solution analyzer). I have loaded all the IIS services and tried to install the first CD (it never asks for the 2nd one. During the system configuration check i get an "edition change check" waring and a "IIS feature requirement" warning. Once the install completes I cant find the query analyzer or any other SQL applications, just the configuration tools folder. I have tried running the latest service pack with no luck. I have visual studio loaded 2005 loaded as well and didnt have any issues with that, could anyone help me out?
Thanks in advance!
View 15 Replies
View Related
