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)

0
votes
2answers
2k views

How to connect an ODBC DSN to nondefault SQL Server instance on default port?

We are migrating an SQL Server 2000 database on one server to SQL Server 2008 R2 on another server. The client application use a User DSN to connect directly to the SQL Server on the internet. I have ...
1
vote
1answer
47 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
1
vote
1answer
26 views

Why does SSMS Restore Database to another database not copy the current state of the “From” database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
2
votes
1answer
376 views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
2
votes
1answer
57 views

Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?

I have multiple databases which are constantly growing. So from time to time, I truncate the log table and shrink the biggest databases. For the biggest one (>40gb) it takes quiete some time. So I ...
0
votes
0answers
430 views

Connecting to MSSQL server using sqlcmd and odbc driver on RHEL 6 fails

I spent the last hour trying to connect to a mssql server using sqlcmd through odbc driver. I was talking to the db guy but he doesn't seem to have a clue what is going on.. Maybe you can help me out ...
1
vote
1answer
135 views

MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?

I have a Microsoft Sql Server that handles a moderate amout of traffic for a company software suite made up of multiple clients in java and c#. It is getting overloaded with 'Suspended' queries. They ...
0
votes
0answers
89 views

IIS7.5 Not connecting to MS SQL Server 2008 with PHP5.2.9 via php_mssql driver

Ok this is going to be somewhat involved. I have three servers: First I have a box running Linux with Apache and PHP 5.2.17. We shall call this "LB" for Linux Box. Second I have a Server Running ...
0
votes
1answer
66 views

Website can not connect to ODBC (no rights?) “Error: 80004005”

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) ...
0
votes
1answer
504 views

How to get php_mssql.dll working properly on IIS 7.5 and PHP version 5.2.17?

First of all I'll give a very brief introduction of what I'm trying to make. I need the mssql php functions to work on the webserver. I know that such functions were deprecated in PHP 5.3 and above. ...
0
votes
1answer
110 views

Connectivity between Web Server and SQL Server inside Amazon VPC

I have a Webserver and a SQL Server inside an Amazon VPC. Previously, a Webserver outside the VPC could connect to the SQL Server fine. Now, sometime, when running SQL Scripts (the deployment script ...
0
votes
0answers
113 views

Cannot generate SSPI context and VPN

I am the developer of a time recording tool written in vb.net using odbc. Using this tool from home via vpn (cisco) everything is working for ME and one other person. My collegue could connect too but ...
1
vote
1answer
66 views

Intermittent performance issues on Azure Web Application with ASYNC_NETWORK_IO errors

Our web application is suddenly experiencing intermittently slow performance (slow page loads, slow ajax calls going from <1 sec to over 20 secs). The only clue is when the application slows, we ...
0
votes
0answers
75 views

Inconsistent server connectivity with System.Net.HttpWebRequest

I have a production database server (Windows Server 2008 / SQL Server 2008) which has a .NET CLR Assembly referenced on it with a CLR function called dbo.fnu_RequestUrl. The purpose of this function ...
4
votes
1answer
147 views

Network traffic to server keeps dropping out

I have a production server that is responsible for controlling a factory. The server runs a number of control applications and a SQL server. The problem I have is that one of the applications that ...
1
vote
1answer
73 views

Downgrade SQL Express 2008 R2 SP2 (x86) to SP1

I'm looking to update vCenter from 5.0 to 5.1U1. In order to do the update, I need to downgrade the current SQL Express 2008 R2 SP2 to SP1 according to VMware compatibility matrix. Can I just ...
0
votes
0answers
18 views

MSSQL 2008 query VERY slow on live server compared to dev server - not sure how to debug?

Running SQL 2008 R2 on both servers. When we run a fairly large query against the developer server, it takes a few seconds. The live server takes around 1.5 minutes, even with no one else connected to ...
0
votes
0answers
96 views

Error:Microsoft SQL Server Native Client 10.0 error '80040e37'

I migrated a website attached to a MSSQL database from Windows 2003 running on IIS6 to a Windows 2008 R2 running on IIS7.5 but I get the error: Microsoft SQL Server Native Client 10.0 error ...
1
vote
1answer
18 views

SQL Server 2005 DROP LOGIN syntax error

This snippet of code (it's just a repeater, not the actual code I'm going to run) throws a syntax error on the DROP LOGIN command: declare @obso_user varchar(16) set @obso_user = 'BEN_VA\20362781' ...
0
votes
3answers
42 views

Separate SQL Server Instance or just new database?

I'm going to deploy an app whose requirement is just 'db_owner' for a database. The database itself must be created separately by the DBA. Based on how the application will work (and its simple ...
0
votes
0answers
35 views

Unable to connect to SQL Server over SSL

I am unable to connect to a SQL Server over SSL. This is the current setup: A server at my location sends data to an external service (SQL Server 2008) using SSL. We are using Websense and an ASA for ...
1
vote
3answers
106 views

How to use the join statement in MSSQL correctly? [closed]

I am pretty new to SQL and I already read something about joins , but coudn't find out. I painted my scenario here : I want to update the Firstname of Table1 into Temp1 where the CreateTS of the ...
1
vote
0answers
27 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
42 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
41 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
29 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
83 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
44 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
831 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
1k 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
154 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
27 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
57 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
39 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
38 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
45 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
50 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
54 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
84 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
41 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
103 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
42 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
97 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
217 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
249 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
86 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
47 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
44 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 ...