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
4answers
592 views

Sharing Excel sheet over network?

Is it possible to have a server PC running a Microsoft Excel sheet to which several Thin Clients, with Barcode Scanners, will be connected via TCP/IP? The scanners should dump their data in the Excel ...
0
votes
0answers
78 views

Sharing MS Excel Sheet over network? [duplicate]

Possible Duplicate: Sharing Excel sheet over network? Is it possible to have a Server PC running a MS Excel Sheet to which several Thin Clients will be connected via TCP/IP having Barcode ...
1
vote
2answers
125 views

Tools to manage SQL Server and Oracle database from the desktop

I am using SQL Server 2008 and Oracle 11G on my system. Running both database services is making my system very slow. In order to stop the services I have to go to Services and stop them manually. ...
3
votes
1answer
2k views

I can't “unmaximize” my window

I've got a windows app (I don't think it matters which one, but in case you're wondering, it's SQL Server Profiler) that I can't put back into "windowed" mode. I can maximize or minimize it, either ...
1
vote
1answer
778 views

Is it possible to replicate SQL Server Express 2008 => SQL Server Express 2012?

Is it be possible to configure the one way replication between SQL Server Express Edition 2008 => SQL Server Express Edition 2012?
0
votes
1answer
607 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
71 views

Visual Studio and SQL Server

I've been looking for users that have development tools installed within a company and have identified many that have Visual Studio and believe they need to keep it because they do SQL Queries. In my ...
0
votes
2answers
2k views

Remote access sql server 2005 over internet

I find so many similar question/problem and go through but unable to solve my problem. As so I am repeating the question again. I would like to connect my sql server 2005 remotely over internet. I ...
1
vote
1answer
200 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
6
votes
1answer
22k views

Why don't I have SQL Profiler on SQL Server Management Studio?

I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )) However I cannot find the option to open SQL Profiler. I was ...
0
votes
1answer
3k views

Downloading MS SQL Server 2008 Standard edition

I want to download MS SQL Server 2008 with business intellegence standard edition. But I don't know how to download it, because the one I got was EXPRESS edition and everytime I run the x86 FULL 2008 ...
0
votes
3answers
65 views

Removing Microsoft SQL Server

I have quite a lot of Microsoft SQL Server installed on my computed which I'ld like to unistall. They were probably used by the previous computer owner, who used it for his software developing, and ...
1
vote
0answers
412 views

Change language of error messages in Windows 7 x64

My Windows 7 installation had Russian localization. When I encountered errors, I thought to translate the errors to Google into English. I decided to change the display language to English. In ...
-1
votes
1answer
2k views

.NET Framework 4 Extended?

To avoid XY, I will preface with the following: I am trying to uninstall an unneeded installation of MS SQL Server 2008 R2 on a production server. The server is also running SQL Server 2008 Express, ...
0
votes
2answers
4k views

SQL Server 2012 Maintenance Plan can't modify

Click on any created Maintenance Plan: TITLE: Microsoft SQL Server Management Studio Value cannot be null. Parameter name: component (System.Design) BUTTONS:OK Create a new Plan I get this error: ...
0
votes
2answers
425 views

Can't start SQL Server installation

I want to install SQL Server. I used the iso file en_sql_server_2008_r2_standard_x86_x64_ia64_dvd_521546.iso. I extracted the files using 7zip and started setup.exe – a setup window opens for few a ...
0
votes
1answer
3k views

SQL server Srevive(MSSQLSERVER) not start

i want to SQL server 2008 Enterprise Edition on my Dell N5110 Laptop With windows 7 Ultimate SP1 64- bit edition. when i click "setup" in installation DVD below Error appear: anyway i click ...
0
votes
0answers
130 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 ...
1
vote
2answers
81 views

SQL Management Studio external database only

I'm trying to speed up my PC, and I figured out that a full version of SQL Management Studio 2012 is installed including localhost server. I only need to connect to remote hosts, so running a local ...
-3
votes
2answers
116 views

how to create website using asp.net and sql server 2005 as backend? [closed]

How to create website in asp.net and sql server 2005 as backend? And i wants to know it is possible to use stored procedure in this Website? How to upload this website into server?
0
votes
1answer
182 views

Microsoft.SqlServer.SMO.dll issue in powershell

I dont have a sql server installed in my server. I am designing a powershell script that can execute sql scripts remotely in a db. I have powershellv1.0 in my server and dont have ...
0
votes
0answers
318 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 ...
9
votes
9answers
24k views

Why does it take so long for SQL Management Studio to connect?

Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect. This ...
2
votes
1answer
6k views

How can i compress when I create SQL backup file in a folder?

