July 17, 2015 at 10:16 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 the data source.
FYI: I am not seeing the replies anymore in the post. I only see one at a time in the email I receive from you. I am having someone look to see what is happening there.
Anyway, I am getting your answers. Unfortunately, things are still not working.
July 17, 2015 at 10:50 am
Okay, so you have SQLExpress installed, which is kind of what I thought. The next step is to go into SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLExpress and enable either named pipes or TCP/IP. Then you should be able to connect using SSDT.
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 11:18 am
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 say EITHER pipes or TCP/IP. So not both???
I enabled both and it did not work. Same message, could not connect to the datadase.
July 17, 2015 at 11:49 am
You don't need both, but you can enable both without doing any harm. Did you restart the SQL Server service after making the change?
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 12:59 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 1:12 pm
Restarted the laptop. Still the same results. Cannot find the data.
July 17, 2015 at 3:37 pm
Jack,
FYI: I got past the hurdle by eliminating "Initial Catalog=AdventureWorks2012" from the connection string.
That should be ok, yes?
July 18, 2015 at 10:44 am
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 files used in the query with an check box by each for all columns. None are checked.
The second section has a list of fields that will display in the query.
The third section has the query.
The fourth section is empty.
When I press the OK button, that query Designer display goes away and I get another message saying: "Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct."
Well, I know the query syntax is correct because I copied it direct from what Microsoft had written.
When I press details, I get: "Invalid object name 'Sales.SalesPerson'." This is the first field in the FROM clause.
Looking more closely at the Query Designer, I see there is a run button on top. So I can understand with that that there would be no data. I clicked on that button. I got a message: SQL Execution Error followed by the query and finishing off with two errors:
Error Source: .Net SqlClient Data Provider
Error Message: Invalid object name "Sales.SalesPerson".
So maybe there really is no connection or an incorrect one.
Any ideas? I'll keep looking here.
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply