[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

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.
0
cllocc
Asked:
cllocc
1 Solution
 
Chris PattersonCommented:
First thing you have to do is on your machine, make sure remote connections are allowed to your local database instance.  You need to right click on the sever instance, then go to properties and make sure " allow remote connections is ticked.  Next you need to verify that either your local firewall is off or configured to allow users to connect to your SQL instance via its configured ports.  After that you need to grant the users access to the databases.  See the following article for assistance:  http://blogs.msdn.com/b/bethmassi/archive/2008/09/17/enabling-remote-sql-express-2008-network-connections-on-vista.aspx.  Hope this helps.
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure

1. Remote login is enabled
0
 
Carl TawnSystems and Integration DeveloperCommented:
List of things you need to do to allow remote connections:

    http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
0
 
clloccAuthor Commented:
will check those two links out and let you know what happens. thanks.
0
 
clloccAuthor Commented:
Most complete answer with a tutorial that pertains to my version of SQL (2008)
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now