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

Discord-Discussions
1

:raising_hand_man: khurram asked

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

2

:man_technologist: 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))

```

3

:raising_hand_man: khurram replied

ok

4

:raising_hand_man: khurram replied

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

5

:raising_hand_man: khurram replied

earlier i created the needed database (that i specified in NC_DB) and sql user had dbo role to that database only

6

:raising_hand_man: khurram replied

thanks for the help man! :+1:

7

:man_technologist: pranavxc replied

Glad it helped :slightly_smiling_face:

8

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs