Link to home
Start Free TrialLog in
Avatar of cllocc
cllocc

asked on

How can I connect to a SQL server from another workstation

Hi,

I have installed MS SQL Server 2008 express and have a  SQLExpress database set up on my computer. I would like other users connect to that database. I tested the connection to the database but the other workstation reports that it is unable to connect

1. Do I need to install SQL Server 2008 express on their machines too?
2. How can I add their windows login as users?
3. How can I allow them to connect to the database on my computer? Do I need to share the database folder in windows?

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Chris Patterson
Chris Patterson

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Alpesh Patel
Please make sure

1. Remote login is enabled
List of things you need to do to allow remote connections:

    http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
Avatar of cllocc
cllocc

ASKER

will check those two links out and let you know what happens. thanks.
Avatar of cllocc

ASKER

Most complete answer with a tutorial that pertains to my version of SQL (2008)