Tagged Questions

0
votes
1answer
27 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 ...
1
vote
0answers
54 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
0
votes
1answer
109 views

Best practice for setting up SQL server on a Virtual Machine [closed]

This is my first attempt at virtualizing SQL server on VMWare and I want to make sure I am doing things correctly. Should I have SQL server installed on the C: drive / same partition as the OS, Then ...
0
votes
1answer
360 views

physical memory usage is high on production sql server [duplicate]

Possible Duplicate: SQL 2008 Memory Usage I'm going threw high physical memory usage in SQL Server. It always around 90%.When i reboot the server, it will initially good but end of the day ...
1
vote
2answers
77 views

What ports do I need to open up on my Win 2k12 server for MSSQL Express 2008?

I'm running Microsoft SQL Express 2008 on a Windows 2012 Server box. Got everything work, and I even manage to connect with the firewall down. But I dont really want the firewall turned off at all ...
0
votes
2answers
983 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 ...
0
votes
1answer
91 views

Data transfer between servers extremely slow

I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same ...
0
votes
1answer
82 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
64 views

DiscountASP.NET/shared hosting [closed]

I am in the process of trying to source an ASP.NET MVC3/SQL2008 host and think I'm happy with DiscountASP.NET however I have a few questions which I can't seem to find answers to: 1) What sort of CPU ...
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 ...
2
votes
2answers
388 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 ...
1
vote
1answer
124 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 ...
0
votes
3answers
39 views

Copying SQL Server 2005 Databases

We currently have a single SQL server (2005, on a Windows server 2003 machine) with 3 DBs on it that I would like to just straight copy so that I can run some test on them for an upgrade. I don't ...
0
votes
1answer
156 views

MS-SQL Server 2008 size limitation on data

I recently discovered that MS-SQL Server 2008 imposes an upper limit of 8000 bytes for a column (for character data). I need to store data that occusionally could surpass this limit. Is there a way to ...
0
votes
2answers
853 views

Cannot install SQL 2008 RC2

I can't run SQL server after installing it. Its looking in e:, but I do not have an e-drive. I have tried resetting my registry key as shown here all the answers here Log file: 2011-05-19 ...
0
votes
2answers
215 views

SQL Server 2008 login failed

I have a virtual machine (vmware) with Windows Server 2008 R2 x64 and SQL Server 2008 R2 installed. I see 2 SQL Server services on this vm : sqlexpress, mssqlserver. Both of them are use the default ...
0
votes
2answers
98 views

How can I check what files people are downloading from my server

I have small server with IIS and windows server 2008 hosting one page. Sometimes my bandwidth is completely overloaded. How can I check what files are being downloaded from my server that is killing ...
1
vote
3answers
1k views

Can I install SQL Server 2008 R2 on a Windows Server 2008 R2 Standard machine in a workgroup then join the server to a domain?

I have a Windows 2008 Server Standard x64 machine that I need to install SQL Server 2008 R2 Standard on then ship it to a different site where it will be joined to a Active Directory domain. The ...
0
votes
1answer
226 views

Configuring Windows Authentication on SQLEXPRESS

I've successfully followed the many tutorials to enable remote connections to my SQLEXPRESS Server. I'm now trying to connect remotely through SQL Server Authentication and the connection works, ...
0
votes
1answer
64 views

DB Tables missing in Script Wizard

I'm trying to script some DB tables in SSMS's Script Wizard, but when I get to the Choose Object Types step, there are no tables, only a checkbox labelled Tables. Anyone have an idea what is wrong ...
3
votes
1answer
73 views

Script to mirror MS SQL Server databases between 2 servers

I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others) One server is production and the other is primarily there as a backup. We're rebuilding all of ...
1
vote
0answers
377 views

Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd

I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services. The proxy mostly works but ...
0
votes
2answers
107 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
313 views

Search Server 2010 Express with full SQL Server 2008

By default, standalone installation mode of Search Server 2010 Express automatically installs SQL Server 2008 Express. Is it possible to use standalone mode with full SQL Server 2008, not Express? Or ...
1
vote
2answers
258 views

SQL Server: Filegrowth options for Data Warehouse database?

I'm creating a database for data warehousing purposes. The database will grow about 10 000 - 100 000 rows in a week (this is a guess). I think that I'll have to go with database file autogrowth, what ...
0
votes
1answer
122 views

CAn't backup database

I created a backup file from one instance and I was going to restore the file in a new Instance, which is SQL server R2. And It didn't work, I got this error. This is the error I am getting when I ...
1
vote
3answers
109 views

I cant reach my new SQL instance

I was using a older version of SQL on my server, and it worked fine when only typing the servername,, I could directly connect to the server, I recently installed a new instance of SQL, and Iam ...
0
votes
4answers
2k views

Performance Monitor w/ SQL Server - how many counters is too many?

I'm doing some performance analysis using the built-in Windows Performance Monitor, both on general hardware and SQL Server. I've been reading a lot about which performance counters to use; in ...
0
votes
1answer
140 views

try to install SQL2008 on windows 7 but got some error

I try to install SQL2008 enterprise ON WINDOWS 7 64bit & 32bit but I got the same error when I installed it I chose instance feature only and the error which I got "on Wait on the Database Engine ...
1
vote
3answers
678 views

SQL Server Enterprise Edition: Use more than 4GB of RAM on a 32 bit Machine?

I would like to install SQL Server 2008 on a 32 bit machine. I have read that it is possible with the SQL Server Enterprise edition to increase the memory over the 4GB? Is this true? Any ...
1
vote
2answers
348 views

Impact Disabling “Update Root Certificates” Has On SQL Server

I was told that Disabling the Update Root Certificates option from the Windows Components section of Add/Remove Programs will cause SQL Server to stop working properly. It this correct, or is my ...
2
votes
3answers
230 views

MSSQL Two Database Servers 1 Database

We have two servers. They are both HP DL 380 G6 servers with the same hardware and specs running Windows Server 2008. Currently the second server is a warm standby for the first with an automatic fail ...
9
votes
1answer
7k views

Remove Setup Bootstrap folder on SQL Server 2008 to free space

Is it "safe" to delete any of the subfolders in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\ from my drive to free up space? Or is it needed for upgrade/uninstall and other patches? ...
1
vote
6answers
7k views

Can't connect to sql server 2008 named instance

I have sql server 2005 and 2008 running on a server on my local (and very straightforward) network. Using sql management studio 2008 and visual studio 2008, I can connect over the network to the 2005 ...
1
vote
1answer
515 views

Installing Office SharePoint 2007 on Windows Server 2008 R2?

I have Windows Server 2008 R2 Standart. I want to install Sharepoint Office Server 2007 on my server. When I try to run setup, Program Compatibility Assistant warning this message : ...
0
votes
1answer
971 views

Where can I get Windows2003 SP2 FileStream HOTFIX?

When I was installing SqlFailover Cluster, at one stage before installing SQL Server it shows: Windows2003 FileStream HOTFIX failed. So I think this is not installed. Where can I get it?
2
votes
1answer
404 views

Windows Essential Business - limitations/experience?

Our company is mid-size, and we are considering the purchase of both Exchange server and SQL server. Buying all the software products and CAL's seperately seems kind of expensive, so I'm wondering if ...
18
votes
8answers
50k views

SQL Server 2008 Express - “Best” backup solution?

What backup solutions would you recommend when using SQL Server 2008 Express? I'm pretty new to SQL Server, but as I'm coming from an MySQL background I thought of setting up replication on another ...