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], ...

learn more… | top users | synonyms

2
votes
1answer
251 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
172 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
270 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
4k 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
546 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
1k 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
4k 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
53 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
3k 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
252 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
286 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
1k 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
8k 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
93 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
1answer
66 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
8k 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
755 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
1k 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
305 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
1k 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
750 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
265 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
657 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: ...
0
votes
1answer
325 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
944 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
44 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
176 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
40 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
76 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
37 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 ...
1
vote
1answer
201 views

Migrate SQL Server 2014 Enterprise to new machine

We had Bizspark, which we are now graduates of. As I understand from the Bizspark page: You can keep, at no charge, all the software you downloaded, including a standard configuration of Windows ...
0
votes
0answers
83 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
1answer
365 views

Comma delimited import issues in SQL Server

I am having a problem with SQL Server. I have a table with 42 columns to which there is frequent monthly imports. These imports are from a flat file using the import and export wizard. My problem is ...
0
votes
0answers
13 views

Programmer's guide to Server Resource Usage Report [closed]

I have ASP.NET MVC 5 Application running on a Windows Server 2012 and a Database Server running SQL Server 2012 on Windows Server 2012. I am trying to get a report on the Resource usages of these ...
-1
votes
1answer
95 views

SQL server not able to stop on windows 8 … please help … using sqlserver 2000 on windows 8 home

I am currently using a software which is dependent on SQL server 2000. However whenever i try to exit the program and try to stop the SQL server i get a message-- An error 5 (access denied) occurred. ...
12
votes
5answers
29k views

Clean reinstall SQL Server Management Studio

I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well. Then, I installed ...
0
votes
2answers
2k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
0
votes
1answer
64 views

Sql server 2012 process reaches 2 GB of memory in one hour if open Management Studio

I have strange situation with Sql Server 2012. If I open Management Studio 2012 (11.0.2100.60) and make some query on a table, the process sqlservr.exe reaches 2 GB of RAM memory in one hour. It ...
0
votes
0answers
594 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 ...
2
votes
1answer
275 views

Should I install SQL Server on a SSD drive (educational purposes only)?

I have just started using a 120 GB SSD drive on my laptop. I wonder if it is a good idea to install SQL-Server on this partition. I am sure I will want to install Management Studio there but what ...
0
votes
0answers
200 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
1answer
406 views

Logging on to SQL Server from a Windows 8.1 PC over a VPN

I currently work remotely (new position) and am logged into my Windows 8.1 development machine with my Windows Live account. I can connect to our corporate LAN via VPN but can not access SQL Server ...
10
votes
6answers
9k views

SQL management studio hangs when opening after being closed down on dual screen

I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014. If I drag the management studio screen across to my 2nd display, and then ...
1
vote
4answers
107 views

Will the Microsoft SQL transaction log by default be enabled during install?

I was asked this question in an interview? Does it depend on version of the server or is it always same (enabled or disabled by default)?
0
votes
1answer
2k views

How do I disable automated SQL Server Backups?

SQL Server seems to be doing full backups (.bak) at random intervals then storing them into, C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup Is there an option to ...
0
votes
1answer
169 views

Error in installation of SQL Server 2008 Management Studio

I have installed SQL Server 2008 Express on my machine but I can't find the Management Studio. I downloaded two versions of SQL Server Management Studio, 2008 and R2 This is the result I don't ...