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
22 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 ...
2
votes
3answers
358 views

How do I restore a SQL Server database from last night's full backup and the active transaction log file?

I have been told that it's good practise to keep your SQL Server data files and log files on physically separate disks, because it'll allow you to recover your data to the point of failure if the data ...
10
votes
3answers
14k views

How to update a CLR Assembly without dropping assembly from SQL Server

How can i update a CLR function (or procedure) assembly dll without having to drop and re-create the assembly in SQL Server (2008 R2)? As it stands now if i update an assembly (e.g. to add a new ...
-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
3answers
620 views

An error occurred during the pre-login handshake. The local security authority cannot be contacted

I am having trouble to connect to SQL Server. The SQL Server, version Express 2008 R2, was running normally until one night that server needed to restart to make some system updates (The machine runs ...
3
votes
1answer
3k views

Failover Cluster Client Access Point Only Responds to Pings on the Owner Node

Background We're running two VMs (Windows Server 2012 R2) on Azure with SQL Server installed, set up as an availability group. We also, of course, have another VM as a dedicated DC. These are all ...
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
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 ...
0
votes
0answers
121 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 ...
2
votes
1answer
725 views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
3
votes
1answer
4k views

Does an SQL Server instance allow both secure and non-secure connections at the same time?

we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links: How to enable SSL encryption for an ...
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(...
3
votes
3answers
10k views

How do I identify slow queries in sql server?

I've found long, complicated instructions like this when googling for the answer to this question, an brief reference links such as in this post. I'm looking for a succinct a procedure as possible to ...
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
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 ...
13
votes
5answers
11k views

SQL Server 2005: There is insufficient system memory to run this query

One of our SQL Servers, which has been running stable for quite some time (years), has recently been throwing insufficient memory errors. From the Application Event Log, we see: Event ID: 701 ...
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 ...
0
votes
1answer
651 views

Website can not connect to ODBC (no rights?) “Error: 80004005”

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) ...
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 ...
2
votes
2answers
55 views

SQL Server Database Recovery

do u have any idea , which is the best software or best way to recover corrupt database in sql 2000/2005/2008
0
votes
1answer
37 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
26 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 ...
2
votes
3answers
992 views

How to read the transaction log for SQL Server 2008 [closed]

I'd like to know whether there is any way of browsing/searching the SQL Server transaction logs (any version). We've previously used tools such as Lumigent Log Explorer against SQL Server 2000 which ...
3
votes
1answer
202 views

How large can the undo file grow to?

I am starting to research setting up log shipping with our server. I am thinking I want to use standby mode for the remote server for the things I want to do (Data checks, ect.) What I wanted to know ...
0
votes
3answers
6k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
1
vote
2answers
66 views

SQL server structure refactoring

Often in my c# code, I can change the name of a variable, and all references to it will change as well. Is there a similar feature that allows me to do this with objects in SQL servers? Some of my ...
3
votes
1answer
269 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 ...
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 ...
1
vote
2answers
504 views

How do I use a domain account to connect to a MSSQL server for NPS accounting?

I'm trying to connect a Server 2008 R2 NPS to a MSSQL server for logging accounting data and I'm running into issues. I configured NPS Accounting through the "Configure Accounting" wizard and, using ...
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. ...
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 = '...
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 ...
-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
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?
0
votes
1answer
113 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
2answers
259 views

SQL Server Error: Failed Assertion = ‘m_iteratorInSafeState’

We have a client running our .NET application which connects to SQL Server 2005 on the backend. A few weeks ago the database crashed and the whole server had to be rebooted. This happened again today ...
3
votes
1answer
31 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
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 ...
2
votes
5answers
14k views

Error when restoring database (Windows 7 test environment)

I have a windows 7 operating system as a test environment. I have SQL Server EE installed with two instances, named as test and production. I took a full backup from AdventureWorks database from test ...
0
votes
1answer
86 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 ...
39
votes
7answers
32k views

Is it safe to have SQL Server auto-shrink turned on?

There are many SQL Server options that can be enabled for databases, and one of the most misunderstood ones is auto-shrink. Is it safe? If not, why not?
0
votes
2answers
544 views

SQL Server in “Recovery Pending” status after reboot

We have quite a few programs of our own design which communicate to our SQL Server (SQL Server 2014 Express). Every now and then they start blowing up all over the place; we run around trying to ...
6
votes
2answers
1k views

Listing pending reboots in windows

I'm trying to install SQL Server 2008 on a Windows Server 2008 x86 system, and I'm getting an error saying "Rule 'Restart computer' failed." I've already found a lot of people saying to clear the ...
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
93 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 ...
21
votes
4answers
32k views

Database 'XXX' is in transition. Try the statement later

im trying to connect to a sql server database i get this error Database 'XXX' is in transition. Try the statement later. i cancelled a long query earlier today but for some reason i can't get the ...
1
vote
2answers
98 views

What is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?

I'm trying to convince a client that their SQL Server backup strategy is insufficient. Long story short is that their current backup "strategy" is a weekly full backup followed by daily transaction ...
0
votes
1answer
1k views

Failing SQL Server Cluster installation, Addnode: Remote registry call failed

I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two ...
6
votes
4answers
17k views

Is there a way to run sqlcmd to get query output without showing the number of rows affected?

I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I was hoping to get the results in a csv format without the headers and the query metadata (how many rows ...