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
20 views

Reporting Services 2014 security configuration

I have some reports in SSRS 2014 that I would like to be available on demand as well as on subscription. Making them available on demand is easy to secure - just set the data source to Windows ...
0
votes
0answers
55 views

Route sql server traffic through firewall

We currently host our web application on multiple servers using Rackspace Auto Scale. This causes our outbound IP addresses to regularly change. At the same time we need to connect to an external sql ...
1
vote
2answers
130 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 ...
0
votes
4answers
1k views

syspolicy_purge_history generates failed logins

I have a development server with 3 instances: Default, A and B. It is a physical server, non clustered. Whenever the syspolicy_purge_history job runs at 2 am, I get failed login alerts. Looking ...
1
vote
1answer
54 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 ...
2
votes
0answers
371 views

.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
50 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
9k 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
32 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
2answers
221 views

Create Report in Microsoft Excel - Permissions Issue in Team Foundation Server 2010

I am trying to use the feature "Create a Report in Microsoft Excel" for Visual Studio TFS 2010. I am being prompted for a username and password in Excel for any given Team Project when right clicking ...
1
vote
1answer
105 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 .... ...
4
votes
2answers
6k 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
33 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 ...
29
votes
6answers
32k 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
84 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
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 ...
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
134 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
215 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 ...
1
vote
0answers
36 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
174 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
2answers
54 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
182 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
9k 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
35 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 = ''}; ...
0
votes
0answers
38 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 ...
0
votes
2answers
3k 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 ...
1
vote
1answer
168 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 ...
8
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
36 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.
26
votes
5answers
3k views

How can I prevent accidentally jacking with a production database?

Just recently, I had a developer accidentally try to restore a database to production, when he should have been restoring to a staging copy. It's easy to do, given that the db names are similar, i.e., ...
0
votes
0answers
82 views

How to execute unicode .sql file on azure sql via sqlcmd?

I have an Azure blog created via "Brandoo WordPress" template (wordpress website and azure sql server). All works fine, but if I populate wordpress tables from .sql file with unicode characters via ...
2
votes
3answers
4k views

Which ports to open for DB Mirroring

We have two physical servers on the different area protected by firewalls. We need to use DB Mirroring for our purpose. So which ports we need to open between two area for using MS SQL 2008 DB ...
2
votes
3answers
7k views

SCCM 2012: SQL Server service running account

When installing System Center Configuration Manager 2012, one of the problems I encountered during the Prerequisite Check was "SQL Server service running account". The detail of the prerequisite check ...
5
votes
4answers
24k views

How to duplicate MSSQL database on the same or another server?

It is perhaps a bit stupid question, but I must admit I have very limited experience with MSSQL and yet has to accomplish this: Take a snapshot of the database and create and exact duplicate on ...
2
votes
2answers
1k views

Sql Server Management Studio 2008 has suddenly become unresponsive

I'm getting a very strange error when I try to launch SSMS from my taskbar. It seems to open in normal speed, but responds to any input with just a beep. CPU usage is 0% in Task Manager, and there is ...
4
votes
2answers
1k views

How to create aliases without installing SQL Server 2005 Client Tools

I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so ...
0
votes
2answers
53 views

What is optimal sql server cluster storage solution?

I have been assigned a project where sql server is running on a single server with single raid 1 volume. This setup has worked fine until hardware failure resulted in about a day worth of downtime ...
-4
votes
2answers
70 views

websitepanel - Is web site panel support sql server 2014 in its services? [closed]

I have server that website panel installed on it for web hosting, my question is that Is web site panel support sql server 2014 in its services?
0
votes
1answer
156 views

SQL 2008 R2 automated install w/ configuration file - The credentials you provided for the SQL Server Agent service are invalid

I am doing an automated installation of SQL Server 2008 R2. I have a new VMware guest with Windows 2008 R2 and ran the SQL Server 2008 R2 setup to create a configuration file. I am only installing the ...
0
votes
1answer
412 views

Installing SQL Server on a Domain Controller [closed]

I want to install SQL Server on a Domain Controller ( windows server 2003 R2) but i have an error because SQL Server services can not run under a local service account or a network service account.
2
votes
1answer
302 views

Mirrored local accounts to connect to database on different server and domain

My database client and database server are on different machines and are not connected to the same domain (this is not supported with my web host). I'm not keen to send username/password details via a ...
-1
votes
2answers
2k views

SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts

Which time out value does SQL server take into consideration while executing a query or stored procedure? The application timeout is set at 20 minutes. The SQL query/command timeout is set at 10 ...
3
votes
4answers
3k views

can SSIS connect to another sql server?

Can an SSIS package run on one SQL Server instance but process data that is located on another SQL Server instance? I'd like to know this before I attempt to install SSIS and require a possible ...
0
votes
3answers
877 views

SQL Server Migration Assistant for Oracle

I've recently installed SSMA and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server I've mapped the necessary schemas from Oracle to MSSQL. The ...
1
vote
2answers
333 views

MySQL Migration Toolkit syntax error when creating Sql Server diagram object

I have another syntax error when migrating a diagram. I'm not certain this diagram is necessary, but it would be nice to have a smooth migration, and this is all that's standing in the way. The error ...
3
votes
1answer
42 views

Architecting for Load Testing

I'm trying to architect a set of web and database servers so that we can load test them. I'm running into some problems given the constraints I have to work with: We can't load test against ...
-1
votes
1answer
55 views

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which ...