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
1k views

Networking in VMware

I am required to imitate a remote database server environment for my project. So I am thinking of installing SQL Server 2008 on a virtual machine (VMware workstation) and then access it from my ...
0
votes
1answer
3k views

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server. Here's a screenshot of the error:
0
votes
2answers
643 views

Best SQL Server Configuration with this hardware

I just received my new SQL Server from Dell. The server will be serve approximately 15 OLTP databases which average 10GB in size. Here are the basic specs: Dell PowerEdge R510 with up to 12 Hot ...
0
votes
1answer
1k views

Install Microsoft SQL express database on Windows XP Home SP3?

I am trying to install Microsoft SQL express on a Windows XP SP3 Home Edition machine. But it does not satisfy the requirements. Is there a way to remove SP3 from my machine and revert to SP2? ...
0
votes
6answers
2k views

sqlserver 2008 or 2005 express cannot install on Windows 7 home?

When installing 2008 it says it requires .NET 3.5 and 2005 fails : what can I do ?
0
votes
1answer
2k views

Getting account lock status in MS SQL Server

I want to unlock an account in MS SQL Server. Before unlocking I have to check whether the account is locked or not - I only want to unlock if the account is locked. Are there any SQL queries or ...
0
votes
2answers
115 views

SQL Server on Linux

For a particular project that is coming up, I am trying to expand my knowledge of Linux, so I am going to set up a Linux system at home. Rather than dual booting, I am thinking about putting SQL ...
0
votes
1answer
302 views

How to find sql server instance?

