Post reply

Newbie002

  • July 15, 2015 at 11:39 am

    #300083

    I'm trying to learn to work with SSRS and the AdventureWorks2012. I have SQL Server 2014.

    I am running SSDT. I have added AdventureWorks2012 as a Data Source in the Report Data pane. (pain to me)

    I have added AdventureWorksDataset as a Dataset.

    AdventureWorks2012 is not pointing to AdventureWorks2012 I downloaded. I know it is there because I use it in SSMS.

    The address AdventureWorks2012 is on my laptop is C:\Users\traczek\TFR\Job\SQL Server

    My question is - How do I get my laptop to recognize that this is where AdventureWorks2012 is? In the data set?

  • July 15, 2015 at 12:44 pm

    #1812764

    How do you know that the data source is not pointing to the correct database?

    What is the connection string you used?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • July 15, 2015 at 1:14 pm

    #1812780

    How do you know that the data source is not pointing to the correct database?

    Because AdventureWorksDataset has no "+" to expand and see the contents of the files (tables).

    Also, when I click on the "Query Designer" button to query the dataset, I get Unable to connect to datasource "AdventureWorks2012." When I press detwils, I get: "You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server."

    What is the connection string you used?

    I used what was in the Microsoft tutorial. Here is the link on the page I am on.

    https://technet.microsoft.com/en-us/library/5ddf2914-bcdd-427d-8cba-0ccb8342f819(v=sql.110)

    You asked what I used for my connection. I used "Data source= local host; initial catalog=AdventureWorks2012"

  • July 15, 2015 at 1:41 pm

    #1812791

    traczek2 (7/15/2015)

    How do you know that the data source is not pointing to the correct database?

    Because AdventureWorksDataset has no "+" to expand and see the contents of the files (tables).

    Also, when I click on the "Query Designer" button to query the dataset, I get Unable to connect to datasource "AdventureWorks2012." When I press detwils, I get: "You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server."

    What is the connection string you used?

    I used what was in the Microsoft tutorial. Here is the link on the page I am on.

    https://technet.microsoft.com/en-us/library/5ddf2914-bcdd-427d-8cba-0ccb8342f819(v=sql.110)

    You asked what I used for my connection. I used "Data source= local host; initial catalog=AdventureWorks2012"

    Can you post a screen shot of your data source configuration? The connection string you have posted above is incorrect because local host should be one word, localhost. Other than that I can't see any issues with what you have posted so far. Screenshots of your data source configuration should be more helpful.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • July 15, 2015 at 3:25 pm

    #1812813

    Thank you for sticking with me on this.

    I do not know how to put a pic of the config here so you can see it.

    I also made "localhost" one word but that did not help.

    I can tell you the values I have used:

    Name - Adventureworks2012

    Embedded Connection is selected.

    Type: Microsoft SQL Server

    Connection String - Data source= localhost; initial catalog=AdventureWorks2012

    Nothing else selected.

    These are the data source properties.

    As for the configuration, I do not know how to do that. The link https://msdn.microsoft.com/en-us/library/w4dd7z6t.aspx I believe is what I need to study.

    Should that give me the answer?

  • July 15, 2015 at 4:14 pm

    #1812820

    Reporting Services Configuration Manager - Is This what I need to work with?

    It does not connect if I want to change databases.

  • July 16, 2015 at 7:27 am

    #1812935

    No. Reporting Services Configuration Manager isn't part of designing a report. Can you attach the report definition file (.rdl) to the thread? You attach files using post options which is below the Post Reply section where you type in your post/reply.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • July 16, 2015 at 12:35 pm

    #1813106

    Thank you for that advice.

    The two RDL's are attached.

    FYI: The original question is really where should my adventure works files be? Maybe now I should relate is o what I am sending you, Should the files (tables) be in the project folder?

  • July 16, 2015 at 12:39 pm

    #1813109

    The AdventureWorks tables are in an .mdf file. Does that need to be in a certain place?

  • July 16, 2015 at 1:20 pm

    #1813114

    Did you follow the instructions for installing and attaching the database, found here, http://social.technet.microsoft.com/wiki/contents/articles/3735.sql-server-samples-readme.aspx?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • July 16, 2015 at 2:19 pm

    #1813127

    I executed: CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'C:\Users\traczek\tfr\job\SQL Server\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

    This was successful.

    Then I went back to my Visual Studio, selected the AdventureWorksDataset, which displays the Dataset Properties window. The script to run was still in the box. I pressed the Query Designer button and I got an error that said: Unable to connect to data source AdventureWorkd2012.

    So I need to ask again, Do I need to have the tables from that .mdf file put in a certain folder for VS (DDTS) to get at it?

    The 2 .rdl files I sent earlier were from this directory:

    C:\Users\traczek\Documents\Visual Studio 2013\Projects\Tutorial\Tutorial

    Is this the issue? That they are not the same?

  • July 16, 2015 at 2:42 pm

    #1813129

    I did. I ran CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'C:\Users\traczek\tfr\job\SQL Server\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

    The files were created in directory: I guess I do not know where the files were created. When I go into SSMS, the files are there. Even when I go into extended propertied, I am not shown the path to the files.

    The .rdf files I sent earlier are in this directory:

    C:\Users\traczek\Documents\Visual Studio 2013\Projects\Tutorial\Tutorial

    Sorry, this was the 2nd time I did this post. I don't know why the first one went to oblivion.

  • July 16, 2015 at 2:43 pm

    #1813130

    Twice I have posted and nothing shows.

  • July 17, 2015 at 8:25 am

    #1813303

    It really doesn't matter what directory the files are in as long as they are in the location specified in your CREATE DATABASE statement which they are. The only thing I can think of is that your SQL Server instance is a named instance so you need to change the Data Source attribute in the connection string. When you connect to the server in SSMS what name do you use? Do you use localhost? Or is is something like localhost\SQL Server 2014? When you have a query oipen in SSMS you can see the server name in 2 places, the status bar (by default at the bottom of the query window) and in the top of the SSMS window. The attached image shows the locations (circled) on my PC. I just have moved the status bar to the top.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • July 17, 2015 at 9:20 am

    #1813340

    I did. I ran CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'C:\Users\traczek\tfr\job\SQL Server\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

    The files were created in directory: I guess I do not know where the files were created. When I go into SSMS, the files are there. Even when I go into extended properties, I am not shown the path to the files.

    The .rdf files I sent earlier are in this directory:

    C:\Users\traczek\Documents\Visual Studio 2013\Projects\Tutorial\Tutorial

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply