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)

6
votes
2answers
3k views

MediaWiki on MS SQL Server

I've been doing some digging on running mediawiki on sql server instead of MySQL, but haven't come across any concrete information. All of our servers are running SQL Server so I'd like to stick with ...
6
votes
1answer
8k views

Will SQL Server 2012 install + run Windows 2003

I can't seem to find any information but can I install SQL Server 2012 Standard Edition on a server running Windows Server 2003 R2 x64? I don't intend to use this for production just for testing and ...
-1
votes
1answer
2k 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 ...
0
votes
1answer
112 views

SQL Server - Cant connect to instance with either windows auth or SA account

I have just installed SQL Server 2012 and I cannot connect to the new instance using any method. The instance is MSSQLServer I have attempted \MSSQLSERVER, .\MSSQLSERVER, localhost\MSSQLSERVER and ...
0
votes
0answers
31 views

MSSQL 2005 - Server Service unable to start while installing

I am trying to install MSSQL 2005 Express on an VM running Windows Server 2012. I get to the point where it installs everything but fails to start the service. I have tried checking the Log-On ...
2
votes
2answers
782 views

Re-downloading Microsoft SQL Server 2008 Standard because of license issues?

I have many clients who have purchased Microsoft SQL Server 2008 Standard. Unlike other Microsoft software, there is not a serial number provided for each customer to install the software. ...
1
vote
1answer
50 views

Port 1434 - Company Website hosting blocking us

We have a small network setup on a Windows Domain. We also have a company website that has the same domain name - but is actually not in any way on the domain - it's hosted elsewhere on a cheapo ...
0
votes
0answers
91 views

How do I migrate a database between servers from SQL 2008 Std to SQL 2014 Std using T-SQL without losing data?

What is the process using T-SQL to copy/move/relocate a database from one server to another? Do I need to take a log backup on the source as well and restore it on the new server? I am pretty sure ...
0
votes
0answers
67 views

Upgrading SQL Server from 2008 to 2012 doesn't respect existing install paths

Basic Information : Running Microsoft Windows Server 2008 with MS SQL Server 2008 (version 10.0.5869), trying to upgrade to SQL Server 2012. Currently working in a cloned VM of our production server ...
0
votes
1answer
48 views

AWS Command Line - Query Instance MS SQL Version

My AWS account runs approximately 50 instances. They all run Windows, but they vary between being just Windows, or running SQL Server STD or SQL Server Web. I'd like to find a way of exporting all ...
3
votes
1answer
4k views

Why can't I connect on port 445?

I need to collect baseline performance data on a SQL Server running on Windows Server 2008 R2. When I open perfmon on my computer running Windows 7 and try to add counters from the remote server, I ...
0
votes
0answers
100 views

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ...
1
vote
2answers
129 views

TCP traffic on port 1433 blocked by NAT rules

We have a SQL server that is hosted on AWS, the SQL server it not directly accessible on the internet, it relies on a NAT box to route traffic to it. We are trying to set up a Linked SQL server from ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
2
votes
2answers
95 views

Windows Server Administration - which services are safe to run internet facing?

Coming from a Linux background and now having to manage some Windows servers (2008R2 & 2012R2) I'm wondering which services are safe to run directly over the internet. The servers are all internet ...
0
votes
1answer
276 views

How to upgrade an RDS SQL Server Instance to an SSD

I'm trying to upgrade my RDS SQL Server 2012 instance from magnetic storage to an SSD. It is an instance class of db.m1.large with bring your own license. I've tried modifying the storage type, but ...
0
votes
0answers
147 views

FIPS 140-2 on Windows 2012R2 with SQL 2014

I'm attempting to set my Microsoft SQL 2014 instance to use FIPS 140-2 complaint encryption as described in this KB article for SQL 2012, but it does not appear to be working. I do not see "FIPS" ...
1
vote
1answer
62 views

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of ...
7
votes
5answers
217 views

How much effort is SQL Server 2008 Administration? [closed]

I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary ...
0
votes
0answers
112 views

Configure Microsoft Sql Server Reporting services to redirect to ssl

I'm setting up an SSRS 2014 install, and I would like to make everything SSL by default. Getting SSL running isn't too hard, but for some reason there seems to be no easy way to redirect the http ...
1
vote
0answers
13 views

Should I back up full-text catalogs?

I am developing a small app for SQL Server database backup (version > 2005). I intend to use VSS snapshots (component based) to back it up and supported modes are Full & differential. Is it ...
1
vote
1answer
926 views

How to filter columns in SQL Server replication?

I need to replicate some data from two tables in one database to another databases. I used snapshot replication. The issue is that I would like to replicate only some selected columns and the others ...
1
vote
1answer
209 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
4
votes
0answers
67 views

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version ...
1
vote
3answers
4k views

Is it safe to restart Sql Server Agent?

I've found myself in the tenuous role of a developer tasked to manage a SQL server. I've set up some jobs to run on a schedule, but would like to receive email notification on completion. I've set ...
0
votes
1answer
159 views

Is there a way to kill a range of session ids (connections) in ms sql server?

i was wondering if there is a way to kill a range of SQL Connections on an Microsoft SQL DB. If i want to kill a single session id i can use kill [session-id]; go;. If i want to kill all sessions i ...
1
vote
1answer
167 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
1answer
130 views

Unable to connect to SQL Server on live server

I have a copy of my client's database and website on my computer. There's also a matching copy of both online where my client's customers will use the website. When I test my local copy of the ...
1
vote
1answer
39 views

Error when using sp_addscriptexec

