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 (4)

1
vote
2answers
14 views

Backup and Restore all databases and users SQL Server

Is there a way to backup and restore an entire SQL Server in one command (Databases, Data and Users)? I've successfully achieved this with out MySql server but can only find examples of single ...
1
vote
1answer
815 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. ...
2
votes
0answers
280 views
+100

.NET + Connection to SQL Server 2008 R2

Recently, our developers have increased the Pool size in all connection strings to 8000. They are using VS 2010 Framework 4.0. In the DB side I am monitoring that up to 4000 connections is opening. ...
0
votes
1answer
13 views

Un-cluster storage added to Windows Failover Cluster Manager

Forgive me if I'm mixing up terminology, I'm a DBA and trying to see if I can un-do my error here. Background: I was adding a 3rd DR site node to a Windows Server Failover Cluster to utilize AlwaysOn ...
0
votes
5answers
8k views

SQL Server Log File Won't Shrink due cause “log are pending replication” on non replicated DB?

I have a non Mission Critial DB 9am-5pm SQL Server database that I have set up to do nightly full backups and log backups every 30 minutes during business hours. The database is in full recovery and ...
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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
18 views

SQLEXPRESS User password from hardcoded application

I am setting up a new computer with an application which has a hardcoded password for the SQL database. I am not getting any help from the apllication provider because they want to do it themselves to ...
0
votes
1answer
25 views

open firewall ports on mssql for SCOM

Im trying to figure out, which ports i have to open on my MSSQL-Server to let the SCOM (System center operations manager) connect successfully. Ive tried: disable the domain network firewall -> SCOM ...
1
vote
1answer
19 views

Can't Install freetds php-mssql on Centos7

I am at my wits end... Newbie to Linux... please help me... Goal is to connect to MS SQL Server 2005 using PHP. I have installed PHP and ODBC. I am running CentOS7. PHP Version => 5.4.16 .... ...
1
vote
1answer
902 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 ...
4
votes
2answers
4k 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
1answer
26 views

Which full backup will my diff backup be connected to?

I am trying to understand exactly how backups work for SQL Server. The hosting provider have a scheduled FULL backup every night. There are also a number of DIFF backups taken during the day. We ...
3
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 ...
28
votes
6answers
31k views

SQL Server (2005/2008): Does full backup truncate the log in full recovery mode

I've just read through a lot of MSDN documentation and I think I understand the different recovery models and the concept of a backup chain. I still have one question: Does a full database backup ...
0
votes
1answer
21 views

TCP packet loss against SQL-server

Where I work, we have had some issues with connections to the database. We get a lot of failures which appear as "recv failed" on the client side. I have used Wireshark to try to debug the problem and ...
2
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 ...
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 ...
2
votes
3answers
2k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
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 ...
5
votes
8answers
8k views

How do I copy a SQL Server 2005 Database?

In my environment I need to copy a database from one server to another. Usually a QA machine to my local box. I do not have access to QA machine. I can connect to the database, but not RDP into the ...
0
votes
4answers
87 views

What's the best way to debug and enhance the speed of your server?

My server has been running slightly slower than normal. I was wondering what strategies I could do to evaluate the speed of my server, and enhance it This question covers database interaction, I/O, ...
4
votes
1answer
129 views

List of things to check before turning on SQL Server CLR?

I am trying to deploy a CLR function (which computes a hash of a text or a file, not available from SQL Server) for the first time on a production server. I was able to test the function on a ...
1
vote
1answer
212 views

SQL SERVER 2008 R2 INSTANCESHAREWOWDIR Issue

I am trying to install SQL SERVER R2 Express Advanced Services on my VServer (Windows 2008 SP2 64bit). The server has also a sql server 2005 express instance for plesk... I am running in the strange ...
0
votes
0answers
20 views

SSL certificate for sql-server on ec2

I have an ec2 node provisioned to host mssql server. I'm trying to request and install an ssl certificate for this node so I can securely connect to it but I can't get the certificate to appear in the ...
0
votes
2answers
33 views

Why isn't sql server using all of the available memory

I Have SQL server 2012 standard 64bit with 64GB RAM and 40 CPU cores. In the server properties, I can see that all the RAM is listed in the memory field on the general tab. Underneath the Memory tab, ...
0
votes
1answer
24 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 ...
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
2answers
18 views

Build a IIS and SQL Server replicated cluster [closed]

I have four Microsoft Windows Server 2012 R2 Standard virtual machines on three physical nodes. Two will be dedicated for IIS, and two for SQL Server 2014 Standard. I have to replicate them (IIS1 to ...
0
votes
1answer
146 views

Seperate SQL databases for Web Applications? Or host both web apps on same SQL?

Ok, my Hyper-V Server 2012 looks like this: we currently have 2 VM's in production, one is running SharePoint 2010, and the other is hosting the SQL Server 2008 R2 for SharePoint. We're getting ...
0
votes
2answers
8k views

How to clean up database log file automatically to prevent errors?

I host website and sometimes get an error: The log file for database '%.*ls' is full. and have to contact my hosting provider for cleaning database log file. How I can disable logging or configure ...
2
votes
2answers
2k views

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name?
0
votes
1answer
28 views

interpret unknown piece of powershell related to SQL Server

I am migrating from SQL 2008 on Win2003 to SQL 2014 on Win2012. One of the jobs from the old system has this step: if ('$(ESCAPE_SQUOTE(INST))' -eq 'MSSQLSERVER') {$a = '\DEFAULT'} ELSE {$a = ''}; ...
-1
votes
1answer
52 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 ...
2
votes
1answer
322 views

Index reorganizing slow after index rebuild

Why does index reorganizing take 3 times longer after I make an index rebuild? I wasn't sure if this happens every time, so I made a test for the last month. I configured SSMS to execute Index ...
0
votes
0answers
25 views

SQL Server service dependency not working

I have an service that tries to connect to a MSSQL DB on startup, but when I start the computer it throws an error becouse it's not able to connect to the DB. This happens becouse the specific DB was ...
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
votes
0answers
14 views

MS SQL Server service account Windows priveleges and rights [migrated]

I quite often have to setup MS SQL Server and wondered if anyone can provide advice on configuring the accounts the services should run as. IMO this has been vaguely documented by Microsoft, while ...
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 ...
-1
votes
0answers
11 views

SQL ssis delete imported rows from source table [migrated]

I have setup a simple SSIS package that copies data from a source table to a destination table which works. I would like to get the package to also delete the data in the source table that has been ...
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
962 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 ...
0
votes
2answers
2k views

SQL server agent job to execute SSIS package fails, package succeds if run manually

I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
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
1answer
56 views

Activity Monitor not showing stored procedures?

This is SQL Server 2008 R2 running in Hyper-V virtual machine with 4 virtual cores. Task Manager is reporting sqlservr.exe to use at least 50% CPU, sometimes 100% for minutes. I/O is very low. The ...
0
votes
1answer
817 views

long access times and errors in iis application

I am having an issue with an IIS application (details of environment at the end of the message). The web site works great most of the time and I cannot reproduce any error in our test system. On the ...
1
vote
1answer
1k views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...
7
votes
7answers
4k views

Is there anyway to determine who dropped a table?

A table in the production database has 'mysteriously' disappeared. Does anybody know of any way to diagnose what the heck happened to it? And who did it? Edit 1: This is an internal app, with weak ...
0
votes
1answer
29 views

Can a database created in MS SQL Server Express be exported to MS SQL standard?

As the title states, can a databse created in MS SQL Server Express be exported to MS SQL standard? For the inent of the question, the version in question is 2008.
1
vote
1answer
1k views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...