var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 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?
Vista 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.
Are you referring to EM in SQL 2000 or 2005? I've tried both with different issues.
EM is 2000. SSMS is 2005. I am running both on a Vista desktop.
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,
Is the SQL Server local or remote?
I have comfirmed that it is set up to allow remote connections.
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.