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)

6
votes
3answers
215 views

Why is it so important to backup your transaction log?

We're currently implementing a backup solution for a client and their ERP solution uses SQL Server. The ERP solution was set up by a different company. And they are telling me that it is super ...
-11
votes
1answer
42 views

Super-power PC for many users - Server (2008 R2) on Hyper-V can not use full Machine hardware resources [on hold]

I have started building a company super-powerful PC to merge all users on one single machine (to keep data centrally, easy to backup, control, and to scale more easily, etc..I know it is not the best ...
1
vote
2answers
259 views

SQL 2005 replication not working

I am in the process of creating replication between 2 remote servers, server 1 is the distributor and publisher and server 2 is the subscription Server 1 windows 2003 server 192.168.10.1 connected ...
2
votes
1answer
719 views

Sharepoint - restore single document from database level backup

Have a single Sharepoint webserver backed by a SQL 2005 server. The sharepoint server has a messed up document in a document library and I have a SQL database backup from the day before. What are my ...
0
votes
1answer
12 views

Deal with dashes and spaces in T-SQL String functions

I am searching for the occurrence of a string in a field on a table. The search statement is done through dynamic sql with my statement template looking like this. SET @sSQL = 'UPDATE ...
0
votes
2answers
21 views

Script out SQL Job Create Statement Without SSMS

Does anyone have an idea of how to generate the Create statement for a SQL Agent Job? I've looked everywhere, and I can't seem to find a search result that doesn't involve using SSMS and going ...
0
votes
1answer
859 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
votes
0answers
8 views

SQL Insert Statement Persists Two Records When I Need Just One

I have altered it to include hardcoded variables when I pulled this chunk of code from the stored procedure. I ran it independent of the application with the same result. I need one insert statement ...
0
votes
0answers
9 views

SQL Client failing SSL certificate encryption under a AD Domain

I have a client machine (web server) that is attempting to connect to a SQL server. The SQL server is 2008 and has the force encryption flag turned on. Both servers are joined to the domain. The ...
1
vote
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 ...
0
votes
1answer
788 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
882 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 ...
3
votes
1answer
1k views

SQL Server 2008 R2 cluster, “available storage” shows “offline”

I've installed a SQL Server 2008 R2 cluster and I found the resource group "available storage" shows "offline" status. What does it mean? It seems I can't take it online. I tried to use the cluster ...
0
votes
1answer
1k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
0
votes
0answers
11 views

SQL Reporting Denying Access to User After Move to New Group

We have a SQL Server 2008 server setup with reporting services so that users can log in and run certain reports. I have a user that was granted browse permissions to this as we had their initial ...
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 ...
0
votes
1answer
886 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 ...
15
votes
3answers
16k views

Database 'XXX' is in transition. Try the statement later

im trying to connect to a sql server database i get this error Database 'XXX' is in transition. Try the statement later. i cancelled a long query earlier today but for some reason i can't get the ...
0
votes
1answer
34 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
1k views

How quickly will SQL Server release RAM when the OS signals a low memory condition?

From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical ...
1
vote
2answers
64 views

omd nagios monitoring servicestate mssql / Failed to open service

I'm trying to monitor mssql service in OMD nagios, but with no success so far. Communication port: 1433 instance name is like: MSSQL$instance Here's my check: check_command check_nt!SERVICESTATE!-l ...
1
vote
0answers
18 views

Why does ADFS have too many SQL connections open?

I'm running ADFS 2.0 in Windows 2008r2, connected to a SQL Server 2005 database server. Right now the ADFS server has 5623 TCP connections open to the SQL server (checked via netstat - counted with ...
0
votes
1answer
70 views

How to setup opserver monitoring by stack exchange?

I'm having trouble understanding how to configure and install opserver project by stack exchange guys. Have anyone configure/install it? I wanting to use it only for MS SQL Servers and maybe i will ...
4
votes
5answers
2k views

How do you configure a MS SQL Server to prevent exposing all database names and logins to any authenticated user?

I'm new to MS SQL and asking this question as a web developer with limited sysadmin experience who desires his service providers to use best practices. We have one database on a remote MS SQL server ...
-1
votes
0answers
39 views

Database Recovery Stuck on “Restoring” [migrated]

Scenario: Sql Server Database routinely backed up with Backup Statement below. The "Recovery Model" was set to "Full" (we usually have them set to "Simple"). The ldf file, which had gotten quite ...
3
votes
2answers
51 views

sql azure vs azure VM with SQLServer Express

Beside beeing cheaper is there any problem/advantages to use SQL Azure vs to use a VM with SQL Express? We are looking to setup a SQL server for more than 50 websites, do you have any ...
3
votes
8answers
5k views

SQL Server 08 Express error when connecting to localhost - “Timeout expired”. Works with ::1 or 127.0.0.1

EDIT New info: Navigating to localhost:1434 in Chrome gives me an "ERR_EMPTY_RESPONSE", while other ports give me an "Oops! This link appears to be broken". So it seems to binding ok there? So ...
0
votes
1answer
18 views

Execute Trigger as Login

Is it possible to impersonate a login when running a trigger? I able able to run execute as 'username' but not execute as login='username' I can usee execute as as such with EXECUTE AS login='smr' ...
1
vote
2answers
1k 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
20 views

How to re-create the symmetric key on Amazon RDS

We have some column encrypted by symmetric key. Now we want to upload our database to Amazon RDS (SQL Server). Can we do that? If yes, how?
0
votes
1answer
803 views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
2
votes
1answer
1k views

WSS Search fills 10 GB limit on SBS server 2011

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most. I've just started getting the following ...
-1
votes
0answers
8 views

Last mod user of a stored procedure

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

Password Manager Pro backend database MS SQL vs PostgreSQL [closed]

I'm looking to manage users passwords through the programme Password Manager Pro. Reading the documentation it explains that you can use ether your own MS SQL database or use their default PostgreSQL ...
1
vote
1answer
762 views

SQL Server: “This filegroup cannot be used as a backup destination” error when attempting restore

When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. ...
0
votes
1answer
1k views

Can't connect on an SQL Server 2012 named instance on a second computer on the network

Both computer have Windows 7 but i can't connect from one computer to the other where SQL Server 2012 Express is installed. EDIT: This is a local network. Ive opened up the program on the firewall ...
4
votes
1answer
912 views

netlogon errors

I have two instances of mssql 2005 and am using CA XOSoft replication. The master is a failover cluster and the replica is a standalone server. They are all running Server 2003 sp2 x64. Same patch ...
0
votes
2answers
30 views

MSSQL-Server: rebuild vs reorganize Index and Update Statistics

We had a database which was very slow (MS SQL SERVER). Now we figured out, that the indexes were never rebuild oder reorganised. (At the moment it is not clear if this really was the problem but we ...
2
votes
3answers
6k views

DBCC CheckDB The operating system returned error 21(The device is not ready.)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S***d\NewAdvWorks.mdf'. Additional messages in the SQL ...
1
vote
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
0
votes
1answer
2k views

How to get php_mssql.dll working properly on IIS 7.5 and PHP version 5.2.17?

First of all I'll give a very brief introduction of what I'm trying to make. I need the mssql php functions to work on the webserver. I know that such functions were deprecated in PHP 5.3 and above. ...
-2
votes
1answer
19 views

Install SQL Express 2005 over 2012

I have a Amazon EC2 Windows 2012 with SQL Server Express 2012, but I need SQL server 2005, What I need to do to get it done? Thank you
1
vote
1answer
800 views

SharePoint 2010 Server Configuration Error -> “Cannot connect to database master”

I recieve the following error when I try to configure SharePoint 2010 Server: "Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current ...
0
votes
1answer
25 views

SQL Server 2012 Express - silent installation.

I am failing to silently install SQL Server 2012 Express (Advanced). I followed the guidance and this is my command: Setup.exe /q /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER ...
0
votes
1answer
318 views

WSUS won't apply SQL Server update

I have a SQL Server 2008 R2 SP1 machine and I want to apply KB2716440 to it from Microsoft bulletin MS12-070 using WSUS. I have placed two nodes in a cluster into a group called Dev. I have approved ...
1
vote
1answer
2k views

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

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 make ...
2
votes
2answers
3k views

How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

I am in serious trouble and I am seeking professional advices here. We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
0
votes
2answers
37 views

SQL Server Transaction Log maximum file size

I have several databases, all in Simple recovery mode. There have been previous concerns about the log file sizes and I have shrunk them all using Management Studio's Shrink task. I have also placed a ...