The MS SQL Server is a database management relational database created by Microsoft in partnership with Sybase in 1988 and inserted as a complementary product to Windows NT. Tag questions specific to a version with [sql-server-2012], [sql-server-2008], etc.

learn more… | top users | synonyms

2
votes
0answers
80 views

Getting error (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY) when migrating from MS Access 2013 to SQL Server 2014

OK.... I've checked and rechecked Google, StackFault, Experts-Exchange, etc... for a resolution on this error and they all say to register the DAO360.DLL and add its path to the environment settings. ...
2
votes
0answers
317 views

Access losing db connections

I have a weird problem going on at work. People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
1
vote
0answers
11 views

Why is sql server native client version “not marked” in odbc data source administrator?

Normally there's a version number in there:
1
vote
0answers
132 views

Connect to SQL Server. Error 26 : the type initializer threw an exception: error locating server instance specified

I have a SQL Server 2014 Express installation. It is configured for Remote connections TCP is activated mixed mode Authentications are allowed and the server firewall is deactivated My program ...
1
vote
0answers
43 views

Cannot install SQL Server 2012

I'm trying to install SQL Server 2012 and got this message: SQL Server Setup has encountered the following error: The resource 'Microsoft.SQL.Chainer.PackageData.Package.xml' failed to load from ...
1
vote
0answers
80 views

Missing arguments in SQL 2012 command line installation

I am new to SQL installation through command line. We are developing an application and using Installation Shield. I need to install SQL server on clients pc, so I am using command line silent ...
1
vote
0answers
603 views

SQL Server 2008 R2 - Process 6 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

I am running Microsoft SQL Server 2008 R2 (SP2) - 10.50.4302.0 (X64) (Latest CU11, Feb 2014) on Windows Server 2012 R2. I have a simple database and a website that runs on the same machine using IIS. ...
1
vote
0answers
68 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
1
vote
0answers
362 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
1
vote
0answers
39 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
1
vote
0answers
225 views

How to set up Openfire XMPP server?

I have installed Openfire and Microsoft Sql Server Management Studio 2102 on my PC. I have made a database called openfire, conected to it, and have executed the script called openfire_sqlserver.sql ...
1
vote
0answers
137 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
1
vote
0answers
390 views

Change language of error messages in Windows 7 x64

My Windows 7 installation had Russian localization. When I encountered errors, I thought to translate the errors to Google into English. I decided to change the display language to English. In ...
1
vote
0answers
253 views

View numeric columns in hex - SQL Server Management Studio

In SQL Server Management Studio, when I run a query which outputs a numeric column (int or similar types), they are displayed in decimal (example: 193). I want them to display in hex (example: 0xC1). ...
1
vote
0answers
48 views

Visual Studio 2010 DON'T CLEAR Query if doesn't succed or syntax error

In VS2010 when you perform a query against database if the query itself has any syntax error the VS by default clears all text from screen. This makes you to type again the text and resolve syntax. ...
1
vote
0answers
161 views

Errors while installing SQL Server SSIS 2005

I was trying to use SQL Server SSIS 2005 for the first time and mysteriously all the SQL SSIS menu items were missing from my start menu and then from the BIDS project choices even though I did a full ...
0
votes
0answers
13 views

performance issues with virtual Win 7 box running unattended WCF/MQ application

