Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
-2
votes
0answers
30 views
Installing SQL Server 2008 R2 in VM [on hold]
I am trying to install SQL Server 2008 R2 in a VM. Although I see "SQL Server 2008 R2 Setup" in Add / Remove Programs (after install), it has not created a server instance.
I have Windows 7 ...
0
votes
1answer
13 views
Need to install Oracle Express 11g Release 2 on a Windows 7 64-bit laptop
I need the Oracle 11g Release 2 sample schemas (HR, OE, etc.) in order to do most of the available online tutorials. I was hoping to install Oracle Express Edition on my Windows 7 laptop to get ...
0
votes
1answer
28 views
export (mysqldump) databases from MySQL version 4.0?
Goal: export the schema and data from a MySQL version 4.0.16 DB.
Background:
I was asked to migrate a database from MySQL version 4.0.16. The database was installed on a Windows XP machine, and I ...
0
votes
0answers
18 views
Oracle XE 11g on Windows 7 64bits
I have a problem with Oracle XE 11g on Windows 7 64.
I know that a lot of people have the same problem but I did'nt find a solution for my case.
In sqlnet.ora:
with SQLNET.AUTHENTICATION_SERVICES = ...
0
votes
1answer
24 views
MySQL Cluster Setup for WAN on Windows
I would like to know whether replication or clustering for MySQL is it possible over a WAN environment?
For example
Site A and Site B are both at different remote place.
Both have MySQL installed.
...
0
votes
4answers
49 views
How do I backup a database from MySQL 32-bit and restore it to MySQL 64-bit?
I'm currently using MySQL version 5.0.16, on my local computer (which runs a 32-bit OS), for easier access while developing my program.
Now that I'm ready to deploy my program, I'd like to test the ...
12
votes
1answer
247 views
“Access is denied” when connecting SSMS to Integration Services
I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name:
Connecting to Integration Services service on the ...
0
votes
0answers
61 views
PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”
I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
2
votes
1answer
105 views
How to restore IBM DB2 database from AIX to Windows?
I had made backup from remote IBM DB2 server in AIX using this command:
./db2 backup database DBEMP to /home/dbemp/backup
Then I grab the backup file using FTP Client from my Windows.
I run this ...
0
votes
0answers
37 views
Performance of large queries on low bandwidth connections
I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
0
votes
0answers
28 views
mysqlnd: same mysql server and php version, can't connect from Windows
(This question is also in StackOverflow http://stackoverflow.com/questions/16575994/mysqlnd-same-mysql-server-and-php-version-cant-connect-from-windows)
I'm migrating mysql functions to mysqli. As ...
2
votes
1answer
114 views
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth?
Some background first:
The problem described below wouldn't exist at all if the database in question would have been built with a DBA's mindset:
Data access only through views and stored procs --> ...
0
votes
0answers
17 views
Authenticate Oracle Database with Active Directory Users [duplicate]
I'm trying to connect to Oracle Database 11gR2 with the users from Active Directory. I'm looking at some resources/guidance on how to go about doing this successfully.
The link Map Oracle Roles to ...
1
vote
1answer
45 views
Restrict access for Windows administrator in PostgreSQL
Is there a way to protect PostgreSQL from user with Windows administrator rights?
Like this question but for Postgres.
1
vote
1answer
63 views
Table corruption: How to perform Innodb Checksum checks in MySQL 5.5 for Windows?
Having a corrupted Mysql 5.5.31 (Windows) database, my question relates to the the top solution provided in How do you identify InnoDB table corruption? , more precisely to the following script that ...
2
votes
2answers
89 views
Changing PostgreSQL port using command line
My PostgreSQL default port is 5432, I want to change default port by using command line (in Windows 7).
I saw this solution before: http://stackoverflow.com/questions/187438/want-to-change-pgsql-port
...
0
votes
2answers
69 views
Can I find out what version of MySQL from the data files?
I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
1
vote
1answer
33 views
Oracle Express intermittently stops responding, requiring a OS reboot to fix
I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out.
There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 ...
0
votes
1answer
88 views
I can't install db-mysql in node.js
When I execute this command: npm install db-mysql, I get the following result. What's the solution to this problem?
C:\Users\Mouad>npm install db-mysql
npm http GET https: ...
-2
votes
1answer
92 views
Windows Server 2008 R2, Active Directory, and Oracle Database Server
I have a group of clients, Windows server 2008 R2(Active Directory Installed in it), and an oracle database Server
I Want to know how to make the configuration of the following Diagram in this link:
...
2
votes
1answer
72 views
Trying to allocate 3G for buffer pool in InnoDB fails
I'm trying to boost my InnoDB driver on my Windows 7 PC since each page request takes just about 1.7 seconds to load versus 0.002 seconds on my Ubuntu 12.10 workstation.
The setting I'm playing ...
5
votes
1answer
417 views
How to resolve ORA-01031: insufficient priviledges error on Windows installation?
I installed Oracle 11G on my Windows 2008 R2 Server. I also installed Oracle Client Libraries using separate installation media. After the client installation, when I try to log into the database ...
1
vote
2answers
127 views
Performance Counters for SQL Server Related to iSCSI Disk Access
I am planning to my SQL server databases (plus TLogs and TempDB) to a new LUN on our iSCSI SAN. The current LUN's used by these of these files are on their own two disk RAID 1 disk group and I'm ...
1
vote
1answer
158 views
MySQL backup InnoDB
I have a VoIP server running 24x7. At low peak hour at lease 150+ users are connected. My server has MySQL running with InnoDB engine on Windows 2008 platform. I like to take at least 2 times full ...
0
votes
0answers
198 views
Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
I had installed PostgreSQL 9.2 earlier and it always installed with the encoding being WIN1252 (the default database was WIN1252). I then some time ago reinstalled it with the encoding being UTF8 (I ...
0
votes
1answer
142 views
Creating the MySQL slow query log file
What do I need to do to generate the slow logs file in MySQL?
I did:
log_slow_queries = C:\Program Files\MySQL\MySQL Server 5.1\mysql-slow.log
long_query_time = 1
What more do I need to do ...
3
votes
4answers
284 views
Stress Test to Saturate Memory for MySQL InnoDB
I'm investigating windows 32bit memory problems (the 2G limit) and am after a test which will max out MySQL's memory including InnoDB Buffer Pool, per connection memory and/or any other uses of ...
0
votes
1answer
87 views
Logging and saving user activity
Database:Oracle 11gR2
OS: Windows 2008 Server R2
I'm not trained DBA, just have to run things on an Oracle database temporarily, which is used to perform OLAP processes.
I need to automatize user ...
1
vote
2answers
150 views
How do I add a database in IBM DB2
I'm supposed to migrate a MySQL database into IBM DB2, but I thought I'd take baby steps first before I do something like that. So for now, I'd just like to add a database.
I'll admit that I have no ...
0
votes
1answer
224 views
How to copy MySQL Database from Linux to Windows?
I would like to copy a MySQL database form Linux to Windows, from a little research I found this url http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html where the author says we ...
4
votes
3answers
78 views
STARTUP command fails : Why is that?
I just installed Oracle Database Express Edition 11g Release 2.This is the first time I am using Oracle. Earlier I have used MySql and MSSql and I bet this one is a lot different !
These are the ...
1
vote
1answer
97 views
Unable to start Oracle Database Server : Get an error as I try to start it
I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop :
but as I click this icon I see this dialog box :
What is it ? How do I ...
1
vote
1answer
64 views
INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so' not working
I'm trying to install semi synchronous replication in my mysql 5.5 and trying to execute the below command:
INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so'
but this command is ...
3
votes
1answer
102 views
Domain group hierarchical group membership and SQL Logins mapped to AD groups [closed]
SQL Version: Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: ...
1
vote
2answers
1k views
Mysql Can't create test file + 1067 Error
I have installed mysql-5.5.30-win32. All works fine until i create my own my.ini configuration file. When I am trying to start the service using CMD (I do run the cmd as administrator, and install the ...
2
votes
1answer
80 views
How does MySQL resolve schema information?
I’ve used MySQL on windows7.
Recently my machine was infected by a virus.
After that SHOW TABLES and SHOW DATABASES statements don’t show any tables and databases but I can see data from tables ...
2
votes
1answer
241 views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
0
votes
1answer
1k views
MySQL Installation error: Unable to update security settings
I tried to configure MySQL server 5.5 on Windows and this is what I get
mysql-server-5.5-winx64:56 - Attempting to update security settings.
mysql-server-5.5-winx64:100 - Unable to update security ...
9
votes
1answer
128 views
What platform for a large record based mathematical database?
Hi I am a civil engineer with some experience of programming but I am not familiar with the vast range of options available today. Hope you could give me any pointers the best way to proceed.
I want ...
4
votes
1answer
298 views
Continuing failovers on production server
At least a few times a day, my main production server has recently begun failing over. Only, the quorum doesn't move to the other node.
I ran the validation report, and got a lot of info I don't ...
0
votes
1answer
191 views
MongoDB Master and Slave Replication - Windows or Linux
I have recently moved my MS SQL Server Database to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...
1
vote
1answer
104 views
Determining the full postgresql size on windows
While opening the Programs and Features tool panel on my Windows 7 (64-bit), I found that my postgresql (8.4) install was taking 108 GB.
I do not use postgresql myself, I just use a tool that need a ...
0
votes
1answer
71 views
MySQL installation and data location on Windows
I'm gonna install MySQL 5.5 in a virtual Windows Server. I'd like to have the data in an separate partition (it may be in a different virtual disk) than the system one. I'm considering two options:
...
2
votes
1answer
420 views
Remove sql server service from windows 7
I had installed and later uninstalled SQL Server 2005 . I used registry cleaner tools and deleted all files related to SQL Server . Still the services console shows entry for previous installed ...
1
vote
1answer
378 views
Is there a progress indicator for OPTIMIZE TABLE progress?
MySQL 5.1.4x (Windows) | Innodb
I recently purged data from a mySQL DB (a few hundred thousand rows) and I'm planning to use
OPTIMIZE TABLE LOGTABLEFOO1,LOGTABLEFOO2,LOGTABLEFOO3;
to reduce the ...
2
votes
1answer
302 views
Unknown option '--no-beep'
I installed a new version of MySQL server (previously 5.0, now 5.5) and I copied the data folder in to the new one. Now I should perform mysql_upgrade. I opened the command prompt (server is located ...
0
votes
1answer
86 views
Converting dbo file from windows to linux
I have a .dbo file which is created from windows. This file is succesfully reloaded into the mysql database in windows. I need to reload the dbo file into the mysql/mariadb database in linux. How I ...
4
votes
2answers
311 views
Problems connecting to Windows-based Postgresql
Other computers are having trouble even finding the running Postgresql 9.1 on my Windows 7 machine. Local connections work just fine of course.
In my pg_hba.conf I have:
#office subnets
host all ...
1
vote
1answer
391 views
Connect to SQL Server using OLEDB or ODBC?
We have a desktop application written in Visual Basic .NET. One our clients needs to use ODBC instead of OLEDB to connect to the SQL Server 2008 R2 Database. The company has several databases ...
10
votes
2answers
225 views
What is shared between two instances on the same server?
We want to install multiple instances of SQL Server on a single Windows server. We cannot use VMs because the server is bare metal Windows 2008 R2.
For security purposes we need to ensure that the ...
