Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

learn more… | top users | synonyms (4)

1
vote
0answers
30 views

Server network communication stalls

I'm running SBS 2008 as a file server, SQL server, IIS7 Server, and Exchange server, and very recently I am getting some very confusing stalls on it. During these "stalls," file services will cause ...
1
vote
4answers
48 views

SQL Express connection issue [closed]

I have installed a instance of sql-express for an MDT deployment solution (XYZ-Deployment) I've got to the stage where I add a database share and when I go to add it, I get the following error ...
0
votes
2answers
42 views

SQL2008R2Std Maximum RAM per instance

In this page : http://msdn.microsoft.com/en-us/library/ms143685%28v=sql.105%29.aspx It's written that SQL 2008R2 Standard supports 64GB of RAM, but is it per instance? For SQL2012 (here : ...
1
vote
1answer
28 views

32 and 64 bit MSSQL on same server

Is it possible to install a 32bit instance of SQL Server and a 64bit instance on the same 64-bit server? I have ODBC drivers that are 32bit, and need to use these as linked servers in SQL Server, so ...
1
vote
0answers
31 views

Why is $job.LastRunOutCome always “Failed”?

I am using sqlps to run a backup job "Backup Something". Set-Location "SQLSERVER:\sql\$hostname\default\jobserver\jobs" $job = Get-ChildItem | Where-Object {$_.Name -eq "Backup Something"} ...
1
vote
1answer
124 views

Licensing and Editions of Microsoft BizTalk and SQL for Development, QA, Stage vs Production [duplicate]

My question is similar to this one, but I am gearing mine more toward which edition to use. In the past places I've worked, these decisions were made by other teams, and now I'm being asked to ...
0
votes
1answer
56 views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
1
vote
1answer
1k views

Can pdo_sqlsrv driver be installed on Linux/Ubuntu with php 5.5.3 using pecl install pdo_sqlsrv?

In all likelihood, I have overlooked a fine print somewhere, so this question may sound stupid, but will clear my doubts. I spent hours trying to install pdo_sqlsrv PDO driver on Ubuntu 13.04 PHP ...
3
votes
2answers
2k views

SQL Server running under a domain account cannot register its SPN

I am trying to configure a fresh install of SQL Server to run under a domain account. However, I get intermittent errors when trying to connect to the server using another domain account, and I still ...
1
vote
4answers
166 views

Why is it so hard to get servers with Lot of Ram, but few cores?

SQL server has a very high per core license cost, but for a lot of workloads benefits more from lots of RAM. his is now even more of the case with in-memory tables. Even if a server with 4 cores ...
1
vote
1answer
38 views

Azure SQL Data Sync between SQL Azure and Azure VM

I used two have 2 SQL Azure databases and they were automatically synced using this service: http://www.windowsazure.com/en-us/documentation/articles/sql-database-get-started-sql-data-sync/ Now one ...
2
votes
1answer
64 views

SQL Service Accounts and which to use

I've done lots and lots of searching and I cant seem to find a simple answer, I assume it is because everyone's circumstances differs however; We need to setup a few SQL servers for production and I ...
0
votes
0answers
46 views

What is a good set of performance counters to measure scalability bottlenecks

We're moving our enterprise product to the cloud (IAAS) and are determining how many users we can support on a single VM. Our product uses SQL Server, SharePoint and a bunch of WCF services. What ...
0
votes
0answers
48 views

Running MS SQL Server DB for Ubuntu PHP site

