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)

-1
votes
0answers
11 views

Multiple sub-queries … Better way to [on hold]

I have a table with products stock in a specific date (a day) of some products ... Not everyday has a stock record if there aren't stock movement ... This is my table : Table : Stocks Columns : ...
1
vote
0answers
10 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 ...
-1
votes
0answers
8 views

Website issues with internal accessing

we are facing a problem within my organization. The problem we are hosting a website internally and allowing public to access it. Public can easily access the website, but for internal users only ...
0
votes
0answers
28 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
17 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
3 views

Transactional replication using articles filters and delete operations [migrated]

The problem with transactional replication using articles filters and delete operations. I have a problem with my transactional replication when I use articles filters and delete operation. When I ...
-2
votes
0answers
12 views

SQL Server, Virtual server and database access for a beginner [closed]

I know nothing about servers. I got the access credentials to a windows virtual private server that has a sql server. Also the password for the sa account on sql server. I need to access some ...
0
votes
0answers
17 views

Consolidating various applications and databases [closed]

I'm hoping that you may be able to advise me how to best consolidate and reduce the number of servers that we currently have applications and databases reside on, in our Windows estate. I'm going 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
28 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
14 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
29 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
32 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
42 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 ...
-1
votes
0answers
5 views

SSRS Reports in Dynamics CRM

I am currently working on SSRS and CRM Prem. connectivity. I have SSRS report which show detail information for specific client where I am passing GUID as ClientId to fetch all values in report. ...
-1
votes
0answers
25 views

Pricing of SQL Server with Remote Access [duplicate]

This isn't necessarily a technical question, but I thought Serverfault would know best. If I want to run SQL Server Management Studio on my local machine in order to access / modify a SQL Server ...
0
votes
0answers
35 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
43 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
0answers
13 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
11 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
14 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
48 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
32 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
12 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
24 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
20 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 ...
2
votes
1answer
55 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
13 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 ...
3
votes
0answers
30 views

When configuring rsyslog to log to mysql DB, what is purpose of SystemEventsProperties table?

I've configured rsyslog on my servers to log to a remote mysql DB. I did this essentially by following the rsyslog wiki and it essentially creates two tables: mysql> show tables; ...
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
43 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 ...
2
votes
1answer
17 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
27 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
27 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
20 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
10 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
67 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
36 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
31 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 ...
0
votes
0answers
18 views

Does Microsoft SQL Server have something similar to 'sqlite:///:memory:'?

Python 2.7 SQLAlchemy Microsoft SQL Server Management Studio 10.50.2500.0 Microsoft Analysis Services Client Tools 10.50.2500.0 Microsoft Data Access Components ...
0
votes
1answer
23 views

Prevent a user from changing extended properties

Question: By default a user can change their own extended properties. Is the following code appropriate to prevent a user changing their user extended properties attributes?: USE ...
-1
votes
1answer
34 views

Migration between Oracle and Azure SQL Data warehouse using SSMA

I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database ...
0
votes
0answers
9 views

php mssql ApplicationIntent=ReadOnly

I am trying to connect to a remote MSSQL database. Before i get too long into this i was wondering when i connected with SSMS i had to specify "ApplicationIntent=ReadOnly" because of the availability ...
0
votes
1answer
19 views

sql server migration assistant for oracle to azure sql

I am facing below error while syncing table from oracle to Azure SQL database using SSMA tool(A tool used to migrate data from oracle to azure SQL). Please suggest a solution. Errors: USE ...
-3
votes
1answer
54 views

MSSQL Server 2008r2 database restoration issue

Let me explain the issue briefly. I am using MSSQL server 2008r2 on which there is a existing database with name "portaluser2" i have created one more database with dbname "chandigarh". I took the ...
0
votes
0answers
23 views

Windows Server…or not? [duplicate]

I need your help to decide on whether the setup of my company requires Windows Server as the "server's" operating system. I am not an expert, but I have read in various articles that if the number of ...
0
votes
0answers
68 views

Problems connecting to SQL Server using ODBC

Since three days ago I have problems connecting to SQL Server on a local network using our Access based application which uses linked tables. It happened suddenly and it only happens on my PC which I ...
0
votes
0answers
17 views

A timeout occurred while waiting for memory resources to execute the query in resource pool 'internal' (1). Rerun the query

When I run this query Select -- Generate the row number ROW_NUMBER() over(order by MenuOrder) as 'rownum', -- get the minimum data from query (Select top 1 ...
0
votes
0answers
15 views

OpenVPN access server on AWS and Integrated Authentication

I have setup an OpenVPN access server (using routed mode) on a VPC in AWS. our servers in the VPC are mostly windows machines, and so are the VPN clients. The client machine (in our office) are not ...