The tag has no usage guidance.

learn more… | top users | synonyms

6
votes
1answer
824 views

Configuring SQL Server 2016 to allow remote connections

I have SQL Server 2016 installed on Windows Server 2016 Core. Locally, it seems to be working. I can connect using SQLCMD.exe and do some basic selects and what not. From remote, I cannot connect. ...
0
votes
0answers
28 views

What are the Computer Management Group Privileges actually granted? [migrated]

Someone wants to do something to database or it's server and they always ask for "Admin" privileges. Often on questioning it turns out they need to add a column to a table, so you grant db_owner on ...
0
votes
1answer
1k 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 ...
1
vote
1answer
55 views

WSFC Quorum query

I have an three node AlwaysOn AG setup, running on SQL Server 2012 SP3 in Windows Server 2012 R2. Node 1 and Node 2 are in the same physical location. Node 2 is the secondary replica. Third node acts ...
0
votes
0answers
27 views

Windows Event Viewer: Event ID 1033

Multiple times a day the following event is recorded in Windows Event Viewer on one of our servers: We have Windows SQL Server 2008 R2 installed. And for the life of me I have no idea why ...
3
votes
3answers
24k 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 ...
0
votes
1answer
24 views

Make a (copy of a) postgis database available to customer?

Our application uses a PostgreSQL database (with the PostGIS spatial extension). Now one of our customers has requested direct access to the database; because, as they claim, it’s their data. We’d ...
0
votes
1answer
124 views

SQL Server Services Automatically Stopping [closed]

We are using Windows Server 2012 R2 Standard on a Dell R730 server. Server is using Microsoft SQL Server 2014. SQL Server service automatically stops some times. We search SQL Logs and we found these ...
1
vote
1answer
2k 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 ...
2
votes
1answer
854 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 ...
3
votes
2answers
166 views

Patching strategy when Windows and SQL Server patches not applied for over 3 years

The company I'm at hasn't patched their production servers for a while, neither SQL 2012 or Windows 2012. When I say "for a while" I mean, well, actually "never" - no patches or updates since the ...
1
vote
1answer
136 views

Oracle TNS Permission denied when creating database

