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. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

4
votes
0answers
166 views

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version ...
3
votes
0answers
245 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
3
votes
0answers
43 views

SQL & BITS Errors on prereq for SCCM 2012

Hey anyone that can help, I've been stumped by this problem for a while now and I've no idea what to do. I've installed SQL 2008 to run with SCCM '12. I've set Log On As a domain account with ...
2
votes
0answers
54 views

After move SQL isn't releasing memory for queries

We recently made a move from one VM hosting environment to another. The machine we moved is a clone so all settings are identical pre- and post-move. However in our new environment our SQL server is ...
2
votes
0answers
430 views

Understanding & Resolving Web Server Exploits

We recently had someone contact our company pointing out that we had numerous security threats that could be used to exploit our systems. They were nice enough to provide a list of these to which we ...
2
votes
0answers
3k views

Intermittent Error SQL Server Error 67 and 17

We are running Windows SQL Server 2012 Standard on Windows Server 2012. There is a SQL Database with an Access Front End which we migrated from older versions of Access and SQL. The Access front end ...
2
votes
0answers
638 views

Restricting access through ODBC to only schema views SQL 2008

I'm pretty green to SQL security, so maybe someone can help me. We've got a database application that, when installed, by default grants the public role access to all the tables in the database. When ...
2
votes
0answers
90 views

Restricted LDAP mimic server backed on SQL

I may not be an expert on the subject, but it seems to me that 99% of any LDAP server installation is used only to provide user authentication credentials and nothing more. Given this restricted ...
2
votes
0answers
51 views

SQL Replication cannot access file

When setting up a subscriber it fails on the first sync with the message The process could not read file <file-name> due to OS error 2 I have tried setting the security rights for the ...
2
votes
0answers
23k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
1
vote
0answers
16 views

Is it possible to see who disabled a SQL backup job?

I'm looking to see if it's possible to audit who disabled a SQL backup job in Microsoft SQL 2008's SSMS on Windows Server 2008 R2. We have a couple admins and I'm attempting to pin point who disabled ...
1
vote
0answers
25 views

How can I list the privileges associated to a custom created role in SQL Azure database?

I have created a custom role in a SQL Azure DB, granting a couple of privileges. How can I, at a later time, list the privileges associated to this custom role? We need this for an audit on the DB ...
1
vote
0answers
24 views

Alias with all users in mysql table for postfix/dovecot

I have a table with users for my mail server. This table for imap authenfication in dovecot: +-------------+------------------+-------------------+------------------+------+------+--------------------...
1
vote
0answers
13 views

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 ...
1
vote
0answers
10 views

Hadoop Hive, Impala, Pig, and more — SQL access to Hadoop?

It appears that Hive, Impala, Pig, and others all provide SQL or SQL-like access to data stored on Hadoop clusters. They all seem to have support for HDFS, S3, and other forms. So why are there so ...
1
vote
0answers
13 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...
1
vote
0answers
44 views

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is ...
1
vote
0answers
124 views

Error when viewing database mirroring monitor in SQL Server with non-default port

I have database mirroring set up (with witness) on SQL Server 2014 Standard. Both servers use default instance on a non-default port (not 1433). Mirroring works perfectly fine. However, when I try to ...
1
vote
0answers
98 views

MSSQL application failing to connect to database server

We run a very old application that connects to an MS SQL server 2008 database using the SQL server native client 10. Sometimes if there has been a power failure with the server the clients will stop ...
1
vote
0answers
41 views

X3250 Server: stuck at firmware screen

The server is initialize, then it is stuck at the IBM System X Server Firmware screen (before F1, F12 appears, etc). You can see in the attached image. https://www.ibm.com/developerworks/community/...
1
vote
0answers
128 views

No messages received on Queue after Failover in SQL Always On

We have an Application, which uses Service Broker to receive notifications from the SQL Server. The application works fine when we don’t have SQL Always On enabled, and when we are interacting with a ...
1
vote
0answers
2k views

The target principal name is incorrect. Cannot generate SSPI context

One of our applications (Running on Server 2008 R2) uses a domain service account to connect to our SQL 2005 database (also running on Server 2008 R2). On occasion, when the application attempts to ...
1
vote
0answers
377 views

How can I unlock a large amount of files on isilon storage if a process had them open?

