2
votes
1answer
118 views

Software crashing randomly and frequently. MS SQL error

So I just start this job at a small business and they have this software (lets call it "GDB") that crashes. The employees said this software did not have this issue three months ago but until ...
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 ...
0
votes
1answer
66 views

IIS/SQL Server showing RAM is 100% utilized but Processes add up to less than 15% usage

I have a Windows Server 2008 system running IIS 7 and SQL Server 2008 R2 with 64gb of RAM which is showing 100% of the available physical RAM being used at all times. However, when you look at the ...
1
vote
3answers
51 views

Restore MS SQL 2008 Database from files

is it possible to restore a MSSQL server by copying its directory/data files? I have a damaged hard disk and was able to salvage the C:\Program Files (x86)\SQL Server 2008\MSSQL\MSSQL10.MYDATABASE ...
0
votes
1answer
35 views

SSIS Execute from Job on server - Show Colors on package

We are running SSIS on SQL Server 2008 R2 I have a SSIS package that gets executed from a job on the server ever morning and it can take a few hours to complete. When you execute the package from ...
0
votes
1answer
113 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
0
votes
0answers
51 views

First login fails on hglab administrative console

I've set up a Server with Windows 2008R2 and Hglab 0.3.10, which is supposed to be a mercurial server. I've followed the instructions where at the end they say I should head to the website and start ...
0
votes
1answer
146 views

SQL Server 2008 side-by-side with SQL Server 2012, possible issues with SAP Business One 8.81 PL:07?

We have a Windows Server 2008 R2 Enterprise system running SQL Server 2008 Enterprise (x64) version 10.0.4067.0 and SAP Business One 8.81 PL:07. We would like to install a named instance of SQL Server ...
0
votes
1answer
1k views

“There are currently no logon servers available to service the logon request” when trying to remote desktop to a VM after a power failure

I have SQL Server 2008 R2 running on a virtual machine (vmware, Windows Server 2008 R2). I was connected to the SQL Server from another virtual machine via SQL Server Management Studio, then a power ...
2
votes
2answers
72 views

Migrating to the Cloud: Private or Public [closed]

This is a matter of opinion but I'm looking for some advice regarding an upcoming migration of physical servers to the cloud. I'm looking for some perspective - any opinions are welcome. Scenario: ...
0
votes
1answer
284 views

Cannot Connect to SQL Server 2008 R2 from Sharepoint Server

I have installed SQL Server 2008 R2 on dbserver and Sharepoint 2010 on webserver. When trying to configure Sharepoint to use the database installed on dbserver, it says it cannot connect. Then I ...
0
votes
1answer
132 views

SQL 2008 R2 Clustering AND DB Mirroring (Async)

I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk ...
0
votes
1answer
36 views

Installing MS SQL Server 2008 R2 Utilizing Data Array

Maybe I can't put together a query that finds what I am looking for on the Internet, but I want to make sure this is done right. I have a new server that has Windows Server 2008 R2 loaded onto a RAID ...
0
votes
0answers
125 views

Network adapter on Windows can't access local network

I have a HP server which has Windows Server 2008 as OS. I also have an Ubuntu server VM running with Hyper-V. My ubuntu server runs a web application which connects to MS SQL Server running on the ...
0
votes
1answer
30 views

Backing PDF files and SQL server DB

I have my own Windows Server an Asp.Net application hosted live. The application allows users to upload CV PDF files and I have the DB also on that server. Which steps should I take to ensure that all ...
0
votes
1answer
55 views

Which Website/User uses the Server resources on Windows Server 2008?

I have a shared webhosting server based on Windows 2008/IIS 7/Plesk 11.0 .Most of the time Server's CPU usage is over 80% and MS SQL Server process uses most of the CPU/RAM resources. I want to know ...
3
votes
2answers
259 views

Windows Failover and Load Balancing confusion

In the next couple months we are looking to add Failover and Load Balancing to our environment. We will have 2 servers that are Hyper V Hosts. We are looking to have an IIS App server and SQL ...
1
vote
1answer
948 views

Ram recommendations vs SQL DB size

we have a medium sized SQL db of around 40GB, and are about to move it to a new box with server 2008 r2 x64 some expensive contractor blokey has just come in and said we need 72gb of ram so that the ...
0
votes
1answer
573 views

