-1
votes
0answers
14 views

Image uploads to server cant be assessed from web untill I run Plesk Reconfigurator

Plesk Reconfiguration offered me the option to change to a folder with another name other than Vhosts so I directed it to a new foler I made in root called WEBSITES. The thing is my Wordpress ...
1
vote
0answers
74 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
0
votes
1answer
106 views

SQL Server Timeout issues at random times causing performance degradation

I am having random timeout during a brief period of time on certain days. My CPU, Memory looks fine. So I ran Performance Monitor during these spikes and found my average disk sec/read was 5.8 ...
2
votes
0answers
84 views

Mirrored local accounts to connect to database on different server and domain

My database client and database server are on different machines and are not connected to the same domain (this is not supported with my web host). I'm not keen to send username/password details via a ...
1
vote
3answers
113 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
4answers
50 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 ...
2
votes
1answer
385 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 ...
1
vote
1answer
58 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
1answer
60 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 ...
0
votes
1answer
75 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
1answer
32 views

Why is SQL Server seperate from the roles in Windows Server 2008 Server Manager?

I have an instance of Windows Server 2008 running on my machine. Within the OS there is a useful application called Server Manager, where I can manage several roles for my machine (such as web server, ...
0
votes
1answer
59 views

How can I troubleshoot an application connecting to SQL Server

I'm trying to get ASP.net StoreFront to Connect to SQL Server Express 2005, on Windows Server 2008. I followed This Microsoft Support article without success. Below is the error. [SqlException ...
0
votes
1answer
107 views

Sharing LINUX NFS Folder on Windows Server

I have some CSV files on Linux. I would like to load them into my SQL Server with a stored procedure. I'm looking for a way to share the files via NFS with my Windows Server. I was wondering if ...
0
votes
1answer
3k 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 ...
1
vote
2answers
726 views

Creating shared folder between to servers

I need to create an SQL log shipping between 2 databases, The source is on an AWS EC2 instance running Windows Server 2008 R2 and SQL Server 2008 The destination is on an Azure VM running Windows ...
0
votes
0answers
90 views

Server infrastructure for busy e-commerce site built on MVC4 using MSSQL and Solr

What kind of server architecture do I need for this kind of application to make it more reliable. eCommerce application with abt 100,000 product with moderate to heavy traffic. The site performs very ...
0
votes
1answer
64 views

Performance issues with windows server, sql-server and apache

I am running into some performance issues on my server, which runs Windows server 2008, SQL Server 2008 R2, and apache. This is a purely internal website, and is accessed by a total of about 6 ...
1
vote
2answers
38 views

2008 Clustered Services (SQL) to 2008 R2 Clustered Services

I've found plenty of articles for upgrading SQL in a clustered environment from SQL 2008 to SQL 2008 R2. However, I have not found much information in relation to migrating a current Server 2008 ...
1
vote
1answer
107 views

Failover server for SQL Server mirror errors after reboot

I have two Windows Server 2008 servers set up, both running SQL Server 2008 R2. One is used as a primary DB, the other as a mirror failover (two website DBs + ASPState for sessions). Everything works ...
0
votes
4answers
119 views

Allow IIS_USR to connect to SQL Server

I have a problem to connect to a SQL Server database with a web application that use ADO. I have one server under Windows Server 2008 with domain controller role and another server under Windows ...
0
votes
1answer
667 views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
0
votes
1answer
49 views

Database got hacked and now our server is unresponsive. [duplicate]

Just recently we noticed in our website (which was made by a 3rd party before) that the database was compromised. All data was appended by a small html information. What we did is to change all the ...
0
votes
1answer
149 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 ...
1
vote
1answer
605 views

Load balancing with High Availability - SQL Server + IIS using AWS

This is my first time load-balancing with high-availability using Windows and SQL Server. Looking for some validation and input on my planned setup. Now, typically when I want to create a HA ...
1
vote
1answer
83 views

Configuring ISS and SQLSERVER for ASP.NET MVC application and windows authentication

I have freshly installed ISS with SQL server and asp.net mvc application. I want my app to use windows authentication. On my application side, i know that i have good connection string, because i was ...
0
votes
1answer
316 views

How to know which application is consuming the ram?

I have the following process list and memory consumption (reported thru process explorer) on a 2008 R2 server with SQL, TFS and some other tools: As you can see the system is consuming 3.6 Gb but ...
0
votes
1answer
181 views

MSsql 2008 sql agent task output to network drive

I'm trying to get the SQL agent job (task) to run my query then put the output file to network drive. When I select the output file the only drives listed are local. I'm new to jobs and MSSQL but have ...
0
votes
1answer
31 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 ...
-2
votes
1answer
78 views

Solarwinds migration

I want to migrate my solarwinds to a new VM ware. Currently my solarwinds is installed in a Windows Desktop with the database stored locally in it. During migration to a VM ware, I want to point the ...
0
votes
1answer
99 views

SQL Server maintenance tasks cannot run after changing computer name

I am having a problem performing maintenance tasks on Microsoft SQL Server 2008 after changing my server name from the original random name given during installation to the one I prefer This is the ...
-1
votes
1answer
95 views

4 CPUs - 2 on 100% 2 on 30% - How do I even the load out?

When running a job on a SQL Server 2008, I notice that 2 CPUs are running at 100% but 2 are only about 30%. How can I spread the load and will it reduce the duration of the job which currently takes ...
4
votes
1answer
171 views

How does a SQL Server Availability Group decide on which secondary will become the new primary when an automatic failover is triggered?

How does a SQL Server Availability Group with multiple synchronous-commit secondary replicas decide on which secondary replica will become the new primary when an automatic failover is triggered? ...
2
votes
1answer
82 views

MSSQL 2008 Service Account

Background: We are a smallish company that prefers to keep things simple and not have to manage our Active Directory very much. My company uses a single administrator account to setup and do all the ...
0
votes
1answer
607 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 ...
1
vote
0answers
200 views

Can I tune my Debian KVM server to benefit my Windows guest?

Debian Squeeze KVM server with Win2k8 server guest. The server has 16GBs of RAM and the guest only runs MS SQL, with a 15GB database on it. I am wondering if there is anything I can tune from the ...
1
vote
2answers
181 views

How to stop / start MS SQL services to allows copying SQL database

I would like to find out how to stop / start MS SQL services so that I can copy SQL database files. I know how to do this manually but I would like to do this from a script.
1
vote
3answers
582 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 ...
0
votes
1answer
616 views

SQL Server NETWORK SERVICE account permissions

My SQL Server Windows service is set to use the NETWORK SERVICE account. The server is installed to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL. However looking at the ...
1
vote
1answer
47 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 ...
1
vote
0answers
380 views

Compressed network file copy

I have 200 GB of SQL Server files I need to copy over a 100 Mbit connection. Assuming maximum throughput that will take five hours. SQL Server files compress very well, generally in the 80 - 90% ...
3
votes
0answers
443 views

Glassfish connection pool don't work after restart server

I have a connection pool in Glassfish 3.1 to connect to SqlServer 2008 Express, this pool works fine, but when Glassfish is restarted, the connection pool can't ping and stops working. To work again, ...
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 ...
1
vote
0answers
66 views

SQL Server related perfmon counter porting 0 on remote machine

I'm trying to monitor a remote SQL Server via perfmon but all SQL related counters are reading 0. What works: On the target Windows Server 2008 running Microsoft SQL Server 2008 R2, reading both ...
0
votes
1answer
75 views

Can Reporting Services 2008 be installed on an existing web farm?

I have a question regarding whether Reporting Services can be installed on an existing web farm, at least the front end portion. The situation is that we have a limited number of servers available to ...
2
votes
3answers
127 views

Server RAID and Partition Config for Small SQL Environment

I've got 5 databases that run on separate servers using SQL Express. Some of these include a Citrix Datastore, Citrix Edgesite Server, an AV db, Time and Billing App, and a document management ...
6
votes
1answer
6k views

How do I limit MS SQL Server memory usage?

I've heard MS SQL Server takes up as much RAM as it can to cache results. Well, it's not leaving enough bargaining room for our little server's RAM. How do I change the settings to limit the amount ...
0
votes
1answer
297 views

Create ODBC Connection from Access to SQL Server

I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with ...
1
vote
2answers
116 views

Create a Public SQL Server

I have a testing environment that I would like my team members to access just to develop on. It is not linked to any other server system or network, however it is open to the Internet. What I would ...
1
vote
3answers
156 views

Windows Server 2008R2 Enterprise for Web Server. Any Benefits?

Hi I've looked at the comparison charts between editions of Windows Server 2008 R2 but I don't see a definitive answer to my question. We have licenses for Windows Server R2 Web as well as R2 ...
-1
votes
1answer
205 views

How Do I Configure SQL Server 2005 Backend? [closed]

I am trying to develop an inventory/payroll system for a factory. The information will be stored on a server, Windows Server 2008 R2, and SQL Server 2005. I'm going to store the records on the server, ...