We have a virtual Windows 7 box running an (unattended) app (written in c#, using WCF 2) that connects to the iSeries Websphere MQ, retrieves messages then sends them to an external service provider ...
0
votes
0answers
8 views

Search views in multiple MS SQL databases for use of Order BY and record which view uses it

In the process of migrating over some old databases to new servers, we know that some views in some databases might be using an ORDER BY, but we're unsure which / where. We'd like to record which ...
0
votes
0answers
56 views

Installation error while Installing SQL Server 2014 Standard Edition

I have tried to install Microsoft SQL Server 2014 Standard Edition and it is giving the error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: ...
0
votes
0answers
24 views

Error installing SQL Server

Yesterday I installed SQL Server 2014 onto a Win2012 server that has already SQL Express 2014 installed. I uninstalled/reinstalled it three times, but to no avail: The server wouldn't start after ...
0
votes
0answers
25 views

localdb gives random pipe connection string everytime starts up

I am using Entity Framework 6.1 and Visual Studio 2013. By default, EF produces "MSSqlLocaldb" as data source in app.config. In development, from time to time I have to run SQL query on the entity ...
0
votes
0answers
24 views

Dynamic field names in Excel queries

As explained here, Excel queries accept dynamic values (e.g. "where name = ?" and "?" can be linked to a cell of your choice). Alas, Excel queries don't seem to accept dynamic field names (e.g. the ...
0
votes
0answers
9 views

How can I catch in logs SQL server failover switched to other node

Hi I want to be notified if SQL Server makes a failover and switches active nodes either if someone switched it or there is a real problem. Our monitoring tool can read windows event logs but I don't ...
0
votes
0answers
37 views

Unable to connect SQL Server 2014 (time out)

I have followed this method (https://www.youtube.com/watch?v=VOUDdUJ5BLY) to set up my SQL Server on my computer A. My Computer B is able to connect to the SQL Server with my public IP within the same ...
0
votes
0answers
7 views

SSMS file tree does not match file tree on drive

I'm trying to add a database to my SQL server using a .mdf file, but the filetree displayed by SSMS does not reflect the filetree on my C drive, so I cannot locate my .mdf file when I try to add the ...
0
votes
0answers
13 views

Password issue for Access db in SAP BI

It is little bit complicated system so let me do it in points: We have SQL server 2005 database that is accessed by multiple programs. We have Access 2013 database that works as front end for ...
0
votes
0answers
175 views

Windows Integrated on IIS with SQL server on different computer

I need to deploy an intranet application on IIS 7.5 that can connect to a SQL server on a different computer with the user identity. The user must use its Identity to connect to SQL Server. I ...
0
votes
0answers
11 views

Can I install SQL Server 2012 Evaluation where SQL Server Express is currently installed?

I'm currently using SQL Server Express on my local machine, but I need to install SQL Server 2012 to be able to use the SQL Server Agent. Will this create a conflict on my machine or I can safely do ...
0
votes
0answers
86 views

Installing Cortana on a windows server

Is it possible to install Cortana on Windows server? The concept is this: Installing cortana on windows server Send commands from raspberry pi to cortana server to be analyzed Sending the data back ...
0
votes
0answers
69 views

ETL Processing in azure

Reading the azure documentation, an Azure VM could reboot once every 3 months to install updates. If I was executing an SSIS ETL job at the time, I presume this would cause the job to fail and require ...
0
votes
0answers
24 views

Copy SQL Server database with full transaction log

I have full SQL server transaction log on one server and one database (full recovery model) that I unfortunately don't have direct access to the database. Something in the software is filling up the ...
0
votes
0answers
87 views

Unable to Install VS 2013 Integration Services Project from SQL Server Data Tools

I am walking through the SSIS Tutorial and have installed the SQL Server Data Tools for Visual Studio 2013, however the only SQL Server project template that gets added is SQL Server Database Project. ...
0
votes
0answers
19 views

Accessing locally stored external data

I have an excel file that has an external connection in it to a SQL server DB. The external data from the last refresh is stored in Excel somewhere as i can create new pivot tables from that data set ...
0
votes
0answers
194 views

Collation error when creating collection in Visual Studio Team Foundation server

I installed Visual Studio Team Foundation server v2010. I configured using the TFS Basic configuration wizard. It was successful. I tried to create the first collection , but there was a error ...... ...
0
votes
0answers
28 views

Weird SQL Time and Date exception in Windows

OS: Windows - Environment: MySQL I am facing a weird problem (for me at least), I was running some tests on database activities, the full scenario is like this: I have two Java programs manipulating ...
0
votes
0answers
28 views

SQL Server Witness Server Alternative

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 ...
0
votes
0answers
17 views

Why do I have to provide the port to connect to my SQL Express server?

I'm playing around with puppet and vagrant. As part of that I installed SQL Express in a Virtualbox using vagrant. That worked just fine, but for some reason I have to specify the port number in the ...
0
votes
0answers
101 views

Setting up SQL Express on Azure VM

I'm trying to set up SQL express on an Azure VM. I already have SSMS 2012 installed but I cannot access .\SQLEXPRESS. This MSDN discussion says: run powershell script "ConfigureSQLExpress.ps1" ...
0
votes
0answers
48 views

unable to access network share and cannot access sql server on windows 8 over vpn

I was wondering if anyone has any tips on this issue I am having. I am running windows 8 and I basically have setup VPN exactly the same as how I have it setup on windows 7. But for some reason over ...
0
votes
0answers
430 views

OpenFire connect to SQL Server Database: Network error IOException: Connection refused

I am trying to get OpenFire to run with my SQL Server. I am following the instructions at Instructions. I have created a new database, named it OpenFireDB, and have created a new login and user, both ...
0
votes
0answers
34 views

If MSSQL machine is maxed out on resources, can it drop off the network and become un-pingable?

The issue is that our SQL machine will just disappear from the network with request timed out when I attempt to ping it. I have to deal with an "IT Guy" who is telling me that it is because Microsoft ...
0
votes
0answers
34 views

Change SQL server back to a trial

I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial. What are the steps to do this? REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
0
votes
0answers
45 views

Microsoft SQL: dealing with invalidated databases

I created a Microsoft SQL Server database that has now changed location. (The details are probably unimportant, but for the curious, I originally created it in a folder on an external drive mapped to ...
0
votes
0answers
40 views

SQL Server Error

I am getting the following error: Executing (Error) Messages Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Base Unit of Measure " returned status value ...
0
votes
0answers
95 views

Equivalent to VirtualBox Oracle dev environment available for SQL Server?

Oracle has this wonderful option in VirtualBox where you can download a virtual Linux machine that is setup with SQL tools and a running instance of Oracle. This setup makes it much easier to test or ...
0
votes
0answers
13 views

Business Intelligence for VS2013

I have a small dilemma/issue right here, I've installed this http://www.microsoft.com/en-us/download/confirmation.aspx?id=42313 in order to use Reporting Services with my SQL Server 2014, but when I ...
0
votes
0answers
15 views

Unable to restore testcase database of quality center 9.2

We are using quality center 9.2 for storing test cases. Recently the Quality center server had some issues, so we took back up of entire C drive and formatted the PC and installed OS newly. Now we ...
0
votes
0answers
446 views

Unable to uninstall SQL Server 2008 R2 on Windows 7

I'm trying to uninstall SQL Server 2008 R2 on a Windows 7 machine. I keep getting this error message: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\sqlcab.dll ...
0
votes
0answers
153 views

SQL Server 2008 (64-bit)

I have transaction log backup failures randomly. SQL Server Log says: Memory constraints resulted reduced backup/restore buffer sizes. Proceding with 6 buffers of size 64KB.', and the SQL Server ...
0
votes
0answers
325 views

SQL Server 2005 Express connection

On my computer I had installed Windows XP Service Pack 2. Then I installed Visual Studio 2008 SP1 and then SQL Server 2008 r2 and SQL Server 2005 Express. Up to that I had no problem using SQL Server ...