I hope you can help me. I need to restore an Oracle 9i (9.2.0.6.0) database on a Windows Server 2003 R2 x64 from a cold backup. I managed to get the 9i installer and the version patch (since I was ...
2
votes
1answer
5k views

SQL Server 2008 R2 Express single CPU core usage and need of upgrade to SQL Server 2014 Express

In our office we are using SQL Server 2008R2 Express which is installed in Windows server 2012. The SQL Server database is accessed by more than 60 users in network simultaneously. In recent days we ...
3
votes
1answer
60 views

Copy SQL DB files/backups

We have a task to copy 2TB of DB files/backups over LAN in a most efficient and speedy way. We are brainstorming amongst our team to come up with a best solution. These files are multiple backups and ...
0
votes
1answer
87 views

SQL server Virtual account and folder permissions

How does SQL server 2012 still work after changing the Service account to a domain account or even a local account. For example: as mentioned in MSDN https://msdn.microsoft.com/en-us/library/...
2
votes
1answer
204 views

Windows SQL Server Express 2012 and LDAP external server integration

I have a new installation of Windows Server 2012 with SQL Server Express 2012 with the management tools. I'm planning to create there a simple synchronization that will make queries twice per day to ...
0
votes
0answers
97 views

Unable to set InnoDB buffer pool size >900Mb

On Windows server 2003 sp2 OS with 4 GB of RAM, running MySQL 5.6 it was previously running with 1000Mb but when I try to restart the service it was failing to start with this error: InnoDB: ...
3
votes
1answer
382 views

SQL Server and SSPI handshake failed error

Recently I faced an issue where users from one domain were unable to login to SQL Server and getting this error: Error: 17806, Severity: 20, State: 2. SSPI handshake failed with error code ...
4
votes
2answers
7k 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 ...
1
vote
1answer
98 views

Least Privilege for SQL Agent to run DISKPART

The DISKPART script SELECT DISK 1 ONLINE DISK runs fine as long as SQL Agent has admin rights on the server; otherwise the script fails with this message: Message Microsoft DiskPart version 6.3....
4
votes
1answer
208 views

SQL Server 2012 mirror setup - how to reduce transaction log files [duplicate]

We just upgraded our Windows Server 2003\SQL Server 2005 setup to Windows Server 2012/SQL Server 2012. Both configurations have a mirror with NO witness server. On the old setup the transaction logs ...
3
votes
1answer
3k views

Multiple IPs registered for listener when using AlwaysOn AGs w/ multi-subnet clustering

We are testing AlwaysOn Availability Groups on a WSFC multi-subnet cluster and using dynamic DNS registration. Our issue is that sometimes the IP for the Availability Group Listener (AGL) in the ...
1
vote
0answers
22 views

How can I prevent SMB digital signing from killing SSIS performance?

My company recently turned on SMB digital signing on the Windows 2012 r2 server that runs SSIS. This has had a severe impact on data transfer performance. The security team did this and I can't get ...
0
votes
2answers
91 views

Killing a process without login to MySQL

Here is the situation: I was running a very complex query on a database which was expected to execute within a few hours over night(server configuration is not good and data set is large). This ...
1
vote
0answers
64 views

What is the best way to clear couple of tables each night at specific hour in Postgres SQL?

I need to clear couple of tables every night on my db so in the morning they will be empty and ready to use for the end users. I already wrote the query to truncate them but I'm not sure what is the ...
1
vote
0answers
283 views

How to check particular SQL UserID windows permissions in MS SQL SERVER 2012?

I would like to say as per my network system administrative security of windows Server 2012 R2. I am unable to start SQL Server agent. As per in MS SQL Server 2012 , i have "sysadmin" & "public" ...
0
votes
1answer
53 views

how big of a role does hardware play? [closed]

I'm the developer, not the DBA. I don't know much about setting up databases but i'm concern of the setup at my current work. The server is installed on desktop PC hardware(i7, 16GB RAM, 1 TB SATA ...
0
votes
0answers
2k views

error 1067 process terminated unexpectedly

I am facing the following error while creating the Mysql instance from command line in Windows server 2012. Steps i follwed for creating a new Mysql Instance as a window service: I have stopped the ...
0
votes
0answers
53 views

Cant Import mysql system DB from another server

Both Servers are the same in hardware, OS, and MySQL versions (5.6.11). One server has MySQL on it and on the other one I just setup a fresh instance. I want to import all of the data to the second ...
2
votes
2answers
376 views

Should a SQL Server DBA know Windows Server and vice versa? Are these roles soon to become synonymous. Or at least more encapsulated/?

I have Jr. experience with SQL Server and a desire to dive deep into Windows System Administration. Are these fields too separate to combine skill sets? Would I be marketable as a Windows Admin who ...
2
votes
1answer
950 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 ...
1
vote
2answers
3k views

SQL Server Cumulative Updates - not visible in Windows Update

I just installed all possible Windows updates on WS2008R2/SQL2012 instance. When I run SELECT @@VERSION I get Microsoft SQL Server 2012 - 11.0.5058.0 (X64) May 14 2014 18:34:29 Copyright ...
1
vote
3answers
2k 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 ...
6
votes
2answers
109k 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 ...
0
votes
1answer
186 views

Login to SQL Server 2008 R2 remotely

It seems this is a common problem over the internet so let me give you details on my environment and the steps I did: Client - Windows 7 32-bit with SQL Management Studio Server - Windows Server 2008 ...
5
votes
2answers
31k 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 ...
0
votes
1answer
1k views

Oracle 12c, can not chose standard edition when install!

i'm trying to install Oracle 12c on Windows 2012 R2 ... I get Enterprise Edition option only! I need to install Standard Edition!
1
vote
1answer
335 views

MongoDB fails with SymInitialize error unless there is a very large Page File in Windows

I'm wondering if someone can help with a MongoDB/page-file issue we seem to experience as our database increases in size over time. Every now and then MongoDB will crash on a particular node in our ...
3
votes
1answer
9k 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 ...
5
votes
4answers
5k 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 ...
1
vote
0answers
79 views

mirroring on sql server 2012 on different windows server 2012

I have 2 servers *.203 and *.205 I have sql server 2012 on each of them I tried to make mirroring between them every thing goes successfuly but when I tried to start mirroring it gives me ...
2
votes
1answer
13k 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 ...
0
votes
1answer
199 views

MonetDB ODBC driver memory allocation error on Windows

The driver is the latest from a month ago: 2014-SP2: 11.17.17, 64-bit. Windows is Server 2012. I have limited options to test whether earlier versions of the driver would work or this version works ...
0
votes
1answer
2k views

Oracle Enterprise Manage “CPU utilization” is confusing

When I display the CPU utilization in the Enterprise Manager (in the Performance tab), there is a big discrepancy between the graph that shows the utilization and the table that shows the operating ...
3
votes
2answers
310 views

RAID Storage Technology Outdated? [closed]

I am working on designing requirements for new SQL Server installation. I have been researching disk storage and everything seemed to point to using RAID. However, I found this article, which ...
0
votes
1answer
79 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 ...
0
votes
0answers
111 views

Oracle 9i Low performance on Windows Server Enterprise 2003

I'm facing some problems with performance with my Oracle database running on a virtual machine with Microsoft Windows Server Enterprise 2003 with 8GB RAM. It works pretty well after the database is ...
1
vote
2answers
5k 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 ...
2
votes
1answer
783 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 ...
1
vote
2answers
421 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 ...