17.2 installation under SQL 2016 - SDM sql client

[Peter Schmidt]

Hi,
we try to install SDM 17.2 under Windows 2016 Standard against SQL Server 2016 (on it's own server).
I would need a description what and how is to be installed for SQL on the SDM Server (primary).
Installing ssms.msi and native client allown do not bring sqlcmd.exe with them.

Is there any techDoc witch steps have to be done before installing CA Service Management?

Regards,
Peter

------------------------------
Senior Technical Consultant
Fujitsu Services
------------------------------

[Lindsay Estabrooks]

Hi Peter,

Any time I have installed SQL Server Management Studio it includes SQLCMD.EXE. I find it under the ..\Tools\Binn folder.

Cheers,
Lindsay

------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------

[Peter Schmidt]

Hi Lindsay,

the server itself is not the problem.

I was talking of sql client used by sdm installation.

Regards,

Peter

---

Von:Lindsay Estabrooks via Broadcom <[e-mail]>
Gesendet: Montag, 13. Januar 2020 18:07
An: "Schmidt, Peter" <[e-mail]>
Betreff: RE: Clarity Service Management : 17.2 installation under SQL 2016 - SDM sql client

Hi Peter, Any time I have installed SQL Server Management Studio it includes SQLCMD.EXE. I find it under the ..\Tools\Binn folder. Cheers,... -replied to the "Clarity Service Management" community

Clarity Service Management   Post New Message Re: 17.2 installation under SQL 2016 - SDM sql client Reply to Group Reply to Sender Jan 13, 2020 12:05 PM Lindsay Estabrooks Hi Peter, Any time I have installed SQL Server Management Studio it includes SQLCMD.EXE. I find it under the ..\Tools\Binn folder. Cheers, Lindsay ------------------------------ Lindsay Estabrooks Principal Consultant IT-EDU Consultants ------------------------------   Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate   You are receiving this notification because you followed the '17.2 installation under SQL 2016 - SDM sql client' message thread. If you do not wish to follow this, please click here. Update your email preferences to choose the types of email you receive [e-mail]" height="1" width="2">

[Lindsay Estabrooks]

Hi Peter,

I was not talking about the MSSQL Server itself.

If you install SQL Server Managment Studio (SSMS) you get the client and the command line utilities.

If you don't want to install SSMS on the application server then you need download and install the SQL Client plus the SQL command line utilities. Make sure you put the folder in which the SQL command line utilities are installed is added to the PATH.

Cheers,
Lindsay

------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------

[Peter Schmidt]

Hi Lindsay,

thanks at first.

I already had installed SSMS, but SQLCMD was not available after that.

Commandline utilities needed odbc, before installing MsSslCmdLnUtils.msi I had to install msodbcsql.msi

Now sqlcmd could be started but does not know whom to talk to. What has to be configured?

Is there any install guide for client with sql 2016?

Instead of problems with sqlcmd itself I could start sdm installation. 
mdb seems to be created successfully.

Regards,

Peter

---

Von:Lindsay Estabrooks via Broadcom <[e-mail]>
Gesendet: Montag, 13. Januar 2020 19:56
An: "Schmidt, Peter" <[e-mail]>
Betreff: RE: Clarity Service Management : 17.2 installation under SQL 2016 - SDM sql client

Hi Peter, I was not talking about the MSSQL Server itself. If you install SQL Server Managment Studio (SSMS) you get the client and the command... -replied to the "Clarity Service Management" community

Clarity Service Management   Post New Message Re: 17.2 installation under SQL 2016 - SDM sql client Reply to Group Reply to Sender Jan 13, 2020 1:54 PM Lindsay Estabrooks Hi Peter, I was not talking about the MSSQL Server itself. If you install SQL Server Managment Studio (SSMS) you get the client and the command line utilities. If you don't want to install SSMS on the application server then you need download and install the SQL Client plus the SQL command line utilities. Make sure you put the folder in which the SQL command line utilities are installed is added to the PATH. Cheers, Lindsay ------------------------------ Lindsay Estabrooks Principal Consultant IT-EDU Consultants ------------------------------   Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate   You are receiving this notification because you followed the '17.2 installation under SQL 2016 - SDM sql client' message thread. If you do not wish to follow this, please click here. Update your email preferences to choose the types of email you receive Unsubscribe from all participation emails

[e-mail]" height="1" width="2">

[Alen Sinanovic]

For SQL I usually install:

• SQL Server Management Studio - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
• MS ODBC SQL - https://www.microsoft.com/en-us/download/confirmation.aspx?id=36434
• MS SQL command line utilities - https://www.microsoft.com/en-us/download/details.aspx?id=36433

------------------------------
Alen Sinanovic
Senior System Engineer Specialist
Sedam IT d.o.o.
Croatia
------------------------------

[Peter Schmidt]

Hi Alen,

thanks a lot.

 

Regards,

Peter

 

[Karen Matoke]

Hi Peter,

My search of knowledge articles came up with this one:
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=17125

It specifically refers to SQL Server 2014, but it would also apply to SQL Server 2016. I'll get that article updated.

Regards,

Karen

------------------------------
Broadcom
------------------------------

[Peter Schmidt]

Hi Karen,

many thanks for the link to the TecDoc.

 

BUT

 

Shouldn't this be an information in installation-guide?

A link to the TecDoc would be ok but not as nice as a own chapter under prerequisites for an installation.

 

Many thanks,

Peter

 

 

[Karen Matoke]

HI Peter,
yes, it would be better for the information to be integrated into the techdocs. I've flagged this up with the internal team.
Regards,  Karen

------------------------------
Broadcom
------------------------------