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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
List of things you need to do to allow remote connections:
http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
ASKER
will check those two links out and let you know what happens. thanks.
ASKER
Most complete answer with a tutorial that pertains to my version of SQL (2008)
1. Remote login is enabled