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)

1
vote
0answers
7 views

How do I determine the spid of the session that is making a query on a linked server? [migrated]

I have a session running on a SQL Server instance that is blocking other sessions (holding on to a lock without releasing it). Querying sys.sysprocesses yielded the hostname of a different SQL Server ...
0
votes
1answer
38 views

How to upgrade a MSSQL Server?

As we were updating a service on an older enviroment, we experienced compartibility issues because the service we were updating is working with MSSQL Server 2008+ only. Now we have the issue that we ...
0
votes
0answers
17 views

MS Excel error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied [on hold]

Hi I am trying to connect to SQL Server on another machine using Data >> Other Source >> SQL Server. I have given IP Address of server in Server Name: and Username and Password. But it is giving ...
2
votes
1answer
46 views

Azure IO performance sql server [duplicate]

We are in the process of migrating our on-premises sql server to Azure and I am having trouble with the IO performance. I have created a new D14 instance and attached 16 virtual disks at 100GB in ...
-1
votes
0answers
11 views

Can I change a trial sql server 2012 install into an ISV one? [duplicate]

I have a server where the company which sells ERP wants to install the ISV SQL Server 2012. I'd like to prepare everything before they come, even install SQL Server 2012, but I can only install it as ...
-2
votes
0answers
8 views

Extracting Data from multiple archive tables(SQL Server) [migrated]

I am developing a report in report builder 3.0 where i am extracting data from a table dbo.odcalls. now the problem is this table is archived on monthly basis on a seperate database(HN_Backup) and i ...
-1
votes
1answer
24 views

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which ...
-2
votes
3answers
49 views

SSDs for MS SQL Server 2008: slc or mlc: what is expected life for mlc? [closed]

Until recently, Dell et all would only provide slc drives for servers. It appears the winds have shifted and now the cheaper mlc drives are avail for servers. In a sql environment, will mlc give ...
2
votes
1answer
28 views

Will SQL Server Express do in this specific situation

I'm doing research on the best suitable database for an in-house web application for our (non-IT) company. It's a web information system with few database-heavy tasks. Users can add new customer ...
1
vote
3answers
44 views

Migrating Mssql databases from different instances to a new server

I have 3 instances of Sql (2008 R2) on 3 different servers. The versions are (10.50.2550.0 SP1 Standard Edition (64-bit), 10.50.2550.0 SP1 Standard Edition (64-bit)). The goal is to migrate all the ...
2
votes
1answer
32 views

IIS 7.5 web application failing with NT Authority\Anonymous Logon

I am finding various google results, but none seem to fix my problem. I am setting up a new WINDOWS 2008 R2 box at work that is to communicate with an existing SQL 2012 box via web tools running in ...
1
vote
1answer
31 views

SQL Express Reporting Server 2014

I have a problem getting my SQL SSRS service working. Version: SQL Express 2014 When I try to start SQL SSRS in services, the service starts, but looking at the event viewer it fails to connect to ...
-1
votes
0answers
21 views

What server config I need to answer 600k request in every 15 minutes for 300 SQL Server database [duplicate]

I will have 300 SQL Server databases on my machine that must answer 600000 request every 15 minutes. This server has a valid IP address and all request come from internet channel. for now I have a ...
0
votes
0answers
13 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
0
votes
1answer
13 views

SQL BCP Permission needed?

Need to check a permission level, a user needs bulk insert\update\delete permission. If I add them to "BulkAdmin" server role, will this be enough? (Running SQL 2012)
1
vote
2answers
53 views

SQL Management Studio Can't Connect to Database---Microsoft fixes failed

I just installed MS SQL Server 2014 a couple days ago and it was working fine until today. I attempted to connect using the Object Viewer and I got the error message Cannot Connect to MyserverName. ...
1
vote
3answers
35 views

SQL Server 2012 SP1 transaction log getting full?