I have tried to run the following command on my server that is using sql 2008 merge replication sp_addscriptexec MyPub, '\\my-server\MSSQL\updateTablePermissions.sql', 1 and I get the following ...
2
votes
5answers
5k views

SQL Server 2008 - 2005 Compatibility

I want to use SQL Server 2008, but I'd also like to maintain a fall back position of switching back to SQL Server 2005. I know I cannot backup 2008 to restore 2005 and detach/attach won't work - what ...
1
vote
2answers
1k views

How to achieve the following RTO & RPO with logshipping only using SQL Server?

Trying to come up with viable backup restore & logshipping solution for achieving the following: 15 minutes Recovery Point Objective (no more than 15 minutes data loss at any time) 5 minutes ...
0
votes
2answers
259 views

SQL Log Shipping Two Databases using the same shared folder

I will configure Log Shipping for more than 1 database on single a server. And I wan't to know If I can use a single Shared Folder or if I have to create a Folder For Each Database. What I mean is: ...
2
votes
2answers
437 views

Move SQL server install to new machine?

I have a Windows Server 2008 R2 that was running SQL Server, until it had a unclean power down and now the operating system become corrupted. Before I struggle to resurrect the machine, I'd like to ...
4
votes
1answer
254 views

Server side antivirus or not?

We have basic server-side virus scanning in our datacenter, but it's expensive, uses a considerable amount of CPU cycles, and is annoying to maintain. I'm not looking for a sales-pitch on "better" AV ...
0
votes
1answer
337 views

SSL Certificate Trust Required for Services

This is in a development system which is why i have a self generated SSL certificate. Its setup on our dev exchange server; i need to add a trust to call it from a CLR running inside SQL Server. Have ...
0
votes
2answers
442 views

SQL Agent started with local user account can't run job with domain user account

I have SQL Agent running under a local user account. Jobs runs well if I used Local account credentials for the cmdExec step. If I try to use a domain user account (created previously in proxies ...
0
votes
1answer
25 views

Will SQL Alias compromise existing connections to [cluster name]/[database name]?

On a migration project we plan to use SQL Alias, since we learned it should be easier to use when moving databases between servers. The plan forward is to continue to move around databases to other ...
3
votes
2answers
719 views

How do I recover a dropped table from SQL Server Express 2005?

Something disastrous happened to me. I accidentally dropped my important table from SQL Server 2005 Express DB. Is there any way to recover that table with all records? Can DB Log file help? I have a ...
0
votes
0answers
246 views

SQL server session tasks all waiting

I have a query that often completes in a fraction of a second (~200ms). Sometimes it takes 10-13 seconds to complete. Doing SET STATISTICS TIME ON it shows: SQL Server Execution Times: CPU time = ...
0
votes
6answers
2k views

Hiding SQL Server 2005 system objects/schemas from Microsoft Query

End users in my company frequently use Microsoft Query (through Excel) to perform ad-hoc queries of selected SQL Server databases. As we move to SQL Server 2005 on the backend, we are discovering ...
0
votes
1answer
478 views

SQL Server Management Tools available on SQL Server 2012 express?

My goal is to access a server with some cube data and query it. If I understand correctly I need Analysis Services in order to accomplish this. My Current install of SQL Server Management Studio ...
0
votes
0answers
47 views

Windows Server Failover Cluster (WSFC) - Customize Failover Policy

On a Windows Server 2012 Windows Server Failover Cluster (WSFC) supporting a SQL 2012 AlwaysOn Failover Cluster Instance (2-node) setup - I am wondering about the following: Is there a way to trigger ...
3
votes
3answers
2k views

How can I determine if a SQL Server ldf log file is in use on a server?

I have a SQL Server ldf file that is a very large 190 gigabytes in size. I am pretty sure that it is just a remnant from an old SharePoint content database that is no longer on this database server, ...
3
votes
1answer
903 views

Impact on SQL 2000 performance of JDBC selectMethod=cursor

(Posted first on SO, but its not getting any answers there. Cross-posting to reach a larger audience, since it is cross-discipline.) In the process of trying to help out an app dev team with some ...
1
vote
2answers
3k views

How to transfer huge files (50GB+) from remote Windows server?

I have a dedicated Windows Server in a remote data center, where my site is running along with a Microsoft SQL Server database. The database is is 50+ GB and I want to have a local backup of the ...
1
vote
1answer
836 views

Problem with quartz and SQL Server in Liferay EE

I'm having a problem with quartz, it gives a java.sql.SQLException with this error message: ERROR [PortalJobStore:3799] ClusterManager: Error managing cluster: Failure obtaining db row lock: Line ...
1
vote
1answer
192 views

MS SQL Server 2014 is not able to connect to Coldfusion 11

I have Coldfusion 11 installed on my Laptop (Windows 8.1 Pro) and MS SQL Server 2014 but unable to get them talking to one another. Here are the three screenshots for your reference, please let me ...
1
vote
1answer
599 views

Is it possible to use the SQL Profiler on SQL Server 2014 Web or Express edition?

I'm a bit confused as to whether or not it is possible to use the SQL Profiler on the Web/Express edition of SQL Server. From what I've read so far people generally say "No - it was removed in SQL ...
0
votes
0answers
44 views

Is it possible to create my own custom SQL 'trigger' with Powershell?

I'm familiar with MSSQL triggers already, however they aren't fine grained enough for what I want to do. In my scenario I want the trigger to fire after a row containing certain information lands in ...
6
votes
5answers
15k views

Calling sp_start_job from a stored procedure

Our developers need to be able to start a SQL Server Agent job from their .Net code. I know I can call msdb..sp_start_job to do just that, but I don't want to give general user accounts direct access ...