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

1
vote
1answer
202 views

SQL AlwaysOn auto fail over due to disk

All, I'm in the process of evaluating SQL AlwaysOn, and everything is failing over as expected, except in one circumstance, when the disk goes belly up. In this case, SQL does nothing, other than ...
0
votes
1answer
210 views

Sql Database Mirroring in a workgroup

I found an article explaining almost everything I need to know here: http://www.sqlservercentral.com/blogs/kendalvandyke/2011/12/01/database-mirroring-in-a-windows-workgroup/ The only difference ...
0
votes
1answer
572 views

User upgraded to SQL Connector 6.6.5 now gets: Authentication with old password no longer supported, use 4.1 style passwords

I have a dev user who is running queries to bugzilla via .NET code, and after updating his connector gets the error "Authentication with old password no longer supported, use 4.1 style passwords." I ...
0
votes
1answer
48 views

missing data after attach mdb

Recently, one of my customers had a server crash. Unfortunately, the 3th party who was responsible for the backup had 'forgotten' to schedule a backup of the DB (I know, I should have noticed that). ...
0
votes
0answers
41 views

Need some information about using SQL-Express 2012 with an OLD databse software

I have a friend who has managed to go for many years running their company on an old piece of software that is no longer supported. The original software vendor is no longer in business and the one ...
0
votes
2answers
296 views

SQL Server account and login permissions for NAS?

We use MS SQL server express 2008 R2 to store data for our application. Recently, we've started storing the databases on a shared NAS drive. Previously, we had the sql server "log in as" built in ...
0
votes
1answer
174 views

SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!

I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export ...
2
votes
2answers
3k views

Postgres INSERT ERROR: permission denied for schema public

In Postgres I created the following table inside a db called testing: CREATE TABLE category_google_taxonomy ( category_id integer references category ON UPDATE CASCADE ON DELETE CASCADE, ...
1
vote
1answer
444 views

MS SQL 2008 - Can I use Windows Authentication to connect from a Mac

I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good. However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
0
votes
2answers
173 views

SQL data and log files on Equallogic volumes

I've recently begun an exercise in looking into SQL best practices in terms of performance. I've read that it is recommended to put MS SQL data files (mdf) and log files (ldf) on separate volumes. ...
0
votes
1answer
191 views

Hyper-V and Windows Server with Powershell/Automated?

So my work is looking into Automating Hyper-V Servers for Test Environments, Basically in the end we want to have a sort of Web/Form interface for selecting a server spin up. Right now it's done ...
1
vote
2answers
1k views

What is a typical Compression Ratio for an SQL Database backup file? [closed]

One of my clients want us to give a safe estimate of how much disk space does a compressed SQL backup file take. They need to size their server hard disks accordingly. We can rouhgly estimate the ...
1
vote
1answer
1k views

Enable MySQL to use more than 1 core (multicore)

I am running a very intensive MySQL query and noticed that only 1 core is being used to 100% while the other cores are idle. The system is running Ubuntu 12.04 and MySQL 5.5.28 Is there a way to ...
2
votes
0answers
269 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 ...
1
vote
0answers
864 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
1answer
50 views

Backing up a mirrored SQL environment

I have 2 SQL servers in Mirror configuration. I want to backup these servers but backing up the SQL databases in Mirror state causes an error. These two mirrors also have a witness set. I would ...
2
votes
2answers
2k views

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: ...
3
votes
3answers
794 views

if I select more than 15 fields, I get catastrophic failure

Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it. When I do select * or select field1,field2,field3....field15 I am getting this error: Msg 7399, Level 16, State 1, ...
1
vote
5answers
593 views

Sharepoint High Disk I/O - WSS_Search_SBS2011.mdf

Have a low specced server I've been troubleshooting (it is above MS's minimum specifications for SBS2011) One of my next steps is disabling what I can of Sharepoint as it is not used. Here are ...
0
votes
1answer
208 views

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out ...
0
votes
0answers
2k views

phpMyAdmin gives #1040 Cannot log in to the MySQL server error after a few weeks

I am running MySQL and phpMyAdmin (under Apache) on a CentOS VPS, everything works fine, but after a few weeks services using the database start having issues and all users except for root get the ...
0
votes
2answers
164 views

Coverting MySQL SQL statements to SQL Server

I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation guide has instructions only on how to make ...
0
votes
1answer
88 views

Onboard Gigabit vs Add-in Server NIC [closed]

If you have server systems running high-end desktop PCs and a few running smaller SQL instances. The systems are time critical so the lower latency we can achieve the better. As it stands we don't ...
0
votes
2answers
144 views

SQL services wont start due to incorrect drive letter after windows restore

SQL services wont start due to incorrect drive letter after windows restore Had a server crash, was successfully able to reinstall windows and restore the server SQL and all the necessary services ...
1
vote
0answers
831 views

Windows Server 2003 ODBC Drivers

I have ran into a problem with Windows Server 2003 and SQL Server 2005 using ODBC Drivers. Here is my following scenario. I have an application that currently uses ODBC System DSN's to connect to a ...
1
vote
1answer
84 views

Apps using SQL on Hyper-V. Separate them or all on one server?