I'm going to be developing a php site (actually more of a application), but the standards and restriction of what I'm building make MS SQL Server the most appropriate DB solution (will also be running ...
2
votes
1answer
54 views

Analyze meeting room coverage on Exchange server

We have a dozen meeting rooms, are looking to get rid of some of them, if we can prove that the remaining meeting rooms will cover our needs. We use an Exchange server. Is there any way I can query ...
0
votes
1answer
69 views

SQL Server error “SQL Server does not exist or access denied”

I have a VB6 application with an SQL Server 2008 database. It works fine on my developer workstation, of course, but when I deployed it in a freshly installed operating system (a virtual machine), an ...
0
votes
1answer
71 views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
0
votes
0answers
25 views

Geronimo 3 and MS SQL DB pool

Has anyony managed to get a MS SQL database pool set up on Geronimo 3. I am trying to use the wizard in the admin console. After entering all the details when clicking next in the wizard the screen ...
0
votes
1answer
99 views

SQL Server Express 2012 - unexplained constant disk activity [closed]

I have installed Microsoft SQL Server Express 2012 on a desktop under Windows 8.1 to teach myself SQL (and eventually work with some data). I am also using SQL Server Management Studio. SQL Server is ...
0
votes
1answer
49 views

How can I get SQL 2012 Web Edition?

If I want to get a copy of SQL 2012 Web Edition, do I have to go through a hosting provider such as Rackspace? What about if I am in the MS Select program and a Volume Licensing account? How is it ...
1
vote
3answers
116 views

SQL Server 2012 RAID Setup and Performance [closed]

At my company we are in the process of setting up a new SQL Server 2012 box. We have 6 physical drives with 3,000 gigs each. We are considering two different RAID configurations and are wondering ...
1
vote
1answer
54 views

How to profile which SQL server a .NET application tries to connect

We have a huge .NET application from 3rd party that would be time consuming to disassemble and understand the code. It is compiled in Release mode. Connection strings to the MS SQL databases are ...
0
votes
0answers
117 views

IIS Hang after moving to locally hosted SQL Server Session States

We have an in-house IIS7 server hosting our various Intranet applications (All coded in .net 2). Its quite a busy server; around 400 users logged in at any given point with peaks of 600+ sessions at ...
1
vote
3answers
344 views

Reverse SSH Tunnel from windows to ubuntu to serve SQL server

just as the question says, I am currently trying to establish a reversed SSH connection from a Windows server behind a NAT to a hosted Ubuntu VPS. I'm pretty much a total beginner in Linux and SSH. ...
0
votes
0answers
382 views

How do I permanently add additional connection parameters in SQL Server Management Studio

In the "Additional Connection Parameters" tab of the login form for SQL Server Management Studio (most recent versions), one may specify custom connection string parameters. See ...
0
votes
0answers
101 views

Use AWS ephemeral drives for SQL Server for redundancy/read-only/other live purposes

Are there any good uses for the ephemeral drives on AWS Windows instances when using SQL Server besides putting TempDB and the pagefile there? I'm wondering, for example, if one could replicate the ...
0
votes
1answer
50 views

The SA user (of the MSSQL database) password changes everyday [closed]

The SA user (of the MSSQL database) password changes everyday. I have disabled password policy and password expiration. Still no luck, everyday it happens Any idea?
0
votes
1answer
48 views

rsync, dd and then add to RAID 1, could cause database corrupted?

Firstly I have a HDD which has been setup as RAID, type Volume, not RAID 0 or RAID 1 ... and I wanna add one more HDD to setup a RAID 1 array. These bellow steps are what I've done. Detach from ...
0
votes
1answer
53 views

Migrate existing database to mirrored database on Azure

I have setup 3 Sql VM's on Azure for database mirroring as described in this link with the idea being that we move our current database, which is currently on a single VM outside of Azure. Everything ...
0
votes
2answers
833 views

Offline database can't be restored: Exclusive access could not be obtained

I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly ...
1
vote
1answer
24 views

SQL Server 2008 - Difference between server and database permissions

And I think I'm almost there conceptually. I think I just need a few example/confirmations to bring it home. 1) My understanding is that server permissions ...
0
votes
1answer
224 views

MSSQL PHP cannot connect over apache's account

I'm fighting with this for a day now, hope someone already faced with this problem and can help me out: I have a CentOs server [root@XXXXX ~]# cat /etc/redhat-release CentOS release 6.5 (Final) ...
0
votes
1answer
73 views

SQL-Server migration assistant (SSMA) Sybase License

It appears that Microsoft's "license registration download" for Sybase is returning a 404 error now. SSMA was downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=28765 . I ...
1
vote
1answer
455 views

Why does one WSUS downstream fail replication but others don't?

I've recently added multiple downstream servers to a WSUS environment for a client. All the servers are running WSUS version 3 SP2 (3.2.7600.226). All of them seem to be working well, with one ...
2
votes
1answer
353 views

Powershell script runs in an infinite loop when executed a certain way

I'm using the Exec Powershell provider for Puppet to run some powershell scripts. I'm having an issue with the way it executes my script. The method of execution causes the script to run over, and ...
0
votes
1answer
57 views

Unable to connect to SQL Server over Azure Point-to-site VPN

I'm having trouble connecting to SQL servers over an Azure point-to-site VPN. SQL Standard is running on an Azure VM which is part of an Azure point-to-site VPN. It is a named instance. SQL Express ...
0
votes
1answer
691 views

SQL Server 2008/2012 Express install fails on scenarioengine.exe [closed]

I'm trying to install SQL Server 2012 Express on a Windows 7 64-bit PC. It also fails to install SQL Server 2008 R2. The bootstrapper extracts all the files, runs setup.exe (with UAC popup) then ...
0
votes
2answers
1k views

SQL Server Database Access fails when User Granted Acess via Domain Group

On a SQL Server 2008 R2 (running on Win2003), we have an issue with logins via domain groups - login access is granted to the server instance, but cannot access certain databases on the server. The ...
3
votes
1answer
62 views

High Available SQL Server without SAN by using AlwaysOn feature

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced. AlwaysOn is a new feature in SQL Server 2012 that is ...
6
votes
3answers
436 views

How to protect SQL Server from Hackers

I am having an issue and could not figure out how to handle it. I have a SQL Server on a Windows 2008 R2 server. This SQL Server 2005 is being used to receive DB subscriptions from another SQL Server ...
0
votes
1answer
50 views

MSSQL2000 How do i bind to localhost only?

How do i make MSSQL2000 listen to 1433/TCP only on 127.0.0.1? Server Network Utility only gives me the option to change listening port, nothing about address binding.
0
votes
1answer
88 views

How to setup log and data files on SSD for SQL Server?

I'm setting up my production SQL server. I have two 800GB SSD disks available to me (for Windows and SQL Server). Where should I put databases' data and log files? How many tempdb files should I ...
1
vote
1answer
28 views

Find out what is using SQL installations on a Windows Server

I have taken over a server that has tons of SQL Server related bits installed, and as far as I know, there are no applications on the server requiring the use of SQL. There are different SQL Server ...
0
votes
0answers
598 views

SQL Server 2012 Connection Timeout Expired

I am running MS-SQL Server on Windows Server 2012. From time to time I get this Exception: Server Exception : System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The ...
2
votes
1answer
108 views

What is the location of the SQL Server Fallback Certificate?

We are required to use encryption with SQL Server, so we have enabled ForceEncryption. According to the documentation, if a certificate is not provided, SQL Server will generate its own internal ...
0
votes
0answers
35 views

SQL Server : Improve SIMPLE SELECT to retun 2 LAC Rows faster?

We have a stored procedure in which we are creating a temp table which has more than 200,000 rows with 30 columns (2 of DATETIME, 4 of INT, 5 of [numeric](20, 3) and rest of VARCHAR(500) data types. ...
1
vote
1answer
182 views

Setting up a SQL Server 2012 Failover Cluster Instance on an Azure VM

I'm trying to set up a test lab in Windows Azure for a SQL Server 2012 Standard Failover Cluster. When deploying a SQL Server 2012 VM through the gallery, the instance that's created is pre-installed ...
0
votes
0answers
122 views

sql server, group by then count, 25 million rows per month, feasibility

So. We are doing some analytics in a scale I have no experience with. We have to extract some aggregate numbers and data from a whole bunch of server logs. (Estimated at 2gig a month total). I'm ...
1
vote
1answer
76 views

Colliding/overlapping full and differential backups in SQL Server

I am trying to set up a monthly full backup and a daily differential. The full backup is currently on the 1st, but I might change it to the first Saturday. I need to retain full backups for a few ...
0
votes
1answer
210 views

How can I view the SQL Server database created by an ASP.NET MVC web application?

I have an ASP.NET MVC web application deployed to IIS on a Windows Server 2012 machine. When the application first starts, it will create the database and tables it needs if necessary. This all ...