Manoj Chaurasia Posted May 30, 2015 Share Posted May 30, 2015 How do you connect to a SQLServer Instance. I tried like this. jdbc:sqlserver://(ServerName)(InstanceName);databaseName=(dbName) But TIBCO Design shuts down without giving any error message. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted June 2, 2015 Author Share Posted June 2, 2015 I am able to connect to Database. I need to know what would the connection string look like for a SQL Server instance Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted June 5, 2015 Author Share Posted June 5, 2015 It will be the same which you are using currently, unless you are using windows authentication for SQL server, if that is the case you can include Integrated Security=True in your connection parameter, this should work I hope. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted June 6, 2015 Author Share Posted June 6, 2015 Thanks. Tried Integrated Security=True, but it is shutting down the TIBCO Designer. I am using BW 5.12 version and SQL 2008 R2. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted June 8, 2015 Author Share Posted June 8, 2015 Okay, are you getting this error only with MS SQL driver or with every other drivers. and where exactly the designer is getting crashed. is it when you test the database connection with JDBC connection resource Link to comment Share on other sites More sharing options...
Anusha R Posted October 23, 2015 Share Posted October 23, 2015 Try either TIBCO provided driver or SQL server driver. driver - com.microsoft.sqlserver.jdbc.SQLServerDriver URL - jdbc:sqlserver://:;databaseName= driver - tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver URL - jdbc:tibcosoftwareinc:sqlserver://:;databaseName= Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted October 23, 2015 Author Share Posted October 23, 2015 @[user:13760|Senthil Murugan V] : I got a notification that you replied to this post. Can you reply again. i cannot see the response here. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted October 23, 2015 Author Share Posted October 23, 2015 Hi Have used the below JDBC Connection string to connect to Sql Server, it is working fine for me. 'jdbc:sqlserver://:;databaseName=' What JDBC jar are you using. Link to comment Share on other sites More sharing options...
Brian Clark Posted January 6, 2019 Share Posted January 6, 2019 A few years too late but maybe this will help someone else. When connecting to a SQL Server instance (I'm assuming you have more than one instance on a machine) the instances are running on different ports. So instead of using the standard 1433 port you will need to use the port number you setup for the sql server. The easiest way to find it is USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now