I have to spend an extra money on hardware if my PC hardware environment for installing SQL Server 2005 is not enough. Please tell me about it. It might be a RAM requirement? I don't know.
View 1 RepliesHi,
I am installing SSRS 2005 with the following scenario:
- Report Server and Report Manager will be installed on web server
- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.
Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1
When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.
The error message is:
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837
But this doesn't work.
I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.
I also look at BOL, but doesn't help much.
Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?
Many Thanks,
Usman Tjiudri
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
My situation:
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
The server is not connected to any network or the internet.
My Question:
Is their any way to fix this? and if yes could anyone tell me where to start
Thanks in Advance!
ps if their is information or logs that u need in order to help me just say so :-)
-Arjan
Hi
I have installed SQL Server Express 2005 on my machine.
I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.
Can these 2 Editions coexist with each other, or any troubles you think might encounter?
Thanks
I am creating a backup strategy for our non-production SQL Server 2005 data. We wish to utiliza the Master/Target Server scenario avaible in SQL Server 2005 with events directed to the Master Server. The question I have is what is the symptoms from the Target Servers if the Master Server fails and is unavailable for whatever reason there might be? I can change the event notification back to local server, but what other impact is there and are there any recommendations as to handle a Master Server outage so Maintenance plans can continue to execute as scheduled on Target Servers.
Thank you!
I am running into an issue trying to uninstall SQL Server 2005 64-bit. It hangs at the same point: Removing backup files. I then get a message that, "The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it." The instance that I am trying to uninstall is in a cluster hosting two other SQL Server installations. I have tried a few combinations when attempting to uninstall: running the cluster group containing the server I am uninstalling on a different cluster node than all the other cluster groups; running them all on the same node. The only one I haven't tried is moving the Cluster Group containing the IP address of the cluster, cluster name, etc to another node while running the other groups on the other node. Has anyone run into this issue? Each of the nodes has been rebooted several times during these attempts and we are using Windows Server 2003 Clustering. Again, the hang happens at the same point every time. The exact error(s) from the even log are as follows:
Product: Microsoft SQL Server 2005 (64-bit) -- Error 29528. The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it.
Product: Microsoft SQL Server 2005 (64-bit) -- Error 29530. Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 2 (The system cannot find the file specified.
)
Thanks,
Todd
Environment:SQL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine
I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS.
I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING.
I got the error message. Please find the Message below.
An error occured while starting mirroring.
additional Information:
:..>Alter failed for Database 'KQDB', (Microsoft SqlServer.Smo)
:..>An exception occured while executing a Transact-SQL statement or batch
[Microsoft SqlServer.Connection.info]
:..>Database mirroring Transport is disabled in the endpoint configuration.
[Microsft SQL Server,Error: 1486]
If anyone have a solution on how to setup a database mirroring environment.Please send.
Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2.
Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed?
Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it.
Thanks in advance to anyone who can help,
Abel
I need to install SQL Server 2005 Standard Edition on a new Windows Server 2003 machine that has SQL Server 2005 Express Edition installed by a backup application (Backup Exec). Will I need to uninstall the express edition in order to install the standard edition? Can the two coexist as separate instances or will the standard edition installation simply upgrade the express installation?
Thanks
I installed sql server 2005 sp2 including business intelligence development suite , however I got a message
some client components not compablitable .This morning I searched my programs and found that I have new
visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence
developer (which does not work) It seems I I would like to get rid of vs 2005 also
fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista
and I would only like to keep tools meant for sql standard 2005 reporting services etc
here is a list of my sql sp2 install package
By the way I doubled clicked sql_tools.msi and did not run as administrator
Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005......
Time: 05/06/2008 20:49:23.437
KB Number: KB921896
Machine: BILLPREC690
OS Version: Professional (Build 6000)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD
Notification Services ENU RTM 9.00.1399.00 x86 STANDARD
Integration Services ENU RTM 9.00.1399.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
SQLXML4 ENU 9.00.1399.06 x86
Backward Compatibility ENU 8.05.1054 x86
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
SQLWriter Microsoft SQL Server VSS Writer Service 2700
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
Success, Reboot Required
Exit Code Returned: 3010
Hi,
We are trying to move our application from SQL2005 to SQL2005, we are using 2005 jdbc driver 1.1.
The problem we have is, when a date is retrieved from the database, only the year part got correctly, but the date is automatically set to January 1 of that year. The interesting thing is this problem doesn't occur on local development environment (developer's windows platform), it only happens when we deploy the application to production server (unix).
Does anyone know what is going on, how to fix it?
Thanks.
Cathie
I have just installed SQL Server 2005 Developer Edition and I can't find any of the GUIs from the Start menu. Can anybody help?
View 3 Replies View RelatedHow can we enable or install the IIS before installing SQL server 2005?
Also how can we find out the edition of the SQL server 2005 to be installed?
Hello Friends,
I need to install SQL server 2005 in my desktop. I have already installed Visual Studio 2005 and selected to install all add ons during initial installation of VS 2005.
Now, when i inserted my CD for installing SQL server 2005, there is nothing that has to be installed.
I checked that SQL 2005 Express edition is already installed in my system.
Kindly let me know, if by installing VS 2005 with all add ons will install SQL server 2005 as well?
Many thanks.
Regards,
Ramki
Hello Friends,
I need to install SQL server 2005 in my desktop. I have already installed Visual Studio 2005 and selected to install all add ons during initial installation of VS 2005.
Now, when i inserted my CD for installing SQL server 2005, there is nothing that has to be installed.
I checked that SQL 2005 Express edition is already installed in my system.
Kindly let me know, if by installing VS 2005 with all add ons will install SQL server 2005 as well?
Many thanks.
Regards,
Ramki
Hi,
I was wondering if anyone might be able to help me. I was trying to run SQL Server 2005 express edition after downloading it from the internet. I must admit i'm new to SQL server. So this is why i like to get a feel of how it works and that sort of things. However, when i tried to run it, it's saying that i needed .Net Framework 2. Then, after having downloaded the .Net and run the setup, the error message came up with the following message.
"Error creating process <c:Documen~1userslocals~1 empixp000.TMPInstall.exe>. Reason: c:windowssystem32advpack.dll"
It still gives me the same error message after updating the advpack.dll i got from the internet.
Has anyone had the same experience as i've been having now?
Any ideas as to solve it?
Thank you in advance
I have a problem. I downloaded SQL server 2005 "standard or develope" trial version, which did not install on my computer. Probably not working on my OS. So the trial version did not work. Could someone please give me a clue which version that would work??
My OS an SP-level is;
Windows XP Professional
Version 5.1 (Build 2600.xpsp_sp2_gdr.050301-1519: Service Pack 2)
(Windows XP Professional version 2002 32-bit, Windows XP
Service Pack 2, IIS, .NET Framework 2.0., 13GB free space,
processor intel 1,5 GHz, 256MB RAM)
Hi All,
When i am going to install SQL Server 2005, its coming error "provide unique instance name".
The error is coming on "SQL Server Database Service".
All the service get installed with out any error.
I have select "default instance".
Please help me to resolve this issue.
Thanks
Abhi
Hello
I am trying to install SQL Server 2005 on XP with SP2. According to Microsoft this should be sufficient. However when I try to install it says I need WIndows Installer 3.1. I cannot get this from Microsofts website as i'm not using a proper copy of XP.
Does anyone know a way round this before I go and buy XP?
This is the file I need...
WindowsInstaller-KB893803-x86.exe
To complicate matters further i'm running XP on my Mac via Virtual PC (but i'm told this shouldn't matter)
Thank you in advance
While i try to install Sql Server 2005 this message appears :
"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."
What can i do?
I am trying to install Sql Server 2005 Enterprise Edition on Windows XP Professional SP2.
Hi all,
i've searched forum and haven't found anything interesting for my problem.
I have installed SQL server 2005 (enterprise) 32-bit and have run SQL server Management Studio. (using: Windows XP)
What/how shall I install/connect to a server name (database engine)?
I have AdventureWorks and would like to use it in Management Studio.
thank you for your help. :)
Hi,
I've installed SQL server 2005 (enterprise edition) and started SQL Server Management Studio; and I don't have any servers nor databases.
What shall/can I do in order to get (at least) a sample database (eg. Adventureworks) getting started.
Thank you for anykind of help.
Hi,
During the installtion of SQL Server 2005 (Win2k3 SP2) the msxml setup fail. When i try to install manually the msxml i get the error "the system administrator has set policies to prevent this installation". I'm the machine administrator.
Someone can help me?
I am new at installing SQL Server 2005 for the first time. How do I configure the server for security and setup user logins? Thanks!
View 3 Replies View RelatedI am getting ready to install SP 1 for 2005 on two servers. Are there any outstanding issues with SP 1 that I should prepare for?
View 5 Replies View RelatedI believe when I installed VB 2008 Express Edition, it also installed SQL Server 2005, so I do not need to install SQL Server 2005 Express Edition, correct?
Thanks,
Dave (aka "da noob")
I've done this before but it's been sometime. When I finish installing the MS SQL Server 2005 Developer edition, all I see under the Microsoft SQL Server 2005 folder in the All Programs is Configuration Tools with the following shortcuts:
Notification Services Command PromptSQL Server Configuration ManagerSQL Server Error and Usage ReportingSQL Server Surface Area Configuration
The are a whole bunch of other programs inside the Microsoft SQL Server 2005 folder that are missing. How do I add those services or program such as the Microsoft SQL Server Management Studio?
I have been trying to install Visual Web Developer 2005 Express Edition and SQL Server 2005. The Web Developer installs ok but the SQL Server installation fails. I can't figure out why. I have (I think...) uninstalled my previous beta intallations. The must be something else that prevents the installation. Can anyone point me to some FAQ or something that can give me some ideas on how to handle the installation./anders
View 2 Replies View RelatedHello,
When installing SQL Server 2005 developer, I get the error:
Product : Visual Studio Integrated Development Environment 2005Error : Internal Error 2356. _14248_Microsoft_VC80_MFC_x86.msm
Any idea why this is happening?
Thanks.
Can you install 64 bit 2k5 sql server on 32 bit 2k3 OS, yes, no? if there is way then can anyone guide me.
thanks
Derek
Hi,
i am getting a warning while installing sqlserver 2005. the warning i got is:
COM Plus Catalog Requirement (Warning)
Messages
-COM Plus Catalog Requirement
-If SQL Server Setup fails,
Setup will roll back the installation but may not remove all
.manifest files. The workaround is to rename the files and then rerun Setup.For more
information, see How to: Work Around COM+ Check Failure in SQL Server Setup.
could you please tell me how to solve this problem
Lakshmi
Friends -
I am going to install sql server 2005 clustering on windows 2003 o/s.
i am using active/passive clustering.
On node : 1 i created a shared disk, quorum, volume1, volume 2 under disk management.
my doubt is do i need to do the same thing again on node :2 like (create shared disk, quorum, volume1, volume 2 same as node:1
Please advise on this.
Cheers:)
vsh
Hi All,
When i am going to install SQL Server 2005, its coming error "provide unique instance name".
The error is coming on "SQL Server Database Service".
All the service get installed with out any error.
I have select "default instance".
Please help me to resolve this issue.
Thanks
Abhi