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
256 views

Moving SQL Server 2008 R2 Logs Causing Access Denied Error

I have just tried moving the log location for the SQL server 2008 R2 logs as I have a fairly small System disk due to the massive size of the Winsxs folder, and now I am getting the following error in ...
0
votes
1answer
50 views

AuthDBDUserPWQuery with multiply tables

I have a MySQL authentication for SVN server. Configuration file looks like this: <Location /svn/project> ... AuthDBDUserPWQuery "SELECT Password FROM SVNUsers WHERE Nickname = %s" ...
0
votes
1answer
13 views

Crossserver SQL Procedures Failing Mid Process

Really need help understanding whats happening. We have two LANs at work with a shared subnet between them acting as a bridge (migration from A > B underway) we recently migrated the server subnet ...
0
votes
1answer
46 views

Sql server 2008 r2 services won't start

We lost power couple of times and I suspect that the UPS didn't keep the server on. I checked the log and it shows that there were couple unexpected shutdowns. I was try to login to sql server ...
1
vote
0answers
682 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 ...
-1
votes
2answers
167 views

Amazon RDS - UTC daylight savings

I haven't been able to get AWS support on the line and need an answer asap - do the SQL instances on Amazon Web Services RDS use daylight savings? I know the timezone is UTC but not sure if it uses ...
0
votes
0answers
59 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 ...
1
vote
1answer
174 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
0
votes
0answers
67 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
1answer
73 views

Is an HP Proliant 350e Gen8 server appropriate for Primevera and Sage applications? [duplicate]

I want to buy a server to accommodate both the Primevera and Sage applications? Would a HP Proliant 350e Gen8 do? Are there any concerns about this platform?
0
votes
0answers
210 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 ...
1
vote
0answers
109 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 ...
0
votes
0answers
46 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
1answer
192 views

CUCM Nested SQL query to link devicepool and licensing

Cisco's licensing manager has a shortcoming in that it provides licensing data per enterprise instead of per cluster. I am attempting to utilize SQL queries to produce this data. Currently, i have two ...
0
votes
1answer
36 views

SQL Server Backup to Azure Tool

I downloaded and tried the Microsoft SQL Server Backup to Azure tool for SQL Server 2008. My goal was to get access to the backup compression functionality built into it. I have it configured to ...
0
votes
1answer
71 views

Upgrade from SQL 2008 to SQL 2012: do we need to change connection string?

We are seeing some terrible performance degradation having just upgraded our MVC4 application from SQL 2008 to SQL 2012. Queries run directly in management studio on the database server run somewhat ...
0
votes
1answer
109 views

Delete files except ones created on sundays with in last 4 weeks

I have a script that copies some files around and deletes older files from destination. right now it just deletes everything older than 10 days. to increase backup retention we need to keep files that ...
0
votes
0answers
32 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 ...
-2
votes
1answer
76 views

do all type of sql server license have SA account? [duplicate]

We are trying to upgrade our sql server from 2005 to 2012. we got some offers for different type of license from some resellers. the only thing I'm not sure now is, there's one type core license with ...
0
votes
1answer
84 views

Single website across multiple servers [closed]

Please forgive me if I'm using incorrect terminology. I tried searching for my question, but I'm not quite sure how to word it in terms simple enough for a search. I found this post and this post ...
0
votes
2answers
1k views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
0
votes
1answer
288 views

Database Copy Fails, but nothing fishy in the logs

I am attempting to copy a database from a remote server (sql server 2008) to my local machine (running sql server express 2014). Everything looks great, right up until the job fails at "Execute SQL ...
0
votes
0answers
46 views

SQL Server Reporting Services 2012 Chinese Language

When running reports in SQL Server 2012 Reporting Services (SSRS), Chinese (Asian) characters show up as question marks (?). Any idea on how to have the characters display properly in reports? ...
0
votes
1answer
60 views

SQL, website and desktop application on a Windows Azure server?

I recently started considering Azure over my current VPS host PhotonVPS for Virtual Machines. I assume that Virtual Machines are the same as VPS servers (please correct me if I am wrong about that). ...
0
votes
0answers
93 views

Any other option than HTTPS + Basic auth for reverse proxied IIS site that uses double hop authentication to SQL server

We've been struggling for a while to get, what I had assumed would be a relatively common scenario to work and would appreciate any pointers. We have 2 x Windows 2012 Servers running IIS Server SQL ...
3
votes
1answer
143 views

Windows 7 WMI ODBC driver installation?

I am interested leveraging the ease of report production provided by Microsoft SQL Report Builder, but I would like WMI as an available datasource. Since SQL Report Builder relies only on SQL, I ...
0
votes
0answers
50 views

SQL Server Table Partitioning and my data lifetime management

My application stores data on Enterprise edition sql server, and I plan to take advantage of table partitioning to manage data retention. Each partition will hold a predefined period of time (say one ...
0
votes
1answer
126 views

PORT 1433 in use by LSASS.EXE, therefore cannot start SQL Server Service

Sysinternals's TCPView shows that port 1433 is used by this OpSys process, both local and remote addresses contain my FQDN, which is a Win Server 2008-R2 fully patched, has someone faced such a ...
0
votes
1answer
59 views

DBVis SQL Query - Using Date Variables

Firstly it's been a very long time since I did any SQL and even then it wasn't at a high level. I have created a SQL query which works but I want it so the date range changes automatically, for ...
2
votes
1answer
394 views

SQL server intermittent connectivity issue every 4 or 5 days

I have a .net web application that calls sql server 2008 running on a different server. From last couple of weeks, after every 4 or 5 days, web applications connectivity to sql server becomes an ...
1
vote
1answer
786 views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
1
vote
1answer
155 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
4
votes
2answers
1k views

SQL Clustering or Hyper V Clustering

We will soon be implementing our Dynamics AX installation. Our aim is to have high availability and we are working closely with our implementers. We raised the question to them about SQL and Hyper-V ...
0
votes
1answer
107 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
-4
votes
2answers
96 views

Is RAM size related to SQL performance? [closed]

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the ...
0
votes
0answers
39 views

SQL server HA when running with PCI Flash device

I want to purchase a PCI based Flash storage device for our ESXi server hosting our SQL Server machine. We use SQL Server 2008 standard edition. storage is on Netapp via NFS. It is a VM (ESXi 5.1) ...
0
votes
0answers
91 views

What's the effective way to compact sqlite3 db?

After a few delete and insert, our sqlite3 (3.7.x) was inflated from 300K to over 4MB. In firefox sqlite3 manager, we open the db and compact it. There is no size change. Then we move the db file to a ...
1
vote
2answers
149 views

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id ...
0
votes
1answer
126 views

Resell SQL Server 2008 Volume Licenses [duplicate]

This may sound like a strange question, but it's incredibly relevant to my company. If it's legit to purchase previously used VL keys for SQL Server 2008 and have them legally transferred over to us ...
0
votes
0answers
80 views

Securing and loadbalancing front-end back-end with sql inspection proxy

I am working on designing a secure way for our network to allow front-end application servers in our DMZ to communicate securely with our databases, and I can see quite clearly that normal firewalling ...
-4
votes
1answer
35 views

Does Nginx support ssh connections? [closed]

I want to build a site with nginx as HTTP server and MariaDB as SQL server. I'm searching in Google if nginx support (or its included) the ssh support to execute ssh_connect thru PHP files, but I ...
0
votes
1answer
587 views

CentOS 5.8 - The most difficult MySQL installation ever?

To install I did: yum --enablerepo=remi,remi-test install mysql mysql-server Result of the last 3 lines: Installed: mysql-server.x86_64 0:5.0.95-5.el5_9 Complete! Then I did the following: ...
0
votes
1answer
133 views

How to execute multiple SQL statements in virtualmin / mysql

Using the "Execute SQL" feature of the mysql addin for virtualmin, what is the syntax for executing multiple statements? For example if I want to do: delete from Table1; delete from Table2; I get ...
-3
votes
2answers
362 views

How do i set the default instance of Microsoft SQL Server? [closed]

I have Sql Server 2000 and Sql server 2005 installed on the Server. How do i set the default instance to 2005? On Running this script Select @@Version i get: Microsoft SQL Server 2000 - 8.00.194 ...
-1
votes
1answer
118 views

Very Slow SQL Performance on VM rinning 2003 through 2012 r2 host [closed]

I have an OLD HP proliant ML350 used as HYBERv Host (win server 2012 - 16 GB RAM , 3x146 GB SAS , one processor). i have a VM (win-server 2003 32bit + sql server 2000) , every thing is working fine ...
0
votes
1answer
78 views

Cannot create MS MDT Database on SQL 2012 Express

I am trying to create a new SQL Server 2012 Express database via MDT 2013. When I did that I got the error above. I have completely rebuilt the server yet this error persists. Now when right-click on ...
0
votes
2answers
3k views

Offline database can't be restored: Exclusive access could not be obtained

I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly ...
1
vote
1answer
30 views

SQL Server 2008 - Difference between server and database permissions

And I think I'm almost there conceptually. I think I just need a few example/confirmations to bring it home. 1) My understanding is that server permissions ...
2
votes
1answer
122 views

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a ...
1
vote
1answer
237 views

SQL error log can't create/write to file

I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :) I'm running WordPress on a developer ...