Installing SQL Server 2005

Jul 11, 2006

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


ADVERTISEMENT

Installing IIS After Installing SQL Server 2005 And Visual Studio 2005 Help Requested!

Aug 31, 2007

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

View 1 Replies View Related

Installing SQL Server Standard Edition 2005 After Installing SQL Server Express 2005

Feb 14, 2007

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

View 5 Replies View Related

Installing MS Visual Studio 2005 (PE). On Vista X64 (BE) Running MS SQL Server 2005 (DE) X64

Feb 10, 2008

Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2.

Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed?

Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it.

Thanks in advance to anyone who can help,

Abel

View 3 Replies View Related

Installing SQL Server 2005 Standard Edition When Express 2005 Is Already On Server

Sep 30, 2007

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

View 3 Replies View Related

Sql Server 2005 (business Intelligence Development Suite ) Problem Installing Sql 2005 On Vista (vs 2008)

May 7, 2008

I installed sql server 2005 sp2 including business intelligence development suite , however I got a message
some client components not compablitable .This morning I searched my programs and found that I have new
visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence
developer (which does not work) It seems I I would like to get rid of vs 2005 also
fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista
and I would only like to keep tools meant for sql standard 2005 reporting services etc
here is a list of my sql sp2 install package
By the way I doubled clicked sql_tools.msi and did not run as administrator
Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005......

Time: 05/06/2008 20:49:23.437
KB Number: KB921896
Machine: BILLPREC690
OS Version: Professional (Build 6000)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD
Notification Services ENU RTM 9.00.1399.00 x86 STANDARD
Integration Services ENU RTM 9.00.1399.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
SQLXML4 ENU 9.00.1399.06 x86
Backward Compatibility ENU 8.05.1054 x86
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
SQLWriter Microsoft SQL Server VSS Writer Service 2700

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
Success, Reboot Required
Exit Code Returned: 3010

View 2 Replies View Related

Installing SQL Server 2005

Jan 18, 2007

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 Related

Installing SQL Server 2005

May 3, 2008

How 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?

View 4 Replies View Related

Installing SQL Server 2005

May 8, 2008

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

View 1 Replies View Related

Installing SQL Server 2005

May 8, 2008

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

View 4 Replies View Related

Help With Installing SQL Server 2005

Jul 10, 2006

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

View 3 Replies View Related

Installing MS Sql Server 2005

Nov 1, 2006

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)

View 9 Replies View Related

SQL Server 2005 Is Not Installing

Apr 4, 2007

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

View 5 Replies View Related

Installing SQL Server 2005

May 15, 2007

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

View 1 Replies View Related

Installing Sql Server 2005

Oct 11, 2007

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.

View 2 Replies View Related

Installing Sql Server 2005

Oct 21, 2007

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. :)

View 5 Replies View Related

New On Installing SQL Server 2005

Nov 5, 2007

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.

View 11 Replies View Related

Installing SQL Server 2005

Jul 11, 2007

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?

View 2 Replies View Related

Installing SP 1 For SQL Server 2005

Jun 28, 2006

I 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 Related

Installing SQL 2005 Server

Apr 21, 2008

I 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")

View 4 Replies View Related

Installing MS SQL Server 2005 Developer

Feb 3, 2007

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?

View 7 Replies View Related

Installing SQL Server 2005 Fails

Nov 25, 2005

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 Related

Installing SQL Server 2005 Developer

Jan 23, 2006

Hello,
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.

View 1 Replies View Related

Installing SQL Server 2005 64 Bit On 32 Bit 2003 OS

Nov 27, 2007

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

View 5 Replies View Related

A Problem While Installing Sql Server 2005

Apr 18, 2008

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

View 7 Replies View Related

Installing SQL Server 2005 Clustering

Jun 9, 2008

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

View 7 Replies View Related

Error On Installing Of SQL Server 2005

Apr 4, 2007

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

View 1 Replies View Related

TROUBLE INSTALLING SQL SERVER 2005

