# SQL Express trough network

**URL:** <https://forum.sambapos.com/t/sql-express-trough-network/5669>\
**Category:** V4 Question\
**Created:** [June 3, 2015, 6:32pm UTC](https://forum.sambapos.com/t/sql-express-trough-network/5669 "2015-06-03T18:32:18Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [June 3, 2015, 6:47pm UTC](https://forum.sambapos.com/t/sql-express-trough-network/5669/4 "2015-06-03T18:47:38Z")

</div>

The Server name and Instance shows up in MSSMS when you connect to your database it looks like this.

![](https://forum.sambapos.com/uploads/default/original/3X/3/d/3dd1ae40d763801c92fee8c44b3cf265ccd577d3.png)

So as you can see my Connection String would look like this:

Data Source=MANCOW2\SQLEXPRESS; Database=DairyCreme

I did not include Password or User Id because I am using windows authentication. However if your using mixed mode you can include those.

You need to ensure a few things are working first.

```
1. in MSSMS right click your server and choose properties then go to Connections and ensure Allow remote connections to this server is enabled.

```

 ![](https://forum.sambapos.com/uploads/default/original/3X/e/4/e446bd0397b3cc8ebde4126b1c9b8a5cf50faf33.png) 

```
2. Ensure the following services are active and running.
SQL Server Browser
SQL Server Agent

```

 ![](https://forum.sambapos.com/uploads/default/original/3X/8/5/85b69bb3a2453cde1aba5dfa580d454d1576f634.png) 

```
3. Go to run and type mmc and press enter to open the Microsoft management console. Go to File > Add new snapin and choose SQL Server Configuration manager

```

 ![](https://forum.sambapos.com/uploads/default/original/3X/f/e/fe6a83790f9fa7909f886b6bb886a5648d5f2a99.png)

```
4. Expand the Native CLient 11.0 and click on Client Protocols and ensure TCP/IP is enabled.
```

---

_[View the full topic](https://forum.sambapos.com/t/sql-express-trough-network/5669)._