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)

2
votes
2answers
47 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 ...
1
vote
1answer
1k views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
0
votes
1answer
17 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
31 views

SQL Server Job Database name

First time post, long time lurker. I am trying to find and write a query for what database is affected by a SQL Server job. I have checked the following: Get a list of SQL Server Agent Jobs and ...
4
votes
1answer
2k views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
0
votes
0answers
8 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" ...
0
votes
1answer
3k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
1
vote
1answer
44 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 ...
0
votes
1answer
2k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
7
votes
5answers
212 views

How much effort is SQL Server 2008 Administration? [on hold]

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 ...
1
vote
1answer
1k views

SQL Server ODBC Connection via Command Line

I need to create a number of ODBC connections to a MS SQL Server, the clients are mainly XP machines. The connection has to use SQL server authentication - is there a way to do this remotely via ...
0
votes
0answers
5 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 ...
0
votes
1answer
825 views

SQL Server NETWORK SERVICE account permissions

My SQL Server Windows service is set to use the NETWORK SERVICE account. The server is installed to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL. However looking at the ...
3
votes
2answers
4k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
1
vote
0answers
9 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
680 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
114 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 ...
0
votes
2answers
1k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
3
votes
0answers
24 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
3k 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
1k views

SQL Server replication pending transactions

I'm having a problem with a transactional replication. I have the publisher in my server and there is a subscriber in another server. In my server, if I go to the details of the subscription I can ...
0
votes
1answer
42 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 ...
2
votes
3answers
2k views

Can’t connect to SQL Server 2008 - looks like Shared Memory problem

I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio. I believe the problem is related to a change I made to the connection protocols. Before the ...
-1
votes
0answers
7 views

Convert/Insert all files in a directory [closed]

My task is to convert jpeg's to binary and then insert them into a table called "images". I need to convert/insert all jpeg files in a directory. I'm able to accomplish the task if the files are ...
1
vote
1answer
27 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
1k views

Firewall configuration for SQL Server 2012 Express on Windows Server 2008 R2 for Workgroup

We are attempting to configure a server application to run on Windows Server 2008 R2 using SQL Server 2012 Express. With the server firewall turned off completely the application can communicate just ...
0
votes
1answer
25 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 ...
2
votes
1answer
1k views

Copy User Mappings for SQL Logins using SQLCMD - MS SQL Server

Is there a way to directly copy the User Mapping from one SQL Server login to another using SQLCMD? In SQL Server Management Studio Object Explorer | (local) | Security | Logins, Right-Click a user ...
1
vote
1answer
13 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 ...
-3
votes
0answers
25 views

sql database recovery from .bkf file [closed]

Few days ago I lost some part of .bkf file where is stored sql database due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem is next, when I ...
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 ...
0
votes
1answer
2k 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 ...
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
236 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: ...
1
vote
2answers
36 views

SQL Server file size

There is something I don't understand with the MSSQLServer mdf files. I have been asked to replace a file with its previous version (the database has been modified between the two versions), but when ...
2
votes
2answers
251 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
189 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
1k views

Performance Issue Between SQL and IIS on Seperate Machines

First time OP on serverfault, but an avid user of stackoverflow. We have two high-specification boxes, both running Windows Server 2008 R2 Standard. On one we have IIS 7.5, the other SQL Server 2008 ...
1
vote
2answers
2k views

How to set up Zabbix to monitor SQL Server Failover Active-Passive Cluster?

It should be simple, so it is just most likely my approach being totally off and someone will hopefully prod me into the right direction. We have a Zabbix 2.0.3 server instance set up monitoring a ...
0
votes
1answer
334 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
295 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 ...
3
votes
2answers
6k views

How to temporarily stop time syncing with domain controller?

I wish to do some testing on my local machine which requires me to put the date forward a year. So I can test some stuff in SQL Server (i've found it not possible to override the sql server time). ...
0
votes
1answer
7 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
657 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
42 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
311 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
17 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
822 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 ...