Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

learn more… | top users | synonyms (3)

0
votes
0answers
17 views

AD, Service Account, SQL Server DNS Issue

I have very very little experience with network admin and AD, so excuse my ignorance.. I am intermittently getting this error in a Windows Service and website running in IIS (both on the same Server ...
-2
votes
0answers
13 views

Mouse cursor getting disabled after open MS SQL in server 2012R2 RDP [on hold]

The mouse cursor is getting disabled after opening MS SQL2012 in a Windows Server 2012R2 RDP connection. How can I fix this?
0
votes
1answer
62 views

How much data can SQL Server handle without a DBA / other professionals?

We deploy clusters that use Cassandra, Elasticsearch and similar NoSQL technologies to index and process data. We go to quite some lengths to make sure we can consume and process records quickly. One ...
0
votes
0answers
22 views

Install SQL Server 2000 on Windows Server 2012 R2

We have a SQL Server 2000 running on a Windows Server 2008 R2 without problem. Now we have upgraded the main server to Windows Server 2012 R2. We have tried to install SQL Server 2000 on that ...
0
votes
0answers
16 views

SQL Server does not exist or access denied but management studio connection works

I am trying to log on to SQLServer express 2008R2 on a Windows 2003 server using Sql server authentication over a VPN. The login and password work for Management Studio but not for the connection ...
0
votes
1answer
14 views

Windows Server 2012 R2 Hyper-V connection to external SQL Server not working

For almost 2 years, I've had a Hyper-V virtual machine on my local Windows 10 (formerly 8.1) machine running IIS and connecting to my production SQL Server (the Hyper-V VM is a development machine). I ...
0
votes
1answer
23 views

Log Shipping and Security for reporting

I have a SQL 2008 server with a database replicated via log shipping to a reporting server. The reporting server database gets updated once a day. The reporting server database is left in ...
0
votes
0answers
32 views

Redhat 6.8 - Where to install php-mssql

I tried following tons resources online to install php-mssql on Redhat 6.8 by using the Extra Packages for Enterprise Linux (EPEL) repo and it says that "No package php-mssql available". I made sure ...
0
votes
1answer
53 views

How to secure dual-homed Windows Servers that are connected to the internet

We have two machines running windows server 2012. Both have one NIC port connected to the public internet and another NIC port connected to a switch with internal IPs (192.168...). What is the most ...
0
votes
0answers
6 views

OSQL only showing server name without the instance

When i run osql.exe -L on one of our MSSQL db servers, one particular server only ever returns its server name and now its servername and SQL instance name. This is causing an issue connecting ...
-3
votes
0answers
29 views

Which server should be more powerful - web or db?

I tried searching a lot on google as well as serverfault but could not find answer to my specific question, so please forgive if i am asking something common. I have an amazon instance running ...
0
votes
2answers
19 views

SQL randomly disconnects in the middle of querying data

I have a strange problem - when I am querying SQL table with more than 9000 rows, SQL randomly disconnects with some unrelated error. 1.) What I mean with randomly disconnects: On average it happens ...
0
votes
0answers
15 views

Cannot create an instance of OLE DB provider. Error 7302

I am trying to connect to Oracle server from SQL server. I have installed Oracle DB and trying to create linked server following this link. But when I click ok on creating linked server it fails ...
0
votes
1answer
26 views

freetds start job at step from linux python script on MSSQL DB

I'm trying to create a python script on a linux box that can execute an agent job. Looking around I found sp_start_job command. But it doesn't seem to exist on python. Does any one know if it does ...
0
votes
1answer
28 views

How do I upgrade Non-Readable replica to readable (active) replica in Azure SQL Database

We have a Azure SQL Database with one read-only replica. We want to upgrade it to a plan that makes the replica active, so that it becomes readable. However, the upgrade procedure produces the ...
0
votes
2answers
48 views

SQL Server Named Pipe Error

I have been trying to install SQL Server Express for a few days now. I tried 2008, 2012, and now 2014 all with the same result. I cannot connect to the database remotely, even if I turn the firewall ...
1
vote
1answer
22 views

Using AWS, EC2, can't reach port 1433 for sql server

