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

4
votes
1answer
172 views

Copying out color theme background from SQL management studio to Outlook

I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
3
votes
1answer
637 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 ...
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 ...
2
votes
1answer
249 views

NetWork Intrusion Attack: MSSQL.worm.helkern attempting to attack local port 1434 from IP address 94.188.21.147?

I was on the internet the other just finishing up a project for work and I saw my internet security saying network attack intrusion and I read about some of it but I can't fully understand the full ...
2
votes
1answer
446 views

How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?

I'd like to make it Ctrl-Shift-F to match Visual Studio. I realize to do that I need to remove that binding from the Query->Save to File item. But, I can't even add ANY shortcut. When I pull up the ...
1
vote
1answer
44 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. ...
1
vote
1answer
282 views

Deployment Fail During Generate Star Schema

I am Using SQL Server Data Tools for Visual Studio 2012 for Generating Start Schema.I am using one Database with four Tables.When i am Click on Start Button. I Got This Error The project could ...
1
vote
1answer
642 views

SQL Server Express “hangs”, on startup

I recently installed SQL Server 2012 "Express", and, also, Visual Studio 2012. I was working with it, and all worked ok. At some point, a few hours ago, SQL Server Express, however, started ...
1
vote
1answer
32 views

Default text for SQL scripts

In MS SSQL Server Management Studio 2012, is it possible to get new scripts to contain some default text? I want to encourage colleagues to comment their scripts more consistently, so I'd like ...
1
vote
1answer
694 views

Restore a database with LDF file only

First of all, i know how stupid it is not to have a any backup. I can't help it, but i have to (try) to solve it. I have a transaction log (LDF) file from a SQL Server 2000 database that contains all ...
1
vote
1answer
77 views

Cannot install SQL Server CE 4

I'm trying to install SQL Server CE 4 on a WinXP Pro SP3 machine. I double-click on the file and absolutely nothing happens. There is nothing in the event viewer and the only effect I can see is the ...
1
vote
1answer
273 views

connecting to sql server from access for multiple users

I just ran the upsizing wizard on my copy of Access and have successfully connected my Access app to my SQL Server DB but I need to do this for multiple users. Am I going to have to run the upsize ...
1
vote
1answer
934 views

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual Studio

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, ...
0
votes
1answer
93 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 ...
0
votes
1answer
105 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
53 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
1answer
55 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
1answer
43 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
1answer
40 views

How to automatic backup SQL server registered servers?

I have many servers registered. I don't know where this information is saved. After PC rebuild, they are gone. Is there way to schedule task to backup this information?
0
votes
1answer
2k views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
1answer
104 views

Installing Sql Server 2012 on Vmware Virtual Server 2008 R2

I have a Virtual Windows Server 2008 R2 set up, I downloaded Sql Server 2012 Evaluation Copy. Now when I try to Install the Sql Server it throws an error, No Error message nothing at all just an error ...
0
votes
1answer
16 views

WEB-INF/web.xml displays mysql credentials?

I found web.xml in /WEB-INF/ on a domain I'm associated with. In said xml file, I see it displays: <database> <jndi-name>jdbc/mysql</jndi-name> <driver> ...
0
votes
1answer
77 views

Why do I have to manually add Local Activation permission for domain account even if it's a member of the local Administrators group?

A SQL Server 2012 agent job was failing with: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {...} and APPID ...
0
votes
1answer
30 views

Log file viewer not displaying database where error occurred

Something keeps being logged to files located here: C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER\MSSQL\Log Files like these keep getting updated: SQLFT0000700007.LOG 15 errors per ...
0
votes
1answer
110 views

How to access SQLite database?

