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
1answer
18 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
17 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
64 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
38 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
16 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
28 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
31 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
99 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
51 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
27 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
74 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
38 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
25 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
70 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
45 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
35 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
21 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
52 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
23 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
32 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
79 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
122 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
25 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 ROW_NUMBER(...
0
votes
0answers
22 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 ...
0
votes
1answer
21 views

Can't connect to SQL Server machine from another server any more

My sql server is on a machine 198.135.X.XX1 My dev server is on a machine 198.135.X.XX2 I used to be able to connect from my dev server to my sql server machines, but not any more. I am still able ...
0
votes
1answer
31 views

from security perspective one instance with Multiple Databases or multiple instance for multiple clients

We have 20 clients which currently every client has his own database on his own server(in his own environment) all the databases have the same structure(schema) and all of them has MS Sql Server 2008 ...
1
vote
2answers
18 views

SQL Server domain-group based login

I have a couple clustered SQL server instances, 2 on 2014 and 1 on 2008r2. In all 3 cases, I've created a SQL login (server principal) for a domain group, say DOMAIN\SqlAdmins. I grant it the '...
0
votes
0answers
7 views

Unable to access Reporting Services using Administrator account Windows 2012R2 / SQL Server 2012

We have a standalone Windows 2012 R2 server with SQL Server 2012 installed. The Windows 2012 server has an Administrator account only in the group "Administrators". This Administrator account is ...
0
votes
1answer
16 views

SQL Server Management Studio always encrypt connections

In the connections dialog of Management Studio there is an option to encrypt the connection so that you can force the connection to the remote server to be encrypted. Is there a way that I can make ...
1
vote
0answers
58 views

Connecting SSIS to AWS RDS SQL Server Instance

I am trying to connect SSIS to an AWS RDS SQL Server instance. Whenever I try to run the packages through the SQL Server Agent, I encounter this error message: Non-SysAdmins have been denied ...
0
votes
1answer
38 views

Setting up End-User Connection to ODBC Data Source

I need to connect my MS Access (front-end) database to SQL Server 2008 (back-end), using my ODBC connection, for all of my team to view the data in the MS Access reports, forms, etc. My MS Access ...
0
votes
1answer
27 views

MS SQL replication run only with system account

I'm trying to configure a new replication with SQL Server 2012 I configured the distribution While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user ...
1
vote
1answer
39 views

SQL Server Full BackUP functionality

In SQL Server 2008 R2 (or Any other Version); Transaction-1 had started at 11:50:00 and it takes 1hr.5min to complete(i.e., completed at 12:55:00) and Transaction-2 had started at 17:45:00 and it ...
0
votes
0answers
62 views

Block Windows Service Access to Remote SQL Server with Firewall

So I've got a fun firewall question. We have a windows service that we have running on a Windows Server 2012 instance. It is connecting to a remote SQL Server that we do not own, among other things. ...
0
votes
1answer
17 views

SQL Server data and log file location on single physical drive

I have just got my hands on a dedicated hosted Windows Server 2012 R2 which has had SQL Server 2014 installed. The server has a single 2Tb drive (C:) which I assume is a standard hard-drive, rather ...
3
votes
1answer
281 views

RDS 2012R2: RD Connection Broker HA - cannot connect to SQL

I have a brand new RDS environment I am trying to set up. I'm trying to follow this guide: https://msfreaks.wordpress.com/2013/12/09/windows-2012-r2-remote-desktop-services-part-1/ and have gotten ...
0
votes
1answer
80 views

Install WSUS with remote SQL on port different to default

How do I specify the connection parameter to a remote MSSQL Server during WSUS setup that's default instance is not running on the default port?
-2
votes
1answer
51 views

SQL Server Backup Procedure and different types of backup [closed]

Need to know perfect solution on how to backup SQL server Database Version SQL server 2008 R2.
0
votes
1answer
114 views

SQL Server 2014 “Relocate all files to folder” option

In SQL Server while restoring database .bak file are are two option "Relocate all files to folder" and "Restore As". I can change the location of database using "Restore As" option, what is the ...
1
vote
1answer
124 views

Configured Azure Backup sends me a health check report every 15 minutes

I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via EXEC msdb.smart_admin.sp_set_parameter @parameter_name = '...
6
votes
1answer
170 views

DL380 Gen9 which processor and what impact on NUMA

We are about to build a new server and I was wondering what would the impact on NUMA with the options available. The system will be built using a Proliant DL380 Gen9 8SFF which has 2 sockets, and 12 ...
0
votes
0answers
6 views

error configuration HTTP connect to analysis services

I want to connect to cube using HTTP/ internet outside. I already set up : copy Folder OLAP in inetpub/wwwroot Added Aplication pool in IIS Added website with application pool i just created enable ...
0
votes
1answer
94 views

multi instance failover clustering (sql server)

just want to straighten my concept properly - when we are talking about SQL multi instance failover cluster, e.g. on a 2 node cluster, it means that each node can run its own sql instance, but each ...
0
votes
1answer
89 views

How to fix a slow connection between web to sql

I use Microsoft SQL Server, my web server is IIS When the database server was on the same network as the web server, it worked very good. Now that the web server is in one network in one city and ...
0
votes
2answers
81 views

Unable to start SQL server agent automatically

I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix ...