Results 1 to 2 of 2

Thread: SQL Server 2005 ,, Help Me Please 2

  1. #1

    Thread Starter
    Addicted Member Zaid's Avatar
    Join Date
    Apr 2006
    Posts
    152

    SQL Server 2005 ,, Help Me Please 2

    Hi
    Installed SQL Server 2005 Express From VS 2005 Collection ...
    and when i try creat database from visual studio ...
    visual studio told me that he cant connect to the server and may be the problem that because not allowed to connect to remote computer !!
    so can you tell me what is the problem ??
    or how can i start the server of he star auto ??
    and how can i allow to connect to remote desktop ??
    thank you

  2. #2
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    CT
    Posts
    17,882

    Re: SQL Server 2005 ,, Help Me Please 2

    Network connections are turned off by default with MS SQL 2005.

    Using MANAGEMENT STUDIO (not sure if you have this tool - it comes with full-blown MS SQL 2005) I right click on the SERVER - select PROPERTIES.

    On the CONNECTIONS PAGE you click the "Allow remote connections to this server" check box.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width