One of my DBs is having a problem with the transaction log filling up. It's set to full recovery and is regularly being backup via maintenance plan. I have a full DB backup every weekend then daily ...
0
votes
1answer
7 views

FIM2010 R2 SP1 service account requirements on database after installation

We're in the process of updating our Forefront Identity Manager to 2010 R2 SP1. The SQL Server instance for the old installation has the FIM service account in the sysadmin role, as is required for ...
-4
votes
1answer
29 views

Setup network between 2 computers connected using wifi [closed]

In my office I have a WiFi Router that allows 2 computers to connect to Internet. I have 2 questions - How can I create a network between these 2 computers for file sharing? Can I access SQL server ...
0
votes
0answers
20 views

MS SQL driver (Azure SQL) for PHP running on an Azure Website?

I am at my wits end. I've been googling this and all I get is 2010 blog posts that unfortunately do not appear to work today. I am trying to set up PHPBB on an Azure Website which uses the MS ...
0
votes
0answers
16 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
1
vote
1answer
52 views

SQL Server 2008 local connection an error occurred during the pre-login handshake

I am getting an error while trying to connect to SQL locally either via a web application or SQL management Studio. Oddly, I can connect fine remotely via apps on other servers or SQL management on my ...
1
vote
2answers
28 views

Configuring PHP and WikiMedia to use Microsoft Sql Server?

I have PHP 5.6 x86 installed on Windows 7 to C:\PHP. IIS is successfully running PHP and MediaWiki when it's configured to use MariaDB. I'm trying to get it to work with MS SQL Server and it's not ...
3
votes
1answer
76 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
0
votes
0answers
33 views

Network connection from old application to SQL Server 2008 R2 lost once in a while

We are trying to migrate an Axapta 2.5 database from SQL Server 2000 to 2008 R2. We are testing performance etc. on the new server, but once in a while, these two events are thrown on the Axapta ...
1
vote
1answer
39 views

SQL Server 2012 and 2014 memory limits

We're in the process of building a new server with 128GB of RAM. We would like to utilise as much of this as possible and my understanding is that 2008, 2008R2 and 2012 (all STANDARD) are all limited ...
2
votes
1answer
51 views

Find Full or Differential backup from .bak (with powershell or by any other means)

I'm trying to determine whether an MS SQL backup file (.bak) is Full or Differential. Is there an easy way to do this? A way of doing this in powershell?
0
votes
1answer
40 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
0
votes
0answers
57 views

Volume Shadow Copy Service error: Unexpected error calling routine XML document is too long. hr = 0x80070018

I have about 1400 SQL databases on my environment (on 3 different volumes). I've got follow errors during taking VSS snap. Also SQLWriter goes from stable to failed "nonretryable" *Event ID 8193, ...
0
votes
2answers
51 views

Microsoft SQL Server Data Limit

I am using a Microft SQL Express edition server limited to 10GB/database. The original database runs on a licenced server and it is ~15GB. I was given a small part of this database (last couple years ...
0
votes
0answers
21 views

Password change to SQL user and SQL Agent user broke mail agent

We changed the passwords on the accounts which the SQL Server service and the SQL Server Agent use to log in. Both seem to be mostly working fine, however the mail agent is now having problems. It is ...
1
vote
1answer
47 views

Cannot start the T-SQL debugger when logged into a remote server via SSMS

Background information SQL Server 2012 on Windows Server 2012 Connecting to server remotely using SSMS The user I am using is in the sysadmin role Able to log in with SSMS and run queries without ...
0
votes
1answer
79 views

Exporting a Subset of Data in Microsoft SQL Server to Script

We are running a Microsoft 2012 SQL Server and are looking at a way to dump a subset of data (based on queries) to .sql scripts we could then run on another server to pull that data back in. We have ...
1
vote
0answers
35 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
122 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 ...
0
votes
0answers
23 views

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
39 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
21 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
34 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
26 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
55 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 ...
13
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
87 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
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
33 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
15 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
427 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
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
224 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 ...