Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql]

Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [mysql], [postgres], [mssql], or [oracle].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
0
votes
2 answers

sql server password reset

I have deleted my windows account on wich I had installed sql server 2008 express. Now I can not perform any operation with my sql server including adding new user. Pleas sombody help me.
Alex James
0
votes
2 answers

Import database: SQL Server 2005 Express to SQL Server 2008 Enterprise

I have two servers 1 x SQL Server 2005 Express and 1 x SQL Server 2008 Enterprise How can I move/import my database from SQL Server 2005 Express to SQL Server 2008 Enterprise? (BACKUP SQL SERVER 2005 and RESTORE to SQL Server 2008, would that work?)
001
  • 491
  • 1
  • 11
  • 21
0
votes
2 answers

Severe Memory Pressure on SSAS 2008 on Windows Server 2008

I have a single instance of SQL Server 2008 Analysis Services running on Windows Server 2008 x64 with 8GB of RAM on the server. All of the settings for memory are left to their defaults. When the SSAS service starts, it behaves normally. However,…
Brian Knight
  • 1,175
  • 2
  • 8
  • 17
0
votes
2 answers

Cannot login to SQL with active directory or SQL authentication

Im installing SQL reporting services. After installation, the databases was created correctly and have the user permissions assigned. A login domain\reportaccount is also created. The problem is when i try to connect from visual studio, i want use…
RAN55
  • 1
  • 2
0
votes
0 answers

SQL DB failing to send server email - intermittent

Recently, we noticed an issue in SASS 2014 logs regarding the failure of some emails to send: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2023-06-29T11:20:17). Exception Message:…
Gytis Varnelis
  • 1
0
votes
0 answers

could not load private key asn.1 decoding failure Navicat

I have a Problem with my Navicat when i want to connect with a SSh-Key to our Company Servers i cant because Navicat give the folloing Error: could not load private key asn.1 decoding failure Has anyone an Idea what is going on?
Marvin Fratzke
  • 1
  • 1
0
votes
0 answers

Getting an error in SQL Server 2019: The certificate chain was issued by an authority that is not trusted

I've enabled "Encrypt connection" I've enabled "Trust server certificate" I've added the TrustServerCertificate=true to my connection string I've confirmed the service is running - there is another service called "SQL Server Agent" that refuses to…
Shanebagel
  • 1
0
votes
0 answers

SSMS 19 issue with AWS RDS

still pretty new to SQL administration so please bear with me. We recently updated to SQL Server Management Studio 19 and have been running into issues. The long and short of it is I am trying to get our custom DNS for our Databases functioning on…
Daniel W.
  • 1
0
votes
0 answers

InfluxDB influxQL v1.8 : Wrong timestamp used for writing to database

I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a systemd-timer. That's a pretty nice working workaround for the…
6a5h4
  • 1
  • 1
0
votes
0 answers

Configure xenforo 1.2.9 Using phpmyadmin 4.x with php 5.6.4 on IIS 10, Windows Server 2019

Versions/Programs: xenforo 1.2.9, phpmyadmin 4.x, php 5.6.4, MySQL 8.0.32 IIS 10, Windows Server 2019 I am trying to host a local server for tinkering on an old computer I have. This server will be hosting a XenForo installation. However, my xenforo…
Fictor
  • 1
0
votes
0 answers

CantStartEngineError: No sql_connection parameter is established

I have been trying to install openstack on centos7 but while building it gives error as "CantStartEngineError: No sql_connection parameter is established". The command I am using to build is "packastack --allinone"
Nimisha Mohapatra
  • 1
0
votes
0 answers

SQL always on cluster on RODC Environment

We are setting up an branch office which has couple of apps and DB servers, and RODC for authentication. we need to configure SQL always on cluster in that branch office. I have done it for RWDC but never done this set up in RODC Environment. I…
karthick
  • 327
  • 1
  • 4
  • 12
0
votes
1 answer

Secure SQL Server and other traffic with end to end security

All, I am wondering if there are any best practices or ways that I can open up secure access to a service such as (for example) SQL Server, or any other program normally requiring a port to be opened and whitelisted? I have a non-production…
billsecond
  • 199
  • 9
0
votes
0 answers

WSB Not Working

Trying to get WSB working on a server running SQL. The current setup is this. Server OS is 2019 Backup target is an iSCSI target configured on a NAS, its setup as a local drive on the server Backups are configured to be sent to this drive nightly.…
mrlizard
  • 71
  • 1
  • 2
0
votes
0 answers

SQL Server Logical Reads increased 10x in past week

I'm not an SQL DBA by any serious standard but I am trying to figure out why the logical reads have gone bonkers on a DB I have for a line of business app. the image below shows a 10 x increase in logical reads? what could be causing that? Feel free…
GKOS
  • 1
1 2 3
…
85 86