Questions tagged [windows-server]
All versions of Windows Server. Please also add a version-specific tag like windows-server-2012 if that is relevant to the question.
437
questions
0
votes
1
answer
673
views
Recurring Memory Issues
We have a Windows Server 2008R2 server with 32GB or RAM running SQL Server 2008R2, along with an IIS server. The machine is also used as a backup server.
The problem is, periodically (every week or ...
- 9
2
votes
3
answers
11k
views
MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?
I have migrated my Database from Windows to Linux server. In many places, query has been written without focusing their cases (uppercase / lowercase). So, these queries are not getting executed and ...
- 2,021
0
votes
2
answers
153
views
SQL Server 2012 - cannot login
Just installed a single instance of SQL Server 2012. The instance name is called Example and the server is called WIN2K8R2. It's on a virtual machine and I am RDP'd into it. I'm trying to login with ...
- 19
3
votes
1
answer
2k
views
SQL Server - Service User Accounts and Licensing? [closed]
Maybe this is the wrong place to post, since its not necessarily sql server related, but here goes.
If I want to setup some service user accounts in the domain to use to run sql services like the sql ...
- 299
2
votes
1
answer
278
views
SSRS ReportServer_XXX.log is giving incorrect CPU count
I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
- 121
3
votes
2
answers
2k
views
Running MongoDB and SQL Server on the same host- memory pressure
We have a new application that is making use of both traditional MS SQL and MongoDB for data storage. We're running both instances on the same Windows 2008R2 x64 machine, with 64GB RAM.
There have ...
- 629
1
vote
1
answer
900
views
Backup Database (SQL 2000 Compatibility) on SQL Server 2005 with CHECKSUM, but Page Verification TORN_PAGES Detection
I am trying to backup a 250GB database on SQL Server 2005 running in SQL 2000 compatibility mode.
The page verification is set to TORN_PAGES detection.
So, far the backup has been corrupted when we ...
- 111
6
votes
3
answers
26k
views
How to allow connections to SQL Server with 2 differents ip
I have a small issue here: I have a SQL Server instance 2012 (let's call it SQLINSTANCE) on a cluster. I also have 2 network interfaces for this instance:
- SQLINSTANCE.my.network
- SQLINSTANCE.mgt....
- 143
2
votes
0
answers
129
views
Attaching Existing Oracle Home to fresh Windows Install
I have a client who recently was forced to reformat and reinstall Windows Server 2008 R2. Their ORACLE_HOME (Oracle 11g) and all of the data was located on a D: drive that was not reformatted. Can I ...
- 217
13
votes
2
answers
9k
views
SQL Agent - PowerShell step "syntax error"
I have the following code setup in SQL Agent Job step that is not running. The message received is simply:
Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed.
...
user507
1
vote
2
answers
779
views
Why does MySQL + Windows Server = crashed tables periodically?
Windows Server 2008 R2 x64
MySQL Server 5.6.14 x64
Is anyone else having an issue in where some tables are marked as crashed on a Microsoft Windows server? We have a couple of Windows servers (not by ...
- 328
4
votes
1
answer
4k
views
Can't restore my distribution DB postgres 9.2 backup into my staging DB postgres 9.3
I keep getting this pg_restore: [archiver] did not find magic string in file header when i execute a pg_restore -Fc -U "username" -d "dbname" "filename".dmpon my staging DB.
These DB are running on ...
- 143
3
votes
1
answer
2k
views
Error installing Clustering with SQL Server 2012 on Windows Server 2012
We are installing SQL Server 2012 on Windows Server 2012 and trying to accomplish clustering.
We've setup all the core functionality on the servers: advanced cluster preparation on all nodes and ...
- 139
1
vote
0
answers
156
views
SQL Server scheduled backup to Azure Table bacpac
I moved my database from Azure SQL to Windows Server 2008 R2 + SQL Server 2012 Web edition virtual machine on Windows Azure.
The Azure SQL provided automated backup to Azure Table as bacpac file. It ...
- 111
1
vote
1
answer
2k
views
Why isn't SQL Server using the Max Server Memory setting?
I have a SQL Server machine with the following:
Windows 2003 Enterprise SP2 (32-Bit)
SQL Server 2005 (32-Bit)
12GB RAM
/PAE switch set in boot.ini
6 SQL instances, all with AWE enabled
No other ...
- 1,973
2
votes
1
answer
21k
views
How to diagnose what is causing DB timeouts [closed]
I'm a web developer which currently has the joy of managing a client website that is still using Classic ASP that uses SQL Server 2000.
The code is quite old and in the process of been updated to a ...
- 145
1
vote
2
answers
9k
views
MySQL on Windows or GNU/Linux?
I've just read this article:
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html
There it says that MySQL on Windows is a good choice. (or is what I've understood)
In ...
- 121
3
votes
1
answer
30k
views
Does "use AWE to allocate memory" do anything on a SQL Server 2008 R2 64bit Windows 2003 system?
After checking the box I noticed that queries that would timeout after 30 seconds would complete execution.
The TechNet article says "AWE is not required and cannot be configured on 64-bit ...
- 33
4
votes
3
answers
883
views
Is it possible to setup failover clustering between a 32 bit instance and a 64 bit instance?
I am attempting to setup a couple of virtual machines in my lab for testing failover clustering on SQL Server 2008 and Windows Server 2008.
One of the hosts I have is not capable of running a 64 bit ...
- 69.5k
2
votes
1
answer
945
views
Is the [NT Service\SQLSERVERAGENT] a supported type for SQL Server Agent service?
Reading and re-reading MSDN "Select an Account for the SQL Server Agent Service".
NT Service\SQLSERVERAGENT is not listed in the "Supported Service Account Types" section.
And, if not, what is it ...
0
votes
1
answer
4k
views
Installing SQL Server 2008 R2 Express on Server 2012 - Could not load file or assembly
I'm trying to install SQL Server 2008 R2 Express Edition SP2 on Windows 2012 server.
The error is:
Any clue?
- 7
6
votes
2
answers
27k
views
SQL Server Service Account login or password is not valid error
I am trying to install SQL Server 2012 Express on a Windows 2012 Server for test purposes. This machine is part of our company domain.
During installation I am trying to use one of domain account ...
- 458
2
votes
4
answers
36k
views
Oracle 11g: LRM-00109 followed by ORA-01078 when using PFILE created by SPFILE
I know this is long, but please bear with me - I think the background info may be important.
OS: Windows Server 2008 R2 64-bit
DB: Oracle 11g 64-bit Enterprise Edition
Yesterday evening we had to ...
- 41
0
votes
1
answer
3k
views
Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?
MySQL 5.1.x | Windows Server 2003
Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue?
For example, if I ...
- 607
0
votes
1
answer
93
views
Software for working with SQL Server databases in Windows Server 2008 [closed]
We have an ASP .NET project that uses SQL Server that we host on a Windows Server 2008 machine. Where does Microsoft keeps its documentation for the tools that can be used for administering SQL Server ...
- 109
4
votes
1
answer
21k
views
SQL Server 2012 Reporting Services: "Unable to connect to the remote server"
I am trying to install SQL Server 2012 Reporting Services on Windows Server 2008, but all the web interface says after adding the feature and confirming all the default settings in Reporting Services ...
- 143
1
vote
1
answer
6k
views
startup mount issues with Oracle
I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the command shutdown immediate;. I get the
Database ...
- 183
19
votes
2
answers
155k
views
The value could not be converted because of a potential loss of data [closed]
Let me start out by clarifying that this is not a duplicate question, nor a potential duplicate for that matter. I have tried implementing every answer to every single variant that already exists of ...
2
votes
1
answer
2k
views
Installing Netezza 6.0.8 ODBC driver on Windows Server 2008
Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set ...
- 2,072
1
vote
1
answer
2k
views
PostgreSQL 8.0 - Windows Server 2008 R2 install - Service won't start
I am trying to install postgreSQL 8.0 on a windows server 2008 R2 machine. After the installation, the service does not start. When I try to start it manually, I get a message saying that the service ...
- 143
1
vote
0
answers
610
views
SQL Server 2012 Failover Cluster and attached SAN
I have three servers in a Windows Server failover cluster. SQL Server 2012 Failover Cluster is installed on all nodes. I have an issue with shared disks attached from SAN.
overview with the same ...
- 597
0
votes
1
answer
5k
views
Cannot Connect to Oracle Database running on Windows 8 Hyper V Virtual Machine
I have oracle server (standard edition) installed on a guest VM (Windows 8 Hyper V). I have mapped a host entry to the VM as "brettvm". I am able to log into the VM and connect to the default ...
- 121
12
votes
3
answers
55k
views
Moving SQL Server to different domain
What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain? What steps definitely/might need to be done for SQL Server before and ...
- 473
4
votes
1
answer
6k
views
SQL Server 2008R2 DBCC CheckDB never finishing
I'm running SQL Server 2008 R2 on Windows server 2008 R2 and up until recently we were having no problems. After windows updates recently (no sql server updates) we cannot run step 1 of our ...
- 41
7
votes
3
answers
10k
views
SQL Server service shutdown due to 'bad?' SSL cert
This morning it transpired that SQL Server 2012 service running on Win2012 had shut itself down. When I logged in as the server admin and tried to access SSMS, after entering my credentials I got the ...
- 830
0
votes
1
answer
621
views
mysqldump including deleted rows [closed]
I'm trying to move a database from a Windows2003Server with mysql 5.0.27-community-nt to a new server with CenTOS. When using mysqldump on the database on the windows server, one table (i haven't ...
- 1
13
votes
3
answers
4k
views
I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?
Since I'm a DBA (and in many cases, the de-facto sysadmin), SQL Server is installed on pretty much every server I have to work with regularly. I realized recently that I've been using the SQL Agent as ...
- 1,228