I have run BinDiff on two binary files, and stored the results in a .BinDiff file. (Which the manufactures assure me is just an SQLite database. How would I open and access this database?
0
votes
1answer
63 views

MS SQL Server 2012 drives

I am buying machine for MS SQL Server 2012 Standard and I have questions about drives and performance. How to locate OS, database, logs, backup on WD RE4 500GB and Intel SSD DC S3500 120GB? OS, ...
0
votes
1answer
103 views

SQL Server Unattended Install through SSH

I'm trying to install SQL Server from the command line through Cygwin open-ssh. The install works when I log onto the server as Administrator and execute the script through a Cygwin shell, but the ...
0
votes
1answer
484 views

List of Services for SQL Server 2012 Express

I recently installed VS2013 Preview onto a clean OS and I'm trying to figure out if SQL Server Express 2012 got installed. Unfortunately, when I look in Control Panel->Administrative Tools->Services, ...
0
votes
1answer
187 views

How Do I Suppress SQL Server “Informational” Messages?

I've just installed SQL Server 2008 R2 Express for local development, and it's flooding the Application Event Log with a seemingly endless barrage of trivia and drivel ("SQL Server is now ready for ...
0
votes
1answer
2k views

SQL Server 2012 (SQLEXPRWT_x86_ENU) Installer doesn't open/do anything

I just downloaded SQLEXPRWT_x86_ENU (multiple times, to verify it worked as expected), which is supposed to be SQL Server Express 2012 with Tools, from here. It appears to be a file with no ...
0
votes
1answer
82 views

SSMS starts without login prompt and stays inactive

recently my SSMS started working really weird, wasting my time. I am working on a laptop connected to additional monitor. SSMS starts without login prompt, and stays inactive as long as I dont shut ...
0
votes
1answer
251 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
0
votes
1answer
507 views

Remote application cannot connect to my local SQL Server 2008 R2

I have set up Microsoft SQL Server 2008 R2 (SP1) on a local machine specifically for a certain application to run. The application itself is designed to use an IP address which is hard coded in to ...
0
votes
1answer
2k views

How do I connect to a MySQL database from another computer in VB.NET?

How do I connect to a database of another computer in the same local network using VB.NET? We have already enabled remote connection in the SQL Server configuration and the SQL browser, and we already ...
0
votes
1answer
723 views

Troubleshooting inconsistent ODBC connectivity

I'm attempting to integrate UPS WorldShip with a SQL Server 2008 R2 database but the connection is very inconsistent. UPS claims this is a DSN/Windows problem and I have not been able to convince them ...
0
votes
1answer
145 views

Sql Server Express Installation

I am learning ADO.NET programming. I want to install Sql Server Express for doing the some programs. I am using Microsoft Visual Studio 2010 Ultimate on my windows 7 home basics 64 bit. I have ...
0
votes
1answer
797 views

Why can't my bulk loadable CSV file be opened?

This is my error: Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.) I've checked permissions and everything seems fine. The auto bulk ...
0
votes
1answer
91 views

Downloading MS SQL Server 2008 Standars

I want to download MS SQL Server 2008 with business intellegence standard edition. But I don't know how to download it, because the on I got became EXPRESS edition and everytime I run the x86 FULL ...
0
votes
1answer
66 views

Password format not liked by installer

I'm installing Chargeback and I get to the database-related information page (step 5 on page 17 of the users guide). Using a Windows account (it is an administrator of the server and I am logged on ...
0
votes
0answers
275 views

How can I access my home MS SQL Server DB from a remotely hosted web service?

As can probably be seen (if not already see below) I am fairly networking illiterate. Here is what I would like to do: Setup a SQL Server DB hosted on a computer I have in my home. I want to be able ...
0
votes
0answers
605 views

Windows could not start the SQL Server (mssqlserver) service on local computer error 17058

I'm working with a virtual machine on Windows 8. There is a SQL Server 2008 on the virtual machine. And in the services, when I try to start the SQL Server service I am getting an error like this:
0
votes
0answers
95 views

SQL Server Data Tools Explore Data error

I am reading a step-by-step book to learn more about SQL Server Analysis Services. I am creating a dimension for an AdventureWorks data source. In the Design Diagram pane, I right click on the header ...
0
votes
0answers
250 views

VS2010 Program won't connect to MYSQL from local SQL Server Computer

my problem here is very weird compared to other that I found on this forum. The VB program is created with VS2010 from computer "A". It work perfectly. Connection to SQL Server and MYSQL DB. But when ...
0
votes
0answers
335 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
35 views

Pause VM when SQL server idle

In OSX Mountain Lion, I run a Windows Server 2003 VM solely to run SQL Sever 2008. It chews up a lot of battery life. Is there some way to automatically pause the VM when the SQL Server is idle and ...
0
votes
0answers
1k views

Cannot connect to SQL Server from another PC

I am using windows XP SP2 and SQL Server 2000. I can successfully connect to a database from the host computer via 127.0.0.1 and also with the local IP (which is 192.168.1.6). But when when I try to ...
0
votes
0answers
779 views

SQL Server 2008 forgets my login and password

For some reason SQL Server 2008 (Management Studio) refuses to remember my username and password for a specific server instance even though I've checked "remember password" probably hundreds of times ...
-1
votes
0answers
31 views

“Error HRESULT E_FAIL” when migrating SQL 2012 DB to SQL 2008R2

I have a 250 GB database (from SQL Server 2012) to a 2008R2 SQL server. I created a script file in 2008 server and when I try to open the script in 2008, I get the error: Error HRESULT E_FAIL has ...
-1
votes
0answers
28 views

Debug in sql server 2012

I have 3 sql server (2005,2008,2012) In 2005 and 2008 remote debug (from sql management studio installed on the client) works without problems. In sql 2012 debugging only works on sql management ...
-1
votes
0answers
23 views

What order is better when I need to install Visual Studio 2013 and MS SQL Server 2012?

I remember I had some problems when I first installed SQL Server 2012 and then Visual Studio 2013 on my previous laptop but I don't remember what was better... either a) first Visual Studio and then ...