1
vote
1answer
42 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
74 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
77 views

Connection Timeout Expired

Message:Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and ...
0
votes
3answers
52 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
1answer
91 views

Sql server 2008 R2 using Half of the memory [closed]

i built a new 2 cpu 8 core 40 gb ram Server for our ERP software which use Sql server 2008 R2 on Win server 2008 standart R2, in Sql There are 7 databases, 2 of them for Tests, 2 of them to keep ...
0
votes
1answer
204 views

GPO WMI username filter not working over RDP

I'm trying to write a WMI filter to prevent a GPO from applying to certain users SELECT * from Win32_ComputerSystem WHERE NOT UserName LIKE 'domain\\user1_%' AND NOT UserName LIKE 'domain\\user2_%' ...
1
vote
1answer
356 views

Servers in DMZ will not communicate with each other

(Full disclosure: I rate barely above "noob" when it comes to networking.) My workplace recent got a new web server. Since we're nearing the end of an overhaul of our website, we're doing a slooooow ...
2
votes
3answers
124 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 ...
1
vote
0answers
131 views

Save Images from MS SQL SERVER to a file on hard disk [closed]

I'm wondering if anyone knows of a free tool, or the actual SQL command that will save a binary image stored in a SQL SERVER 2008 R2 database to a file on my hard disk. I use Heidi SQL which works ...
2
votes
3answers
166 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 :( ...
0
votes
0answers
327 views

Key Card using SQL database can not connect to it's own database

What would be the main cause of an application not being able to connect to it's own SQL DB on a Windows 2008 standard server? It is localy installed just so you know.
0
votes
2answers
134 views

AWE turned on but still not using memory

I do have a server 2008 64 running a SQL server 2005. I do have 8GB on the server and I want SQL to use most of the memory on that server. I have turned the page-locking on for the account and also ...
0
votes
4answers
67 views

Installing SQL Server 2008 R2 Enterprise on my SQL Server express edition machine?

I recently got my copy of SQL Server 2008 R2 Enterprise. Is it safe to install SQL Server 2008 R2 Enterprise edition to my current machine with SQL Server 2008 Express already installed? Or do I ...
0
votes
1answer
161 views

Best solution for 2 servers for HA

Just to say I know some about servers and databases but not enough to achieve what has been asked so I just need some advice to set me straight :) Okay so we have two dedicated servers running ...
2
votes
1answer
97 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
0
votes
1answer
95 views

sql 2008 hard drive configuration

I'm building out a new SQL Server 2008R2 64BIT, will be running two user database of about 20gb and 15gb, maybe 50/50 read/write, and about 210 users Base hardware would be DL380, 48GB, and IntelĀ® ...
0
votes
2answers
44 views

Network MSSQL with local failover

I currently have a database setup where my MSSQL 2008 R2 server runs on my local network, but the program runs on a notebook that is normally mobile and away from the network. VPN works, but I'm ...
0
votes
2answers
63 views

SQL Server 2008 Vs SQL Server 2000

The performance of SQL Server 2000 database is not improving with the latest multi-core processors. I think SQL Server 2000 is not capable of utilising these cores. So, I plan to switch to SQL ...
0
votes
1answer
50 views

find out which method is pegging my IIS 7 server?

I have a pretty simple web service app running on my server but every once and awhile it pegs one of my cores to 25% constantly until I stop and re-start then it goes back down to between 1% ~7%. I ...
0
votes
1answer
400 views

How many threads/replies SQL Server Express will be able to serve?

I know that SQL Server Express is limited in its size but I don't know how to calculate and estimate the size needed. However, could you tell me roughly how many users and threads will it handle? ...
0
votes
1answer
102 views

Can't submit timesheets on Project 2007 and Server 2008R2 new install

I'm trying to test move a SharePoint 2007 and Project 2007 to Server 2008R2 and using SQL 2008 as the backend. I'm setting it up just like I have done numerous times for Server '03 and there are no ...
0
votes
2answers
119 views

Deleted user default database - SQL Server 2008

I cannot connect to the database anymore, I'm getting: Cannot open user default database. Login failed. I have deleted the database during a previous session and then tried to recreate it. But ...
0
votes
1answer
168 views

restore error on sql server 2005

open SQL Server Management Studio created one new database which is "house"(db name). Right click on this Databases node | All Tasks | Restore database. Click radio button 'From database'. Then i ...
0
votes
3answers
693 views

