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. (p
i have completely installed visual studio community 2022 with data processing tools but when i want to add services based database and sql based database in my Asp.net and Window form project it does not allowed to create mdf file it gives the following…
Execution Context for MS Access front end to SQL Server backend
Hello, we have a business application that is based on MS Access front end and SQL Server backend. Tables are linked via DNS-less connection. The application is using SQL Server Authentication using an ODBC connection, driver is SQL Server (connection…
Microsoft sql studio - dark mode enabling.
do we have a dark mode on Microsoft SQL Server Management Studio ?, of so, can anyone help me on how to get that enabled.
Cannot install SSIS, no Visual Instance Studio found
I have Visual Studio 2022, Visual Studio 2017, SSMS 19 installed on my machine, but when I go to install SSIS no instance of VS is found.
Locking comparison SQL Server 2017 versus SQL Server 2022
We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…
Please wait for the user profile service problem
As, i am using sql server 2019 in windows server 2019, while login it got stuck in Please wait for the user profile service and please wait for the profsvc. As i cannot connet my server to internet due to security protocols. This problem happen each day…
OLEDB varchar max not working
Having issues with OLEDB when writing a SQL Query that compares value with VARCHAR(MAX) column for inclusion. I'm wondering if the way that OLEDB connects to a database causes the issue or if it's the adapter itself. Edit: The query below by example…
SQL Patches KB5035434 installation failure - Failed to retrieve data for this request
When install SQL Server 2019 RTM GDR patches (KB5035434), I've got below error, anyone could help, thanks! Overall summary: Final result: The patch installer has failed to update the shared features. To determine the reason for…
Is it Possible or is there a way to use the database you have been working on the developer option for production?
Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…
EDI cross reference table
Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?
Migrate On prem to Azure Sql Managed instance
I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance. I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without…
Unable to install SQL Server (setup.exe). Exit code 2147467259
Are you able to provide some guidance on how I can install SQL to my laptop? I also tried custom setup and got another error (Also asked). But if I go through basic setup, this is the error. Please find attached: Detail.txt
how to fix an ERROR 500 on SSRS 2019 Enterprise edition
The Microsoft Web SSRS portal have Error 500 time to time. sometimes we have the following error: The report execution 1kowwtmibuga4m45d4wt55ai has expired or cannot be found. (rsExecutionNotFound). The SSRS is installed on Windows server 2022…
Upgrade OS and SQLServer to 2019
Any issues while upgrading both OS from 2012 to 2019 and SQLserver from 2014 to 2019? We would like to proceed with inplace upgrade. How long does it typically take to upgrade SQLserver
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
Sql Server cluster on K8S
Hi all, I am learning about deploying sql server on k8s. I have read documents as below: https://pradeepl.com/blog/kubernetes/deploying-sql-server-on-kubernetes/…
How to check SSRS version by querying database?
Hello, Is there a way to query SSRS version currently installed using TSQL? In sql server 2019 there is a table 'ProductInfoHistory' and it looks like it keeps the history but I have noticed that it is not consistent and I do not see it updated when I…
VS 2022 ReportViewer Error: "The report cannot be displayed. The report viewer could not find a report definition."
Please help me with this problem I'm having. I'll start by explaining my problem: I need to load reports, and for that I'm using the native reports of VS 2022. Here's what I've done so far: I created my .xsd file called DataSetInformes.xsd I added my…
Error Installing Application on Another Computer: Invalid Connection String
Good evening dear community, I am bringing up my problem again since I have not been able to find a solution. To the point: I created a small application with a single Windows Forms form. It has its own connection string to the database and an example…
How to audit instance changes and Profiler usage?
Greetings. I have a vendor with unlimited access to our most important SQL box, and that's not about to change. The best I can do here is track whatever they do. I've already got some tools in place for DB changes, as well as user/ login modifications.…