we're using two AWS EC2 instances, win 2012 servers, one for MS SQL Server and one for IIS. IIS is unable to reach port 1433 on the SQL Server. Here's what we've tried: Checked VPC setting and no ...
0
votes
0answers
10 views

SQL Server Licensing Proof [duplicate]

I have a SQL Server 2008R2 installation that was purchased back in 2012. Our network admin did a MS SAM Audit and is requiring proof of purchase etc. I cannot find it in my records anywhere. Is ...
1
vote
0answers
16 views

Certificate is not showing up in SQL Server

I need to say first that I am not a DBA and so, my problem is getting SQL Server Configuration Manager to recognize a certificate. I have 3 SQL Instances I work on, 2 are on the same network, the ...
0
votes
0answers
77 views

SQL Server 2016 RC2 and RC3 Install ERROR (Pictures and logs provided)

Can't install, updated Windows Server 2012 R2 fully with all Optional and Important Updates. I enabled a proxy to gain outside access which works (since Windows updates work). There is no anti-virus ...
1
vote
0answers
28 views

Move Azure SQL database server between subscriptions

We have two subscriptions (DEV and PROD). A database server has been deployed to the DEV subscription, but it is now in use by our production system. I want to move the Azure SQL database server to ...
0
votes
0answers
18 views

Ubuntu connecting to MS SQL Server shows users instead of schemas

I've tried several different Ubuntu 14.04 clients to connect to a remote MS SQL Server, and each one gives me a list of database users instead of a list of schemas or tables. I've tried DBeaver, ...
2
votes
0answers
32 views

SQL Server without memory reservation completely hangs

We are currently experiencing failures on our SQL Server machines. It appears that once a server on the same (VMWare) host as our SQL Servers starts a maintenance procedure. The SQL Servers will ...
0
votes
0answers
18 views

SQL Server Mirroring and Azure Regions Connection Error

I can't seem to get my SQL Server mirroring to work. I keep getting a server can't be reached when I enable the mirroring part. My virtual machines are in different regions. I can connect to all ...
1
vote
2answers
35 views

Why do I keep getting Microsoft-Kernel-Power error and my 2012 R2 DataCenter is randomly restarting with this error

Microsoft-Kernel-Power error ID=41 on Windows Server 2012 R2 Data Center. My server went down twice yesterday due to this error happening, causing the server to restart on its own. This is an Azure ...
1
vote
2answers
33 views

SQL2012 Evaluation expired - Trying to upgrade to fully licensed 2014 version

We have a dev box that one of our developers installed SQL2012 on. The problem is he used an evaluation version. Now I am in the unfortunate situation of it expiring and being unable to access the ...
1
vote
1answer
57 views

Azure SQL reserve external IP

How can I set an Azure SQL database to have a fixed static IP? We are using the Resource Group model - I can reserve IPs no problem and I can assign them to VMs easily but I cannot see how to assign ...
0
votes
0answers
47 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
-1
votes
2answers
62 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
0
votes
1answer
23 views

How to create a full dbo role for specified databases

We supply specialised data management software to the geothermal industry. From time to time, the database structure needs to be changed, and we issue a new version of the software that automatically ...
1
vote
1answer
16 views

SQL Server Agent Service - SSIS package scheduling not working

We have a local admin privilege to our VPN users and we have created SSIS packages but not able to run it through SQL server agent services as its not allowing to run throwing error being ...
0
votes
1answer
17 views

Does transferring a database to a new SQL Server instance lose statistics and execution plans?

I am transferring a database to a new SQL Server and was wondering, will it lose it's execution plans and statistics that its collected over the years for the benefit of performance and have to start ...
0
votes
0answers
15 views

SQL Server SSMS/Other Processes Allow Login from Untrusted and Unassociated domain

We have a Windows/SQL server development environment which is completely separate from our developers primary systems, including completely separate domains (no forest association, etc.) Our SQL ...
0
votes
1answer
61 views

How to deal with VHD for database storage in a multi VM setup in Azure

I've learned that to have the most available Windows Azure VM setup it's best to create availability sets. My setup would be to have an availability-set for 2 web-VM's and a set for 2-sql-VM's The ...
0
votes
1answer
35 views

Secure way of granting access to production database