MSSQL 2008 R2- Restoring MASTER database from v10.00.1600 to v10.50.1600 fails with error

I backed up the master database on a machine with SQL Server 2008 version 10.00.1600. Then I turned on SQL Server in single-user mode on the new machine with SQL Server 2008 R2 version 10.50.1600 with ...
0
votes
3answers
169 views

sql server 2 node cluster - different apps on different nodes

I've got a 2-node SQL Server cluster (SQL 2008 sp1) running on Windows Server 2008 R2. It's an active/passive cluster and currently, node1 is the active node. There is an app running on node1. I've ...
2
votes
3answers
4k views

Can't Open Port 1433 on Window Server 2008 (attempting to connect to SQL Server 2008 Express)

I'm trying to open Port 1433 on windows firewall but not having much luck. I've added a new Inbound Rule (attempting to open TCP 1433) which looks okay and appears to be on but when I run netstat -an ...
0
votes
1answer
71 views

Why is sql server changing the value of the minimum and maximum memory?

I have a SQL Server 2008 R2 x64 instance. I tried to change the Minimum and Maximum memory to 60 MB and 2000 MB using Management Studio (Server Properties->Memory). When I close and reopen Management ...
0
votes
1answer
51 views

multiple clustered sql server

Is it possible to have more than 2 servers? (mirror principle) for multiple cluster?
2
votes
3answers
1k views

Managing SQL Server users via Active directory groups

I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server and database logins. I have several groups with different roles (admin, developer, user etc.), and I ...
3
votes
4answers
130 views

Upgrade SQLServer 2008 hardware

Forgive me if I'm not able to be totally clear here. It is not intentional, I'm a senior level developer in a very small company having to act like a manager at the moment. Anyway, the story is that ...
0
votes
1answer
195 views

Run a script prior to start of SQL instance via Windows clusters

We have a Windows 2008 cluster with several SQL 2008 instance. We would like to run a script that modifies 4 registry keys prior to the startup of SQL. I do not know if there is a way to have a ...
0
votes
2answers
119 views

trying to install SQL 2008 on Windows 2008 server R2

Hi I was trying to install MSSQL 2008 server on Windows 2008 server R2 Standard Machine, but I got this message: Program Compatibility Assistant, And that I should apply SQL server 2008 SP 1 I ...
1
vote
1answer
39 views

Shared SQL Server 2008

I have a Windows Hyper VPS plan with 1024 MB of RAM. After installing SQL Server 2008 Express, my memory usage went up to 75% without running my site yet. I know that SQL Server consumes a lot of ...
0
votes
1answer
791 views

Microsoft Windows Web Server 2008 + Microsoft SQL Server 2008 Web Edition

I am a totally rookie in this area. I am about to rent a Dedicated Server, that has Microsoft Windows Web Server 2008 installed in it. The plan is to put a web application that we have developed in ...
1
vote
4answers
556 views

cannot login to sql express 2008 by sql auth

I have just restored a database that has been backed up from MS SQL 2005 to plain (non configured) MS SQL 2008 that is running on Win Std Server 2008. I have recreated users but I cannot login when I ...
0
votes
2answers
2k views

Severe Memory Pressure on SSAS 2008 on Windows Server 2008

I have a single instance of SQL Server 2008 Analysis Services running on Windows Server 2008 x64 with 8GB of RAM on the server. All of the settings for memory are left to their defaults. When the ...
0
votes
1answer
403 views

SQL Server 2008 install error: VS2008 SP1?

I'm installing the developer edition of SQL Server 2008 and it's giving me the error: "A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft VS2008 to ...
3
votes
2answers
6k views

Can't restore SQL 2008 backup - error that the database is in use but it isn't

I am trying to restore a SQL Server 2008 backup and am getting the following error: RESTORE cannot process database because it is in use by this session. ADDITIONAL INFORMATION: ...
1
vote
5answers
6k views

Remote connection sql server not working but if firewall disabled it does?

I have setup sql server express 2008 on a windows 2008 server. And i have done all the standard stuff in sql to allow remote connections. The strange thing is if i disable the windows 2008 server ...
1
vote
3answers
1k views

Sql Anywhere 9 cannot access on Network

heres the situation, i have a windows 2008 enterprise server (brand new) so far the only thing installed on it out of the box is SQL Anywhere 9.0.2 and Mysql 5.1 its all setup and working i have ...