Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-...

learn more… | top users | synonyms

1
vote
0answers
40 views

Presenting relationship of rows in SQL Server

I have two tables named FORM and FORMACTION. The rows in FORM represent screens in a CRM system and FORMACTION represents which FORMs lead to which. e.g. FORM ID,NAME,LNAME 1,"CustomerD","Enter ...
0
votes
1answer
35 views

Is there a database that speaks pure SQL?

My understanding is that SQL is the standardized basic framework for quite a variety of different SQL flavors like MS SQL, MySQL, PostgreSQL, ... But all of these different flavors introduce a ...
0
votes
1answer
243 views

Can't install SQL server 2008 or SQL Server 2014

When I try to run the SQL SERVER 2008 setup, it shows the following error and exits: SQL Server Setup has encountered the following error: Unable to cast object of type 'System....
0
votes
1answer
360 views

Connecting to SQL Server on AWS RDS

I have an SQL Server running on an AWS RDS Instance. I can connect fine using SQL SMgr on my local machine but I get an error message from an application I run on my local machine which needs to ...
2
votes
1answer
69 views

How to put Windows Server into something like “Standby mode” so I can safely pull the plug off of it?

I have an interesting problem - we are going to test our UPS backup system by pulling the plug in our server room for a short time. Ideally the UPS will kick in and nothing interesting will happen, ...
1
vote
0answers
78 views

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

Normally there's a version number in there:
0
votes
1answer
21 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
1answer
3k views

Why can't I connect to my local SQL Server Express (2014)?

After I installed Microsoft SQL Server Express (2014) on my local computer (for testing while building a web interface which uses databases), I could connect just fine, but for some random reason, now ...
1
vote
1answer
377 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: ...
2
votes
0answers
675 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. ...
-1
votes
2answers
342 views

Is SQL Express pre-installed in Windows?

In Windows 7, 8 and 10, is there any SQL Server Express Engine included already in the freshly installed OS? If yes, which version of SQL Express comes with each OS ? I'd like to create and ...
2
votes
0answers
226 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 ...
2
votes
1answer
98 views

Accessing a local SQL server 2014 from within a VM running vista using VS2005 fails

My laptop is running Win 7 (x64) and is part of a domain. I've installed SQL Server 2014 Dev and VS2012 on it as I want to use the laptop for development. Since some of my development has to be done ...
0
votes
1answer
149 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 "...
4
votes
3answers
178 views

How do I force an application to recognise two names for a disk drive?

I have an extensive image database (3.25GB metadata, 90K images) held in a legacy product (idImager V5). This in turn utilises SQL Server 2005 as the underlying DBMS. Over time, I have been adding ...
2
votes
1answer
1k views

Do I need SQL Server paths in my PATH environment variable for it to work?

SQL Server adds things to my PATH environment variable, and over time that bloat makes me hit the 2048-char limit in Windows 7. Do I really need them there for SQL Server to run? This is on a ...
2
votes
1answer
275 views

Windows 8.1 VPN connection to customer's network blocks access to local domain's shares, SQL Server [duplicate]

With Windows 7, I could access my company's Windows Server file shares and SQL Servers (with Windows authentication) from that same LAN while connected to my customer's VPN. With Windows 8.1, I lose ...
0
votes
1answer
190 views

How do I host the PostgreSQL server locally? It won't let me run as SuperUser, and it won't let me log out of SuperUser

I've spent all day working on a Database project to try and teach myself how to use SQL and PHP. When I finally went to go and try to host it, the command prompt kept closing really quickly. I took a ...
0
votes
1answer
331 views

Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[]. Is it possible to import these byte[] into Excel and convert them back into images? I already have a connection to the database in my Excel ...
6
votes
2answers
6k views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
1
vote
2answers
749 views

Why I can't see the users that I have created

I have created 4 users on Active Directory Users and Computer: But I can't see the users on my computer management under "local users and groups" nor on my sql server! So, why I does not have "local ...
1
vote
1answer
2k views

Cannot connect to sql server express over host-only virtualbox interface

I have set up sql server express 2014 in a Windows 7 virtualbox guest, but I cannot connect to it using the jTDS JDBC driver from my Ubuntu host. I get a Could not retrieve database information error. ...
0
votes
0answers
31 views

SQL Server 2012 change query result position [duplicate]

Traditionally in SQL Server while executing a query the result is displayed below the query dividing the screen horizontally. Is there any settings that can be done to displays the result to the side ...
1
vote
2answers
6k views

Unable to install SQL 2014

When I'm trying to install SQLEXPRADV_x64_ENU i got following error. SQL Server Setup has encountered the following error: There was an error generating the XML document. Error code ...
0
votes
1answer
56 views

What ports do I need to open for offshore to access our SQL Server db?

When using SSMS, for example, for connect to a SQL Server, I would specify the server name to which a wanted to connect as well as the Authentication method, in this case, Windows Authentication. If ...
1
vote
1answer
5k views

