0
votes
0answers
60 views

Transferring Windows server from Rackspace to AWS

I've had a Windows server hosted with Rackspace for a while. The same setup also hosts the SQL server, and has all the IIS configs, etc. Being a Windows server noob, I have no idea how I could ...
0
votes
1answer
102 views

High memory usage windows 2008

I have a Windows server with 32 GB RAM, which is running sqlserver and tomcat. In resource monitor it show more than 95% memory usage, but when I searched in processes all process, each process is ...
0
votes
1answer
87 views

Installing SQL remotely using Invoke-Command

i'm trying to install SQL Server 2012 on Win 2012 r2 server remotely via Powershell using Invoke-Command, but it fails with this error "Validation for setting 'SQLSVCACCOUNT' failed. Error message: ...
0
votes
0answers
40 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
360 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
1answer
50 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?
1
vote
1answer
115 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 ...
0
votes
1answer
117 views

SNMP walk on Virtual Ip not working? what can be the reason

I have two MSSQLcluster, at a time VIP [virtual ip] that will be assigned to on of the master. The problem is when i try to do any snmpwalk on VIP from a different machine its returning me a time out. ...
0
votes
1answer
95 views

Windows Server and SQL Server Licenses [duplicate]

I have the following servers: PROD: 2 x web servers (content delivery) 1 x cms server 2 x database servers (SQL) UAT: 1 x web server (content delivery + cms) 1 x database server (SQL) I'm a ...
0
votes
1answer
1k views

Telnet 1433 on SQL Server Failing

I work with a number of SQL servers. Some are clusters and some are standalone. Some of the standalone servers run multiple instances and some do not. What I've found is that any SQL server I have ...
2
votes
1answer
46 views

Windows Server grindingly slow due to disk bottleneck caused by SQL Server

Doing anything on my Windows Server box is unbearably slow to the point of the system nearly being unusable...Looking into it I can see CPU isn't being used and there's plenty of RAM free. However SQL ...
-2
votes
2answers
325 views

Windows Server Configuration with Exchange, SQL Express and IIS [closed]

In our small office we are currently running a standalone tower server with WS 2008 R2, SQL Express and IIS. This server is going to be decommissioned and scrapped as its old and very noisy. We are ...
2
votes
1answer
323 views

SQL Server cannot be reached by name only by IP

I have several computers (XP) connected to domain controller (2008R2). Last time I had to change IP address of the SQL Server 2008 R2 (simple instance, no clustering or replication). DNS has been ...
0
votes
1answer
739 views

Can't connect to Windows Internal Database with SQL Server Management Studio 2012

I'm trying to connect using the following connection string, and Windows Authentication (Trying both to log in using the Administrator account, and the account I used when setting up the SQL Server ...
1
vote
0answers
170 views

How to index document files in NAS storage?

I'm currently developing an application that have to index document files (.pdf and .doc) which are in NAS storage. After that I want to query them over the application. My customer does not want to ...
0
votes
1answer
112 views

Can eventvwr.msc's log files be exported to text or sql server in Windows?

Can the events from the "Event Viewer" (eventvwr.msc) in Windows (7/2003 Server/2008 Server R2) be exported to sql server or to text files? Every search I do on Google for this returns how to export ...
2
votes
1answer
1k views

How do I log in, using SSPI, to SQL Server 2008 R2 on a server in one workgroup from a workstation in another?

We're having trouble connecting to our SQL Server (2008 R2) via SSPI. Our team has recently moved from a domain-based setup to a decentralised workgroup-based setup. Each developer has access to a ...
0
votes
2answers
441 views

Ban IP address based on X number of unsuccessful sql server login attempts?

Is it possible to expand on the idea presented in Ban IP address based on X number of unsuccessful login attempts? to encompass IP addresses for repeated failed sql server login attempts? There are ...
0
votes
1answer
226 views

MongoDB Master and Slave - Windows or Linux [closed]

I have recently moved my MS Sql Server DB to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...
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
167 views

EC2 + RDS, or just a bigger EC2? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Web Sites I need to develop a system that connect to multiples outter systems to get XML data and reply with ...
0
votes
1answer
59 views

Is it safe/wise to run Drupal alongside bespoke business web apps in production? [closed]

I'm interested to know the general community feeling about the safety of running Drupal alongside bespoke, business critial ASP.NET MVC apps on a production server. Previously my employer's Drupal ...
2
votes
2answers
283 views

Creating database backups using SQL Server 2012 Tools that can be imported by SQL Server 2008 R2

Basically I was learning the Ms stack of software and working on an application that used an *.mdf file mounted to the local ./SQLEXPRESS instance. I then upgraded all software on the machine to ...
1
vote
1answer
90 views

How to keep track (audit) of SQL Server users on multiple instances

I've a need probably most of you already solved in some way: beside (automatically) creating users (DB + users on single DBs) on multiple SQLServer instances, I need to keep "track" of them and, ...
1
vote
1answer
683 views

MS SQL can't connect with JDBC…permissions issues?

