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
vote
0answers
44 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 ...
6
votes
7answers
20k views

How to rollback a deleted table data?

I have deleted one table accidentally how can I rollback that. Please suggest that.
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 ...
5
votes
3answers
13k views

SQL Server running under a domain account cannot register its SPN

I am trying to configure a fresh install of SQL Server to run under a domain account. However, I get intermittent errors when trying to connect to the server using another domain account, and I still ...
0
votes
3answers
7k views

Using Subversion with SQL Server Management Studio

I am a member of a team with 3 developers. We have started using Redmine here for project management and issue tracking and LOVE it. I have seen elsewhere how nicely Redmine can work when a back-end ...
7
votes
4answers
19k views

How can I add myself to my local sql server's windows authentication?

IT recently re-setup my laptop with 64bit windows. He installed Sql Server dev edition for me and set it up with a username and password. I logged in and tried changing Sql Server to windows ...
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
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) ...
8
votes
6answers
7k views

What's the best wiki to run on Windows? [closed]

I want to set up a wiki for my team. I need it to run on Windows/IIS and if it needs a database, against SQL Server. User-authentication must use/integrate with Active Directory, ideally natively ...
2
votes
0answers
778 views

Connecting to MS SQL Server using FreeTDS: Error 20002: “Adaptive Server connection failed”

I am trying to use FreeTDS to connect from a Linux server (RHEL v7) to a separate server running MS SQL Server 2014. However, when attempting to connect with tsql I get the following errors (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 ...
0
votes
2answers
98 views

what to do with ms sql error 40 “”

I had no problem with my sql server and management studio yesterday, but today it does not connect and show me this error: A network-related or instance-specific error occurred while ...
-1
votes
3answers
1k views

How to set password to SQL server database [closed]

I am unable to set password to SQL server database. Please advise how to do it.
2
votes
1answer
4k views

MSSQL 2008 is claiming the firewall is blocking ports even from local machine

I was just hoping to step through a couple queries to see how the temp tables are interacting and I'm getting this message. The windows firewall on this machine is currently blocking remote ...
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 ...
0
votes
0answers
20 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 ...
7
votes
1answer
10k views

How can a Perfmon “% Processor Time” counter be over 100%?

The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
3
votes
2answers
12k views

Installing PDO_DBLIB for PHP [closed]

I'm trying to get PDO's to work with SQL Server and I'm completely lost. I found this : http://www.php.net/manual/en/ref.pdo-dblib.php http://pecl.php.net/package/PDO_DBLIB and told to try this: ...
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
1answer
24 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 ...
0
votes
0answers
14 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 ...
9
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
68 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
556 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 ...
2
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
30 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
104 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
709 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
18 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 ...
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
21 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
19 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
6 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
614 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
42 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
33 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
21 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
957 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
187 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 ...