Connecting to MSSQL EXPRESS 2005

I am have having trouble to connectting to MSSQL EXPRESS 2005 on shared hosting via VPN from MSSQL 2005 Server Management. Does connection to Express work differently that normal SQL.
frosty1Asked:
Who is Participating?
 
SNilssonCommented:
No it should be the same, state servername(or IP),(port if needed) and sql account and pass.
0
 
SNilssonCommented:
Have a look here as it might be port related:

http://www.maximumasp.com/support/kb/article.aspx?article=1024
0
 
frosty1Author Commented:
thanks you answered my question. Turns out that the hosting company was using 2008. Therefore i need to download

http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en
0
 
SNilssonCommented:
Thanks!
If you dont have permission to view all databases on the 2008 enviroment and if you will need to use management studio 2008, you will most likely get this error:
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx

To fix it:
click View, Object Explorer Details. Then, open Databases. Finally, click the header columns and uncheck Collation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.