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

0
votes
3answers
5k 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. ...
0
votes
0answers
13 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 ...
1
vote
1answer
182 views

Windows 8 & Server 2012: SQL Server Connection Delay

When connecting from a Windows Server 2012 or Windows 8 box to a SQL Server machine, it takes 2 sec to open a SQL connection and .5 sec for any SQL command to execute. Connecting to the same SQL ...
0
votes
0answers
13 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
2answers
3k 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
2k 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 ...
1
vote
2answers
575 views

Database is full; what should be the strategy?

What if my database is full and I don't have any spare hard disk or memory space. What should my strategy to free up the space?
2
votes
0answers
277 views

Access losing db connections

I have a weird problem going on at work. People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
1
vote
3answers
479 views

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database. How can I make it ...
5
votes
4answers
6k views

MS Access vs MS SQL Server

These are two offerings from Microsoft - MS Access and MS SQL Server. What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products ...
0
votes
4answers
912 views

What are the best tools for modeling a pre-existing SQL database structure?

I have a MS SQL database that has been running strong for 10+ years. I'd like to diagram the database structure, without spending hours laying it all out in Visio or something similar... I've ...
2
votes
1answer
154 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 ...
2
votes
2answers
1k 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 ...
12
votes
6answers
40k views

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried). I cannot find any options ...
0
votes
3answers
4k views

Dates not recognized as dates in pivot table pulling directly from SQL Server

My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...
0
votes
4answers
382 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
0
votes
0answers
24 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
2answers
6k 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 ...
4
votes
4answers
7k 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 ...
1
vote
1answer
144 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
236 views

Invoke-Sqlcmd not working after PowerShell 4 install

I installed PowerShell 4 yesterday and ever since then, I get the error "The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function". This has been working just fine for months ...
0
votes
0answers
11 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 ...
2
votes
1answer
881 views

Sql Server Managmenet Studio Alternative - Are there any?

I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL. LINQPad is not an option (although it's ...
0
votes
1answer
50 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 ...
2
votes
1answer
1k views

Visual Studio 2012 SQL editor missing tool bar

I have a number of SQL script files in a database project. When I open some of them, the editor includes a toolbar, with options to connect to database, execute the script, etc. However, when I open ...
0
votes
1answer
50 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
82 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
11 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
2answers
7k views

SQL Server 2012 fails to install or remove

Got an odd problem here. Installed programs is showing SQL Server 2012 installed, but fails to remove itself when running the uninstaller. To add insult to injury, it also won't let install the ...
0
votes
1answer
62 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
1answer
11k views

SQL Server Express 2008 R2 Installation error at Windows 7

I created an install script that will install SQL Server 2008 R2 on Windows XP SP3, Windows Vista and Windows 7. One of the command that I used in the installation is for silent installation of SQL ...
3
votes
1answer
604 views

Calculation takes forever in large data set on Excel

I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
0
votes
2answers
65 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
29 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" ...
20
votes
10answers
84k views

How do I open SQL Server Management Studio?

How do I open SQL Server Management Studio? I installed it but I don't see where I can open it.
0
votes
1answer
46 views

Which Azure services comprise a basic IIS/SQL web application scenario?

Thanks for looking. I need to deploy a site to Azure but their marketing literature and various tiers has left me thoroughly confused as to what should be selected. Here is the information I have ...
0
votes
0answers
29 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
252 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
41 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
140 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
21 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
0answers
38 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
1answer
54 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
0answers
27 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
0answers
105 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
28 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
94 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
3answers
3k views

Error message on SQL Server 2012 install

I am trying to install SQL Server 2012 Standard Edition on my Windows Server 2012. The installation keeps failing, and I have tried everything that I can come up with, but nothing helps. The error ...
0
votes
0answers
20 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
2answers
204 views

Can I change the default folder location for applications?

Basically I want to know if it is possible to change the path of certain applications that are saving folders in My Documents. For example: Whenever I open SQL Server Management Studio it creates a ...