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

1
vote
1answer
14 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
0answers
13 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
150 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 ...
-1
votes
0answers
26 views

Struggle to get SqlSrv to work on Windows 2012r2

I need to connect to a SQL Server database from PHP. I'm given a Windows 2012r2 machine and installed XAMPP on it and then continued to copy php_sqlsrv_56_nts.dll into php/ext and modified my php.ini ...
1
vote
1answer
41 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
54 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
0answers
8 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
18 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
1answer
26 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
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
8 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
1answer
50 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 ...
1
vote
2answers
106 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
32 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
122 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
30 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 ...
0
votes
2answers
53 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
29 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 ...
0
votes
0answers
57 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 ...
1
vote
1answer
66 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
33 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
72 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 ...
0
votes
0answers
7 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 ...
-3
votes
1answer
24 views

sql database errors 823. Can someone help me? [closed]

I have a question….How to fix sql database when generating an errors 823? Please help me to out this! Thanks
0
votes
0answers
66 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 ...
2
votes
1answer
63 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 ...
0
votes
1answer
99 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
39 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 ...
0
votes
0answers
45 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
19 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
47 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
1answer
24 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?
1
vote
1answer
290 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
213 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
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
138 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
27 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 ...
1
vote
1answer
591 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
0answers
21 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
1answer
135 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
314 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
427 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
0answers
14 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
1answer
285 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 ...
0
votes
0answers
73 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
140 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 ...
0
votes
0answers
40 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 ...
1
vote
1answer
612 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: ...
0
votes
1answer
98 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. ...
0
votes
0answers
328 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 ...