Connecting to MSSQL EXPRESS 2005

Posted on 2009-04-19
Last Modified: 2012-05-06
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.
Question by:frosty1
    LVL 8

    Accepted Solution

    No it should be the same, state servername(or IP),(port if needed) and sql account and pass.
    LVL 8

    Expert Comment

    Have a look here as it might be port related:

    Author Comment

    thanks you answered my question. Turns out that the hosting company was using 2008. Therefore i need to download
    LVL 8

    Expert Comment

    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:

    To fix it:
    click View, Object Explorer Details. Then, open Databases. Finally, click the header columns and uncheck Collation

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now