problem with "SQL Server windows NT 64 Bit"

[Edlaos]

when I update Power BI with database, it locks the database and can no longer access the database with other applications. I always have to stop the task "PowerBI Desktop - SQL Server Windows NT 64 Bit", in the Task Manager, then it works again. The problem is the same the other way around.

All other applications can access the database at the same time without any problem, the problem occurs only with Power BI.

Error message:

Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred.

[amitchandak · Accepted solution]

@Edlaos , You should use service to stop or start SQL server.

Try to start SQL server from services and check if it gives any error

[Edlaos · Accepted solution]

thank you for your answer,

I don't understand exactly what you mean, I don't need to stop the SQL Server in the service, I always need the services for all other applications. I just need to stop the task "SQL Server Windows NT - 64 Bit" in the processes, every time it is not needed anymore. How do I do this automatically?

[Edlaos · Accepted solution]

Ok, it works when I stop sqlservr.exe from task services. But how can I do it automatically when it is no longer needed?

[v-janeyg-msft · Accepted solution]

Hi, @Edlaos 

Generally speaking, this problem won't occur all the time, you can uninstall powerbi desktop and reinstall it.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,

Community Support Team _Janey

If this post helps, then please consider Accept it as the solution to help the other members find it more.

[Edlaos · Accepted solution]

ok, I solved the problem. Need the \SQLEXPRESS for my project now and not the \MSSQLLocalDB. It looks like the \MSSQLLocalDB only manages one project.

[willjoe2442]

How do I fix Microsoft SQL Server?

How to Repair SQL Server Management Studio

1. Close the SSMS application (if it is running).
2. On the computer, go to Control Panel > All Control Panel Items > Programs and Features.
3. From the list of programs, right-click SQL Server Management Studio and click Uninstall.
4. Click Repair to begin the SSMS install repair.

Regards,

Willjoe

[Edlaos · Accepted solution]

ok, I solved the problem. Need the \SQLEXPRESS for my project now and not the \MSSQLLocalDB. It looks like the \MSSQLLocalDB only manages one project.

[Edlaos · Accepted solution]

thank you for your answer,

I don't understand exactly what you mean, I don't need to stop the SQL Server in the service, I always need the services for all other applications. I just need to stop the task "SQL Server Windows NT - 64 Bit" in the processes, every time it is not needed anymore. How do I do this automatically?

[amitchandak · Accepted solution]

@Edlaos , You should use service to stop or start SQL server.

Try to start SQL server from services and check if it gives any error

[Edlaos · Accepted solution]

Ok, it works when I stop sqlservr.exe from task services. But how can I do it automatically when it is no longer needed?

[v-janeyg-msft · Accepted solution]

Hi, @Edlaos 

Generally speaking, this problem won't occur all the time, you can uninstall powerbi desktop and reinstall it.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,

Community Support Team _Janey

If this post helps, then please consider Accept it as the solution to help the other members find it more.

[Edlaos · Accepted solution]

ok, I solved the problem. Need the \SQLEXPRESS for my project now and not the \MSSQLLocalDB. It looks like the \MSSQLLocalDB only manages one project.