Connecting to a 2005 database using 2000 EM

What are the steps to be able to add a 2005 server to a server group in the
2000 enterprise manager?
Thanks for any help,
Bob
You can't do that. You can, however, add a SQL 2000 database to SQL Server
Management Studio (the SQL 2005 replacement for EM.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Robert Dufour" <bdufour@.sgiims.com> wrote in message
news:%23grWQilGHHA.1912@.TK2MSFTNGP03.phx.gbl...
> What are the steps to be able to add a 2005 server to a server group in
> the 2000 enterprise manager?
> Thanks for any help,
> Bob
>

Connecting a web site to a remote SQL Server

Hello everybody!

Can anyone tell me what steps i should follow in order to get my web site (which is hosted with a web host in ireland) to connect to yet another server (different country) where SQL Server 2005 will be running?

Thank you! - Callam

Hi,

normally, and if I understood your question correctly, you would only have to change your connection string in the web.config file so that it points to the correct database on the other server.

Grz, Kris.

Connect to SQL Server 2000 trough internet (adsl connection )

Hi guys,

Can somebody tell me where i can find ( or explain me ) the steps to

connect to sql server using the internet. I am using VB6 (SP6) and SQL SERVER 2000

I want to set up asql server on a central location ( PC ) so that 4 different sites can access the data stored

Thanks for all help

grtz Robert

Instead of a ServerName in the Connection String, use the IP address instead (the port number may also be necessary.)

Server=10.0.0.1

Server=10.0.0.1,2500;

The above connects using IP port 2500 (the SQL Server default port on a single instance computer is 1433).

There may be firewall issues. Verify that the same port number is open through firewalls for the server and all computers that will connect to the server.