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
votes
1answer
342 views

SQL Server 2012 - No connection could be made because the target machine actively refused it

I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked. I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL ...
0
votes
3answers
54 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
0answers
58 views

Tips on Copying 3 Database files nearing 250 GB?

We are upgrading from SQL Workgroup 2005 to SQL Standard 2012. We have plenty of databases of smaller sizes that copied over with straight windows file copy in a reasonable time frame. We have one ...
0
votes
1answer
45 views

Need to DROP TABLE from 100s of SQL backup files

I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command ...
0
votes
2answers
76 views

Upgraded SQL server, performance plummets

Seeking help with a new SQL server. A client of mine was running an aging SBS 2003 server (Xeon 3060, 4 gig of RAM) and a line of business application with a 25 gig SQL Database using SQL Server ...
0
votes
1answer
49 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
1answer
106 views

Sql server 2008 R2 using Half of the memory [closed]

i built a new 2 cpu 8 core 40 gb ram Server for our ERP software which use Sql server 2008 R2 on Win server 2008 standart R2, in Sql There are 7 databases, 2 of them for Tests, 2 of them to keep ...
1
vote
1answer
24 views

Migrating from SQL 2008 to SQl express on the same VM

I have a windows 2008 r2 VM running SQL std 2008. I want to migrate my database from SQL server to SQL express which is a free product. Since I have one VM, I plan to install SQL express alongside SQL ...
0
votes
2answers
47 views

Export import sql database without downloading

Recently i need to change my server to another webhosting providers server. To do that just discovered that my MySQL database size is too much to download & upload with the access that I have. ...
1
vote
1answer
192 views

Plesk MS SQL Data backup restore issue

I am tiring to restore mssql backup in plesk but it showing following error please give me suggestions. Error: dbbackup failed: Unable to restore database 'admin_db' Not valid backup Cannot open ...
0
votes
1answer
46 views

SQL Server Setup RAID 5, RAID 10

I am new to setting up SQL Servers and Vms. My predecessor used Raid 5 for C Drive where the SQL installation resided and RAID 10 for both database files and database logs. I was wondering whether ...
2
votes
1answer
117 views

Does changing a Service from Automatic to Manual mean that it is unable to be started by other services/applications?

Morning all. We have a script that checks for services that are set to Automatic, but not running. It alerts us if this is the case. We've got a couple of services, like SQL Server Active Directory ...
0
votes
1answer
38 views

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. ...
0
votes
1answer
190 views

SQL Error When Running My “Find All Unused Packages” in SCCM 2007 Report Console

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I ...
0
votes
1answer
34 views

Remote servers replicating data to a Master server for reporting

I have Windows servers that are running SQL Server 200(5/8) in many remote locations on the east coast. At our corporate office, we are trying to set up a reporting server that can get as real-time as ...
1
vote
0answers
80 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 ...
0
votes
3answers
74 views

How to connect to ms sql express?

I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
0
votes
0answers
75 views

SQL failover cluster on single ESXi host

I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
0
votes
2answers
493 views

SQL Server does not exist or access denied on a local machine

I have the following exception when trying to open a connection to the server since last week. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I'm using MSSQL ...
0
votes
1answer
103 views

Compare two values in a single column SQL Server [closed]

I have a SQL Server database in which I ran a query that collects the data about two different tournamnets and the number of people enrolled in the tournament. So for instance the output is: Name of ...
1
vote
1answer
134 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
111 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
501 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
46 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
37 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
184 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
105 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 ...
1
vote
2answers
2k 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, ...
0
votes
1answer
252 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
133 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
141 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 ...
0
votes
2answers
678 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
654 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
153 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
386 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
44 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
976 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
509 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
326 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
135 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
1k 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
123 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
85 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
120 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
540 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
80 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
176 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
107 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
281 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
66 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 ...