What is “NT AUTHORITY” and “NT SERVICE”

I can find many info on what is "NT AUTHORITY" slash "something". Same for "NT SERVICE". But not for the part before the slash. I run into them from time to time in my work. I might receive ...
2
votes
1answer
276 views

SSMSE version is suitable for MS SQL Server 2008 SP4 in Win 8

Can anybody know and provide the suitable version & download link of MS Management Studio for MS SQL Server 2008 SP 4 in win 8? Am downloaded the SQLManagementStudio_x64_ENU and when install it ...
1
vote
0answers
304 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 ...
2
votes
1answer
2k views

Connecting to host OS database from guest OS VirtualBox virtual machine

I’m using Pentaho BI server in a CentOS VirtualBox machine, and now I want to connect it to an SQL Server database that I am running in my Windows host OS (localhost). Is there a simple way to do ...
3
votes
1answer
10k views

Is it safe to uninstall MS SQL server from my PC?

My OS is Windows 7. When cleaning unnecessary sofrware from my computer I noticed that I have lots of SQL related programs installed. I don't know with what program thet came, I don't do anything SQL ...
1
vote
0answers
100 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 'E:\...
0
votes
1answer
71 views

SQL Server 2008 Backup to networked drive

When I go to backup a SQL database - I only see options to do the backup on a local disk. Is it possible to backup to a network drive directly?
5
votes
3answers
9k views

Windows 10 .NET 3.5 installation

I'm on build 9841 of Windows 10. I downloaded .NET 3.5 SP 1 full. I double click the installer but nothing happens. Is that .NET version not compatible with Windows 10? I need it to install SQL Server ...
1
vote
1answer
808 views

AdventureWorks 2014

I'm trying to restore the AdventureWorks2014.bak file. SQL Server is installed locally and the .bak is saved locally. I am using the instructions from https://www.youtube.com/watch?v=JhuDtvbpses. ...
0
votes
1answer
2k views

Reducing system disk space usage on computer with SQL Server

The disk usage on my computer continues to rising with time. How can reduce his size without damaging programs and windows. The disk is SSD with 180 GB, because of that this is sensitive to me ! ...
0
votes
1answer
345 views

Cannot connect to remote SQL Server with SQL Server Management Studio with Visual Studi

I'm developing a small app on my own and I am trying to install a database on a local machine that I will be using for development. So far I have done all of these things: Install SQL Server ...
0
votes
1answer
2k views

Excel does not import Guids (Unique Identifiers) when importing data using the “External Data” feature

When I try to use Excel 2013 to import External Data from a SQL Server Data Source, it does not import the Guids. The Query I'm using is: SELECT * FROM TABLENAME The table Structure is: ThingId ...
-1
votes
1answer
1k views

Unable to install SQL Server Express 2014 Management Studio

Unable to install SQL Server Express 2014 Management Studio on Windows 7/8.1 SQL Server 2012 is already installed on PC. Error is Same architecture installation - Failed No results in google search. ...
0
votes
1answer
842 views

Microsoft SQL Server 2008 R2 Installation Error

I am desperate for some help installing SQL Server 2008 R2. It came as part of a software package from Rockwell Automation for their FactoryTalk View Studio software. I had the whole package working ...
1
vote
0answers
287 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
2answers
782 views

Error is using Microsoft Query data in excel in 3rd Person's PC

I have a problem when using Microsoft Query in Excel Data Link. I have used SQL Server Connections before in Excel. When we use SQL Server, after doing the connection and retrieving the data, the ...
2
votes
1answer
2k views

Microsoft PHP SQL Server Drivers not working, cant load module

I am trying to install Drivers for PHP to be able to talk to my SQL Server. I am running PHP 5.5.15 on XAMPP, and SQL Server 2014. I downloaded a driver package from here: http://www.microsoft.com/en-...
0
votes
1answer
357 views

How does SQL Server deal with a missing tempDB?

Azure has announced the new "D" series of VM's where the temporary drive resides on a SSD I was planning to use this as the tempDB, it should speed up SQL somewhat with faster temoDB access. However,...
0
votes
0answers
1k 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
1answer
51 views

Sql Server 2012 Replication Report

We have about 30 users with local installs of SQL Server that have to replicate merge their local data once a month with a central SQL Server 2012 repository. Is there a SQL Server first-party or ...
1
vote
1answer
189 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 ...
0
votes
0answers
41 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
1answer
79 views

Silent, power saving mini-server for home [closed]

I am looking for hardware to make a small, silent, power saving mini-server for use at home. My specifications are: Small Fanless / Small fan Able to run Windows server OS Has 2GB of RAM, ideally ...
0
votes
1answer
2k views

Visual Studio 2013 + Business Intelligence SSDT and missing Reporting Server templates

The other day I have installed Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 (SSDT: Replacement for BIDS) and started using reporting features in VS2013. However, ...
0
votes
0answers
38 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 ...