Unable To Install SQL2005 I64 On A 2003 SP1 Itanium
Sep 29, 2006
Hello,
I have many problem when I try to install SQL 2005 Ets edition ia64 on a 2003 ets Itanium edition.
When I launch the setup, all is all right. But during the installation, it tryes to start MSSQL services.
The staring of this service failed. So I try to start the service mannually. Nothing.
Error messages I can get (in the event log) :
Source : Service Control Manager ; ID : 7000
Description :Service SQL Server (MSSQLSERVER) failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
Source : MsiInstaller ; ID 10005
Description : Product: Microsoft SQL Server 2005 (64 bits) -- Error 29503. Failure of the starting of service SQL Server. For more information, to see the headings of on line help €śProcedure: to post the files newspapers of installation of SQL Server 2005€? and €śmanual Starting of SQL Server€?. This error is (1053) The service did not respond to the start or control request in a timely fashion.
HELPPPPP PLEEEAAAASSEEEEEE !!!!!!!!!! ;-)
View 7 Replies
ADVERTISEMENT
Dec 4, 2007
While SQL Server installed into our clustered environment with no significant problems Service Pack 2 will not install with the Error "Unable to install Windows Installer MSP file" during the update to the Database Services.
Subsequently, Integration Services, Native Client and Backwards Compatibilty also fail to upgrade due to suspended installs.
Searching for this returns a number of articles none of which match what we are seeing, including:-
http://support.microsoft.com/kb/918357 indicates this is a problem with the Setup Support Files.
This is not the case and the Setup Support files are updated. Also the permissions are correct on the folder and files mentioned,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=448685&SiteID=1 also point to a problem when installing the Setup Support Files. Our install gets past this but fails on the database engine then sets up a chain of suspended installs.
Other finds indicate there may be another msi running, again this is not the case and the server has been failed over and rebooted a number of times.
At the moment we are sitting at RTM having rebuilt the machine completely but would like to move forward onto SP2. Has anyone come across this and provide any further information or resolution?
We have successfully deployed SP2 onto a number of other servers cover both clustered and non clustered, 32 bit and X64 installations with no problems and now wondering if the problem is Itanium edition specific.
extract from the install log from the failed install. The logs mentioned in this log do not exist post install, in fact the Hotfix folder is not there.
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 IA64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 IA64 ENTERPRISE
Integration Services ENU RTM 9.00.1399.00 IA64 ENTERPRISE
SQL Server Native Client ENU 9.00.1399.06 IA64
Client Components ENU RTM 9.00.1399.06 IA64 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3883.8 IA64
SQLXML4 ENU 9.00.1399.06 IA64
Backward Compatibility ENU 8.05.1054 IA64
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 IA64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
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) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 1601
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 1601
Error Description : MSP Error: 1704 An installation for Microsoft SQL Server 2005 (64-bit) is currently suspended. You must undo the changes made by that installation to continue. Do you want to undo those changes?
View 1 Replies
View Related
Aug 17, 2006
Hello Experts,
I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.
Click here for image
So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.
Click here for image
Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?
How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.
Help! :(
View 1 Replies
View Related
Sep 19, 2007
I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.
I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."
I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.
Can anybody please advise?
View 1 Replies
View Related
Feb 19, 2007
I devloped this app with vs2005 and SQL 2005 express, everything seems to work fine, when I deploied the app to my web server I got a few different error messages that I worked through but now stuck on this one. i am sure it is something with SQL 2005 server. is there anywhere that has a good check list for doing things right in asp and SQL deployment?
here is the error message i am getting from debugging.
The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'. 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: The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.
Source Error:
Line 33: SqlConnection connection = CreateConnection();Line 34: SqlCommand command = CreateCommand(connection, query, parameters);Line 35: SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);Line 36: Line 37: Type datatype = factory.GetDataType();
Source File: c:InetpublogplankroadApp_CodeUtilitiesSqlDatabase.cs Line: 35
View 1 Replies
View Related
Jan 30, 2008
Have Server2003 Enterprise running IIS6 and sql2005. Lease is up and have to migrate to new server. Any migration tools out there to make this easier? Saw one for exchange, 2000-2003, but not one to do the server2003-server2003 and/or IISy-IIS6 and SQL2005-SQL2005. Any pointers for assistance?
thanks,
Janet
View 6 Replies
View Related
Apr 25, 2008
Hi All,
Just installed a new version of SQL2005 on a brand new Application Server.
However, when i fired up Access 2003, it gives me some chaos about how Access isn't compatible with SQL2005. Fantastic lack of backward compatibility straight out the box.
Ok, so I do as it says and download all the updates.
Try again... Still won't allow me.
Wen't to Control Panel > Data Sources and confirmed the Native Client is in there. Added a System DSN for the new Server.
Tried Access again, still not working?? What the...
Why can't I create a new project in Access 2003, and edit it from my desktop instead of sitting on the server for every table modification? I hate designing tables on the SQL studio.
Any clues or help would be great. I'm just disappointed at the moment, on how this is holding up my database projects.
Thanks,
Chris.
View 1 Replies
View Related
Aug 21, 2006
Hi All,
When we to inset record into the tables through BCP we are getting following errors.
C:> bcp ACCT.dbo.dtpro out C: estdtpro_TA.dat -T-n
C:>bcp ACCT.dbo.Semiaa out C: estSemiaa_TA.dat -T -n
BCP out works fine only BCP in have problems.
Please can you let me know how to resolved this problem.
===========
Exp - 1
===========
C:> bcp ACCT.dbo.dtpro in C: estdtpro_TA.dat -T-n
Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
===========
Exp - 2
===========
C:>bcp ACCT.dbo.Semiaa in C: estSemiaa_TA.dat -T -n
Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
============
Exp-3
============
C:>bcp ACCT.dbo.SemiH in C: estSemiH_TA.dat -T -n
Starting copy...SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
SQLState = 42000, NativeError = 7339
Error = [Microsoft][SQL Native Client][SQL Server]OLE DB provider 'STREAM' for l
inked server '(null)' returned invalid data for column '[!BulkInsert].Created'.
BCP copy in failed
Thanks in Advance
View 12 Replies
View Related
Jan 31, 2008
I have an application written in VB6 that creates a ADO connection using the (native SQL2005 clien)t from the client to SQLServer 2005 on Server 2003 configured as a stand alone server. The application works great on XP and has for a number of years.
Now I am attempting to deploy in Vista and using the same code the connection speed CRAWLS. it's in the magnitude of atleast 10 times slower. It eventualy works but the selects and doing a readnext against the resulting record set is at a snails pace.
What am I missing. It's has to be some sort of configuration problem somewhere.
View 2 Replies
View Related
Sep 14, 2005
Will it be possible to do an in-place upgrade from SQL 2000 Server Enterprise SP4 32 bit running on top of 64 bit Windows 2003 Enterprise , clustered, to SQL 2005 Enterprise 64 bit?
The 32 bit SQL 2000 to 64 bit SQL 2005 in place upgrade seems questionable to me...
Anybody tried anything like this?
View 1 Replies
View Related
Mar 18, 2008
I get this problem when tryoing to connect to the surface area configuration for services & connections
As well as for features.
However I can connect via another computer and change the options accordingly but I just can't do it locally from the server ?
Does any one know why please, the links in the message don't help ?
===================================
An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request)
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ProcessRequest(Request req)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiSmoObject.EnumChildren(String childTypeName, WmiCollectionBase coll)
at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.InitializeChildCollection()
at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.get_Count()
at Microsoft.SqlSac.MainPanel.FormFeatures..ctor(String machineName, Form callingForm)
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request)
===================================
------------------------------
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildDataTable(ManagementObjectCollection listManagementObject)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildResult(ManagementObjectCollection listManagementObject)
at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
Hmm A tad strange.
View 3 Replies
View Related
May 6, 2008
I found sql2005 Enterprise cannot be installed under Simplied Chinese win 2003, the only thing i suspect is that win2003 is an envaluation copy with netframework 2.0 be installed.
View 1 Replies
View Related
Jun 16, 2006
I am in the process of moving a SQL2000 database to a SQL2005 database.
Porting from: SQL200, Windows Server 2000(SP4) (32 bit dual processor)
to:SQL2005, Windows Server 2003(SP1) (x64 bit dual processor)
After porting the database from SQL2000 to SQL2005 (no changes) running the same update statement from Management Studio on the 2003 Server and and Query analiser on the 2000 Server.
SQL2000 completes the command in 2 minutes SQL2005 is still running after 60 minutes.
SQL2000 is the live/production system with users connected, the SQL2005 is in a test environment with no other processors running.
When the problem first showed up the SQL2005 activity monitor displayed CXPACKET wait type on 2 processes with the same pid number. I now no longer have any wait type being displayed but my wait time is increasing rapidly. No block is reported.
I assume that I have an CXPACKET lock problem.
Am I correct that I have a CXPACKET problem and if so what is the resolution?
The update statement is as follows...
update BI_LENDING_TRANSACTIONS
set [Balance Movement Month] = M.[Balance Movement Month]
from BI_LENDING_TRANSACTIONS as T,
BI_BALANCE_MOVEMENT_DATES as M,
BI_COMPANIES as C
where (T.[Transaction Date] >=
(SELECT DATEADD(d, - 70, minDate) from (select min([Transaction Date]) minDate
from p_BI_LENDING_TRANSACTIONS) t1)
OR
T.[Transaction Date] >= C.[MostRecentSnapShotDate] or
T.[Value Date] = T.[Balance Movement Month] ) and
T.[Value Date] <= C.[MostRecentSnapShotDate] and
T.[Value Date] >= T.[Transaction Date] and
T.[Company_Code] = M.[Company_Code] and
T.[Value Date] > M.[SnapShotFromDate] and
T.[Value Date] <= M.[SnapShotToDate] and
C.[Company_Code] = M.[Company_Code]
View 1 Replies
View Related
Jan 25, 2008
working with Altiris Software deployment - when installing SQL 2005 i receive the follwing error "failed to set registry settings for server network libraries. the action is SetDefaults. The error is 111 (The file name is too long.)
I have the Install log (error log) and I'm looking at all these errors and pulling my hair out - any help would be appreciated!! Help GURUS!!
2008-01-25 09:35:30.25 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2008-01-25 09:35:30.57 Server (c) 2005 Microsoft Corporation.
2008-01-25 09:35:30.57 Server All rights reserved.
2008-01-25 09:35:30.59 Server Server process ID is 812.
2008-01-25 09:35:30.59 Server Authentication mode is MIXED.
2008-01-25 09:35:30.64 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2008-01-25 09:35:30.70 Server Registry startup parameters:
2008-01-25 09:35:30.75 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2008-01-25 09:35:30.75 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2008-01-25 09:35:30.75 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2008-01-25 09:35:30.92 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2008-01-25 09:35:30.92 Server Detected 2 CPUs. This is an informational message; no user action is required.
2008-01-25 09:35:32.12 Server Error: 8316, Severity: 16, State: 1.
2008-01-25 09:35:32.12 Server Cannot open registry key 'HKLMSYSTEMCurrentControlSetServicesMSSQL$XACTWAREPerformance'. SQL Server performance counters are disabled.
2008-01-25 09:35:35.48 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2008-01-25 09:35:38.79 Server Database mirroring has been enabled on this instance of SQL Server.
2008-01-25 09:35:39.23 spid5s Starting up database 'master'.
2008-01-25 09:35:40.06 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2008-01-25 09:35:40.76 spid5s SQL Trace ID 1 was started by login "sa".
2008-01-25 09:35:40.98 spid5s Starting up database 'mssqlsystemresource'.
2008-01-25 09:35:41.15 spid5s Error: 17207, Severity: 16, State: 1.
2008-01-25 09:35:41.15 spid5s FCB::Open: Operating system error 21(The device is not ready.) occurred while creating or opening file 'D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.mdf'. Diagnose and correct the operating system error, and retry the operation.
2008-01-25 09:35:41.18 spid5s Error: 17204, Severity: 16, State: 1.
2008-01-25 09:35:41.18 spid5s FCB::Open failed: Could not open file D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.mdf for file number 1. OS error: 21(The device is not ready.).
2008-01-25 09:35:41.28 spid5s Error: 5120, Severity: 16, State: 101.
2008-01-25 09:35:41.28 spid5s Unable to open the physical file "D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.mdf". Operating system error 21: "21(The device is not ready.)".
2008-01-25 09:35:41.70 spid5s Error: 17207, Severity: 16, State: 1.
2008-01-25 09:35:41.70 spid5s FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.
2008-01-25 09:35:41.70 spid5s File activation failure. The physical file name "D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.ldf" may be incorrect.
2008-01-25 09:35:41.74 spid5s Error: 945, Severity: 14, State: 2.
2008-01-25 09:35:41.74 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2008-01-25 09:35:41.87 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
angela
View 3 Replies
View Related
May 12, 2006
How to install database and SQL logging separately on a NON system partition in sql2005.
View 4 Replies
View Related
Nov 20, 2007
Hi
Im in the process of upgrading my sqlserver 2000 to 2005.I want to migrate all the jobs from sql2000 to 2005.
I scripted the job (right click job--->all tasks--->generate sqlscript).
I ran the same script on sql2005,i was getting an error like this
"Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
The statement has been terminated."
What does the error mean? cant i run the same script generated in sql2000 on sql2005.
Wht is the approach to transfer the jobs from sql2000 to sql2005 ?
I know ther is one more way i can transfer.It is through sqlserver business intelligence development studio and using transfer job task.But i dont want to use that.I want to script the job and execute it on sql2005.
Regards
Arvind
View 14 Replies
View Related
Jun 12, 2007
I have an interesting problem. I am running xp pro and when I try to connect to an instance of SQL2005 running on WIN2003 using SQL Sevrer Management Studio, I get the following error:
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)
This instance is protected by a vpn and is running on a clustered environment. I can connect to other SQL2000 servers that are running on a clustered environment and SQL2005 that is not clustered.
After adding a host file entry, I was able to connect to the server using OSQL. I was able to telnet into the port the server is listening on.
Others in my group can connect to the server using SQL Server Management Studio with no problems. They are running Win2003 Server. I originally could connect to this server, but I needed to change my password. After that I lost my remote connectivity. I can RDP into the server and map drives to the server. I map to a local administrator of this machine.
I am not sure what else to try?
Help.
View 4 Replies
View Related
Jun 8, 2006
Hi
After SP1 install completes successfully, I checked the log file and next to all the products it shows "Not Applied" yet it seems to have worked. Can I ignore these messages?
Cheers
View 1 Replies
View Related
Mar 29, 2007
Hi!
We have a TFS server include this components:
windows standard R2 server + SP1
Microsoft SQL Server 2005 + SP1
Microsoft Visual Studio 2005 Team Foundation Server - ENU + SP1
Microsoft Windows SharePoint Services 2.0.
Can I install sql 2005 SP2 without any problem?
Best Regards,
Mihaly Demeczky
View 1 Replies
View Related
Jul 9, 2007
Hi,
I need to install SQL2000 onto a machine (W2K3 R2, SP2) that already has SQL2005, SP1 running. I can't disturb the SQL2005 installation.
Are there any problems or pitfalls to avoid? I've googled and looked on Technet but not yet found an answer.
Has anyone done this?
I know that if I install a separate instance of SQL2000 alongside a default installation of SQL2000 then I'll get a totally separate installation which won't affect the other one at all, so I reckon it could be done. But I have to be sure before I start!
Thanks in advance,
Steve
View 8 Replies
View Related
Mar 19, 2007
Hi All
I cannot complete the sql2k5 express update to sp2. I get the error no 1635. This patch package could not be opened. Verify that the patch package exists... etc. The log file states the following.
Trying source \DLc$5f3f0e35b9c57ea30accad3e6b66585fHotFixSqlSupportFiles.
Why is it looking here for the install when the patch files are located in c: empsp2 ??
What can i try
View 3 Replies
View Related
Feb 27, 2007
I ran a test upgrade of sql 2005, sp1, to SP2, on a Windows 2003 server. After the upgrade (which seemed to work well) I got an additional information dialog box:
"By default, users on Windows Vista and later Operaitng systems are not members of the System Administrator role for the Sql or Analysis services. To add users to the System adminstrator role.. launch the sql 2005 User Provisioning Tool for Windows Vista after SP2 installation completes...."
Huh? Are users on any OS, be default, members of the sysadmin role?
While I am "glad" for the extra information, it seems irrelevant to the current situation.
Barkingdog
View 1 Replies
View Related
Dec 18, 2003
I am trying to install MSDE according to:
http://www.siue.edu/~dbock/cmis460/msde.htm
But it says I need to go to control panel to install components, but it is not listed on the VS.NET 2003 install.
In VS.NET 2002 it worked fine as per instructions, but now i can't seem to get it to work in VS.nET 2003
View 2 Replies
View Related
Jul 28, 2007
I have been trying to setup SharePoint Services 3.0 on 2003 Server (Advanced) and when I run the setup for it I get this error:
SharePonit Products and Technologies Configuration Wizzard
"Failed to start the database service MSSQL$Microsoft##SSEE. Repair this product by selecting it from the Add/Remove Programs menu."
I have run a repair on all of the SQL products in the Add/Remove Programs menu and I continue to get the same error as above.
Please advise as I have un-installed and re-installed SQL Express 2005 and SharePoint Services 3.0 prior to this posting.
View 4 Replies
View Related
Jun 23, 2006
Hello
to everyone again to get info and support I relay on forums.....
I buy Visual studio 2005 professional there is included MS SQL 2005 developer edition
I buy Brand new DELL PC ($4750) with Windows server 2003 web edition
I can not install MS SQL 2005 developer edition
my curently cost to buy all these MS products was $1080CAD + $350CAD for win 2003
I didn't find normal to have no telephone suport and no version capability
I am really mad!!!!
please if there is step-by-step guide how to install MS SQL 2005 on win 2003 web please let me know
mail@bluelabs.ca
Thank you in advance
Valentin Petkov
View 8 Replies
View Related
Nov 19, 2006
Getting error 1326.
I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).
I'm trying to connect from SQL Studio Express on Vista.
TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted.
I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?
Thanks, John
View 1 Replies
View Related
May 16, 2006
Can SQL Server 2005 Standard and VS2005 Professional be installed and work on Windows XP Professional? Thanks.
View 1 Replies
View Related
Feb 15, 2007
I had a SQL2000 Server with a simple database. I did an "in place" upgrade to SQL2005 expecting the DB Server and databases to upgrade. However, now when I run SQL Server Management Studio and enter the query:-
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
I get the answer:-
8.00.2039SP4Enterprise Edition
Why didn't it upgrade? And how do I upgrade it now? I'm very confused!
View 3 Replies
View Related
Aug 3, 2006
Any assistance is appreciated.I would like to know if there is a way to specify the path for databaselog files to be located during the SQL2005 Standard installation.Under the Advanced button there is the ability to specify a differentpath for data files but nothing for logs.Thanks in advance,John
View 5 Replies
View Related
Apr 19, 2008
Hi.
Im getting a error when trying to install the QoE reports
it says this in the install log.
Script Output: Parent folder QMSReport created successfully
Data source QMSDB created successfully
Report: Call Detail Report published successfully with no warnings
Report: Call List Report published successfully with no warnings
Report: QMS Home Page published successfully with no warnings
Report: QoE Summary Report published successfully with no warnings
Report: QoE Trend Report published successfully with no warnings
Report: QoE Device Report published successfully with no warnings
Report: Server Health Report published successfully with no warnings
Report: Worst Performing Endpoints Report published successfully with no warnings
Report: QoE Overall Summary Report published successfully with no warnings
Report: AudioStream SubReport published successfully with no warnings
QMS Browser has been removed successfully.
QMS Content Manager has been removed successfully.
QMS Browser has been created successfully
QMS Content Manager has been created successfully
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The user or group name 'MYDOMAINRTCUniversalServerAdmins' is not recognized. ---> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'MYDOMAINRTCUniversalServerAdmins' is not recognized.
at Microsoft.ReportingServices.Library.Security.XmlPolicyToAclStruct(String& xmlPolicy, SecurityScope scope, Hashtable relatedRoles, Hashtable& principalsAndRoles)
at Microsoft.ReportingServices.Library.Security.CompileXmlPolicy(SecurityPolicy policy, Byte[]& realSecDesc, String& stringSecDesc)
at Microsoft.ReportingServices.Library.Security.InnerSetPolicies(SecurityPolicy policy)
at Microsoft.ReportingServices.Library.Security.SetCatalogItemPolicies(String catalogItemPath, ItemType catItemType, String xmlPolicy)
at Microsoft.ReportingServices.Library.SetPoliciesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetPolicies(String Item, Policy[] Policies)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.SetPolicies(String Item, Policy[] Policies)
at ____ScriptClass.CreateRoleAssignment(String roleName, String userGroup)
at ____ScriptClass.Main()
Unhandled exception:
The user or group name 'MYDOMAINRTCUniversalServerAdmins' is not recognized.
View 1 Replies
View Related
Feb 18, 2007
yesterday i installed sql2k5 on a activepassive cluster and for some strange reason the mssqlserver service does not want to start up on the node that i installed it on but if i fail it over to the passive node it will start fine. system info below:
system info:
* win2k3 enterprise r2 (x64) cluster activepassive*
* sql2k5 enterprise (x64) clustered*
the win2k3 cluster works fine. i installed the msdtc service running as a cluster as well and that works fine.
both servers are identical to each other. sql virtual server is running on the passive node which is now the active node. any ideas?
--alan
View 3 Replies
View Related
May 17, 2008
Hi
I'm trying to install sql express sp2 2005 in my laptop but i can't, give me this error
Machine : W7J
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_W7J_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
I'm choosing Windows autentication mode, so i don't know it says "sa" user.
can you help me?
Thanks
View 1 Replies
View Related
Feb 13, 2008
Hi,
I have a problem about the SP2 installation with using command line in vbscript.
In the vbscript, I use the command line as follow.
'Command line parameters to install SQL Server 2005 Service Pack 2
Set WSHShell = WScript.CreateObject("WScript.Shell")
strAppsp2 = "c:sqlsetupSP2SQLServer2005SP2-x64.exe /Passive /quiet"
WSHShell.Exec(strAppsp2)
set shell = createobject("wscript.shell")
...
But it cannot install the SP2.
Then I tried to test the command line again at the command prompt
c:sqlsetupSP2SQLServer2005SP2-x64.exe /allinstances /passive
After that the SP2 installation box is shown but I need to install in unattend mode.
Would you please suggest me the command line to install the sp2 in unattend mode.
Regard,
View 2 Replies
View Related