I need help accessing my local SQLExpress

Question

I need help accessing my local SQLExpress

Rod at work

SSC-Dedicated

Points: 34029
More actions
January 10, 2025 at 5:17 pm

#4513365

My PC has been causing me problems for months. I've told my desktop support team. They reimaged my machine, but it hasn't helped. I cannot run SSMS against the LocalDB I get this error:
and that's as far as that goes. If I try to connect to LocalDB I get this error:
and that ends that.
If I try connecting to localhost I get this error:
And so, for the third time, I am blocked.
If I try to use Azure Data Studio to connect to localhost I get this error:
If I try connecting to LocalDB I get this error:
I have even repaired both SSMS and ADS, which has NOT HELPED AT ALL.
I've told my desktop support team. Their solution, uninstall SSMS and ADS and leave them off.
I hate this FU attitude from my support, but that's what I have to deal with.
What can I do to try to make it possible for me to do my job???????????????????????????????????????
Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 8 posts - 1 through 7 (of 7 total)

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

Rod at work SSC-Dedicated Points: 34029 More actions · Answer 1

I forgot to mention that if I try to use ADS against a different database, a regular SQL Server database, it allows me to use it for a couple minutes then it crashes with this error:

Screenshot 2025-01-10 103032

it does that over and over and over and over and over and over and over and over and over and over and over and over and over again, very rapidly.

Kindest Regards, Rod Connect with me on LinkedIn.

Danny Springer Ten Centuries Points: 1279 More actions · Answer 2

Hi Rod,

Some weeks ago I had exactly the same thing with the usersettings-error and found the solution here: https://learn.microsoft.com/en-us/answers/questions/1848448/unable-to-process-the-existing-user-settings-and-w

Basically throw away the usersettings file and restart ssms.

Regards,

Danny

Eirikur Eiriksson SSC Guru Points: 182935 More actions · Answer 3

Quick question, have you enabled TCP in the network settings for the server instance?

😎

Rod at work SSC-Dedicated Points: 34029 More actions · Answer 4

Eirikur Eiriksson wrote:

Quick question, have you enabled TCP in the network settings for the server instance? 😎

No. However, I don't have permissions on the server to do that. (I'm talking about one of our SQL Server servers, not my dev box.) I'm checking with the DBAs.

Addendum

The DBAs assured me that TCP is enabled in the network settings on the server instance.

This reply was modified 3 days, 7 hours ago by Rod at work.
This reply was modified 3 days, 6 hours ago by Rod at work.

Kindest Regards, Rod Connect with me on LinkedIn.

Eirikur Eiriksson SSC Guru Points: 182935 More actions · Answer 5

Are there any firewall TCP port restrictions?

😎

Another thought, can anyone else access the server remotely?

Rod at work SSC-Dedicated Points: 34029 More actions · Answer 6

Eirikur Eiriksson wrote:

Are there any firewall TCP port restrictions? 😎 Another thought, can anyone else access the server remotely?

No one else can access the server remotely, because it is my development desktop. Only I have access to it.

Kindest Regards, Rod Connect with me on LinkedIn.

cyrusbaratt SSC-Addicted Points: 430 More actions · Answer 7

Please apply firewall rule for inbound/outbound port 1433 (on the server and your computer).

It is best to use more secure ports / certificate. DO you have connect database connect permission granted?

You may need data-reader / data-writer access settings depending on your needs.

DBASupport