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

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
0
votes
0answers
19 views

SQL Server Express 2014, Windows Authentication problems

I am using SQL Server Express 2014, and I currenly have a (probably) very stupid problem with Windows Authentication. I have a AD server, a MS-SQL server and a Client, where everything was installed ...
0
votes
2answers
261 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
1answer
2k 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 ...
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 ...
0
votes
2answers
16k views

How to successfully connect to Foxpro database files using MSSQL Linked Server feature and ODBC?

We're trying to access Foxpro file-based database files via MSSQL Server's linked server feature, using Foxpro ODBC driver. For this, we've installed the latest Foxpro ODBC Driver from Microsoft, ...
0
votes
1answer
2k views

Change server on sap client

I have a SAP business one 8.0 installed on my Windows server 2003. It uses sql-server express 2005 for the database. Then I installed the client on another PC. How do I configure the client so it can ...
0
votes
1answer
48 views

Importing bacpac file with 25000 tables on SQL Server fails with timeout

I'd like to import a bacpac file that was exported from an 500MB DB that however has around 25000 tables. The bacpac itself is around 18MB. Importing through the UI of SQL Server Management Studio ...
1
vote
1answer
1k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
1
vote
2answers
3k views

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed ...
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 ...
0
votes
2answers
44 views

SQL 2012 Availability Group Doesn't Failover When Shutting Down Service

I am having an issue with SQL 2012 Availability Groups where it does not fail over when shutting down the service. When you shut down the service you will get an error: A network-related or ...
2
votes
1answer
2k 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 ...
0
votes
0answers
11 views

SQL Server 2014 SSIS job fails

I have an SSIS project that runs perfectly when I run it right off of the Microsoft Visual Studio editor. I need it to be a job in SQL SERVER 2014. I have created a proxy for it so that the same ...
0
votes
0answers
19 views

MSSQL Server 2008 - Allow One Outside IP with Windows Firewall

We have a MSSQL Server that has localhost connections, but need to have one connection to another machine. The other machine needs to login to MSSQL server. We added an Inbound Windows Firewall rule ...
1
vote
2answers
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 ...
3
votes
3answers
3k 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 ...
0
votes
1answer
2k views

Reporting Services 2008 Service Account error

I saved over the encryption key backup file when changing from one account to another. Now I can't see reports, change accounts, or use any of the Encryption key tools in the configuration manager. ...
1
vote
0answers
36 views

SQL Server Windows authentication - username not changed

I've recently changed my PC name and Windows user account as well. Before: OLDPCNAME\oldusername After: NEWPCNAME\newusername When I log in to my SQL Server management studio using Windows ...
5
votes
3answers
14k views

Why is “DbccFilesCompact” status is “Suspended”?

