i my developer pc with the 2008 express on 1 site and the server somewhere else is it possible to connect and view the server's DB?


Yes, all you need to do is install and launch the SQL Server Management Studio and use it to connect to the remote database.

  • can i do it with windows authentication or only with SQL? – Y.G.J Dec 4 '10 at 7:27
  • what if i install that managment but sent my server with windows authentication - how can i change it? – Y.G.J Dec 4 '10 at 7:27
  • If your computer and the server are on the same Windows domain then your domain account just needs to be given access to the server. If they aren't on the same domain then you can create an account on the server with the same username and password as the account which you use on your computer. This will allow you to use Windows Authentication. You can change the server to use SQL Authentication by logging into the server as an admin and right clicking on the instance and selecting properties then select the security tab. – mrdenny Dec 4 '10 at 10:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.