Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I use SSMS 2005 to on SQL Server 2008?
Message
From
04/11/2011 05:49:42
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01527995
Message ID:
01528032
Views:
39
>>>>>Hi,
>>>>>
>>>>>I have SQL Server Management Studio 2005 on my PC (this is what says on the Connect to Server window). Can I use it to connect to SQL Server 2008? TIA.
>>>>
>>>>Yes, I believe you can. BTW, if you have IP address you can connect directly from your SQL Server - no need for VPN.
>>>
>>>Thank you for the answer to my SQL 2005 - SQL 2008 question. 'William is right; the customer told me that I must have VPN connected in order to connect to the SQL Server. The customer is very sensitive to their security.
>>
>>If you're connected via VPN, then you will be using SSMS installed there, right? Do they have SSMS 2005 installed?
>
>No. The customer told me that I should have SSMS install on my computer connecting to their SQL Server when I am connected via VPN. Does it make sense?

As others have said you should be able to use SSMS on your machine to access the remote SQL server over VPN. But why not install the latest SSMS on your machine - it's free and will work with all versions of SQL server....
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform