Accessing SQL Server 2005 through Vista

I just bought a new HP laptop that has Vista installed. Not happy about the OS but it is what it is...

I need to use Enterprise Manager, or an equivalent, to access a remote server, running SQL 2005.

With XP, I always installed and used SQL Server 2000 Client features.

Vista does not play well with SQL 2000 so I am looking for an alternative to simply be able to access, and perform DTS functions, a remote SQL 2005 system.

Does SQL Server 2005 Express offer client alias features?

Can anyone recommend another approach or product?

Thank you,

SteveVista sucks, no doubt about it. I had to install it at work, but it will be a LONG time before I choose to install it at home.
That said, what errors or issues to you run into running Enterprise Manager on Vista? This is one thing that I have not had a problem with.|||Thanks blindman,

Are you referring to EM in SQL 2000 or 2005? I've tried both with different issues.

Steve|||EM is 2000. SSMS is 2005. I am running both on a Vista desktop.|||blindman,

I have installed SMSS and it is running. However, when I try to open or modify any tables or views, SQL stalls out.

I can see the databases, the table names but when I try to open any table, regardless of size, it shoes (expanding) but then stalls out.

I have created an exception in Windows firewall...

Thanks for any insight,

Steve|||Is the SQL Server local or remote?|||remote.

I have comfirmed that it is set up to allow remote connections.

thanks|||If SSMS opens correctly under Vista, but merely stalls out when trying to connect to a remote database server, then my guess is that you have a network issue.

Accessing SQL Server 2005 through Vista

I just bought a new HP laptop that has Vista installed.

I need to use Enterprise Manager, or an equivalent, to access a remote server, running SQL 2005.

With XP, I always installed and used SQL Server 2000 Client features.

Vista does not play well with SQL 2000 so I am looking for an alternative to simply be able to access, and perform DTS functions, a remote SQL 2005 system.

Does SQL Server 2005 Express offer client alias features?

Can anyone recommend another approach or product?

Thank you,

Steve

Just install the SQL 2005 client tools with the DTS add tool (available from microsoft.com/sql).|||SQL 2000 is not supported on Vista and you have depend only on SQL 2005 - http://www.microsoft.com/sql/prodinfo/previousversions/faq-sql_on_vista.mspx fyi on vista support.|||

SQL Server Configuration Manager lets you define aliases for servers in the SQL Native Client Configuration | Aliases node. You can register servers in Management Studio to simplify connecting to them as well.

Hope this helps,

Steve

Accessing SQL Server 2005 through Vista

I just bought a new HP laptop that has Vista installed.

I need to use Enterprise Manager, or an equivalent, to access a remote server, running SQL 2005.

With XP, I always installed and used SQL Server 2000 Client features.

Vista does not play well with SQL 2000 so I am looking for an alternative to simply be able to access, and perform DTS functions, a remote SQL 2005 system.

Does SQL Server 2005 Express offer client alias features?

Can anyone recommend another approach or product?

Thank you,

Steve

Just install the SQL 2005 client tools with the DTS add tool (available from microsoft.com/sql).|||SQL 2000 is not supported on Vista and you have depend only on SQL 2005 - http://www.microsoft.com/sql/prodinfo/previousversions/faq-sql_on_vista.mspx fyi on vista support.|||

SQL Server Configuration Manager lets you define aliases for servers in the SQL Native Client Configuration | Aliases node. You can register servers in Management Studio to simplify connecting to them as well.

Hope this helps,

Steve