[Migrated from old forumParticipant April 5, 2015 at 10:49 am Post count: 327]

#5681 |

Hello,

Can anyone help me, I have problem with connecting my IS with Microsoft SQL Server Menagment Studio.
I have Visual Dialplan pro with embedded IS. When I try to connect to my SQL server I get error message “Network error IOException: Connection refused”.
I use Windows authentication metod for SQL Server 2005 with username:Raman and no password.
In VDP in Database properties I use ‘jTDS Microsoft SQL’ type
user name: ‘Raman’ and no password.

Thank in advance.

[Migrated from old forumParticipant April 5, 2015 at 10:49 am Post count: 327]

#5682 |

Raman,
I’ll double check but using windows authentication with a jdbc provider probably isn’t supported. Try enabling mixed mode support on sql server, create a user and password (or use the ‘sa’ user that’s built in) and use that user name and password as the credentials in IS and try again. Let me know how you make out.

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:49 am Post count: 327]

#5683 |

Hi Kevin,

I tried with sa username and my password but it’s giving me error message again.
Is there maybe some tutorial of how to setup IS with MSSQL?

Thanks.

[Migrated from old forumParticipant April 5, 2015 at 10:50 am Post count: 327]

#5684 |

Raman,
Just as an FYI, you can connect to mssql using either method. I will post 2 videos shortly that show how to connect with and without using windows auth.

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:50 am Post count: 327]

#5685 |

Raman,

Here is a link to my video on setting up IS to connect to MSSQL using windows auth. It is video only, future ones will include audio. 😉

Connecting to MSSQL using Win auth in IS:
http://www.screencast.com/t/ZWFjMmQzNjI

Let me know if this helps. I will also put one up for using mixed mode authentication, as well as connecting to other DB systems in the future.

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:50 am Post count: 327]

#5686 |

Raman,

Here is the video for connecting to MSSQL using mixed mode authentication in IS.

Connect to MSSQL using mixed mode authentication(external link) Screencast:
http://www.screencast.com/t/MWIxNjllOW

Connect to MSSQL using mixed mode authentication(external link) Youtube:

Hope these help

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:51 am Post count: 327]

#5687 |

Hi Kevin,

I watched your movies and tried to apply your tips but unfortunately without success.
I don’t know what is the problem?
Maybe something on the MS SQL server side needs to be properly configured to allow that connection?
I’m new at MS SQL and any help would be appreciated.

[Migrated from old forumParticipant April 5, 2015 at 10:51 am Post count: 327]

#5688 |

Raman,
Windows authentication is supported “out of the box” with SQL server so you shouldn’t need to do anything for that. What version of MSSQL server are you using? Is your IS server on the same network as your MSSQL server? Have you configured TCP/IP connectivity in the SQL Manager? Depending on the version this is disabled during a normal install and may need to be enabled. Take a look at the below web pages and see if they help at all.

http://support.microsoft.com/kb/914277
http://support.microsoft.com/kb/265808
http://msdn.microsoft.com/en-us/library/ms191260.aspx

Hopefully one of these might help. You should definitely get some books/reference materials on working with SQL Server since it is a fairly complex database.

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:51 am Post count: 327]

#5689 |

Hi Kevin,
Thank you very much for your help, i have finaly menaged to link Integration server and MS SQL server.
I have Developer edition of MS SQL server and I didn’t know that by default remoting is disabled.
I just followed guidelines on http://support.microsoft.com/kb/914277(external link) and set up my MS SQL server properly.
Thanks again 🙂