# Hello folk new to nocodb trying to set \[Oct 06\]

**URL:** <https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704 "2022-11-03T11:17:39Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/1 "2022-11-03T11:17:39Z")

</div>

> 🙋‍♂️ **khurram** _asked_

## hello folk; new to nocodb; trying to set it up in docker with sql server which is external

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/2 "2022-11-03T11:17:41Z")

</div>

> 👨‍💻 **pranavxc** _replied_

#### Can you try a simple script with `knex` and your credentials, something as follows:

#### 

#### ```js

#### const knex = require(‘knex’)({

#### client: ‘mssql’,

#### connection: {

#### host: ‘localhost’,

#### port: 1432,

#### user: ‘sa’,

#### password: ‘password’,

#### database: ‘test’

#### }

#### });

#### 

#### knex.raw(‘select 1+1’).then(res =\> console.log(res)).catch(e =\> console.log(e))

#### ```

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/3 "2022-11-03T11:17:42Z")

</div>

> 🙋‍♂️ **khurram** _replied_

#### ok

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/4 "2022-11-03T11:17:43Z")

</div>

> 🙋‍♂️ **khurram** _replied_

#### has given sysadmin role to sql user; and its working now

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/5 "2022-11-03T11:17:45Z")

</div>

> 🙋‍♂️ **khurram** _replied_

#### earlier i created the needed database (that i specified in NC\_DB) and sql user had dbo role to that database only

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/6 "2022-11-03T11:17:46Z")

</div>

> 🙋‍♂️ **khurram** _replied_

#### thanks for the help man! 👍

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/7 "2022-11-03T11:17:47Z")

</div>

> 👨‍💻 **pranavxc** _replied_

#### Glad it helped 🙂

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 11:17am UTC](https://community.nocodb.com/t/hello-folk-new-to-nocodb-trying-to-set-oct-06/704/8 "2022-11-03T11:17:48Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/1024925025024876584)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)