I am running SHRINK file on a 600G data file. Currently, status is reported as "suspended" and sys.dm_exec_requests.percent_complete for DbccFilesCompact command reports that it is running (but very ...
0
votes
0answers
53 views

How to export SQLCMD output to Excel

I am using SQLCMD command in powershell to run SQL scripts. When i pipe the output to TXT ,the formatting is all messed up. i want to export the results to excel file. how can i do that. My command ...
4
votes
5answers
38k views

Cannot login to SQL Server 2008 R2 with Windows authentication

When i try to connect to SQL Server (2008 R2) using Windows authentication: i cannot: Checking the Windows Application event log, i find the error: Login failed for user 'AVATOPIA\ian'. ...
1
vote
2answers
8k views

Finding out who has modified a Stored Procedure on SQL Server?

Looks like somebody has logged in and modified a Stored Procedure on our SQL Server database. Is there a way to find out the credentials of the person that has done that?
0
votes
0answers
19 views

What format does commvault restore to for SQL server backups?

I have a pretty challenging task that I need to figure out. I have 6TB of data in New Hampshire that I need to move to Texas. It is all SQL Server data. The data is backed up to tape via Commvault as ...
0
votes
0answers
10 views

Sql Server recovery

We installed a POS system onto a pc which we used for an expo. Before we could create a backup and print the reports we had a SQL server connection error and had to re-set up the database. Is there ...
0
votes
1answer
3k 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 ...
0
votes
0answers
13 views

SQL Activity monitor doesn't show information

i am using SQL Server 2014 Management studio, it seems there is some problem with my activity monitor when connecting to the local SQL server. I am not able to see any information in that [User SA]. I ...
2
votes
1answer
21 views

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
0
votes
1answer
34 views

Can I use SQL Server Enterprise Edition on VM Azure for production use

I have Microsoft BizSpark subscription in which I received Azure credits as well. I created a Virtual machine on it and I am planning to install SQL Server Enterprise edition which I see available ...
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 ...
-5
votes
2answers
72 views

Create a domain on server to have all users on it + shared SQL Server 2012 [closed]

I'm new to Active Directory Domain Services and to Windows Servers in general. I created a domain on Windows Server 2008 R2 using AD DS and I joined all company's PCs to this domain. Now what I want ...
1
vote
1answer
64 views

install sql server driver on ubuntu

I want to connect to sql server database which is placed on a remote server while my php code has been installed on an ubuntu server. I found that it needs to install sqlsrv driver or mssql driver ...
2
votes
2answers
752 views

High context switches on SQL Server box

We have a server with 2 quad xeon 5550 processors. The only application installed on the server is SQL server. CPU usage rarely goes above 40%, and the transaction rate is 2,000 transactions per ...
0
votes
0answers
33 views

SQL Server 2012 Microsoft-Windows-Perflib Error Message Event Code 1010

I am seeing the below error message occur every 15 minutes on a Hyper-V guest running Server 2012 R2 with SQL Server 2012 with SP2 (DB, SSIS, SSRS). I am wondering how to diagnose what this error ...
1
vote
0answers
13 views

Installing SSDT on Windows Server 2008 R2 SP1

I'm trying to install SQL Server Data Tools on a Windows Server 2008 R2 SP1 machine. I'm getting the following error: I've tried using both the .exe file and the ISO. I'm getting my files from ...
5
votes
5answers
13k views

How to rename a project in the Team Foundation Server (TFS)

How to rename a project in the Team Foundation Server 2008? What are khown issues?
1
vote
3answers
854 views

Amazon EC2 MS SQL Instances

We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one - ...
0
votes
0answers
41 views

Cannot add NT Authority login into SQL Server

I installed SQL Server 2014 on a Windows 2012 R2 instance. I named the instance SQLExpress. After installing SQL Server, I joined this machine to an Active Directory domain and logged in using the ...
0
votes
1answer
155 views

Server high memory and cpu - no leads

I've been asked to troubleshoot a server hosting our application at a client's facility. The client has complained to us on two separate occasions in the last week - week and a half. In one instance ...
0
votes
1answer
34 views

How to record/log query execution stats for long running SQL Queries?

I work on a system that comprises of a SQL Server 2012 DB server that is queried frequently with complex queries. Sometimes these queries take more than 2 or 3 mins to return. How can I record or ...
1
vote
0answers
22 views

Is it safe to back up SQL Server data directly if using VSS?

I have a client with a very basic single server setup that includes a small SQL Server Express database. I recently configured Symantec Backup Exec 2010 Quickstart edition for them. This is the ...
0
votes
1answer
32 views

Bring back to restoring state an online database

I configured logshinging for a database. I did some tests and tried a controlled failover. During log shipping secondary db is in restoring state. To have a controlled failover i stopped the primary ...
0
votes
1answer
46 views

Using a Load Balancer in front of SQL Server

We are setting up SQL Server 2014 AG with multiple secondary readonly instances since we have some significant queries that are killing our primary. What we would like to do is put a Load Balancer in ...
0
votes
1answer
41 views

Backup and Restore Multiple MS SQL Databases

We have switched to a new CAD package at work (elecworks) which uses MS SQL Server to store it's data. Unfortunately, it seems to use a separate database for each drawing that is created. We are ...
0
votes
1answer
80 views

Intermittent DB connection failure

Recently I started to see intermittent errors in log files of my web application. Raising from different places of the application the error is always about failed connection to DB which is located on ...
3
votes
3answers
13k views

SQL Server Linked Server RPC Options?

When setting up a linked server in SQL Server (we're on 2005), you can set two server options: Rpc Rpc Out Looking at the MSDN article, all it states is: RPC - Enables RPC from the specified ...
0
votes
2answers
28 views

Restarting sql servers

Ok I am our only IT guy here and all this was set up by the previous guy. I know pretty much nothing about databases. We have some software called E2 that keeps track of all our inventory. We also ...
0
votes
1answer
829 views

No file access permissions after restore database

I have a strange phenomon. When I restore a SQL-Server 2012 database to a folder on my D-Drive, it gets restored just fine. I can access the database and basically it works fine. But when I check the ...
0
votes
1answer
30 views

MSDE 2000 database size limit workaround

We have an application that came with MSDE 2000 version (yeah, quite a while ago) that is no longer supported, but we have not replaced it with something else. It works for us just fine, and ...
2
votes
4answers
8k views

Login failed--password of account must be changed--error 18488

I failed to connect to a production SQL server. My administrator reset my password, and told me what it was. SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: ...