Hello
I have copied my web site to the default folder on IIS 5.1 (I am using XP Pro), and now when i run the app, i get to the login page and after hitting "Login" button the page refreshes and clears the fields but no error message.
I am not sure what to do.
I followed the steps outlined in a blog I found to setup SS2005 express for remote connections. Everything appeared to go smooth until I actually tried to logon ;)
I have Sql Server 2005 Express installed on my WinXP PRO machine at home (no domain). I have opened the ports on the firewall, etc.
When I try and login from the SQLCMD command line tool I get a Login Failed error. Here is the connection string that I'm trying to use:
SQLCMD -S **.***.**.*SQLEXPRESS -U Steve -P MyPassword
The error:
Login failed for user 'Steve'.
When I use Management Studio Express on the same machine running Sql Server, it shows the User name: NEVERSTILLSteve
'NEVERSTILL' is the name of my computer.
If I try and use that same username with a remote connection I get the same error.
I have googled for the error and msg code, but nothing fitting my situation is coming up.
Anyone have any ideas for me?
This is the connectionstring I use to get to sql server 2000
Data Source=GBLOND0MSQL_COMDEV_DEV1;Initial Catalog=testDB;Persist Security Info=True;User Id=Webspeople;Password=something;
Now on another server I installed sql server 2005.
Restored a backup of sql server 2000 databse into sql server 2005.
So now I have sql server 2005 with the database that I was using in sql 2000.
The question is to do with login.
In sql 2000, connecting to sql query analyser using the above credentails, works fine. But not in sql 2005
The error is:
Login failed for user webspeople. The user is not associated with a trusted sql server connection.
Any guidance to solve this issue please?
Thanks
Hi,
Im getting this error when attempting to retrieve data from an sql database.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'projectAllocations'. Login fails. Login failed for user 'sa'.
Source Error:
Line 13: objConn = New SqlConnection( "Server=LAB303-066NETSDK; Database=projectAllocations; User ID=sa;Password=mypassword")
Line 14: objCmd = New SqlCommand("SELECT * FROM project_descriptions", objConn)
Line 15: objConn.Open()
Line 16: objRdr = objCmd.ExecuteReader()
Line 17: While objRdr.Read()
Source File: C:finalyearproject2sample.aspx Line: 15
Please Help!! Im a beginner to this, so if anyone knows the answer, take baby steps when explaining. Thanks
Been looking through the forums for a solution to this problem.I already tried granting access through statements such as:exec sp_grantloginaccess N1'machineNameASPNET'But they don't seem to work.. i vaguely remember seeing somewhere a DOS command line statement that grants access to the ASPNET_WP and that fixed my problem before on another computer.. but this is a new computer and i forgot to write down the command.Can anyone help explain and propose a solution to my problem. Many thanxs.
View 9 Replies View Relatedcreate login dave with password='abc', default_database=tempdb
View 6 Replies View RelatedI am using the MSDE to connect to my ASP.NET application. I get this error after clicking the login button of my login page. Anyone know why this would happen?
Thanks for any help,
Cannot open database requested in login 'DataSQL'. Login fails. Login failed for user 'serverASPNET'.
I have read alot of threads her about 15025 and not one of them have addressed my problem or solved it.
I wanted to add a user to a new database, when I go to security and logins her login is not in the system, yet she was able to log into the production db and do her job without any problems using Windows Domain account.
I went to the New Login and tried to add the record but it gave me an error that the DomainUserName already existed error 15025.
I have gone into every database on the server to see if the login was in any of them and it was not. Then I tried to find orphan users and did find one in about 1/2 the databases that was from our Software provider.
My guess is there is a sid issue, but I am at a loose how to find it or fix it so I can add them to other db's.
I did run these commands
execute as login = 'DomainUserLogin'
-- Completed Sucessfully
select suser_name()
-- Returned the DomainUserLogn
I am using the Managment Student to manage the users.
Hi there
I'm trying to connect to sqlserver express using dreamweaver mx. TYhey are both installed on the same machine (win 2000 server),
What I am confused about is the user and password, I have installed the example Northwind database and attempting to connect to it.
In dreamweaver I add a connection (SQL Server connection) , a template shows and I add the data:
Persist Security = false;
Data Source =mycomputersqlexpress;
Initial Catalog = Northwind;
User ID = ?
Password = ?
What do I put in the User ID, Password and how do I configure sqlserver (I'm using Server Management Studio).. As I said I already have Northwind under the database section? but don't know how to set permissions.. Thanks
Hi, all
I installed SQL 2005 express edition in my pc (Pro XP), then I can login from SQL 2005 Managerment Studio Express. After a few days later, I can't do it and an error message as belows:
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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
It seems that the default setting does not allow remote connections, however, I connected it before and havn't change any setting. I try to reinstall the studio express but still not working.
Any idea / solution will be welcome.
Kevin Cheang
I am trying to upgrade SQL Server Express 2005 Report Server to SQL 2005 Standard and it fails with the following error:
SQL Server Setup did not have the administrator permissions required to copy a file: C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting ServicesReportServer
ssrvpolicy.config. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
After I click OK on the message, this whole path where the upgrade is bieng installed dissapears C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting Services. The error is a bit missleading because the file that it is trying to copy rssrvpolicy.config does appear in that upgrade folder so I am not sure why it would try to copy a file that has already been copied.
I was able to upgrade the Database Engine instance fine but can't upgrade Reporting Services due to that error. I have verified that the account that ran the setup had the administrator permissions. Your prompt reply to my question would be greatly appreciatted.
HI, My computer keeps trying to download SQL Server 2005 Express Edition SP2 and fails with the error code 0x2B22. It is a new computer running with Windows XP Pro.
I have spent hours searching the forums and the internet, but I can't find anything to help, or I don't understand the solutions or whether they relate to my computer. I don't know how to find out why the update is failing either.
Please can someone help!!
Thank you!
Hi
I am trying to upgrade SQL Server 2005 Express to SQL Server 2005 Enterprise Edition.
(As a Preparation to install SQLServer2005 Service Pack 2 (CTP))
I tried to upgrade a particular Instance (OFFICESERVERS, which was based on SQL Server 2005 Express ).
During the upgrade I get a message saying that ...
.....Your upgrade is blocked because of edition upgrade rules.....
All other components I selected for Installation are propertly installed (Analysis, Reporting)
The setup log contains the following detail information:
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29543
MSI (s) (DC!C8) [13:57:26:265]: Product: Microsoft SQL Server 2005 -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Fri Dec 29 13:57:26 2006
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
Error Code: 0x80077367 (29543)
Windows Error Text: Source File Name: sqlcaupgradeproduct.cpp
Compiler Timestamp: Mon Sep 19 01:07:45 2005
Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 142
---- Context -----------------------------------------------
I also tried to explicitly upgrade the OFFICESERVERS instance by executing Setup from the command shell:
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=OFFICESERVERS UPGRADE=SQL_Engine SKUU
PGRADE=1 /qb
The result is the same, i.e.... Your upgrade is blocked because of edition upgrade rules...
Does anybody know about this problem?
Some more information about the system:
W2K3 R2 Enterprise Edition
WSS3.0
MOSS2007
previously installed SQL Server 2005 Express Edition (Version 9.00.2047.00)
Kinde regards
Andreas
Dear Sir,
We are using VB.NET 2005 (Winform) and the backend SQL Server Express 2005. We would like to connect the Express (.mdf) database from Remote Machine. What type of connection string we have to use?
We tried the following ConnectionString but we got the error:
Provider=SQLNCLI.1;Server=.SQLEXPRESS;AttachDbFileName=S:MLJData.mdf;Database=MLJData;Trusted_Connection=Yes;
Also suggest what are all the prerequisites to run sql server express 2005 database in client machine.
We did installed the following tools in client machine:
1. .NET framework 2.0
2. sqlncli.msi (SQL Server Native Client Setup)
Please provide us the solution for this.
Thanks
M. Gopalan
Sofist India
okugops@hotmail.com
The installation fails and crashes with "Error 110", while attempting to install the SQL Native Client... then crashes (DrWatson). This happens on every OS and test machines that we have within our company... flavors of W2K and WXP, all with .Net Framework 2.0.
If the SQL Native Client exists, the installation continues without error. If SQLEXPR32.EXE is run directly from the command line, the installation will succeed.
If SQLEXPR32.EXE is called from a Windows Installer Custom Action type 50, it will always fail. This is the method we used to successfully install MSDE previously.
Our command line is:
/qb ADDLOCAL=SQL_Engine,SQL_Data_Files SAPWD=password1 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=2 INSTANCENAME=Instance SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 ENABLERANU=0
The problem appears to start with: Error: Action "ComponentUpdateAction" threw an exception during execution.
-----------------------------------------------
SQLSetup0009_Core.log
Microsoft SQL Server 2005 Setup beginning at Thu Mar 01 08:07:09 2007
Process ID : 852
c:57774bfc862c706a2e923076f41d037csetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/2/1 8:7:9
Complete: LoadResourcesAction at: 2007/2/1 8:7:9, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/1 8:7:9
Loaded DLL:c:57774bfc862c706a2e923076f41d037cxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/2/1 8:7:9, returned true
Running: ValidateWinNTAction at: 2007/2/1 8:7:9
Complete: ValidateWinNTAction at: 2007/2/1 8:7:9, returned true
Running: ValidateMinOSAction at: 2007/2/1 8:7:9
Complete: ValidateMinOSAction at: 2007/2/1 8:7:9, returned true
Running: PerformSCCAction at: 2007/2/1 8:7:9
Complete: PerformSCCAction at: 2007/2/1 8:7:9, returned true
Running: ActivateLoggingAction at: 2007/2/1 8:7:9
Complete: ActivateLoggingAction at: 2007/2/1 8:7:9, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__852" returned false.
Running: PerformSCCAction2 at: 2007/2/1 8:7:9
Complete: PerformSCCAction2 at: 2007/2/1 8:7:9, returned true
Running: PerformDotNetCheck at: 2007/2/1 8:7:9
Complete: PerformDotNetCheck at: 2007/2/1 8:7:9, returned true
Running: ComponentUpdateAction at: 2007/2/1 8:7:9
Error: Action "ComponentUpdateAction" threw an exception during execution. Error information reported during run:
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='SnacComp::Init'>
<Func Name='SnacComp::IsRequired'>
SNAC version installing: 9.00.3042.00
The installed SNAC version is less then the installing version
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:506}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
<Func Name='SnacComp::InstallImp'>
Failed to install SNAC
Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}
SCU_SetupMgr::svc() caught exception: Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}. SetupMgr: state=ERROR, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=c:57774bfc862c706a2e923076f41d037c
QuietMode=false
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=c:57774bfc862c706a2e923076f41d037c
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:520}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
<EndFunc Name='UpdateComponents' Return='1603' GetLastError='87'>
Component update returned a fatal error : 110
Error Code: 0x8007006e (110)
Windows Error Text: The system cannot open the device or file specified.
Source File Name: sqlncli.msi
Compiler Timestamp: Thu Oct 5 12:22:33 2006
Function Name: Unknown
Source Line Number: 1583
Class not registered.
--------------------------------------------
SQLSetup0009_SNAC.log
=== Verbose logging started: 3/1/2007 8:07:10 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:WINDOWSsystem32msiexec.exe ===
MSI (c) (FC:C8) [08:07:10:062]: Resetting cached policy values
MSI (c) (FC:C8) [08:07:10:062]: Machine policy value 'Debug' is 0
MSI (c) (FC:C8) [08:07:10:062]: ******* RunEngine:
******* Product: c:57774bfc862c706a2e923076f41d037csetupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (c) (FC:C8) [08:07:10:062]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (FC:C8) [08:07:10:062]: Grabbed execution mutex.
MSI (c) (FC:C8) [08:07:10:109]: Cloaking enabled.
MSI (c) (FC:C8) [08:07:10:109]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (FC:C8) [08:07:10:125]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:5C) [08:07:10:140]: Grabbed execution mutex.
MSI (s) (30:B0) [08:07:10:140]: Resetting cached policy values
MSI (s) (30:B0) [08:07:10:140]: Machine policy value 'Debug' is 0
MSI (s) (30:B0) [08:07:10:140]: ******* RunEngine:
******* Product: c:57774bfc862c706a2e923076f41d037csetupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (s) (30:B0) [08:07:10:156]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (30:B0) [08:07:10:171]: Note: 1: 1309 2: 5 3: C:57774bfc862c706a2e923076f41d037csetupsqlncli.msi
MSI (s) (30:B0) [08:07:10:171]: MainEngineThread is returning 110
The system cannot open the device or file specified.
MSI (c) (FC:C8) [08:07:10:171]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (FC:C8) [08:07:10:171]: MainEngineThread is returning 110
=== Verbose logging stopped: 3/1/2007 8:07:10 ===
All --
Please help.
I have some questions about connection strings.
BACKGROUND...
Note that I am using the "SQL Native Client OLE DB Provider", SQL Sever 2005 Express, ASP.NET, C#.NET, and VS.NET 2005.
Note that I do not want to use the "Attach a database file" type of connection string.
Note that I am using the site http://www.ConnectionStrings.com as a reference.
Note that this "Standard security" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Uid=MyDatabaseUser;Pwd=MyDatabasePassword;" />...does not work and causes the following run-time error...A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Note that this "Trusted connection" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Trusted_Connection=yes;" />...works but is less-than ideal because it uses a Trusted Connection rather than a Username/Password combination.
QUESTIONS...
(A) What exactly does the error in Item 4 mean?
(B) Do 4 and 5 imply that one must use a Trusted_Connection for all SQL Server 2005 Express connection strings when the database does not reside in the web application's App_Data folder or use a "Attach a database file" type of connection string?
(C) Are there any alternatives?
(D) What do you suggest?
Please advise.
Thank you.
-- Mark Kamoski
This is what I did:
The instructions for changing the registry entries per previous MSDN postings were:
For Windows 2000
Oracle
8.1 [HKEY_LOCAL_MACHINESOFTWARE
MicrosoftMSDTCMTxOCI]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"
Changed the registry entries on my WindowsXP machine:
entry name old value new values
"OracleXaLib" xa80.dll oraclient10.dll
"OracleSqlLib" sqllib80.dll orasql10.dll
"OracleOciLib" oci.dll oci.dll
Then created the Linkserver definition:
EXEC sp_addlinkedserver 'ORA10G', 'ORACLE', 'MSDAORA', 'ORA10G'
Command(s) completed successfully.
EXEC sp_addlinkedsrvlogin 'ORA10G', 'FALSE',NULL, 'scott', 'tiger'
Command(s) completed successfully.
Note:
scott/tiger is given as an example here; used my real userid/pw instead. BTW, I am able to connect
to the Oracle database using the userid/pw from the same host that is running the Sqlserver db.So, the
Oracle client software is installed and is working correctly.
Then attempted to query a table on the Oracle database:
select count(*) from ORA10G..<schemaname>.<tablename>
Got the following error message(s)
OLE DB provider "MSDAORA" for linked server "ORA10G" returned message "ORA-12154: TNS:could not resolve the connect identifier specified
".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "ORA10G".
All the previous discussions and suggested solutions are all for SqlServer 2000 and Oracle8. But I did not see much discussions on SqlServer2005 and Oracle10g. Any help to resolve this problem will be appreciated.
Thank you.
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require.
Hardware:P4 1.7G CPU,30G HDD space,1G memory
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Jul 21 15:08:24 2006
Machine : YANGNAN
Product : Microsoft SQL Server 安装程åº?支æŒ?文件(英è¯)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : Microsoft SQL Server VSS 编写器
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : MSXML 6.0 分�程�
Product Version : 6.00.3883.15
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : SQL Server Database Services
Error : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQL.log
Last Action : DetectSKUOS
Error String : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online.
Error Number : 28018
--------------------------------------------------------------------------------
In C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles SQLSetup0001_MYSERVER_Core(Local).log I have the following error:
=============
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 3
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" to cab file : "C:SQLEXPRsetup.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2008/2/18 18:14:45
Message pump returning: 3
============
The file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" does not exist.
What I've tried so far:
1. Using Add/Remove Programs, uninstall the following:
A. Microsoft SQL Server Native Client
B. Microsoft SQL Server Setup Support Files (English)
C. Microsoft SQL Server VSS Writer
D. Microsoft .NET Framework 2.0 (based on a post elsewhere that this resolved someone else problem)
2. Verified that the following Registry Keys were removed:
A. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
B. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
C. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native Client
(If they were not, I deleted them manually.)
When I was asked to help, the SSE installation had already been attempted 4 times. Part of their resolution attempts had been to install .NET 3.0, but I have not yet re-installed that.
It appears that .NET is still the culprit. Here is some information on the system:
Host Name: MYSERVER
OS Name: Microsoft(R) Windows(R) Server 2003, Standard Edition
OS Version: 5.2.3790 Service Pack 2 Build 3790
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Server
OS Build Type: Multiprocessor Free
Registered Owner: User
Registered Organization: MY LLC
Product ID: 69712-OEM-4411902-02111
Original Install Date: 8/30/2007, 3:29:16 PM
System Up Time: 0 Days, 2 Hours, 1 Minutes, 56 Seconds
System Manufacturer: Dell Computer Corporation
System Model: PowerEdge 840
System Type: X86-based PC
Processor(s): 2 Processor(s) Installed.
[01]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz
[02]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz
BIOS Version: DELL - 1
Windows Directory: C:WINDOWS
System Directory: C:WINDOWSsystem32
Boot Device: DeviceHarddiskVolume2
System Locale: en-us;English (United States)
Input Locale: en-us;English (United States)
Time Zone: (GMT-07:00) Mountain Time (US & Canada)
Total Physical Memory: 4,095 MB
Available Physical Memory: 3,626 MB
Page File: Max Size: 5,976 MB
Page File: Available: 5,665 MB
Page File: In Use: 311 MB
Page File Location(s): C:pagefile.sys
Domain: WORKGROUP
Logon Server: \MYSERVER
Hotfix(s): 79 Hotfix(s) Installed.
[01]: File 1
[02]: File 1
[03]: File 1
[04]: File 1
[05]: File 1
[06]: File 1
[07]: File 1
[08]: File 1
[09]: File 1
[10]: File 1
[11]: File 1
[12]: File 1
[13]: File 1
[14]: File 1
[15]: File 1
[16]: File 1
[17]: File 1
[18]: File 1
[19]: File 1
[20]: File 1
[21]: File 1
[22]: File 1
[23]: File 1
[24]: File 1
[25]: File 1
[26]: File 1
[27]: File 1
[28]: File 1
[29]: File 1
[30]: File 1
[31]: File 1
[32]: File 1
[33]: File 1
[34]: File 1
[35]: File 1
[36]: File 1
[37]: Q147222
[38]: KB933854 - QFE
[39]: Q936181
[40]: IDNMitigationAPIs - Update
[41]: NLSDownlevelMapping - Update
[42]: KB925398_WMP64
[43]: KB937143-IE7 - Update
[44]: KB938127-IE7 - Update
[45]: KB939653-IE7 - Update
[46]: KB942615-IE7 - Update
[47]: KB944533-IE7 - Update
[48]: KB921503 - Update
[49]: KB924667-v2 - Update
[50]: KB925876 - Update
[51]: KB925902 - Update
[52]: KB926122 - Update
[53]: KB927891 - Update
[54]: KB929123 - Update
[55]: KB930178 - Update
[56]: KB931784 - Update
[57]: KB932168 - Update
[58]: KB933360 - Update
[59]: KB933729 - Update
[60]: KB933854 - Update
[61]: KB935839 - Update
[62]: KB935840 - Update
[63]: KB936021 - Update
[64]: KB936357 - Update
[65]: KB936782 - Update
[66]: KB937143 - Update
[67]: KB938127 - Update
[68]: KB941202 - Update
[69]: KB941568 - Update
[70]: KB941569 - Update
[71]: KB941644 - Update
[72]: KB942763 - Update
[73]: KB943055 - Update
[74]: KB943460 - Update
[75]: KB943485 - Update
[76]: KB944653 - Update
[77]: KB946026 - Update
[78]: KB948496 - Update
[79]: XpsEPSC
My next thought is to try this:
http://groups.google.com/group/microsoft.public.windowsupdate/msg/4d76de7769d04493
Does anyone have any better suggestions?
Is the .NET Framework the likely problem here?
TIA,
Brian
I have had 3 tries at getting SQL Server 2005 Express installed on my XP Pro 64-bit.
In the System Configuration Check at the start of the install process I get two warnings: COM Plus Catalog Requirement and ASP .NET Version Registration Requirement (64-bit ASP .Net is Registered. Required 32-bit ASP .Net to install Microsoft Reporting Services 2005(32-bit).).
In the Setup Progress I get green ticks for MSXML6, SQL Setup Support Files, SQL Native Client and SQL VSS Writer, but half way through SQL Server Database Services I get a popup - Generic Host Process for Win32 Services has encountered a problem and needs to close. Then another popup - SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. ... Final popup is - This system is shutting down... This shutdown was initiated by NT AUTHORITYSYSTEM with the message: Windows must now restart because the Remote Procedure Call (RPC) service terminated unexpectedly.
Any help much appreciated
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require. Web Developer and C# Express install OK.
I have been trying to install this for around 2 weeks now with no luck ... I even had the PC formatted and rebuilt but the install still fails. If it installed and worked before, i cannot understand why it doesn't work now. The summary log is provided below:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Thu Jun 22 10:42:08 2006
GLKD2396800 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : GLKD2396800
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : SQL Server Database Services
Error : 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."
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : SQL Server Database Services
Error : 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."
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQL.log
Last Action : InstallFinalize
Error String : 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 Number : 29503
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Thu Jun 22 10:46:19 2006
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQL.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SCC.log
c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
Hello,
I'm using the latest version of SQLEXPR32.EXE found here :
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en
Here is the command line that fails :
"sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress
INSTANCENAME=MYINSTANCE SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
Interrestingly, when the following command line is used to launch the setup,
it completes successfully :
"sqlexpr32.exe /norebootchk reboot=ReallySuppress INSTANCENAME=MYINSTANCE
SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
The only difference between the two is the quiet switches used in the first
case : "-q" and "/qn"
After spending some time to understand what is going wrong, it seems that in
quied mode, Setup Prerequisite 'SQL Native Client' is not installed. Then
the remaining part of the setup fails because of this.
Any help appreciated.
Hi All
I am getting below error while
Error string: Cannot open database requested in login 'XXXXXXXXXXX'. Login fails.
what is possible casue for above problem.
Hi all,
I have SQL Server Express and VB 2005 Express installed in a Microsoft Windows XP Pro PC that is a terminal PC in our office Network. My Network Administrator has granted my terminal PC for Administrator Use. I tried to do the ADO.NET 2.0-VB 2005 programming in my terminal PC and I could not get a remote connection in the Window Form Application via Window Authorization. I do not know how to make this kind of remote connection in my Network. Please help and advise.
Thanks in advance,
Scott Chang
Hi,
I have an app that creates and attaches tables from SQL Server into an Access mdb using an ODBC link from VB6 using DAO 3.51 on Windows 2000. Recently I upgraded to SQL Server Express edition and tested it. It worked fine against the Express Edition. So, I installed SQL Server 2005 Standard Edition on our Server hoping that they operate identically. How wrong one can be! the same code that worked against Express Edition does not work on Standard Edition.
It is strange that the App works for about 5 seconds which attaches about 38 tables and after that the connection drops and I have a hell of a time to get the rest of the tables linked. The error that comes up is:
Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
The PC that I am using to connect is in a different domain to the Server where the SQL Server database resides. I thought that domains might be the reason. But even joining the PC to the same domain as the server still does not work and behaves the same. So I do not think it is a domain related issue.
I have also looked at the SQL Server and database configurtaions. I cannot see anywhere any specific time out of around 5 seconds. Even the time out through the SQL Server ODBC driver is set to 30 seconds by default as far as I know. So, it looks like there is a time out somewhere but I am absolutely confused as to where this 5 second time out is comming from.
I also thought permissions on the database or tables might be the issue but after looking at the database and table permissions, they all look OK. The user has prettymuch the same access as the SA on the database.
Has anybody came across this problem? If so, I appreciate if someboday can give me a hint as to where I can start.
Thanks,
When I was trying to SQL Server 2005 Express SP2 (November CTP) on Vista RTM, setup failed on the Database Services component with the following log messages:
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Sat Nov 18 09:21:28 2006SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connectsqlstate=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_batchsqlstate=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_batchsqlstate=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_batchsqlstate=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_batchsqlstate=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_batchsqlstate=42000, level=11, state=1, native_error=15401, msg=[Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.sqlstate=42000, level=16, state=1, native_error=15007, msg=[Microsoft][SQL Native Client][SQL Server]'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' is not a valid login or you do not have permission. Error Code: 0x80073c29 (15401)Windows Error Text: Source File Name: libodbc_statement.hCompiler Timestamp: Wed Aug 2 16:21:02 2006 Function Name: OdbcStatement::execute_batch@CnfgSQL@80Source Line Number: 91---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsUSE [master ]<Started SQL statement: Sat Nov 18 09:21:28 2006>declare @ServerName nvarchar(255) if not exists (select * from sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName')) execute sys.sp_addserver @ServerName, local end<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>ALTER DATABASE model SET RECOVERY SIMPLE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 1 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>DECLARE @Name AS nvarchar(128), @LangID AS smallint SELECT @Name=name, @LangID=langid FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @Name EXEC sp_configure N'default language', @LangID EXEC sp_configure N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 0 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'BUILTINAdministrators' EXEC sys.sp_addsrvrolemember N'BUILTINAdministrators', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'NT AUTHORITYSYSTEM' EXEC sys.sp_addsrvrolemember N'NT AUTHORITYSYSTEM', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' EXEC sys.sp_addsrvrolemember N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS', N'sysadmin'Originial error was 80073c29 (15401)Do_sqlScriptSqlScriptHlprError Code: 15401MSI (s) (98:50) [09:21:30:219]: I/O on thread 3236 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3300 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3652 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3424 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3244 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3544 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3064 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3428 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 2000 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 1740 could not be cancelled. Error: 1168MSI (s) (98!78) [09:21:30:219]: Product: Microsoft SQL Server 2005 -- Error 29521. 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 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.Error 29521. 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 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS exists and contains NT AUTHORITYNETWORK SERVICE when the error occurs.
Any suggestions on how to get SQL Server to install on Vista?
Hii
I am trying to setup Sql server 2005 express edition but ı getting an error message that cannot install. The Logfile is below.
Thanks...
Cagri
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Tue Sep 04 22:44:28 2007
Machine : QUIETUS-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : QUIETUS-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : QUIETUS-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : QUIETUS-PC
Product : SQL Server Database Services
Error : 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 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
--------------------------------------------------------------------------------
Machine : QUIETUS-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQL.log
Last Action : InstallFinalize
Error String : 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 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
Error Number : 29521
--------------------------------------------------------------------------------
when i installed visual web developer and sql management studio,i try to use sql management studio to connect to sql 2005 express,but a error ocurred.here is the error message.
TITLE: Connect to Server------------------------------
Cannot connect to DHSQLEXPRESS.
------------------------------ADDITIONAL INFORMATION:
The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data)
------------------------------
The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data)
------------------------------
The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data)
------------------------------
Configuration system failed to initialize (System.Configuration)
------------------------------
Unrecognized configuration section system.serviceModel. (C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Configmachine.config line 136) (System.Configuration)
and i wonder if anybody has experienced this error can tell me how to solve?
Hello,
I'm trying to log into a remote SQL Server but get: Login Failed for user
'XXXXXXXX' and I also get the 18456 error.
The host company assure me they are the right logins and curiously when I use Visual Web Developer and the data connection I can access the database tables etc.
I am using TCP/IP
any ideas what might be going wrong?
thanks.
Hello all
Im new to SQL 2005 express so please bare with me,
I have set up wireless peer to peer network and I am trying to access an express database from one machine to another. I can transfer files no problem.
When I try to create a new login, I am forced to only select logins local to the machine with the database. When I try and create a new login by typing <machinename><windows account > of the second PC, SQL can not see it.
I have tried both Windows authentication and mixed mode... no success.
Any ideas?
Thanks
Hello,
I am currently trying to use the Login control in an ASP.NET website with IIS. The control works fine when I am running the website in debug mode within Visual Studio 2005. However, when I create the Virtual Directory in IIS, and try to log in from there, I get an error message as follows:
Cannot open user default database. Login failed. Login failed for user 'machinenameASPNET'
Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'machinenameASPNET'.
The application is very simple. I created a Login.aspx page with a login control on it, and I have the default.aspx page. I used theASP.NET administration tool to change the authentication mode to AspNetSqlProvider (forms authentication), and to create one user (no roles). I am using the default provider with the aspnetdb.mdf database. I have been working on this for a few days now, and have searched this site but have not found a solution that works for me. Any suggestions?
Jen
During an install of SQL Server 2005 Express setting the sa password does not work consistently. The install is being run as administrator and I am using an .ini file to pass the settings,
SECURITYMODE=SQL
ADDLOCAL=ALL
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
INSTANCENAME=DBSERVER
SAPWD=Westtech#1
and while most times it works correctly, occasionally, maybe 4 out of 10 times it fails to set the password and I have been unable to find any warnings or errors in the logs it generates.
We are coming up on release and this is causing us some real problems. Does anyone have any ideas, something I could look at?
Thank you,
Kathy Mook
Westbrook Technologies, Inc.
In the last step of installing the SQL Server 2005 Express edition I get the following error:
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007
Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007
Service failed unexpectedly (1814)
Error Code: 0x80070716 (1814)
Windows Error Text: The specified resource name cannot be found in the image file.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Error Code: 1814
MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- 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 (1814) The specified resource name cannot be found in the image file.
.
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 (1814) The specified resource name cannot be found in the image file.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007
Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007
Service failed unexpectedly (1814)
Error Code: 0x80070716 (1814)
Windows Error Text: The specified resource name cannot be found in the image file.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 301
Any idea how I can fix this?