none
Connect SQL Server Express 2005 on a remote Computer

    Question

  • Hello Everyone,

    I just got a Virtual Dedicated Server and installed SQL Server Express 2005 on it and while I was installing choose Mix Mode authentication and setup a sa password.....

    I want to connect to that database remotely from my machine using VS 2005 or Management Studio....both are encountering the same problems.....

    On the Virtual Dedicated machine if I install management studio I run has no problem....it asks me for the server name : something\SQLEXPRESS then username and password and works fine...

    The same thing I try to do remotely is not happy with ....I tried to give the IP address of the server same thing no luck.....

    Can somebody tell me what I'm doing wrong and where....

    Thanks,

    Harsimrat

    Sunday, May 28, 2006 6:06 PM

Answers