We are currently using the FedEx Ship Manager in our warehouse and would like to automate the process of entering customer shipping information automatically. Inside the ship manager there is an ...
0
votes
0answers
15 views

MySQL not creating tables automatically when JAMES APACHE is started

The programs I am using: JAMES Apache Server 2.3.1 binary MySQL Workbench 6.1 CE MySQL Connector 5.1.38-bin.jar in ~/james/lib OS: Windows 10 64-bit In james 3, I am able to create MySQL ...
0
votes
0answers
26 views

Database locks up with READ_COMMITTED_SNAPSHOT ON after upgrade to SQL 2014

Since we migrated our database from SQL Server 2005 to SQL 2014, we're experiencing repetitive locks in the database. We used to have very few locks in SQL 2005. The READ_COMMITTED_SNAPSHOT is ON in ...
0
votes
1answer
25 views

MSSQL query not working, even if there is data

Trying to run a more complex SQL query on an MS SQL server, but I get no data output. Logically should be fine, but I cant see why it doesnt work: SELECT D.NAME DATABASE_NAME,T.NAME TABLE_NAME,I.NAME ...
3
votes
1answer
75 views

Change SQL Server user SID

I have SQL Server 2012 and I am using domain users (from Active Directory). By mistake users were deleted from AD, created new with identical logins and passwords (but with different SIDs), deleted ...
2
votes
2answers
16 views

SQL 2012 Standard - AlwaysOn FCI - Single point of contact?

I am looking at HA options for SQL 2012 Standard. I like the look of AlwaysOn FCI. I am using a SAN, so I think I can meet all of the requirements, but one of the applications I am looking at cannot ...
0
votes
0answers
9 views

SSPI Context not generated

I have migrated a SQL server from another server box that was decommissioned.They have the same name and also same IP address. I am however getting SSPI context error when I connect from an ...
-4
votes
2answers
44 views

Config to allow SQL Server to be connected through CloudFlare?

I have already known the risk of exposing SQL Server database on the Internet, but please look at my situation: I have two instances of SQL Server: production (default instance SQLEXPRESS) and dev ...
3
votes
1answer
23 views

What happens to running queries when stopping a Microsoft SQL Server instance?

Consider that a MS SQL Server instance is executing a long-running query the service is stopped via services.msc or - as it actually happening - a system shutdown triggered by a UPS as the server is ...
1
vote
0answers
45 views

SQL Server Agent job run as: permissions

I have a number of SQL Server Agent jobs running CmdExec statements. They are simple jobs that call simple batch files. They are run with a Run As: Proxy account, that has permissions to run as a ...
1
vote
1answer
36 views

Intermittent Server Performance Degradation Troubleshooting

I have been troubleshooting an intermittent server performance issue for too long and I am running out of ideas. I am looking for any suggestions as to how I might be able to identify the cause of ...
1
vote
0answers
23 views

Strange error in SQL Server from ASP.NET app

I posted this question on stack overflow, but to no avail. Getting desperate here. So we have an extremely random error (by which I mean, there appears to be no usage pattern that precedes the error) ...
1
vote
0answers
12 views

How do I stop SSRS from sending any missed reports when starting the service?

We fired up a test SSRS service that hasn't run for a couple of months. It appears that it has decided to send all reports where it has missed the schedule (so any report that didn't send since it was ...
1
vote
1answer
69 views

MS Native SQL driver 10.0 and SQL Server 2008 connection creation failure

I'm trying to narrow down and debug quite elusive error: State: 08001 Code: 258 Msg: [Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. State: HYT00 Code: 0 Msg: ...
2
votes
1answer
40 views

Assign to ASP.NET identity to AD group for accessing remote SQL Server

I have an ASP.NET 4.0 (IIS 7.5) application running on a server(Window Server 2008 R2 Standard), named WEBSERV, and a SQL Server (2008) database on another server, named DATASERV. The SQL Server has a ...
0
votes
1answer
32 views

Does 2012 R2/TFS/SQL need limits set so it doesn't eat up disk space with logs?

Setup: Hyper-V 2012 R2 host, primary guest is TFS single server installation w/ SharePoint (includes SQL for TFS ops) This question was posted on StackExchange SharePoint WRT the SharePoint aspect ...