We're moving to a Hyper-V cluster with data center licensing soon, and will be able to spin up several virtual servers if needed. We have about eight applications which use SQL databases. Is there any ...
2
votes
1answer
308 views

Missing MSSQL10.SQLEXPRESS folder

I seem to be missing my C:\Program Files\Microsoft Sql SERVER\MSSQL10.SQLEXPRESS folder. I have reinstalled SQL Server 2008 and Visual Studio 2010 but still do not have it. Any ideas?
0
votes
1answer
133 views

MS SQL 2012 - Are IP's being resolved to hostnames by the SQL server?

When I check the activity monitor on the SQL server, under processes, all the hostnames are resolved to the connecting server's hostname. I'm interested to know if the SQL server is resolving the IP ...
4
votes
1answer
311 views

Ran out of disk space, how to tar without creating copy

I am at 98% of an 8GB SSD, and I have a 3 GB mysql data that I need to gzip and or tar and then download it, so then I can delete it. How can I tar or gzip the sql (or the mysql tables) so that that ...
2
votes
0answers
72 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 ...
0
votes
1answer
89 views

MS SQL Server 2008 R2 downloads for practice

I plan to download MS SQL Server 2008 R2 SP1 - Express Edition. I know I need one of the two applications to download with it: 1) SQL Server 2008 R2 Express with Tools and 2) SQL Server 2008 R2 - ...
0
votes
1answer
918 views

DB2 'The string constant beginning with…is too long' error when inserting 40000 characters to CLOB(50000) field [closed]

I have created a CLOB(50000) field in a DB2 table, and verified it has correctly created with DB2 DESCRIBE TABLE dbname ...however I received the following error message even when only attempting ...
0
votes
1answer
1k views

Can't enable 'sa' account in SQL Server 2008

I'm trying to enable 'sa' account in SQL Server 2008 through the MS SQL Server Management Studio Express. When I set the properties through the 'Properties' section of the login and click Ok, there ...
1
vote
0answers
210 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, ...
0
votes
0answers
175 views

What can cause a segmentation fault (11) in apache2 after activating ssl

Configuration is as follows: OpenSuse 12.1 minimal installation 64 bit ISPConfig 3.0.4.6 Everything runs smooth but if I activate SSL for apache2, the web server becomes unavailable. The log ...
0
votes
1answer
20 views

Error when creating Publications

Here`s a screenshot of error I get when I try to create publication .... Here's a link! What should I do? edit So now I have problem that I cant delete distributor I created, any tips?
0
votes
1answer
166 views

What is an Offloaded SQL server? [closed]

My job has pushed me far along enough to build a web app on a VPS. I've decided to go with an unmanaged KVM VPS through http://buyvm.net There are some features that I am unfamiliar with. I can not ...
0
votes
2answers
283 views

Best way to upgrade Hard Disks holding SQL Data Files?

We have an SQL 2005 Server we need to upgrade the Hard Disks on. The most efficient way I can think of to do this is the following; Run a backup using Backup Exec on the D:\ Partition (This ...
1
vote
2answers
558 views

Group By , COUNT(*) and JOIN

When running the SQL below, any placemark_types.id that doesn't have a id match in placemarks table does not return anything in the results. I'm trying to at least get a type_count of 0 back where ...
0
votes
1answer
357 views

GPO WMI username filter not working over RDP

I'm trying to write a WMI filter to prevent a GPO from applying to certain users SELECT * from Win32_ComputerSystem WHERE NOT UserName LIKE 'domain\\user1_%' AND NOT UserName LIKE 'domain\\user2_%' ...
1
vote
1answer
175 views

Failed Simple Maintenance Plan only when Full Backups do not run

Let me start off that I'm new to SQL administration and have inherited an older server that serves the main DB for our day in/out operations. So, my apologies in advanced to my beginner questions. ...
1
vote
1answer
605 views

Servers in DMZ will not communicate with each other

(Full disclosure: I rate barely above "noob" when it comes to networking.) My workplace recent got a new web server. Since we're nearing the end of an overhaul of our website, we're doing a slooooow ...
1
vote
0answers
134 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 ...
0
votes
3answers
517 views

How to update phpmyadmin on hosted website? [closed]

I have a personal home page and I decided to start a server. I use ipage.com and their phpmyadmin is an old version. How to update to the newest 3rd version? I've read documentations and the problem ...
1
vote
0answers
66 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 ...
0
votes
1answer
79 views

Delete data from a SQL Server database on a full partition

I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I ...
3
votes
2answers
543 views

sql server trusted connection with windows 8 microsoft account

We have a few developers that work, connecting in through a VPN for access to the development SQL Server 2012. Historically they've used Win7 machines and develop the website against this database in ...
-3
votes
1answer
809 views

How To Change MS SQL 2008 R2 Hostname? [closed]

I Installed MS SQL 2008 R2 Express And Plesk 11 MS SQL Hostname is ".\MSSQLSERVER2008" Right Now ! I Want Change it to "localhost" Can U Help Me ?
3
votes
2answers
79 views

Connecting to SQL server over the internet

One of my clients has a db that contains their data (this server also host an ASP.NET webshop) and they had me write a program for their client which with they can query their db. My problem is that i ...
2
votes
5answers
2k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 ...