Hello,
I have SQL Server 2000 on my machine and just installed SQL Server 2005 but
my registered server on my local machine still reads MyServer (SQL Server
8.0.760- MyServer\drake). Can I have two registrations on my local machine
using Windows Authentication. One for the old version and one for 2005? If
not, how do I upgrade the registered server to SQL Server 2005? Also, can I
uninstall SQL Server 2000?
--
Thanks in advance,
sck10"Can I have two registrations on my local machine
using Windows Authentication. "
This is independent from any authentication mode. Yes you can, if yo
mean with registration instances --> YOu can create multiple instances
on the machine.
One for the old version and one for 2005?
-Sure, side by side is possible.
If not, how do I upgrade the registered server to SQL Server 2005?
-Upgrade is possible: More information within the "SQL Server 2005
Upgrade advisor" ,
http://www.microsoft.com/downloads/details.aspx?familyid=6107C27A-662C-4319-AFE7-B52D1568C30A&displaylang=en
Also, can I uninstall SQL Server 2000?
Sure use the Add/remove programs in your Control Panel.
HTH, Jens Suessmeyer.|||I have the same problem. Both versions are running on my machine, but Visual
Studio 2005 only sees the default "SQL Server 2000", and SQL Server express.
How do I get a project to use SQL Server 2005 ?
Thanks
John
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139325038.293705.169180@.g14g2000cwa.googlegroups.com...
> "Can I have two registrations on my local machine
> using Windows Authentication. "
> This is independent from any authentication mode. Yes you can, if yo
> mean with registration instances --> YOu can create multiple instances
> on the machine.
> One for the old version and one for 2005?
> -Sure, side by side is possible.
> If not, how do I upgrade the registered server to SQL Server 2005?
> -Upgrade is possible: More information within the "SQL Server 2005
> Upgrade advisor" ,
> http://www.microsoft.com/downloads/details.aspx?familyid=6107C27A-662C-4319-AFE7-B52D1568C30A&displaylang=en
> Also, can I uninstall SQL Server 2000?
> Sure use the Add/remove programs in your Control Panel.
>
> HTH, Jens Suessmeyer.
>|||Hi sck10,
Welcome to use the MSDN Managed Newsgroup Support!
To resove this issue, please do the following steps:
1. In Registered Servers, right-click any node in the Registered Servers
tree, and then click Update Local Server Registration. Did you see the SQL
Server 2005 instance?
2. If you create a new registered server of your SQL Server 2005 Instance,
does any error occur?
To create a new registered server, please follow the SQL Server 2005 Books
online:
How to: Create a New Registered Server (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms190733.aspx
Hope this will be helpful!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Beppe,
Just checking in to see if the suggestions were helpful. Please let us
know if you would like further assistance.
Have a great day!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment