Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2005 and 2000 versions
Message
From
22/08/2006 14:04:11
 
 
To
22/08/2006 13:39:07
Keith Payne
Technical Marketing Solutions
Florida, United States
General information
Forum:
Microsoft SQL Server
Category:
Installation
Miscellaneous
Thread ID:
01147527
Message ID:
01147648
Views:
22
>>Hi,
>>
>>
>>With SQL Server 2005 installed I install the SQL Server 2000.
>>Now, when I try to access SQL Server 2005 I get this message where try to login.
>>
>>
>>
>>TITLE: Connect to Server
>>------------------------------
>>
>>Cannot connect to DELL.
>>
>>------------------------------
>>ADDITIONAL INFORMATION:
>>
>>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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
>>
>>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
>>
>>------------------------------
>>BUTTONS:
>>
>>OK
>>------------------------------
>>

>>
>>
>>
>>
>>>Yes, I've done so and have no had any problems.
>>>
>>>>Hi,
>>>>
>>>>
>>>>Can I to install "SQL Server 2005" and "SQL Server 2000" in the same computer without problem ?
>
>Geraldo,
>
>SQL 2000 and SQL 2005 should have different instance names. I know that SQL 2005 will not let you install over 2000 with the same instance name. I don't know if SQL 2000 works the same. You may have both versions sharing the same instance name.


Yes, with the same login and password the two versions works, but a Data Base that I have in 2005 version can't be opned. When I try to Atach in the new instance an error message is displayed.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform