Adding a Data Source (DWDataMart)

Karen_Bruster1

I need to add the SCSM DWDataMart database to Cireson for some reports. I am trying to get the full Incident classification hierarchy.

This is what I am using to make the connection but I think I am missing something.

Data Source=servername;Initial Catalog=DWDataMart;Integrated Security=SSPI;

My question is for servername do you put the host name and then the instance or just the instance?

Karen

Brian_Wiest

Here is what Cireson showed me to do
Right click on your desktop and create a new txt document 
Rename to testing.udl
double click and you get a Data link properties connection windows
put in your setting and test connection 
You should get a box Test connection succeeded
Hit Ok
Now right click and open in notepad it will show your your connection string
HTH

Brian_Wiest

The same string you use to connect via SSMS. 
So you can use the direct server name or the instance or the cluster name. However your environment is setup.

Karen_Bruster1

@Brian_Wiest Is there a way to test it? When  I select it as the source in the SQL Chart it will not let me save the SQL Script.

Brian_Wiest

Here is what Cireson showed me to do
Right click on your desktop and create a new txt document 
Rename to testing.udl
double click and you get a Data link properties connection windows
put in your setting and test connection 
You should get a box Test connection succeeded
Hit Ok
Now right click and open in notepad it will show your your connection string
HTH

Karen_Bruster1

@Brian_Wiest Thank you, that gave me the information I needed and it now lets me create my SQL scripts against the DWDataMart.