Viewing 15 posts - 1 through 15 (of 16 total)
I believe it is working now because I do not get any window asking me to check to see if the connection works.
I added initial "catalog=AdventureWorks2012" back into the...
July 21, 2015 at 1:00 pm
More to say:
When I press the Query Designer, I get a Query Designer display. It is divided into four sections.
The top section contains the name of all six...
July 18, 2015 at 10:44 am
Jack,
FYI: I got past the hurdle by eliminating "Initial Catalog=AdventureWorks2012" from the connection string.
That should be ok, yes?
July 17, 2015 at 3:37 pm
Restarted the laptop. Still the same results. Cannot find the data.
July 17, 2015 at 1:12 pm
Yes, I restarted the SQL Server data tools.
I am going to restart the laptop to see what that does.
July 17, 2015 at 12:59 pm
OK. I did as you said; SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLExpress and enable either named pipes or TCP/IP.
At the end, you...
July 17, 2015 at 11:18 am
Thank you for giving me that information.
The name is TRACZEK-LAPTOP\MSSQLEXPRESS
In the Data Source Properties, I replaced 'laptop' with TRACZEK-LAPTOP\MSSQLEXPRESS but is get the same error message: Unable to connect with...
July 17, 2015 at 10:16 am
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...
July 17, 2015 at 9:20 am
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...
July 16, 2015 at 2:42 pm
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...
July 16, 2015 at 2:19 pm
The AdventureWorks tables are in an .mdf file. Does that need to be in a certain place?
July 16, 2015 at 12:39 pm
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...
July 16, 2015 at 12:35 pm
Reporting Services Configuration Manager - Is This what I need to work with?
It does not connect if I want to change databases.
July 15, 2015 at 4:14 pm
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...
July 15, 2015 at 3:25 pm
Viewing 15 posts - 1 through 15 (of 16 total)