MS SQL Database configuration issues

[HAL]

Is it an Issue with this path? should this be changed?

[scottwilkerson]

You might want to change that in the first line of the script. As it doesn't appear to be loading this as a python script...

[HAL]

I have chnaged the command line to say python at the beginning. However when we run a command other than connection time we see a message reading "CRITICAL: Can access the server but cannot query". our DB admin has confirmed that the user had rights to query and they can do so on DB console.

[scottwilkerson]

Just to verify, are you using Windows Authentication or SQL Authentication?

The reason I ask is that this plugin requires using a SQL account and will not work with Windows Authentication.

If you are using SQL authentication you need to make sure the user has select access on the master database.

[HAL]

Yes, we are using an SQL user account created specifically to access these SQL databases and has required rights to the connect to these databases.

[scottwilkerson]

Yes, we are using an SQL user account created specifically to access these SQL databases and has required rights to the connect to these databases.

When you say "these databases" do you mean the master database?

[HAL]

yes, we mean the master database. We have run the plugin on different databases on different servers ending up with the same result.

[HAL]

Hi,
Any findings from the previous post?
Awaiting your response!

[scottwilkerson]

Is this an instance based system or just running on port 1433?

[HAL]

I think its port based running on 1433