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
1answer
23 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
162 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
66 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
302 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
279 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
46 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
507 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
489 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
57 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
333 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
46 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
63 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
492 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
78 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
30 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
154 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
104 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
59 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
133 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 ...
1
vote
1answer
33 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
0
votes
1answer
171 views

SQL Server 2012 Reporting Services need to repair

I had SQL 2012 installed with SSRS. Then I was playing with IIS and deleted (I think) ReportServer aliases and webs Now I need to work with SSRS but can't figure out how to return it back. Service is ...
0
votes
1answer
49 views

SSRS 2012 SharePoint-Integrated mode

We have a 2-server (web and app server plus a database server) SharePoint 2013 farm. We would like to add SharePoint-integrated mode SSRS 2012 to it. We were thinking of installing SSRS SharePoint ...
1
vote
3answers
84 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
0
votes
0answers
25 views

Can't Find SQL Server 2008 R2 SP2 uninstall option

Supposedly, the method to uninstall a service pack to SQL Server 2008 R2 (and other versions after a certain point) is through Control Panel > Programs and Features. I think it's supposed to be ...
2
votes
4answers
413 views

Suitability of DL380p-Gen8 + D2700 for SQL 2012 Standard Edition

A question for those who know about HP server performance and SQL... I am trying to spec a suitable server that has the following requirements: Run SQL 2012 Standard Edition (I cannot get approval ...
1
vote
1answer
49 views

Failover clustering or Network Load Balance on windows server

I have 2 servers with Windows 2008 R2 standard OS. I need to create a cluster in case on of the servers goes down ; so the other one will continue provide services. The services we mostly use are a ...
1
vote
1answer
46 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
0
votes
2answers
96 views

Less than 10% Free Space on Database Server

2-weeks ago one of our web servers CPU Usage started bottle-necking lot at 100% for long periods of time when an application runs and requests "sqlserver.exe"..When this app runs and does its ...
0
votes
0answers
24 views

Reporting Services layout changed

I have a new SQL 2012 Reporting Services installation on Server 2008 R2. I logged into the site using Internet Explorer 8 and it is now appearing like this. Does anyone know what is causing this and ...
0
votes
1answer
56 views

Internal Office Domain and External Server Domain Trusts

I have a single office domain - internal with an external IP address. This server is our office active directory running windows server 2008r2. (AD : PPInternal) With that, I have a private cloud ...
3
votes
1answer
945 views

Why does my SQL Server use AWE memory? and why is this not visible in RAMMap?

We have a Windows Server 2008 R2 (64-bit) 8GB server where, according to Sysinternals RAMMap, 2GB of memory is allocated using AWE. As far as I understood, this means that these pages stay in ...
1
vote
1answer
455 views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...
0
votes
0answers
42 views

SQL Server 2008R2 multi instance Cluster with mutual active/passive

I'm looking for a way to set up an 2008R2 SQL Server with an multi instance Cluster which serves mutual active/passive. So basically two nodes where each one holds half of the databases active and ...
-1
votes
1answer
68 views

How to create a new sql server instance without installation media

I'm relatively new to SQL Server installations ( however I use extensively the Management Studio), the situation is that I have a server (machine) where the SQL Server has been installed ( not by me ...
0
votes
2answers
25 views

Do you have to fully install SQL Server if you want a .NET application to do a remote connection?

I have a .NET application that connects to a local SQL Server 2008 database. Now the application is changing to connect to a remote database. My question is, if I'm going to install this application ...
1
vote
2answers
281 views

Can remote queries cause locks?

We have a SQL Server 2005 (SERVER-A) server that holds the database for an application that has been locking a lot lately. We suspect that the problem are transaction locks, so we decided to capture ...
0
votes
2answers
55 views

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to ...
0
votes
1answer
60 views

SSPI authentication error and untrusted domain with valid account

I am developing a program in .Net and it works great in the development environment. It connects to a few databases (SQL Server) and uses SSPI authentication to do so. When I move this program local ...
-1
votes
2answers
72 views

Secure communication between two hosted dedicated servers? [closed]

I'm planning to host a site on a pair of dedicated servers (both running IIS/SQL Server with SQL replication). Since the hoster only provides a public IP on each machine, how would I secure ...
0
votes
0answers
170 views

SQL Failover Cluster Resource DNS Registration Failure

I've got a cluster I migrated from one location to another (new IPs). I've moved a few other clusters like this recently with no issues. This recent cluster all came up fine except one 2012 instance. ...
2
votes
3answers
157 views

Is it okay to put applications on an Active Directory secondary server? What pitfalls?

I have a fixed number of VMs in my Windows/IIS website setup, which I cannot change in the short term: a web server, which is badly overloaded from a memory and cpu load standpoint (IIS6, Server ...
4
votes
1answer
482 views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
1
vote
1answer
546 views

Install MSSQL and .Net Framework 3.5 in Windows Server 2012

I have downloaded Windows Server 2012 VHD (Hyper-V VM) and wanna install MSSQL 2012 in it. But it's failing asking for "NetFX3". Googling about it I discovered it's .Net Framework 3.5 and lots of ...
3
votes
1answer
353 views

Why do I get prompted for “Data Source Credentials” when editing a SSRS report for SCCM?

When attempting to add a dataset in Report Builder I am prompted to "Enter Data Source Credentials." Choosing "Use the current Windows user" fails, and I don't have the password for the specified ...
0
votes
2answers
72 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
1
vote
1answer
36 views

Protecting SQL from Profiling

We have some sensitive IPR in some Stored Procedures. We encrypt the stored procedures. However, at the point they are created, they are plain text. Is there anyway we can prevent SQL Server Profiler ...
0
votes
0answers
55 views

MSSQL on AWS RDS - Should I be worried about falling freeable memory?

My question is similar to What is "freeable memory"?, however we are using MSSQL on RDS, as opposed to mysql. We are seeing a consistent downward trend in freeable memory. Currently sitting ...
1
vote
2answers
120 views

Spoof database connection to be local instead of remote

I am trying to connect one of our clients "as is" programs to a remote database instead of a local one, they think that they have coded it to work that way, but for some reason the program crashes ...
0
votes
0answers
64 views

SQL database instance cannot be set to SINGLE_USER

I am trying to make my database Single User Mode and I tried executing this: ALTER DATABASE [db] SET SINGLE_USER WITH NO_WAIT and it returned: Option 'SINGLE_USER' cannot be set in database ...