Aug 11, 2007

Hello,

I am trying to install SQL Server 2005. I just installed Microsoft Visual Studio 2005(.NET). I got an option in my Start -> Programs for Microsoft SQL Server 2005. But I don't see how to bring up the query analyzer. It just has options for Configuration Tools ->SQL Server Configuration Manager,SQL Server Error and Usage Reporting, SQL Server Surface Area Configuration.

Did I install it wrong by chance? Do I need to do something else now? Do I need to configure it? If yes, how do I do that? Could anyone lead me in the right direction please? Thanks!

I have no idea how to proceed since I've never installed this before.
Could anyone please help me install or do whatever needs to be done to it so I can bring up the query analyzer/user interface and be able to use SQL?

Thanks,
Looking forward to hearing from you.

View 3 Replies View Related

Installing Sql Server 2005 For The First Time

Feb 12, 2008

I will be installing SQL Server 2005 enterprise edition for the first time and was looking for some hints...

unfortuntely, I don't know alot about what kind of applications they will be using the databases for.. but I do know that I have 400GB to allocate. My manager suggested a seperate volume for the SQL Server Binaries.. not sure why... ANY OPINIONS ON THAT???

This is what he suggested
C: OS
D:SQL Server application install
E:datafiles
F:Logfile
e:tempdb

any hints, suggestions, opinions, things to watch out for... ???????

I was thinking more along the lines of
c:OS and application installs (sql server etc..)
E:datafiles and TempDB
F:Logsfiles

View 6 Replies View Related

Installing SQL Server 2005 On Vista

Mar 6, 2008

Hi,

I'm about to purchase a new development laptop and want to ensure I won't have any issues installing SQL Server 2005 on Windows Vista.

I can see from http://technet.microsoft.com/en-us/library/ms143506.aspx that it is possible but states that SQL Server 2005 SP2 must be installed.

My install CD is for SQL Server Developer Edition without SP1 or SP2. Will I be able to install off this and then install SP2 afterwards or will I encounter problems because I need SP2 present on the install media?

Any advice would be greatly appreciated.

Cheers,
Gavin.

www.gavinharriss.com

View 3 Replies View Related

Failure Installing SQL Server 2005 SP 1

Apr 22, 2006

Windows XP Pro
SQL Server 2005 Express
SQL Server 2005 Standard

I installed the service pack for SQL Server Express first.
Then I tried to install the service pack for SQL Server. I got the error message, "A recently applied update, KB913090, failed to install.", while it was upgrading the Setup Support Files.

Jonathan Allen

Log follows...



