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.
No comments:
Post a Comment