Questions tagged as ['sql-server']
I'm using SQL Server 2016 dev edition and have one question.
When I tried to "Object Explorer -> Management -> Maintenance Plans -> double click one full backup plan -> double click subplan -> trying to see list of database on selection box" => got an error message in some cases(system said it can't be shown, "This task requires the connection to be initialized").
It's not the prob ...
I tried to create a new local publication on SSMS. It errored out and I figured I could just try again. I think it said something like there were no databases setup for transactional publications?
Now when I right click Local Publications on SSMS, and click New Publication, I get this error:
10.13.14.8 must be enabled as a Publisher before you can create a publication. In the following dialog box, ena ...
I have a SQL Server 2019 instance installed on Server 2019. A CA Cert is in the server and the SQL server is forcing SSL using that Certificate. I am able to login to the SQL server with the Management Studio using the connection information SERVER.DOMAIN.COM\DATABASE. The certificate uses the FQDN to secure the connection.
I am trying to access the SQL Server database from a client on the same n ...
In a coming update, I will need to convert multiple tables in our server from UTF-16 to UTF-8. I expect this will take multiple hours.
Is there a good way to turn off INSERTS and UPDATES, but still allow SELECTS in the database?
Or do I need to block changes at the business level / turn off the database while the update is happening?
I am running SQL Server on Windows and using Link Server to connect to a second SQL Server instance. The second SQL Server is managed by a different company and the instance requires me to use Windows Authentication to connect. I did this by adding the user in Windows Credential Manager and it connected without issue.
Recently I switched to SQL Server on Linux. I am trying to reconnect Link Serve ...
I am new at Linux OS but successfully installed apache, PHPMyAdmin, and MariaDB.
All works fine, but I have an issue and am not able to resolve it. My issue is establishing a connection to the SQL Express server which runs on WIndows machine on the same network. My script to sql ex
I was working with Windows environment with XAMPP installed I had no issues drivers for SQL express server were working ...
I have an AlwaysOn cluster of SQL Server 2019, containing an Availability Group of 3 replicas in Synchronous mode. According to Microsoft documentation:
- The secondary replica hardens the log and returns an acknowledgement to the primary replica.
- On receiving the confirmation from the secondary replica, the primary replica finishes the commit processing and sends a confirmation message to the client.
I have an asp.net core web api that run an 404 after it get's deployed to elastic beanstalk. Any version from 1.0 to 5.0 all show the same error 404.
The api works just fine on localhost but once it get uploded to elasticbeanstalk. It dosn't show anything.
Here is the full error.
This aspnetcoretoelasticbeanstalk-dev.us-east-1.elasticbeanstalk.com page can’t be foundNo webpage was found for the web add ...
I am not a DBA so I am not well versed on the intricacies, considerations, potential issues with in-place upgrading just the OS of an existing SQL Server.
A client has several stand-alone SQL Server 2012 servers on Windows Server 2012 R2. Their current mandate is to upgrade their server OSes to Windows 2016 or 2019.
In place upgrades of the OS is straight forward enough but are there any special co ...
One of the users already has all the OBDC connections configured on to the RDC user account. That machine is used to connect to all the databases.
A new user on boards into the organization, his log in account is created on the same machine. This time the new user is being provided with an ODBC reg file, the ODBC reg file is an export from the initial user.
The ODBC file contains connection details ...
I need to export the data that I have in a Google Cloud SQL Server database to BigQuery in order to make some data analysis and reporting. I found that the recommended way to do that is using BigQuery Cloud SQL federated query but this doesn't support SQL Server database, only MySql and Postgres in Google Cloud SQL service.
I'm looking for a way to do that with the Google Cloud resources, maybe a ...
So is it possible to use basic authentification to perform a sql ...
There is a database we use for archiving old data which I want to be 'serverless' so that it only fires up when we make a query.
I changed the size from standard to serverless without issues. I have not connected to this DB since making the change.
However it doesn't pause despite setting the auto-pause to 1 hour.
Looking in Query Performance Insight, I can see there is a query which regularly polls th ...
source: SQL Server 10.50.x
destination: SQL Server 11.x (Not SQL Express. It was installed with en_sql_server_2012_standard_edition_with_service_pack_4_x64_dvd_100075944.iso) I'm afraid I don't know much about modern MS SQL Server. I am trying to migrate from one machine to another and it looks like I need to import the maintenance plan. I found instructions that said to use SQL Server Management St ...
I trying to find out if SQL Server 2016 and 2019 Web Edition supports encryption (on AWS)?
any help will be appreciated.
Thank you, Moshe
I'm having troubles with an EC2 server
I need to connect with an external SQL server that has whitelisted an elastic IP attached to the instance. All the security rules and routes are set in the most permissive way. However, the outbounding traffic from my EC2 seems to have another IP.
sqlcmd -S <SQLServerIP> -U <User> -P Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Lo ...