How can I uninstall SQL Server Express from Windows Server 2008?

I installed Windows Server 2008 as my OS, but I dislike the SQL Server Express which it provided by default, so I changed to SQL Sever 2008 Enterprise. The problem is, I don't know how to remove the ...
2
votes
5answers
818 views

Cannot connect to windows server by name over vpn connection

I have a rented dedicated windows server on a public ip that is acting as a SQL Server and VPN server. I need to connect to this server via computer name to get replication in place. I cannot use an ...
1
vote
1answer
47 views

SQL Server 2008 Timeout Expired

I asked the question below on Stackoverflow without any answers, however, someone suggested I ask the question on serverfault also. Hopefully someone can help. I recently publish my ASP.Net MVC 3 web ...
3
votes
1answer
270 views

Highly available and scalable SQL Servers with read-only databases?

I've been thinking about building a website which could potentially get a lot of traffic. It would be a research site of sorts with wiki capabilities. So users would be able to edit information on ...
1
vote
3answers
497 views

SQL Server returning empty result sets (to busy?)

My apologies from the start, I don't have much information to go on and I am just looking for some help debugging my issue. I have 5 sites running on a Windows Server Web Edition 2008 with SQL Server ...
1
vote
2answers
101 views

Database Server Can't Find 300GB

I have a Windows Server 2008 R2 running Microsoft SQL Server 2008 R2. I have some how lost 300 GB of disk space, and I can't seem to find it anywhere. The Hard Drive is 500GB and I can only account ...
1
vote
1answer
156 views

single application multiple users through thin client

I am having one application built in C# winforms. In the backend I am using SQLSERVER 2008 Express. The application is used remotely through thin clients. My problem is that when one user is using my ...
0
votes
2answers
1k views

High memory usage, where is it coming from?

I have a virtual machine (Windows 2008 Server R2 64 bit running on vmware esxi 4) with 6 GB of installed RAM. It's reporting 95% memory usage and close to 0% CPU. This server hosts some WCF services ...
2
votes
1answer
128 views

Retrieve SQL Server 2008 Product Key

I am trying to obtain the SQL Server 2008 Product key from an installed instance on Server 2008 Std. The previous company never passed us the details and we need to install on a new server to ...
1
vote
1answer
46 views

SQL Server Rights to backup drive

I'm trying to copy a backup I've made from one server to another using either an SSIS or Powershell step in a job. I've run into the same error on both systems when running the step under the sql ...
3
votes
1answer
2k views

Windows Server 2008 Memory Usage with SQL Server 2008?

I have the following kit: windows server 2008r2 Microsoft SQL Server 2008r2 Dual Quad Core Xeons 52GB Ram The Ram usage on the server is currently at 98% which is fine, SQL server is happily ...
0
votes
1answer
52 views

SQL Server NIC Power Saving

We have a server running Windows Server 2008 which is dedicated to hosting a SQL Server 2008 Database. Whilst auditing the server OS we have noticed that the NIC Power saving feature is enabled. ...
0
votes
3answers
254 views

“Virtual” shared storage for SQL Server 2008 R2 Cluster

I am trying to set up a virtual test environment for a SQL Server 2008 R2 Cluster (2 nodes) running on Hyper-V. The cluster requires a shared storage to function properly, however in this test ...
0
votes
1answer
104 views

2 VMs with Win Server 08 - how to ping/connect to a DB?

In the past, I always installed SQL Server on the same machine as the server application that would be using it. Now for the first time I need to install a MS SQL Server 2008 R2 DB instance on a ...
2
votes
1answer
347 views

Allowing a specific IP Address through a blocked port in Windows Server 2008 R2 Firewall

I have created an Inbound rule to block port number 1433 however I need to allow my static ip address to access this as I use SQL Management Studio to connect to databases on the server. I have ...
1
vote
1answer
657 views

SQL Server 2008 R2 memory leak

We're in the process of moving from one server to another. I'm running the SQL Server database off our new server, with the old server now using that as a DB server with the aim to make it a smooth ...
0
votes
3answers
557 views

SQL Server 2008, should I set minimum server memory?