I use SQL Server Express and I create backup files for all databases every day using Time Scheduling script. One script Like that; BACKUP DATABASE [Jira] TO DISK = N'C:\Backup\Jira.bak' WITH ...
1
vote
0answers
232 views

How to set up Openfire XMPP server?

I have installed Openfire and Microsoft Sql Server Management Studio 2102 on my PC. I have made a database called openfire, conected to it, and have executed the script called openfire_sqlserver.sql ...
2
votes
1answer
1k views

The Login is from an untrusted domain - domain setup with computer level login

I have a SQL Server 2008 R2 database I'm attempting to connect to using ADO.NET using integrated security in the connection string. The database resides on a 64-bit Windows Server 2003 machine. The ...
1
vote
2answers
2k views

MS SQL Server 2012 Express Setup crashes with .NET error

I'm trying to install MS SQL Server 2012 Express on a virtual machine at a client. It's fresh install of Windows Server 2008 R2 Enterprise SP1. I added the "File Services" and "Application Server" ...
1
vote
0answers
153 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
0
votes
1answer
92 views

When will Microsoft stop supporting SQL Server 2005? [closed]

We are purchasing proprietary software that requires it run on a SQL Server 2005. My concern is we will not be able to change/modify/enhance at all. SQL Server 2005 is pretty old and want to know if ...
0
votes
1answer
261 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 ...
3
votes
1answer
550 views

Do Excel / SQL data connections refresh both ways

I've created a connection in Excel that fetches some data from our SQL server. The connection string looks like: Provider=SQLOLEDB.1;Persist Security Info=True;User ID=testuser;Initial ...
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 ...
1
vote
2answers
2k views

SQL Server Linux admin tools

I would like to know if there is sql server tools for linux? eg. tools like sql server enterprise manager.
0
votes
1answer
5k views

How to connect php 5.4.4 with microsoft sql server 2008 R2 in windows Xp?

How to connect php 5.4.4 with microsoft sql server 2008 R2 in windows Xp? i have installed xampp 1.8.0 with apache2.4 and php 5.4.4 embedded in it. i have installed microsoft sql server 2008 R2. i ...
0
votes
1answer
142 views

Why does a certain program need .NET Framework and SQL Server?

My question is not intended to provoke a deep discussion, I'm just looking for peace-of-mind. I'd like to download and play this simple game: ...
0
votes
1answer
109 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 ...
1
vote
2answers
429 views

Working on a .NET project in VMware Fusion – good way to edit files in OS X?

I'm working in a client's .NET-based web project right now – I have it running well in IIS with SQL Server in my VMware Fusion VM. The .mdf/.ldf files are in the project directory as well. I'm a ...
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 ...
0
votes
1answer
361 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
3k views

Accessing SQL Server in Windows XP Mode Virtual Pc

I have a laptop running 64bit Windows 7 Ultimate. I created a Virtual PC using Microsoft XP Mode. I've installed SQL Server 2000 on the Virtual Machine. I have SQL Server 2008 R2 installed on the ...
2
votes
1answer
3k views

Component Services Error Log - SQL Server Distributed Replay Client

I am getting the following error on a Windows Server 2008 x64 R2 Virtual Machine install: Log Name: System Source: Distributed COM Event ID: 10016 Level: Error Date: 2/20/2013 8:22:14 AM The ...
1
vote
2answers
16k views

How to forward port on a dedicated windows server 2008?

In MSDN to make SQL Server accessible from Internet http://msdn.microsoft.com/en-us/library/ms175483.aspx They say to forward port from sql server remote port to usual sql server port 1443. I have ...
4
votes
3answers
1k views

Is it possible to enable Intellisense for SQL Server Management Studio Express 2012 (SSMS)?

I have installed SSMS to connect with my Old SQL Server 2005. Just want to test new features for new version of SSMS Express 2012. I use Right click on the Text Editor to enable Intellisense but I ...
0
votes
1answer
1k views

How to un-install sql server 2008 analysis service only?

Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
-1
votes
1answer
42 views

SQL Server 2008 Express, just create a few tables and run queries? [closed]

I have installed SQL Server 2008 Express, as I just want to create a few tables and run queries against them. After installing I am a little unstuck. I have an "instance" running, but I am not sure ...
3
votes
1answer
4k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
1
vote
2answers
849 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
1
vote
2answers
3k views

How do I get a standalone SQL Server Management Studio (SSMS)?

I don't want to install the entire SQL Server (2005 or 2008) on my Virtual PC (saving space), yet I need the SSMS to connect to external databases. What are my options?
1
vote
1answer
1k 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
4k views

Unable to install SQL Server 2012

When I am trying to install a new instance of SQL server 2012 on my server, I get the following error message when I try to run the iso (before any gui appears): The operating system on this ...