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

0
votes
0answers
44 views

RDP, IIS, SQL Server no longer working

Remote desktop, as well as SQL Server 2008 R2, as well as IIS 7.5 have all mysteriously stopped allowing connections via my local network. Originally, I thought that this could be the result of a root ...
0
votes
0answers
140 views

How to port forward through two routers in a network

I am trying to connect my SQL server through public network. So, I am having lots of problem in understanding it. One router is AirOS's(Outside my house) another is Iball's Baton(Inside my house). ...
0
votes
1answer
272 views

Compatibility between Windows 7 and Windows 10. [closed]

I receive the free update from Microsoft for Windows 10. At the moment I'm using Windows 7 Ultimate. I have several question, for which I can't find anything in google or at least my search words was ...
0
votes
0answers
17 views

Error When Logging In

I am able to log in with Windows Authentication, but my user account does not have any permissions to perform the operation (e.g. Exec, grand, alter, create…etc). Even though I am not able to create ...
0
votes
0answers
33 views

Unable to open SSMS from run window

I'm having an issues that bugs me and can't seem to be able to solve it. I have SQL Server 2005 and 2012. For the 2005 instance this is my path (for both 2005 and 2012 the path that leads straight to ...
0
votes
0answers
20 views

How do you create a sql 2014 cluster disk for a cluster across multiple hyper-v machines

I have an SQL 2014 cluster spread across multiple physical machines running Windows Server 2012 and Hyper-V. I'm attempting to install Skype for Business 2015. However the install script appears to ...
3
votes
1answer
45 views

Images Stuck on Server

I've run into a strange problem with images being "stuck" on the server. The problem began when I uploaded an updated picture via FTP (I use Cyberduck for Mac) to override the picture. This didn't ...
0
votes
1answer
142 views

Error Installing Windows SQL Server on Windows Server 2012 R2

I have been completely unable to install Windows SQL Server Express on Windows Server 2012 R2. Every time, I get: TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: Wait ...
1
vote
1answer
188 views

Crystal Reports Dynamic Parameter

Help someone. I have a Crystal Report (CR) that prompts for an acct number. The main report data source uses a sql view to take the acct number input and look up the information it needs to print ...
1
vote
0answers
39 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
0answers
17 views

What SQL Server feature do I need to check to get SqlPackage.exe installed?

What SQL Server feature do I need to check to get SqlPackage.exe installed? Checking the one called "SQL Server Data Tools" (feature name BIDS) created the DAC directory and puts a few text files in ...
0
votes
1answer
34 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
0answers
17 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
1answer
151 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 ...
0
votes
1answer
264 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
58 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
53 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
1k 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
199 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
433 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
181 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
161 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
54 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 ...
2
votes
1answer
84 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
111 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
174 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
805 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
225 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
12 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
75 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
135 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
12 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
58 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
208 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 ...
4
votes
2answers
3k 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
335 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
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 ...
1
vote
2answers
3k 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
51 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
334 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
2k 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
218 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
238 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
18 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
162 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
990 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 ...
2
votes
1answer
6k 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
75 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 ...