We move from this server: SQL Server Express R2 (has a 1CPU/1GB ram limit as far as I'm aware) 2GB Ram 2 core 2.1ghz To this server: SQL Server R2 Enterprise 8GB Ram 4 core 3.2ghz Everything ...
2
votes
2answers
2k views

SQL Server 2008 R2 doesn't start automatically on Windows 2008 R2 Web

I've got a SQL Server 2008 R2 Express running on a Windows Server 2008 R2 Web edition. Evertything works great except that the SQL service doesn't start automaticaly on server boot. The SQL Service, ...
0
votes
1answer
109 views

sql script mssql express 2008 windows 2008 server R2 x64

Scenerio:I need to run an update sql script after another scheduled task. server=Windows Server 2008 R2 x64 db = Sql Express 2008 when? - Everyday buy Sunday(i know how to do this) Why? A third party ...
0
votes
1answer
371 views

Can I install SharePoint Foundation 2010 with full SQL Server 2008?

I cannot find out how do I install SharePoint Foundation 2010 with full SQL Server 2008, it seems that installation wizard forces me to use Express edition. Is there a way to use Foundation with ...
1
vote
1answer
283 views

Setting Local Policy not working?

What could I be doing wrong here? Added Everyone to local security settings (testing purposes only) Forced the policy to update with gpupdate /force ran whoami /priv The permission I added is ...
1
vote
5answers
1k views

database sync across servers in SQL 2008R2

as we are in the process of expanding of businees, now we are stepping a ahead to add few more datacenter, now we have a requirement where we need to sync the production database with other ...
0
votes
4answers
2k views

Does sql server standard come packaged with windows server 2008 r2?

Does sql server standard come packaged with windows server 2008 r2?
1
vote
1answer
101 views

Server license - to purchase or not? [duplicate]

Possible Duplicate: Can you help me with my software licensing question? As an sys admins we need to provide our development team with both an integration and development environment. ...
2
votes
1answer
1k views

What is the default account/group for SQL 2008 R2 cluster permissions and can you create/add them?

Last night we had an issue where the permissions were altered a SQL 2008 R2 Cluster Instance, such that the instance could no longer access the shared drives where the system databases were installed. ...
0
votes
2answers
212 views

Can't connect to SQL server on dev server

I'm using VS2008 on my local machine for writing an ASP.Net app. Our SQL Server 2008 instance is hosted remotely on a dedicated database server. I can connect to the server through my app on both my ...
3
votes
3answers
371 views

SQL Server 2008 Workgroup Edition on virtual server with no swapping

I have rented a virtual server with 4 GB memory from Hosteurope, including a license for SQL Server 2008 Workgroup Edition. It works alright and is plenty fast, but whenever I put some load on it, it ...
1
vote
1answer
128 views

SQL Server connection for Active Directory users without creating explicit logins for each of them

Users, who are part of an Active Directory domain (Windows Server 2008), need to be able to connect to a SQL Server 2008 R2 (it can be Express edition) with the "public" role rights. Should I ...
2
votes
3answers
190 views

Trying to upgrade SQL Server 2008 to R2 getting strange error

The error states: No mapping between account names and security IDs was done. This is during an upgrade of 2008 sql server with sp3 to r2. This results in the database engine not being installed :( ...
2
votes
1answer
187 views

apache 2.2 with php 5.3 and miscrosoft sql 2008 crash

I am using Apache 2.2 with PHP 5.3 and Microsoft SQL Server 2008 on Windows Server 2008 64-bit. Every 3 to 5 hours, I get the error in the event viewer that Apache crashed for 20 seconds and then ...
1
vote
1answer
52 views

Do SQL Server 2008 Cumulative Updates Require a Reboot?

I have SQL box that I need to apply a CU (specifically #14). Can anyone confirm if a server re-start is needed after this update? I'm hoping that it doesn't need one but I'm guessing that's not ...
1
vote
0answers
473 views

SQLServerAgent could not be started (reason: Unable to connect to server ) Error 103?

Does anyone know how to make the second SQL instance Agent working on the same MSCS SQL Server 2008 R2 cluster? In the clustered SQL Server service instance2 i have assigned the same service account ...