Tagged Questions

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
0answers
107 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
435 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
154 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
20 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
223 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
21 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
62 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
48 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
125 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
34 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
51 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
46 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
34 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
228 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
128 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
2k 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
3k 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
194 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
55 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
75 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
60 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
72 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
61 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
135 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
143 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
32 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
128 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
71 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
261 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
74 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
141 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
588 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. ...
1
vote
1answer
657 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
129 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
57 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
66 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
67 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
2k 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
28 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
399 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
85 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
785 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
524 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
81 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
1k 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
2k 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
76 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
681 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
56 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.