Hi Susmita;

  SQL server management studio is a Microsoft product and has nothing to do with PowerBuilder. Since you mention SSMS, I am assuming that your using the SQL Server DBMS. Thus, you would use the DB profile painter in the PB IDE & the Transaction Object in your PB application to manage your SS connection.

FYI: https://docs.appeon.com/pb2019/connecting_to_your_database/ch13s02.html

  In your application, you would code ...

Connect using SQLCA;

HTH

Regards ... Chris 

Hi, Susmita - 

It sounds like you could be relatively new to PowerBuilder. If so, I suggest you spend a little time and review the material in the Connecting to Your Database publication:

    https://docs.appeon.com/pb2019r3/connecting_to_your_database/ch01.html

Since you are new to the forum, it's always a great idea when you post on the Question & Answer forum to include the version/release/build of PowerBuilder or PowerServer you are using. In your case, that would've been good to know because Appeon added support for a new native database interface for SQL Server, the Microsoft MSOLEDBSQL interface beginning with PB 2019 Release 3 (which is the current Long Term Support [LTS] version). Microsoft's older SQL Server Native Client provider has been deprecated, although Appeon continues to support it (currently) and it continues to unofficially work with the newer versions of SQL Server.

That being said, if you are connecting to a SQL Server database with a PowerBuilder application, I suggest you consider using either the MSOLEDBSQL native interface or ODBC to ensure future connectivity.

Welcome to the Q&A forum! We're here to help. The only dumb question is the one never asked. Best regards and good luck!

John Fauss