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
0answers
86 views

How many MSDTC clustered services (if any) are needed for a multiple-instance SQL Server 2012 cluster?

I'm creating a new SQL Server 2012 cluster, running on 2 physical nodes (the O.S. is Windows Server 2012 R2); the cluster will host multiple SQL Server instances; the exact number is yet to be ...
3
votes
3answers
559 views

Is there an alternative to xp_cmdshell and net use for backing up MSSQL to UNC as a different user

Is there an alternative to xp_cmdshell and net use for backing up MSSQL to a UNC with a different user? I'm now using EXEC xp_cmdshell 'net use \\SERVER\SHARE Password /USER:DOMAIN\USER ...
1
vote
1answer
64 views
+50

Change SSL Protocol in MSSQL 2012

Is there a way to change the SSL Protocol support in MSSQL express 2012 on windows 2008R2 ? I want to change the protocol from SSL3 to TLS (1.0,1.1,1.2), after hours of looking I cant find ...
0
votes
1answer
44 views

Securing Webserver and Database

I need to secure an internal web server and sql db, that is going to be made public(www) At this stage im only looking to provide a reasonable amount of security($$) until it gets bigger at which ...
0
votes
2answers
31 views

How to tell what process in SQL is making up the Processor Time reported in Activity Monitor

In SQL Activity Monitor, I see a constant 35% to 40% CPU usage in the Processor Time scrolling graph. How can I tell what Processes within SQL are responsible for that CPU usage?
1
vote
1answer
69 views

How to set up an authentication system to authenticate users against an existing SQL Server database

I have a pre-existing SQL Server database with login information (user names, password hashes) for thousands of users maintained by an ASP.NET website. I would like to provide an authentication ...
0
votes
0answers
72 views

Biztalk 2010 BAM on SQL Server 2014

While running Biztalk 2010 Configuration targeting my local PC with MS SQL Server 2014, the BAM Tools indicate that it is unable to find "Microsoft SQL Server 2008 SP1 or later" on the machine. I've ...
0
votes
1answer
382 views

Easy way to alias the default SQL Server instance to a named instance?

I have SQL Server Express installed on my machine as the default instance. "server=.;database=...." I'm now working with a new client where their config files are all checked into the repository. They ...
12
votes
9answers
3k 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
102 views

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

Desription of problem changed : how to make sure, that my Hyper-V is using all my hardware resources, and if it is using, what is the bottleneck of the system, when discovering performance issues? - ...
0
votes
1answer
118 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
69 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
22 views

Unable to view SQL Server Agent while logged in as user

I apologize for asking with insufficient information. I have granted SQLAgentUserRole permission to one of the user in SQL server on msdb database, but when user login in to SSMS using his ...
0
votes
0answers
28 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
30 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
1k 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
0answers
53 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
458 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 ...
1
vote
2answers
412 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
1answer
93 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
27 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
63 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
2answers
300 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
25 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
94 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
2answers
975 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
71 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.
-2
votes
1answer
53 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
1answer
366 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
0answers
28 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
109 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
29 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
363 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 ...
2
votes
1answer
564 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). ...
1
vote
1answer
72 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" ...
0
votes
0answers
323 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
0answers
10 views

Connect to Cube without using Windows account

Is it possible to connect to OLAP Cube (SQL Server) without using Windows account. Currently, I need to be on the same domain in order to connect to a cube. Are there any other solutions?
5
votes
3answers
1k 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 ...
0
votes
1answer
55 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
53 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 ...
1
vote
0answers
473 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
0answers
37 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 ...
-2
votes
1answer
36 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?
1
vote
1answer
56 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
107 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
1answer
208 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
117 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 ...
-1
votes
1answer
66 views

Will an average PC run a 10 concurrent write intensive request with 50MB daily database server? [closed]

As I am a average programmer who have never been purchasing any hardware myself, I have to choose a computer for a prototype database server that will be used to serve 10 concurrent request per one ...
0
votes
0answers
93 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
0
votes
1answer
117 views

Windows server and ddns which binding and sql hostname do i use?

i'm trying to connect to websites on this server from outside the network. i've opened ports in router and firewall and can ping the ports using portchecker. let's pretend i want to use wordpress or ...