Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

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

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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