04/22/2006 10:52:34.781 ================================================================================
04/22/2006 10:52:34.875 Hotfix package launched
04/22/2006 10:53:47.546 Attempting to install instance: SQL Server Native Client
04/22/2006 10:53:47.578 Attempting to install target: RADICALJAY
04/22/2006 10:53:47.593 Attempting to install file: sqlncli.msi
04/22/2006 10:53:47.687 Attempting to install file: \RADICALJAYc$1f5502657526de4ed0cHotFixSqlncliFilessqlncli.msi
04/22/2006 10:53:47.687 Creating MSI install log file at: C:WINDOWSHotfixRedist9LogsRedist9_Hotfix_KB913090_sqlncli.msi.log
04/22/2006 10:53:47.703 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/22/2006 10:53:47.718 Failed to read registry key: Debug
04/22/2006 10:53:49.578 MSP returned 0: The action completed successfully.
04/22/2006 10:53:49.765 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/22/2006 10:53:49.781 Failed to read registry key: Debug
04/22/2006 10:53:49.781 Successfully installed file: \RADICALJAYc$1f5502657526de4ed0cHotFixSqlncliFilessqlncli.msi
04/22/2006 10:53:49.796 Successfully installed target: RADICALJAY
04/22/2006 10:53:49.812 Successfully installed instance: SQL Server Native Client
04/22/2006 10:53:49.828
04/22/2006 10:53:49.828 Product Status Summary:
04/22/2006 10:53:49.843 Product: SQL Server Native Client
04/22/2006 10:53:49.859 SQL Server Native Client (RTM ) - Success
04/22/2006 10:53:49.859
04/22/2006 10:53:49.875 Product: Setup Support Files
04/22/2006 10:53:49.890 Setup Support Files (RTM ) - Not Applied
04/22/2006 10:53:49.890
04/22/2006 10:53:49.906 Product: Database Services
04/22/2006 10:53:49.921 Database Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:49.937 Analysis Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:49.937 Reporting Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:49.953
04/22/2006 10:53:49.968 Product: Database Services
04/22/2006 10:53:49.968 Database Services (SP1 2047 ENU) - NA
04/22/2006 10:53:49.984 Details: Instances of SQL Server Express cannot be updated by using this Service Pack installer. To update instances of SQL Server Express, use the SQL Server Express Service Pack installer.
04/22/2006 10:53:50.000
04/22/2006 10:53:50.015 Product: Notification Services
04/22/2006 10:53:50.015 Notification Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:50.031
04/22/2006 10:53:50.046 Product: Integration Services
04/22/2006 10:53:50.046 Integration Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:50.062
04/22/2006 10:53:50.078 Product: Client Components
04/22/2006 10:53:50.093 Client Components (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:50.093
04/22/2006 10:53:50.109 Product: MSXML 6.0 Parser
04/22/2006 10:53:50.125 MSXML 6.0 Parser (RTM ) - Not Applied
04/22/2006 10:53:50.125
04/22/2006 10:53:50.140 Product: SQLXML4
04/22/2006 10:53:50.156 SQLXML4 (RTM ) - Not Applied
04/22/2006 10:53:50.171
04/22/2006 10:53:50.171 Product: Backward Compatibility
04/22/2006 10:53:50.187 Backward Compatibility (RTM ) - Not Applied
04/22/2006 10:53:50.203
04/22/2006 10:53:50.203 Product: Microsoft SQL Server VSS Writer
04/22/2006 10:53:50.218 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
04/22/2006 10:53:50.234


View 10 Replies View Related

Installing SQL Server 2005 Corrupt.

Sep 10, 2007



Hi,

I hope there is some body arround here to solve my problem.

After reinstalling SQL server 2005 I got this message:

Your SQL Server installation is either corrupt or has been tampered with ( Error getting Instance ID From name).
Please uninstall, then re-run stetup to correct this problem.

There are also 51 setup log files in: Setup/Boostrap/Log/files/


Can Ido that manually? Or is there another way to solve this problem.

Henk

View 11 Replies View Related

Installing SQL Server 2005 Express

Dec 8, 2006

I am working on Win2K Pro & had SQL Server 2005 Express & SQL Server Management Studio installed. The SQL Server name was MerverSQLEXPRESS. Due to some unavoidable reasons, I had to repair (& not re-install) Win2K but after doing so, I found that I am not able to connect to the database server. I uninstalled all the components related to SQL Server 2005 Express (like Management Studio, Support Files, BOL etc.) from my m/c & then restarted my m/c.

After doing so, I first re-installed SQL Server 2005 Express & other related components (I intended to install SQL Server 2005 Management Studio after installing SQL Server 2005 Express). While installing SQL Server 2005 Express, all the steps get executed successfully except for the last one which happens to be SQL Server Database Services. At this point, I get the following error:

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

The problem is after I click the OK button, I am not even given the option to change the instance name! The Status message corresponding to SQL Server Database Services just says Setup failed. Refer to the Setup log for details. Finally, when I click the Next button, the next dialog finishes the Setup (showing the Finish button).

Now how do I overcome this problem? Please note that the Authentication mode I am using is Windows Authentication.

Someone please suggest me a concrete solution. It's driving me nuts! My receding hairline is getting further receded!

Lastly, please note that, as far as possible, I would like to keep the instance name as MerverSQLEXPRESS only.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved