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)

3
votes
2answers
10k 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 ...
1
vote
2answers
302 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
761 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
28 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
35 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
0answers
15 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 ...
0
votes
0answers
16 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 ...
17
votes
3answers
18k 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
456 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 ...
1
vote
2answers
152 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
33 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
230 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 ...
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
29 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' ...
0
votes
1answer
21 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
37 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 ...
0
votes
1answer
2k 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 ...
0
votes
2answers
72 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
1answer
21 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
0
votes
1answer
47 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
342 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 ...
0
votes
2answers
238 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 ...
0
votes
1answer
107 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
0
votes
1answer
53 views

what happens to sql server if the active directory server goes down?

What happens to sql server if the active directory server goes down and the sql agent services is logged on as a windows user.
0
votes
1answer
657 views

sqlcmd is not recognised as an internal or external command, operable program or batch file SQL2014

I have written an installer that is supposed to install SQL Server Express 2014, create an instance, and then use sqlcmd to connect to the instance and build the database from a schema. It works by, ...
-2
votes
1answer
39 views

sql server 2005 on server 2003 slow performance [closed]

We are running a Windows Server 2003 r2 x64 with SQL Server 2005 (Production Server) on it. Our software provider usually access to our server to fix/update/add features to our systems ...
0
votes
2answers
2k views

SQL Server Database Access fails when User Granted Acess via Domain Group

On a SQL Server 2008 R2 (running on Win2003), we have an issue with logins via domain groups - login access is granted to the server instance, but cannot access certain databases on the server. The ...
0
votes
0answers
27 views

MSSQL High Availability Advice Required

I'm looking to implement a high availability SQL installation using MSSQL2012 or 2014 and there is 1 part of this I'm not sure about. I plan to have a SQL cluster at site a, and a secondary SQL ...
0
votes
1answer
52 views

How to view the SQL Server transaction log on AWS RDS?

Is it possible to see the T-SQL Query log in AWS RDS? is there a UI for that in the console, or i need to use the CLI or SQL Management Studio?
0
votes
2answers
23 views

How to view datetime when a SQL Server DB was created?

I need to see when a Database was created in SQL Server, and who created it if possible. Is there a command to get that data?
0
votes
3answers
62 views

Sql server transaction timeout

Is there any parameter to prevent long transactions? I would like to automatically rollback all transaction that takes more than 5 minutes. Is it possibile? I'm working on a Microsoft SQL server 2008 ...
1
vote
1answer
47 views

Find out who installed SQL server - they forgot to add other logons

We have a site where one of our team of techies installed SQL Server 2012. They forgot to add our administrators group as sysadmins so only they can access SQL - everyone else gets "Access Denied" ...
2
votes
1answer
219 views

Error on CMDEXEC job step even with proxy account defined

I’m not yet used to managing permissions on SQL Server 2008. I’m currently trying to create a SQL Server job directly from SQL with a user that isn’t sysadmin (but has the role SQLAgentUserRole). ...
0
votes
0answers
168 views

Actual minimum RAM usage of Windows 2012 Server + IIS + SQL Server 2014 Express + .NET application server

I currently have a physical server running Windows Server 2008 R2. I am planning to replace it with a cloud-hosted virtual machine running Windows Server 2012. The server needs IIS, SQL Server Express ...
0
votes
2answers
241 views

Can't connect to my AWS EC2

I have an AWS server (MS SQL SERVER EXPRESS 2008 R2 with IIS), with an elastic IP of 54.214.8.111, security groups configured with HTTP, MS SQL and FTP, and I can connect to the remote virtual machine ...
1
vote
0answers
229 views

Kerberos Configuration Manager for SQL Server error “unable to access user principal information from the system”

When I launch the Kerberos Configuration Manager for SQL Server and try to connect to the local machine it's on, I am getting the error "Kerberos Configuration Manager for SQL Server error "unable to ...
0
votes
1answer
25 views

MS-SQL Server Implicit_transaction on table

I'm trying to experiment with implicit_transaction on sql server. However, after executing: SET IMPLICIT_TRANSACTIONS ON; INSERT INTO [Interface].[dbo].[Log] ([String], [Time], [theUser]) VALUES ...
0
votes
1answer
40 views

What are the performance issues in SQL for single schema and multiple schema?

I have a critical performance scenario that, I have to use more than 100 schema in a database. Each schema having more than 50 tables and few views. I need to use join queries for communicating ...
0
votes
2answers
197 views

Configure Apache to use SQL Server authentication

I believe it's possible to configure Apache to use SQL Server for authentication. You supply the DB connection parameters and a query to run. I suppose the contract is something like: If the query ...
-2
votes
1answer
33 views

Does SQL Server Enterprise edition contain all the components that Business Intelligence edition has? [closed]

Are there any missing components that are available in BI edition but not in Enterprise edition?
0
votes
2answers
293 views

IIS Express, SQL Express as production server

Can Microsoft's IIS Express and SQL Express servers be implemented for a small web application in production environment? What is the limitation of them?
0
votes
0answers
19 views

Password expiration in SQL/ODBC before AD

I have a script that emails users that their password expires in X days. Today a user got an alert that her password expires in 8 days. She was having problems with Excel and Access databases that ...
1
vote
1answer
52 views

Databbase file structure on disk [closed]

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most ...
1
vote
1answer
60 views

What maintenance tasks should I run on my MS-SQL 2008/2012 servers?

The servers are using database mirroring for high-availability running SQL server standard on newer hardware. The existing plans were setup by a DBA many years ago and are using the built in ...
0
votes
2answers
1k views

Cannot access local database with IIS Manager

I've created a local .mdf database with Visual Studio 2010 and did a couple of modifications to it. Now I want to edit it in IIS Manager. However, I cannot access it neither by connection string, nor ...
0
votes
1answer
2k views

Can't connect to Windows Internal Database with SQL Server Management Studio 2012

I'm trying to connect using the following connection string, and Windows Authentication (Trying both to log in using the Administrator account, and the account I used when setting up the SQL Server ...
0
votes
1answer
101 views

Sql Server 2012 Disk I/O Too high

I am running SQL Server 2012 on windows azure VM Windows server 2012. This is a live Database, about 250GB, with high usage. I applied some best practice articles for the temp-db long ago, and also ...
0
votes
1answer
49 views

How to run validate cluster test without taking cluster offline?

I'm trying to run "Validate a Cluster" wizard but when I selected Run all test it gave a warning that running storage test will result in role failure. What test can I run in Run only tests I select ...
3
votes
4answers
664 views

Windows SQL Server Cluster Failover Without Disruption

Is MS SQL server clustering capable of performing a seamless fail over between nodes? That is, where the clients wouldn't notice anything had changed except perhaps a short delay during the ...