I have sql server 2000 and 2005 installed on my machine. Now instances were installed as Machine04 [2000] and other Machine04\SomeInstance [2005] (this some instance i don't remember now) So is ...
0
votes
3answers
256 views

How can I know about the local SQL Server on my system ( windows 7 )

How do I know whether I have a local SQL Server on my system? If there is what are the login details to the local SQL Server ? I have a windows 7.
0
votes
1answer
29 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
1answer
135 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 ...
0
votes
1answer
98 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
182 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 ...
0
votes
2answers
4k views

How do I login to MS SQL server ? authentication

I have no idea on how SQL works. I'm just trying to use a program that is using SQL Server. I have SQL Server 2005 and 2008. In my start menu I only see a list of programs in 2008. In the 2005, I ...
0
votes
1answer
2k views

Connecting to a local SQL Server instance fails with an error

I have installed MS SQL Server 2008 R2 with authentication mode but when now when I click to the connect I gives such kind of error: A network-related or instance-specific error occurred while ...
0
votes
2answers
5k views

how to synchronize local and remote database?

I have a database in SQL server on local computer, we have the same database on remote p.c , i want to sync it with remote server, is there any script for SQL server or any plugin? Thank you. OS: ...
0
votes
2answers
366 views

How can Windows performance counter data be saved directly to SQL Server tables?

I would like to log data from a given set of Windows performance counters directly to tables SQL Server. Does Windows provide a way to do this without writing a custom application to do so? If so, ...
0
votes
3answers
6k 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
1answer
4k 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
135 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
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 ...
0
votes
2answers
1k views

How to setup Vagrant Windows Server machine with SQL Server on it

Can anyone explain (or give a link) how to setup MS Windows Server VM using Vagrant on Linux (Arch Linux)? I was searching in Google but only think that I found are instructions how to setup Vagrant ...
0
votes
2answers
969 views

How do I install SQL Server Reporting Services for my version of SQL Server?

I believe the version of SQL Server 2012 that I have installed is a developer version. It is version 11.0.3000. I would like to install Reporting Services and Report Builder. I tried this link: ...
0
votes
1answer
699 views

Possible SQL injection

I have a desktop based software that's built on top of SQL 2005. The SQL server is hosted inside my office, and there is 1 public facing website which displays some of the content from this database. ...
0
votes
1answer
4k views

Powershell SQL query--connection string

I am trying to query several different SQL servers and run a command on each of them. I am unable to get the connection string right. Code, below. I receive the following error:Login failed. The ...
0
votes
1answer
548 views

SQL SERVER 2000 JDBC DRIVER

I am trying to find the SQL SERVER 2000 JDBC Driver to use in extracting data from SQL SERVER and also carrying out several operation implemented in Java/JSF. Any idea where I could get my hands on ...
0
votes
2answers
4k views

Skip restarting during SQL Server installation

I tried to install MSSQL Express R2 2008 but I noticed that it needs SP3 on Windows XP 32bit. I did install XP SP3 and did not restart the PC. When I try to install SQLServer, it asks for a restart. ...
0
votes
1answer
663 views

Export .mdf to SQL Server database

I am on a shared hosting plan and cannot install SQL Server Express, is there another way I can use my .mdf database or will I need to export it to a SQL Server database and change all my connection ...
0
votes
1answer
273 views

How to determine sql server name

I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql. ![enter image description here][1] I get the notice: unable to connect to ...
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 ...
0
votes
3answers
840 views

Drupal 7 on Windows - File Module Problems

Installed Drupal 7 using the Web Platform installer on Windows 2008 For some reason, the file module, when you upload a file, uses the first few letters of the filename as the unique key to store in ...
0
votes
3answers
5k 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
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
1answer
2k views

Starting a SQL server on fedora

I am a total databases noob, hence please be gentle. I am looking for tutorials how to create a SQL table, how to start a SQL server, and what software to use on fedora. Would anyone share links to ...
0
votes
1answer
259 views

Recover database (SQL Server) from Windows.old folder

I have just installed Windows 7 on a machine which previously ran Windows XP. The old installation had a database which I need a copy of, but of course I did not think far enough ahead to do a backup ...
0
votes
1answer
122 views

How may I use other server features on Windows Home Server without breaking it?

I am hoping to run some virtual machines, IIS, SQL Server, MOSS, and Team Foundation Server on my HP MediaSmart Server 495, probably not all at the same time. There is a frightening warning message ...
0
votes
1answer
12k 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 ...
0
votes
1answer
39 views

issue on MS SQL managament studio 2005..?

am having MS SQL 2005 developer edition. And when am trying to install it(MS SQL 2005) on my windows XP SP2 system- am not getting MS SQL management studio..?/ what will be the issue..??
0
votes
1answer
144 views

SQL Server 2005 - backup during database changes

Is backing up live database that is being actively used safe and consistent ? I mean will the system take a snapshot of all tables when backup starts or does it save each table content as it was when ...
0
votes
3answers
167 views

User Accounts in Win 7

I am having a difficulty in Win 7 because of different accounts (Me the user account, and the admin account). Many times I have to close the program (Visual Studio, SQL Server) and restart again as ...
0
votes
1answer
26 views

Does anyone know of a program that can search database objects (i.e. StoredProcedures) for keywords?

Is there a tool that would look through a group of stored procedures for source code keywords? A client has a lot of business logic coded into their database and I need to find where it is using ...
0
votes
1answer
690 views

is using Hosts for resolving a sql-server more performant?

we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections. Now we consider to use a ...
0
votes
1answer
217 views

SQL Server 2000 Client won't connect

One day instead of connecting to the database my SQL Server Management gave me the following error: "Data Source name not found & no default driver found" Note it had been working for several ...
0
votes
1answer
2k views

How to backup Windows 7 Live Photo Gallery?

How do I backup Windows Live Photo Gallery? I've been running on Windows 7 RC and I want to upgrade to the full Windows 7 release. I've been managing my photos with Live Photo Gallery. I want to ...
0
votes
4answers
18k views

Run as administrator needed for IE8 workaround but user is in Administrators group

I'm running IE8 on Windows 7 and logging in under a company domain account (not the machine domain). The domain account is assigned to the machine's administrators group. As a workaround for the issue ...
0
votes
0answers
13 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
0answers
8 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
18 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
26 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
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 ...