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
1answer
110 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
20 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 ...
1
vote
1answer
4k views

Query parameters in an external connection to sql server

I want to do exactly this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
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 ...
1
vote
2answers
4k views

Sql query suddenly takes a long time to run

I have an application that is processing lots of items from a sql database. It runs along fine and then after about 4 million items processed it starts hanging up. Using sql server profiler, I ...
5
votes
4answers
4k 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 ...
0
votes
1answer
22 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 ...
0
votes
0answers
14 views

Query from SQL not outputting to Excel spreasheet [on hold]

So I'm trying to make a parameterized SQL query within Excel by following this tutorial, http://snippetsandhelp.blogspot.com/2013/05/excel-2013-getting-data-from.html and everything works fine with ...
2
votes
1answer
40 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, ...
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
2answers
4k views

Cannot uninstall SQL Server 2005, no matter what I do

Windows 2003 Server R2 64 bit I do Control Panel, remove programs, and get: Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the red ...
2
votes
1answer
3k views

SQL Server 2012 Connecting to MS Access 2003

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something. I just installed SQL Server ...
-2
votes
0answers
22 views

SQL Server Management Studio 2014 x64

we using Windows 8.1, Professional edition. I am trying to install SQL Server Management Studio 2014 x64 and its either it fails or says boots-trapper how can I fix it?
0
votes
1answer
443 views

BCM - Database Tool 2013 on SQL 2008r2

Im trying to setup a Database with the Business Contact Manager Database Tool -2013 on one of our server. The tool is able to detect the SQL intance but can't create the Database. I've gone through ...
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
1answer
50 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 ...
0
votes
3answers
7k views

SQL Server Express while attaching a database getting error 5120

I have SQL Server Express installed on my local machine. When I try to attach a database file, it's giving me the following error Unable to open physical file "C:\Adventures2012_data.mdf. ...
2
votes
1answer
382 views

Loading Files from My User Directory in SQL Server Management Studio 2012 Under Windows 8

I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible ...
4
votes
3answers
160 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
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. ...
-1
votes
2answers
42 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 ...
1
vote
2answers
603 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 ...
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 ...
7
votes
5answers
12k views

Cannot find one or more components. Please reinstall application

I am running Windows 8, 64 bit and have SQL Server 2012 installed. I downloaded the client tools, looked in the directory for SQL Server Management Studio, and see it's there. When I try to run SQL ...
2
votes
1answer
42 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 ...
5
votes
5answers
14k 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
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 ...
11
votes
4answers
23k views

Which ports to open for Microsoft SQL Server?

Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of ...
0
votes
1answer
95 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
votes
3answers
522 views

What does the term CXPACKET stand for?

Google does not appear to have a definition of the term.
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
1answer
212 views

Fix/Reinstall SQL Native Client?

Don't know what happened but on my Windows 7 64bit the connection to SQL2005 using SQL Native client is not working anymore. More in detail, if I try to connect to the SQL server using oledb it works ...
1
vote
1answer
200 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 ...
0
votes
1answer
49 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
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 ...
1
vote
2answers
451 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
65 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
303 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. ...
2
votes
1answer
65 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 ...
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
1answer
106 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 ...
0
votes
2answers
285 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
32 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?
0
votes
1answer
32 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
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 ...
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 ...