I ran into the following problem when installing SQL 2005 developer edition on Vista:
��SQL Server Setup Failed to compile the Managed Object Format (MOF) file E:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.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.�?
Ok guys, I am trying to install Sql server 2005 on Vista but I am still stuck with this warning message in the System Configuration Check during Sql server 2K5 installation :
SQL Server Edition Operating System Compatibility (Warning) Messages * SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Now, I know I need to install SP2 but how the hell I am going to install SP2 if Sql server 2005 doesn't install any of the components including Sql server Database services, Analysus services, Reporting integration services( only the workstation component is available for installation)?
Any work around for this issue?
P.S.: I didn't install VS.NET 2005 yet, can this solve the problem?
I am running on Vista Ultimate and Installing Sql Server 2k5 enterprise edition
I have installed the Beta version for Windows Vista and installed VS 2005 for Software Developers which includes SQL Server Express.
When installing the SQL Server express part compatibility issues appear. Do i need to install a fresh copy of SQL Server Express which inlcludes Service Pack 1?
I cannot connect to any mdf file through the data connection section in the VS 2005 IDE. Cant remember the exact error message, something like "Cannot find the entry or starting point".
I am running a fresh install off the latest Dotnetnuke starter kit and get a database compatibility error so my guess is this could also be as a result of SP 1 not being installed?
Help! I'm trying to install SQL Server 2005 on 32-bit Vista RTM. Have tried several editions (Developer, Standard, Enterprise). Have tried installing while logged in as domain user account in machine administrator group as well as built-in Administrator user. Running SETUP program with elevated privilges. Certain portions (Analysis services, Notification services) install correctly, but never the database engine. Always fails consistently with the same error reported. Machine has Visual Studio 2005 installed already, but NOT SQL Server 2005 Express Edition. Error logs reports are below ({computer name} is the name of my machine)
UI error reported: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group '{computer name}SQLServer2005MSSQLUser${computer name}$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
Portion of Setup error log reports:
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'. sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english. SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch sqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'. SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install. sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install. SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. SQL_ERROR (-1) in OdbcStatement::execute_batch sqlstate=42000, level=11, state=1, native_error=15401, msg=[Microsoft][SQL Native Client][SQL Server]Windows NT user or group '{computer name}SQLServer2005MSSQLUser${computer name}$MSSQLSERVER' not found. Check the name again. sqlstate=42000, level=16, state=1, native_error=15007, msg=[Microsoft][SQL Native Client][SQL Server]'{computer name}SQLServer2005MSSQLUser${computer name}$MSSQLSERVER' is not a valid login or you do not have permission. Error Code: 0x80073c29 (15401) Windows Error Text: Source File Name: libodbc_statement.h Compiler Timestamp: Mon Jun 13 14:30:24 2005 Function Name: OdbcStatement::execute_batch@CnfgSQL@80 Source Line Number: 91
While installing SQL Server 2005 Express Edition SP2 or SQL Server 2005 Express Edition with Advanced Services SP2
on Vista Ultimate, I get the error "The feature(s) selected are not valid for this edition of SQL server". Then the installation stops and exist. The only feature selected is Database Services, data files and shared tools.
hi i have windows vista home basic.I am trying to install sql server 2005. I have two issue: 1)Its always throwing a popup window saying sql server has a know issue and do you want to continue. 2)I am not able to connect to any database engine.
I just bought a new laptop with Vista pre-installed and was able to install Visual Studio 2005 Pro, but when attempting to install SQL Server 2005 it just hangs at the IIS detection step. I was using the administrative account. I was able to install the Developer Edition of SQL Server 2000, but I need 2005.
Some posts mention IIS version issues and 32 vs 64 bit version issues. Can anyone ellaborate on what is happening and why? What is the work around?
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
I am trying to install SQL Server 2005 on Windows Vista Home Premium edition, when I run the Installer I received are the following error message.
IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
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.
I already configure IIS7 with all feature, but system still generate above mentioned message.
I'm trying to perform a fresh new install of SQL Express 2005 Advanced SP (CTP) on Vista Ultimate RTM but running into an installation issue preventing me from installing the Reporting Services option. When the SQL Express Advanced installation does it's system configuration check, it gives me this warning ...
- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
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.
I do have IIS7 installed and running on my system with all options except for FTP. Why isn't the SQL Express install recognizing IIS7? Is there a workaround? I'd really like to get Reporting Services installed. But SQL Express isn't giving me that option during install because of this IIS issue. Thanks in advance!
Im encountering yet another problem in Vista(Vista Home Premium). I have turned on all IIS features from control panel. When I open http://localhost it gives the error HTTP Error 404.4 - Not Found
Description: The resource you are looking for does not have a handler associated with it
How should i resolve this?
Also, when I try to install SQL server 2005 express edition, it gives the warning that IIS is not installed, though I have installed all the features and it is running.
I have been struggling for the past one week, just to install SQL server on vista!
While installing SQL Server 2005 Enterprise Edition on Windows Vista Ultimate the setup alerts me "there are known compatibility problems, please install SP2 after this". So ok, all went nice and installed without error. IIS 7 installed fully, so all green in setup display. (But after installation i do not see any service which begins with SQL***...) At the end, the setup wanted to start the administration Tool. Ok, but my name was not listed, so i could not add me to the permitted users. I can not use any tool, because i have no rights.
Some Ideas?
Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services-Clienttools 2005.090.3042.00 Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205) Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 7.0.6000.16546 Microsoft .NET Framework 2.0.50727.312 Betriebssystem 6.0.6000
hi i have windows vista home basic.I am trying to install sql server 2005. I have two issue: 1)Its always throwing a popup window saying sql server has a know issue and do you want to continue. 2)I am not able to connect to any database engine.
Hi, I have a serious issue installing sql server express (advanced edition) on Windows Vista Home Premium. I'm doing the install with elevated priviledges but setup of the sql server always fails at the same point with the following error:
{Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'
I've tried many different combinations, including advanced installation options selecting sql server instance to run as local system or local server but nothing came out of that. I always select add current user to the sql server administrators group. Any help on this issue is appreciated. Below follows the setup summary log:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Home Edition (Build 6000) Time : Mon Feb 26 22:02:41 2007
Machine : JUPITER Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : JUPITER Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : JUPITER Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : JUPITER Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : JUPITER Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_JUPITER_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I couldn't manage to install SQL Server 2005 Express or Standart Edition on Windows Vista. The installation fails with the error message I pasted below:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'FUSIONSQLServer2005MSSQLUser$FUSION$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29
Can someone please help me on this as this is an urgent situation...
I am using vista home edition i already installed vs 2005 standard addition which included sql server express edition also. but due to my unawareness, i uninstalled the sql server. later, i needed it and installed, but by this time, as i was using sql server 2000, i didn't know about sql server management studio and i looked for sql enterprise (as in 2000) , and i installed and uninstalled sql 4-5 times. now i could not install sql server. i searched for some solutions, as in this forum i tried, uppercase computer name(which i already had), and windows installer cleanup utility (but i didn't uninstalled VS 2005). and before using windows installer cleanup utility , my error was Machine : ANANTA-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0025_ANANTA-PC_SQL.log Error Number : 1603
and after cleanup utility installed, my error is
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
The installer has encountered an unexpected error. The error code is 2331. Error loading library c:Program FilesMicrosoft SQL Server90Setup BootstrapBin{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}sqlca.dll or finding entry point The process cannot access the file because it is being used by another process. .
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=2331&EvtType=e%3a%5csql9_sp2_t%5csql%5csetup%5cdarwin%5csqlcastub%5cstubredirect.cpp%40Do_LogInstallStart%40launchFunction%40x20
i even tried this link too, their is no useful information, so what may be the problem and what i need to do??
Hi, I am trying to install Sql Server 2005 on VISTA Ultimate and even though it says it will install the server components, when I get as far as the screen showing the components to be installed everything is greyed out except for the Client side components for Vis Studio. nothing else. It will not install anything of the Sql Server. I heard something about sp2 for Vista? We can't even install sql server in first place.
Just installed SQL Server 2005 Enterprise onto Vista 64bit (while i have my UAC turned off) After installing SQL Server, I setup SQL SP2 and then run up SQL Server Management Studio and attempted to connect to the localserver. The problem is that there appears to be no local server. No instance or Database Engine.
In addition, none of the services appear to have been installed, or at least I cannot see them from services.msc and there has been no management snap-in added to the services and applications area of the computer management tool (Manage from the My Computer icon).
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).
The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?
Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?
SQLServer2005_SSMSEE in my notebook with vista business and nearly the end of installation the process is cancelled by an error. its necessary install some application before? SQL Server Express is installed by default in the notebook.
thaks a lot and excuse for my bad english (bettr more for me is SPANISH)
I have recently updated from XP to Vista Home Premium. Now when I try to install SQL Serve Express SP2 I get :
"setup has detected problem with .net framework installation and cannot proceed. Microsoft .net framework 2.0 is either not installed or is corrupt."
I have tried to run sfc /scannow to make sure my .NET 2.0 was not corrupted and also was running as an administrator but could not get it installed. Anyone has any ideas?
I'll install SQL Server Express SP2 on Vista during my Setup. But the setup beaks with error 110. In other articles it sounds like an folder access problem. On a Custom Action Type 210 i start a application which execute the sqlexpress.exe. I tried some other codes to impersonate or noImersonate but without success.
But i can not use the unpacked files because size is to large(170MB)
An good Idea would be unpack the setup files during setup to an custom folder with right permissions. But I dont know how unpack files without GUI (SQLEXPRESS x always show the GUI).
Hi We have a problem installing SQL Express Edition SP1 on Vista. The installation stops during installation of setup support files with the following message:
Errors occurred during the installation:Error 2 installing Microsoft SQL Server 2005 Setup Support Files. See log file for more detailed information.Det går inte att hitta filen. (translated: File not found) The log file points to the support.log file with the following content:
=== Verbose logging started: 2007-03-13 17:34:23 Build type: SHIP UNICODE 4.00.6000.00 Calling process: C:cd nät40..SQLEXPRSetup.exe ===MSI (c) (C4:F4) [17:34:23:450]: Resetting cached policy valuesMSI (c) (C4:F4) [17:34:23:450]: Machine policy value 'Debug' is 0MSI (c) (C4:F4) [17:34:23:450]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (c) (C4:F4) [17:34:23:450]: Client-side and UI is none or basic: Running entire install on the server.MSI (c) (C4:F4) [17:34:23:450]: Grabbed execution mutex.MSI (c) (C4:F4) [17:34:23:591]: Cloaking enabled.MSI (c) (C4:F4) [17:34:23:591]: Attempting to enable all disabled privileges before calling Install on ServerMSI (c) (C4:F4) [17:34:23:607]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (s) (00:10) [17:34:23:622]: Grabbed execution mutex.MSI (s) (00:1C) [17:34:23:622]: Resetting cached policy valuesMSI (s) (00:1C) [17:34:23:622]: Machine policy value 'Debug' is 0MSI (s) (00:1C) [17:34:23:622]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (s) (00:1C) [17:34:23:622]: Machine policy value 'DisableUserInstalls' is 0MSI (s) (00:1C) [17:34:23:669]: SRSetRestorePoint skipped for this transaction.MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesExplorer 3: 2 MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1324 2: .. 3: 1 MSI (s) (00:1C) [17:34:23:669]: MainEngineThread is returning 2MSI (s) (00:10) [17:34:23:669]: No System Restore sequence number for this installation.MSI (c) (C4:F4) [17:34:23:669]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1MSI (c) (C4:F4) [17:34:23:669]: MainEngineThread is returning 2=== Verbose logging stopped: 2007-03-13 17:34:23 === The funny thing here is that it works fine when the installer is run from a network share, ie \testserversetupsetup.exe but when the same folder is burned to a CD or copied to a local folder it fails. I have verified that the folders are identical.
I'm not sure what info is required to pinpoint the problem but here are some log files and a screen shot of the message.
Any help or pointers would be greatly appreciated.
I have been through virtually every last posting on installing SQL Server Express with Advanced Services in this site and still have no success accessing the Reporting Services site: http://localhost.reports$sqlexpress. I get a the correct background to the site as in the tutorials, but only get "ERROR - unable to connect to the remote server", which may be indicative because this is all installed on my local machine (Dell AMD Athlon 64 X2 Dual Core 4000+ 2.11 Ghz, 1GB, Windows Ultimate). I have gone through How to install ... on a Windows Vista-based computer, KB934164, and most recently, How to configure .. to allow remote connections, kb 914277, in hopes of addressing the "remote server" issue. I still can't get past this obstacle. PLEASE HELP!! :-)
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...
"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"
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.
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
********************************************************************************** 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 : ----------------------------------------------------------------------------------
I'm trying to use SQL Management Studio to connect from a Vista SQL 2005 client w/ SP2 over to a Windows XP workstation running SQL server developer edition (non-sp2) using windows authentication.
I'm already preauthenticated by network shares to the xp workstation. This worked just fine in windows xp but stop working in vista.
After searching around, i found out that vista handles trusted authentication differently than windows xp due to changes in the SSPI. Logging in as sql authentication works fine. Logging in as windows authentication does not.
UPDATE: I found out that two workstations running vista and sql 2005 sp2 cannot connect to each other using windows trusted authentication!!!
What the heck?
UPDATE: I found out that my IIS 7.0 using ASP.NET and connecting to SQL 2005 (non sp2) on a Windows 2003 server (SP1) WILL connect to the database using trusted authentication... apparently IIS can access the credentials and pass them to the sql 2005 box just fine. My Sql 2K5 SP2 tools cannot. I'm forced to use SQL authentication to the box.
Same thing applies with a Windows XP SP2 box running SQL 2005 (non sp2).
Here is my sql server error log off of the windows xp workstation:
2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2. 2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100] 2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1. 2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]
How can i Fix this issue?
[1] Client side:
What is the connection string in you app or DSN? N/A If client fails to connect, what is the client error messages?
Is the client remote or local to the SQL server machine? Remote
Can you ping your server? YES
Can you telnet to your SQL Server? YES
What is your client database provider? SQL Management Studio
Is your client computer in the same domain as the Server computer? WorkGroup
What protocol the client enabled? Shared Memory & TCPIP
Do you have aliases configured that match the server name portion of your connection string? NO
Do you select force encryption on server and/or client? NO
[2] Server side:
What is the MS SQL version? SQL Server 2005
What is the SKU of MS SQL? Developer
What is the SQL Server Protocol enabled? Shared Memory & TCPIP
Does the server start successfully? YES
If SQL Server is a named instance, is the SQL browser enabled? N/A
What is the account that the SQL Server is running under? Network Service
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? YES
Do you make firewall exception for SQL Browser UDP port 1434? N/A
[3] Platform:
What is the OS version? Client - Windows Vista Final w/ SQL Server 2005 SP2 & Network Client SP2
Server - Windows XP Professional SP2 w/ SQL 2005 Server Developer Edition
Do you have third party antivirus, anti-spareware software installed? None
[4] Misc:
If you have certificate configuration issue: Please use ��certutil.exe ��v ��store my�? to dump certificate specific info and post it in your question. N/A
Tips:
1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG
2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2. 2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100] 2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1. 2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]
[1] Client side:
What is the connection string in you app or DSN? N/A If client fails to connect, what is the client error messages?
Is the client remote or local to the SQL server machine? Remote
Can you ping your server? YES
Can you telnet to your SQL Server? YES
What is your client database provider? SQL Management Studio
Is your client computer in the same domain as the Server computer? WorkGroup
What protocol the client enabled? Shared Memory & TCPIP
Do you have aliases configured that match the server name portion of your connection string? NO
Do you select force encryption on server and/or client? NO
[2] Server side:
What is the MS SQL version? SQL Server 2005
What is the SKU of MS SQL? Developer
What is the SQL Server Protocol enabled? Shared Memory & TCPIP
Does the server start successfully? YES
If SQL Server is a named instance, is the SQL browser enabled? N/A
What is the account that the SQL Server is running under? Network Service
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? YES
Do you make firewall exception for SQL Browser UDP port 1434? N/A
[3] Platform:
What is the OS version? Client - Windows Vista Final w/ SQL Server 2005 SP2 & Network Client SP2
Server - Windows XP Professional SP2 w/ SQL 2005 Server Developer Edition
Do you have third party antivirus, anti-spareware software installed? None
[4] Misc:
If you have certificate configuration issue: Please use ��certutil.exe ��v ��store my�? to dump certificate specific info and post it in your question. N/A
Tips:
1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG
2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2. 2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100] 2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1. 2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]
Experts... im completely stuck. My laptop was stolen, my replacement arrives with vista on it. Get my SQL Stuff on it and when I try executing a select statement on one of the sql servers I get the error; An error occurred while executing batch. Error message is: Internal connection fatal error. and it simply disconnects. I cant run any queries! Please help.
Has anyone managed to get SQL server 2005 standard edition working on Vista?
If I install from CD I get an error message
Error Message:
sql server setup could not connect to the database service for server confiurgration.The error was[Microsoft][SQL Native Client]Shared Memory Provider:No process is on the other end of pipe.
I have then tried installing SP1 (which i understand is meant to fix some of the vista issues), but then when I then try to re-install from the CD it says the version on my PC is more up-to-date and doesnt install.
All I have in Programs - SQL server 2005 - Are the Configuration tools, not the Management studio etc.
