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

3
votes
0answers
32 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 ...
2
votes
0answers
34 views

backup compression ratio in SQL 2012 worse than in SQL 2008

We have SQL 2008 Enterprise with TDE enabled and upgraded to SQL 2012 with TDE still enabled. Everything works fine except that I am getting worse backup compression than in SQL 2008. I do ...
2
votes
0answers
982 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
308 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
76 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
41 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 ...
1
vote
0answers
19 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. ...
1
vote
0answers
681 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
126 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 ...
1
vote
0answers
141 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
86 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
1k 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
225 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
138 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
68 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
9k 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
113 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
264 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
48 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
156 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
2k 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
461 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
162 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
684 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
4 views

SSRS Report fails with conversion error but runs fine in ssms?

I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then ...
0
votes
0answers
18 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
0
votes
0answers
9 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...
0
votes
0answers
16 views

MSSQL 2005 - Server Service unable to start while installing

I am trying to install MSSQL 2005 Express on an VM running Windows Server 2012. I get to the point where it installs everything but fails to start the service. I have tried checking the Log-On ...
0
votes
0answers
5 views

SQL alwaysON and WSFC

I have a WSFC configured on 2 (hardware)nodes with SQL AlwaysOn group. The problem is, if the node Where I have created the cluster goes down the cluster is not available for second node and here ...
0
votes
0answers
23 views

SQL 2014 Collation Policy job failing

I have setup a new SQL 2014 server and created a policy to make sure all DBs have the same collation. I created a DB names test and gave ##MS_PolicyTsqlExecutionLogin## permission to it and all ...
0
votes
0answers
36 views

Cisco CallManager AXL SQL Toolkit - Retrieve directory number and user ID

I have the below SQL query to retrieve the list of userid and their telephonenumber using Cisco CallManager AXL SQL Toolkit: sql query="select d.name as deviceName, e.userid, e.telephonenumber from ...
0
votes
0answers
17 views

SQL 2012 IPSec or SSL

I have a requirement to secure connections to SQL server. (at transit that is) - TDE will be used for encryption at rest. SQL provides two options which are either certificate based SSL or Windows ...
0
votes
0answers
164 views

MySQL unable to repair, dump, upgrade table (simply crashes)

I need to backup one of my databases from MySQL (Running MariaDB). The issue is that aside from all of my other databases that backup perfectly fine, this database has issues backing up and crashes ...
0
votes
0answers
31 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 ...
0
votes
0answers
34 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
0answers
40 views

Can't connect our ERP Database to MSSQL Server 2005

We have a Windows Server 2003 R2 using SQL Server 2005 Within the server are Two Lan Workgroup (IP Add 192.168.1.33 and 192.168.2.33) Neither IP has a problem connecting to the Server, their ping is ...
0
votes
0answers
58 views

First steps in distributed cache and application

Background: We provide a client with a single server to which we provide a data dashboard site (ASP.NET/IIS7) feeding multiple MSSQL databases (OS: Windows Server 2012 / SQL: MSSQL 2008R2). One of the ...
0
votes
0answers
25 views

denydatawriter role on Azure SQL

I'm trying to create a read-only user on an Azure sql instance. I've got the login and the user, and I execute the sp_addrolemember procedure which should set the db_denydatawriter role for the login ...
0
votes
0answers
52 views

SQL Listener on Azure can't connect

I'm having an issue trying to create an SQL listener on a VM hosted in Azure. I have followed the instructions from MS on this link and everything seemed to go through fine. The listener created ...
0
votes
0answers
16 views

Migrating from SQL 2008 to SQL 2012 but cannot connect to the database

We are now migrating from a SQL 2008 to a SQL 2012 server. I am testing the databases one at a time as these are live databases. I have backed the database up and then restored this onto the new ...
0
votes
0answers
93 views

Overactive SQL Injection Attack Firewall Rules

We have a web app that our client's employees use to submit signatures from customers using HTML5 canvas to create PNG images. The signature pad is converted to base64 encoded HTTP POST data. Our ...
0
votes
0answers
200 views

SQL Server Agent shutting down minute after starting

I'm a noob :) to SQL , so please don't judge me to harsh When I start SQL Server Agent it's shutting down minute after starting . I tried to set Alerts to send email. After I configured Database Mail ...
0
votes
0answers
93 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
0
votes
0answers
61 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
0
votes
0answers
76 views

Network Issues Connection to SQL database on MS server

Prior to asking this question, I followed this thread: Cannot telnet to SQL Server on port 1433 I am attempting to connect to a database on a server distinct from the computer upon which I am ...
0
votes
0answers
236 views

SQL VSS Writer missing from VSSADMIN

We just installed the latest updates for patch Tuesday onto our AD FS 2.0 farm members. Everything went fine except for one of them, after the updates were installed and I rebooted the server, the ...
0
votes
0answers
84 views

MySQL character-set-server won't take effect

I'm trying to have my MySQL server use UTF8 as the default collation and character set. I am able to set everything except for the character_set_server which always takes 'latin1' as value. I have ...
0
votes
0answers
53 views

SQL Server Management Studio Import Wizard

I am trying to import a small excel spreadsheet into SQL using the SQL Server Management Studio Import Wizard, which is running on the Windows server (2008 R2) itself. When clicking "Import Data" from ...
0
votes
0answers
76 views

MySQL, Table marked as crashed after vServer reboot

i am using a vServer in a data storage center. Sometimes the host machine is rebooted by data center admins which causes the vServer to be rebooted too. After every reboot the database crashes, the ...
0
votes
0answers
34 views

After upgrading to TFS 2012 is it safe to uninstall “Microsoft Team Foundation Server 2010 Sharepoint Configure”

After upgrading TFS from 2010 to 2012, I find that in Add/Remove Programs, there is till this software listed: Microsoft Team Foundation Server 2010 SharePoint Configure Also, I still see the ...