Some background information : I have a couple SQL servers that have half their databases on isilon storage (I know, no bueno. I'm in the process of moving them). During the night one of those SQL ...
1
vote
0answers
98 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
1
vote
0answers
2k views

SQL Server Replication Requires the actual server name

How Hard can it be? Ive spent the last 4 hours googling just to find either nothing works, or people randomly posting information that 'sounds good' My setup: Two SQL2012 Servers, in two different ...
1
vote
0answers
268 views

SQL 2008 fail-over cluster---specified credentials for the SQL Server service are not valid

We had Two Node SQL 2008 fail-over cluster. Last week one node was crashed, so we decided to re-build the passive Node(crashed Node), we reinstalled the OS and added to windows cluster successfully, ...
1
vote
0answers
158 views

Kerberos: connection from win app running from IIS to SQL failed

I have an IIS web-application with Windows authentication and impersonation. This application connects to SQL server. In this case Kerberos works fine. But there is a problem. Web-application runs ...
1
vote
0answers
73 views

No remote access to PostgreSQL db

i'm stuck in connecting to a PostresSQL database from remote host. The server is accepting incoming connections on port 5432 and i've configured pg_hba.conf like this: local all all ...
1
vote
0answers
196 views

SQuirreL Client: Opening up a table in a separate tab

I've switched to SQuirrel Client to view an Oracle database with a variety of tables. At any given time, I need to look at the contents of several related tables at the same time. The problem is ...
1
vote
0answers
317 views

SQL 2005 to SQL 2000 Linked Server Update Error

I have a linked server from a 2005 instance to a 2000 instance that I am getting an error when trying to do an Update accross the linked server. This Update has worked for the past 2 years without ...
1
vote
0answers
54 views

How to make OPENXML call set based

I have a table that stores a name | value pair, which I'm trying to load from a column stored as XML. The only way that I have found to shred the id and value from the XML document is to create a ...
1
vote
0answers
173 views

Trying to connect to sql server on ec2

I moved from my home office to an office in midtown. I can't figure out how to connect to my sql server hosted on Amazon. I'm using the exact same VmWare image just on a machine in the office. I can ...
1
vote
0answers
3k views

Unable to authenticate proxy when starting SQL snapshot agent

I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied, I have restored a database from an old image (SQL 2005) and am trying to get web-sync ...
1
vote
0answers
568 views

Switched Oracle to use Shared Servers, now Java app throws SQLRecoverableExceptions

This issue might blur the line between Java and database problem, so I apologize if this is the wrong place for it. Not sure which side is to blame yet. I'm a Java developer temporarily playing DBA ...
1
vote
0answers
172 views

SQL server periodically gets disconnected

Our environment is: Windows Server 2003, Service Pack 2 SQL Server Express 2005 SQLServer JDBC driver 1.2 (also tried Jtds) Sun JDK 1.6 (we tried this on JDK 1.5 as well) There is no virus protection ...
1
vote
0answers
879 views

How can I uninstall a clustered SQL instance if the cluster has been destroyed?

First time going through this scenario, and apparently I did it very wrong. On the DB servers I deleted the cluster group that held SQL and Reporting Services. I then destroyed the cluster. Then I ...
0
votes
0answers
13 views

WMI10 Report server error followed by SQL Server Reporting Services error

Anyone have any idea how to overcome those issue? Inside my Event View, I found those error lists which I need to resolve in order to successfully run my SQL reporting service. reportserver (WMI10) ...
0
votes
0answers
24 views

SCCM - Find when an application deployed to a specific computer

Is it possible to find when SCCM ran a deployment against a specific client PC, from the server? (CAS, primary or even secondary will do so long as I can script through to the data starting with only ...
0
votes
0answers
6 views

SQL Server 2014 High CPU

When finding out which DB is most CPU Consuming I get the database with ID 32767 (internal resources database) on top of CPU, 88% to be precise. How can I check why is this happening? Thank you
0
votes
0answers
9 views

Convert into multiple data ranges

I have employee data link below This is one example in the file a have multiple lines. Initial input can have more than 2 lines for each employee but convert logic will be the same. Thank you ...
0
votes
0answers
13 views

Where are stored phpMyAdmin SQL import files?

When a data file (SQL, CSV, XML…) is imported with phpMyAdmin, is it in volatile or non-volatile memory? If it stored on hard disk, is it temporary? When the file is deleted and what is the default ...
0
votes
0answers
33 views

missing components on SQL server 2016 installation

I'm trying to install SQL Server 2016 (Developer or Evaluation edition) to get familiar with it as I have not used it for several years. Downloaded SQL Server Developer from Visual Studio Dev ...
0
votes
0answers
16 views

AWS Windows SQL EC2/EBS application consistent snapshot

Has anyone found a way to take a EBS snapshot for a Windows Server that maintains Application Consistency? In my case it's with SQL and I'd like to maintain SQL app consistency. Either via quiescing ...
0
votes
0answers
12 views

SQL Event Notifications to Remote Server

I have event notifications for SQL and I currently have them writing to a another DB on the same database server. Is there a way to have it write to a remote DB on another DB server? My goal is to ...
0
votes
0answers
18 views

Strange Postgres PreparedStatement behaviour (JDBC)

i have a strange problem with the following parameterized PreparedStatement in Java: PreparedStatement ps=DBUtil.newPreparedStatement( "SELECT * FROM msg as m WHERE " + ...
0
votes
0answers
14 views

SQL Sending Maintenance Plan Notification WITH the actual error message

For some time, we searched for a solution to provide details from a failed SQL Maintenance plan to the IT Support team, who were responsible for the services being scheduled; trying to escape the ...
0
votes
0answers
243 views

SQL Server 2016 RC2 and RC3 Install ERROR (Pictures and logs provided)

Can't install, updated Windows Server 2012 R2 fully with all Optional and Important Updates. I enabled a proxy to gain outside access which works (since Windows updates work). There is no anti-virus ...
0
votes
0answers
29 views

Setting up Active Directory, Adding Machines with Different OSes & adding a server with an instance of SQL

I have 2 servers to manage at work, a Dell Poweredge with has a software called "Abecas" which uses SQL Server, The Poweredge is running Win Server 2008, there is no AD in place as of yet. I have ...
0
votes
0answers
42 views

MS SQL - HA & load balancing best solution for servers at different geo-location

Customers has App server (MS Server 2012) and Storage server (MS SQL 2012), with several hundred clients accessing server app via VPN. Now they want to have a high-availability and also load ...
0
votes
0answers
12 views

SQL request in Bacula database

I would like to get all the files that are at least in one job which is now saved on one determined tape in the Bacula database. This could replace a tape listing. I have tried several request to ...