Viewing 15 posts - 1 through 15 (of 16 total)
Thanks again.
I do have TCP/IP enabled (see below).
September 13, 2024 at 3:46 pm
Thanks for the reply.
Unfortunately, prefixing with Localhost did not work. I can only connect to the SQL server with NP:ServerName and then I can see all of the databases and...
September 13, 2024 at 2:06 pm
Still looking for an answer on this one, so hopefully someone can chime in.
September 9, 2024 at 3:37 pm
From what I can see TCP/IP and Named Pipes are both configured and ready in SQL Server (see below).
September 5, 2024 at 12:59 pm
Okay, using NP:ServerName worked for that part. I was able to connect to SQL Server and choose my existing Report Server database.
However, in the step that follows I'm getting this...
September 4, 2024 at 4:31 pm
No problem. During my investigation, one of the troubleshooting threads for Microsoft said to test local TCP/IP.
How do I set the connection string in the SSRS Configuration? It doesn't look...
September 4, 2024 at 3:25 pm
Thanks for the help.
As I said, this is all running local so there is no network communication going on. It's all on the local machine. I can unplug from the...
September 4, 2024 at 3:01 pm
I'm in a standalone situation so there are no servers involved. I don't believe there's a Firewall for my local SQL server instance. I've never heard about that before. How...
September 4, 2024 at 2:52 pm
Thanks for the reply!
I disabled the Firewall and my local machine malware monitor and still cannot connect.
Yes, SSMS is running correctly on the same machine. This is all my local...
September 4, 2024 at 2:04 pm
Bumping this to see if anyone might have some fixes to try.
Thanks!!
September 4, 2024 at 12:44 pm
Thanks for all of the replies.
At the present time, there is no latency on the Query and everything's running fine. I'll check the execution plan the next time I see...
December 6, 2019 at 4:57 pm
That was it!!
I didn't notice that the URL had _DEVBOX appended to the end. I'll have to remember that.
Thanks for the help!!
March 15, 2018 at 3:31 pm
I get the same error even with the URL that you suggested.
March 15, 2018 at 2:06 pm
Found out what the issue was.
Through the app I was passing login credentials and the password in the Web.Config file was incorrect as it was a copy from a previous...
December 10, 2015 at 2:14 pm
Just another update. I have a new desktop and did a fresh install of SQL 2014 along with SSRS and my web application and I'm still getting the 401 error....
December 9, 2015 at 10:52 am
Viewing 15 posts - 1 through 15 (of 16 total)