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
4answers
7k 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: ...
0
votes
1answer
2k views

Active Directory SQL Server Random Handshake Timeouts

We've installed active directory on a new server and joined our database server and web servers to this new domain. However, randomly, we'll get the following error. What would be the cause of the ...
5
votes
2answers
17k views

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text ...
0
votes
0answers
43 views

Running SQL Server under “NT Service\MSSQLServer” caused “Object or Property not found”

I have a server called "server.domain.com" which was a Windows Server 2008 R2 domain controller This server also ran SQL Server 2008 R2 I renamed the domain controller (using the instructions on ...
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 ...
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. ...
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
1answer
13 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
1
vote
3answers
3k views

What are the steps to TDE encrypt a SQL Server 2008 database?

We have been trying the steps here: http://msdn.microsoft.com/en-us/library/cc278098.aspx but keep getting this error: Msg 15151, Level 16, State 1, Line 1 Cannot find the certificate 'tdeCert', ...
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 ...
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 ...
3
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 ...
0
votes
0answers
18 views

What does the sqldumper_errorlog file contain?

The SQL Server error logs are continually showing (along with many more messages) BEGIN STACK DUMP. * User initiated stack dump. This is not a server exception dump. Followed by External dump process ...
0
votes
2answers
964 views

Is there a download available for SQL Server 2005 Replication Components?

I'm trying to install SQL Server Compact 3.5 Server Tools. I'm getting an error saying I need to install SQL Server 2005 Replication Components in order to proceed. From searching online it appears ...
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 ...
-1
votes
1answer
26 views

Why are server authentication mode options are greyed out in Sql server 2005

I tried to search for the solution but couldn't find any. Please help me understand why the server authentication mode options are greyed out in Sql server 2005. I want to allow SQL Server login mode ...
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 ...
4
votes
2answers
4k 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
15 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
-3
votes
1answer
19 views

System databases are in standby…how can I make them editable?

My System Databases are stuck in a standby/read-only state. RESTORE DATABASE msdb WITH RECOVERY does not seem to have had any affect. How can I get them out of the standby state?
-1
votes
0answers
25 views

How to push the SQL installation from SCCM 2012.

I need to push out SQL 2008 to a new server using SCCM 2012. I was wondering if anyone had done this? I thought it was a case of finding the device in collections and deploying a package to it. ...
9
votes
7answers
10k views

Reclaiming memory from SQL Server

I have an SQL Server instance who's memory usage gradually grows until windows will give it no more. It seems logical that the occasional big query result would cause the instance to grow. Is there a ...
0
votes
1answer
2k 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 ...
-1
votes
1answer
35 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
6
votes
1answer
474 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
0
votes
1answer
20 views

SQL Server 2014 Backups not inheriting NTFS permissions

I am running a script I run on all my SQL servers however on this specific server I have run into the problem where the script fails to make a copy of the DB backups in an external location because ...
25
votes
7answers
9k views

Is it OK to run perfmon on production servers? And why?

Or should perfmon be limited to a Dev/QA server with load tests that simulate production activity? I'd like to run perfmon for two days (like Sql Server master Brent Ozar suggests) to get an overall ...
0
votes
0answers
26 views

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do ...
2
votes
2answers
3k views

Problem in restoring differential backup

I tried to restore differential backup but i got a following error: Restore failed for server .(Microsoft.Sqlserver.smoextended) Additional Information: system.data.sqlclient.sqlerror:The file ...
1
vote
1answer
2k 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 ...
2
votes
2answers
2k views

Hide database from other users in SQL Server 2008

I have created a database in SQL Server 2008 and it shows in server object explorer to all users that can login to SQL. I want to hide it from those users, I want it to be viewable by me only. How ...
0
votes
0answers
81 views

Repairing corrupt MS SQL master database - no SQL client access

Apologies for any duplication but I feel like I'm falling at the first hurdle. I have a MS SQL 2005 Server which is refusing to start and for which I don't have a password (including the 'sa' ...
1
vote
1answer
49 views

Import IIS Advanced Logs into SQL

I'm using IIS 8.5 Advanced Logging and also logging some custom HTTP headers. How can I import the raw logs into SQL on a regular basis (i.e. every minute)? I want to avoid the overhead of ODBC ...
0
votes
2answers
45 views

Copy DB table across 2 different MSSQL servers

I have 2 MSSQL servers running, with more or less the same data set. It is really a production/development setup. Now, my workflow is like this. Every day backups are made of each one of the ...
0
votes
1answer
34 views

how to create public SQL server [closed]

I installed sql server on my computer. I can work with it as localserver. But i want to it to be a public server. I followed lot of tutorials but it's still don't work(I can't connect the server ...
2
votes
1answer
634 views

Windows Performance Monitor keeps trying to add unwanted counters

I have been running a Data Collector Set for SQL Server for a week, and everything was going just fine until I tried clicking on Action -> Save Current View and now it always tries to add the ...
26
votes
3answers
67k views

What is the difference between SQL Server standard and web edition?

Is there any technical difference between these 2 editions or is it just how they are licenced?
0
votes
1answer
20 views

Restoring From Another Dev's MDF on Same Database: MDF Cannot be Overwritten

Here is the situation: We have multiple developers. We want to import/export(restore/backup) .bak files whilst working on the same, but local, databases(Each dev has a local instance of DB: A). The ...
4
votes
2answers
1k views

Renamed a SQL Server, however maintenance plans still have old name

A colleague has renamed a SQL server, however all of the maintenance plans still have references to 'OLD_NAME' as 'Local Server Connection'. The text boxes containing the server names for Local ...
0
votes
1answer
56 views

Is it possible to connect to MS SQL server via HAProxy?

I need to be able to connect to MS SQL server hosted on Amazon (RDS, single AZ) via HAProxy. I tried the following configuration (bottom) but MS SQL returned me (although I used valid login and ...
0
votes
1answer
39 views

32Bit ODBC DSN “Server does not exist or access denied” but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
1
vote
5answers
1k views

User not functioning after backup and restore of database to another server in SQL Server 2005

We have a database called 'foo' on the first sql server instance called 'SQL01' that is backed up nightly via a snapshot with Snap Manager for SQL Server and then flex cloned and restored to a second ...
17
votes
3answers
19k views

How to check progress of DBCC SHRINKFILE?

Is there a way to find out the progress of DBCC SHRINKFILE statement? Here is how I was running it dbcc shrinkfile('main_data', 250000) I am running above statement on both SQL Server 2005 and ...
0
votes
2answers
6k views

Using Subversion with SQL Server Management Studio

I am a member of a team with 3 developers. We have started using Redmine here for project management and issue tracking and LOVE it. I have seen elsewhere how nicely Redmine can work when a back-end ...
1
vote
1answer
2k views

sqlcmd won't execute - Claims Native Client not installed properly [closed]

I'm trying to use sqlcmd to execute some SQL scripts. Using a test command with a simple query like: sqlcmd -S HOSTNAME -d MYDATABASE -Q 'SELECT Names FROM Customers' sqlcmd does not appear to ...
3
votes
5answers
8k views

SQL Server 2008 R2 vs. SQL Server 2008 R2 Express

What differences exist between the pay and free version of MSSQL2008R2? Microsoft SQL Server 2008 R2 http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx and Microsoft SQL Server 2008 R2 Express ...
1
vote
0answers
167 views

PostgreSQL - Invalid byte sequence for encoding “UTF8”: 0xe7 0x75 0x20

Here is the problem : Everything worked fine with my postgresql system until I decided to click on the "rotate logs" button in the server status tab (from pgAdmin). After that, I faced this issue, ...
1
vote
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 ...
4
votes
0answers
74 views

Windows Authentication to a Remote Server within an Intranet Environment

I have several servers (all on the same DC) within an Intranet environment at my company. For simplicity, I'll focus my question on the IIS and SQL Servers. I have an IIS 7.5 web server and a remote ...