I used "sa" to create a user "secure1" and I can connect as secure1 using Management Studio locally and remotely. When I then switch to JDBC with the url(I use two \ in the url below but ...
1
vote
1answer
36 views

Installing Asp.net 3.5 sp1 on windows 2008 web server edition

I am trying to install sql server 2012 on windows 2008 web server edition but failing as asp.net 3.5 sp1 is missing. I cannot add asp.net 3.5 on this version as there is no 'Application Server' role. ...
1
vote
2answers
10k views

SQL Server 2012: I can connect locally but not remotelly

I'm trying to access a SQL Server 2012 database from a SQL Server Management Studio 2008 from a remote machine(on the same LAN). I can connect to the database using "sa" user under ...
2
votes
2answers
1k views

Windows authentication to SQL Server via IIS and PHP

We're running a PHP 5.4 application on Server 2008 R2. We would like to connect to a SQL Server 2008 database, on a separate server, using Windows authentication (must be Windows authentication--the ...
0
votes
1answer
1k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
0
votes
1answer
632 views

Server 2008R2 in Extra Small Windows Azure Instance?

Windows Azure hosting for an Extra Small (XS) Windows VM seems to come out to be about $10 a month right now. I think this XS instance gives you the equivalent of a 1 GHZ CPU with 768MB of RAM. I ...
0
votes
1answer
133 views

Windows, Apache and MSSQL Authentication

I have a create database script written in perl. I remember it working just fine another machine. A couple years later using a Vista machine I am trying to use it again and it keeps failing. The ...
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
275 views

exe hangs when scheduled from SQL Agent, but fine when run by user

I have a SQL Agent job on a clustered SQL 2008R2 server on Windows 2003 Enterprise. It's an Operating System (CmdExec) step, running an executable. When it runs on schedule, the process does start up, ...
1
vote
3answers
114 views

Is there a relation between MS SQL Server client licenses and performance

I have a customer who has an .Net application running on MS SQL Server 2008, supplied by our company as a part of Microsoft Small Business Server. He started off with around 5 users, and hence we had ...
-4
votes
1answer
896 views

Does SQL Server 2012 Developer Edition exist? [closed]

On my server, I have SQL Server 2008 R2 Developer Edition installed, and setup don't want to upgrade it to SQL Server 2012 Express. Does SQL Server 2012 Developer Edition exist?
1
vote
1answer
745 views

EC2 Sql Server with EBS and ephemeral drives

I'm planning to start a EC2 high memory instance with SQL server on it. I'm working through how to setup the drives as the current dedicated hardware is set to a raid-5 but only 4gb of ram so a lot of ...
0
votes
1answer
99 views

Configure SQLServer 2000 Win7 [closed]

I've got SQL Server 2000 running on Win7. There's no management tools so I wonder how do I configure/interact with the server. Main purpose for me is to enable remote connections. I know how to do ...
1
vote
1answer
398 views

what is the difference between 'NT Authority\Service' and 'NT Authority\Network Service'?

I am configuring a SQL Server Express 2008R2 instance, and I want the current logged in user to be able to access SQLEXPRESS. Which one should I add at the Database engine configuration step of the ...
1
vote
1answer
49 views

I am setting up SQL Server Express 2008 R2, how do 'Service Accounts' work

Ok I am setting up SQL Server Express 2008 R2 and I am at the following screen: What do I need to do here. Can I just press next? I'm guessing if I press next it will work but is this what you're ...
1
vote
2answers
256 views

How to I properly measure the network performance of SQL Server across a WAN?

We're in the process of migrating a number of servers to a different data center. As a stop gap measure, we've moved a set of web servers to the new data center and have left their supporting SQL ...
4
votes
3answers
699 views

How to create a minimum-privilege user for SQL server?

The installation documentation says best practice is to create a minimum-privilege account for the SQL Engine service to run as. What is the recommended practice on Windows to create such an ...
1
vote
1answer
3k views

SQL Server 2008 in Windows 8

I installed Windows 8 on my laptop and I'm going through installing my software. I just installed SQL Server 2008 R2, but none of the logon information I supplied will allow me to logon. I'm not ...
1
vote
1answer
692 views

Setup ejabberd with SQL Server 2008

Here's what I have got so far. Windows 2008 Server 64 bit. Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe. The windows service starts up fine but seems ineffective. ...
2
votes
2answers
1k views

Importing database from MS SQL Server 2003 to MS SQL Server 2008

I have 2 MS SQL Servers running on 2 separate domains and I'm trying to import data from 1 to the other. The 1st MS SQL Server runs on Windows server 2003. The 2nd SQL Server runs on Windows server ...
0
votes
1answer
209 views

A utility to backup single tables on MSSQL?

Are there any Windows utilities that allow you back up single MSSQL tables? Having a lot or trouble finding any. I hear sqlbackupandftp is good, but as far as I can see, it doesn't back up single ...
1
vote
1answer
182 views

Using Encrypting File System on SQL Server data files

I have SQL Server 2008 standard edition running on Windows Server 2003. I need to encrypt the databases. One obvious option is to upgrade to enterprise edition and use TDE. However, this might not ...
1
vote
1answer
257 views

How to execute rskeymgmt utility silently in windows server 2008

When i run reskeymgmt.exe - to create a backup copy of the encryption key, it responses "Are you sure want to extract the key from the Report Server? Yes (y)/ No (n)?" I found this link which ...
1
vote
1answer
278 views

Does enabling Kerberos require a server reboot?

We are going to enable Kerberos to allow double hop authentication between our SQL Servers. Our company is nearly 24 hours which leaves a very small window for server restarts. Is it possible to ...
0
votes
5answers
200 views

Have opened a port. Is my server vulnerable?

I have two dedicated servers. One which stores all the files (scripting) and the other hosts just the db. In order to connect to the other server I have enabled port 2335 on TCP/IP and added the ...
0
votes
1answer
151 views

How to check which port to enable on Windows Server 2008 Firewall

I have an application which supposed to be launch from a client machine, but every time I launch it, it shows me an error saying "Failed to talk to database". By the way it is a .Net application and ...