A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

learn more… | top users | synonyms

0
votes
4answers
399 views

Log Shipping multiple database SQLServer 2008 Standard

We currently use a fairly basic script we wrote to log ship our databases to our DR site (and back again) but want to move to a better solution. We initially discounted the inbuilt logshipping ...
2
votes
3answers
524 views

SQL 2008 - db mail issue

I have two instances of SQL Server 2008. One was upgraded from SQL Server 2000 and one was a clean, new install. The instances are running on different nodes of the same cluster, although I have ...
1
vote
3answers
339 views

MSSQL Server is inaccessible from other domain users

I am unable to connect to other machines with the same domain and network. SQL Server 2008 is running, I can connect locally with MSSQL01\Administrator and password using Windows authentication. ...
1
vote
3answers
2k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
1
vote
3answers
559 views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
1
vote
3answers
391 views

2 Servers setup for redundency, backup

I presently have 1 dedicated virtual server running my website/blog/mail, etc. This is on Hyper-V with 512MB RAM. Windows Web2008. With the VM, I have these running within it: SmarterMail – for ...
0
votes
3answers
47 views

How do I update the SQL Server 2008 to include the studio?

How do I update the SQL Server 2008 to include the studio? Here is what I currently have on my machine: I assume I am supposed to clidk on "SQL Server Installation Center" From there I get this ...
0
votes
3answers
2k views

Connect over WiFi to SQL Server from another computer

I tried to connect over WiFi to SQL Server with SQL Server Management Studio from another computer, but it failed. I have a computer with Windows 7 & SQL Server 2008 (lets say the server ...
0
votes
3answers
708 views

syspolicy_purge_history generates failed logins

I have a development server with 3 instances: Default, A and B. It is a physical server, non clustered. Whenever the syspolicy_purge_history job runs at 2 am, I get failed login alerts. Looking ...
0
votes
3answers
279 views

Unable to connect to local SQL Express (2008)

I'm trying to get an installation of SQL Express 2008 working, but no matter what I do I can't connect to it with management studio. I've enabled TCP/IP for the instance. I've tried connecting with ...
0
votes
3answers
2k views

Disable remote access for one user/database in SQL Server 2008

is this possible to disable remote access for one user or database in SQL Server 2008? Thanks
0
votes
3answers
101 views

SQL Server 2008 hosting (for development)

We are doing distributed development, working at home, office and sometimes at customers. We are using assembla for source-repository and we need a centralized-remote SQL Server 2008 database hosting ...
2
votes
2answers
345 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
1
vote
2answers
250 views

Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2

I am trying to add a anonymous IIS user [IUSR] to a SQL SERVER 2008 r2 database. But I am getting the following error: 'notebook/iusr' is not a valid login or you do not have permission. I think ...
1
vote
2answers
148 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 ...
1
vote
2answers
170 views

I cannot connect to SQL Server 2008 Mangement Studio

I'm trying to connect to SQL Server 2008 and I get the following message: Cannot connect to .\SqlExpress. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while ...
1
vote
2answers
160 views

Xen virtualized Server 2K8R2 w/ SQL 2K8 becomming unresponsive

About a year ago, we virtualized most of our small business Windows and Linux infrastructure, which included starting a fresh (not P2V) Server 2008 R2 VM. This performed acceptably until a few weeks ...
1
vote
2answers
162 views

SQL mirroring Error- SQL 2008

I am trying to configure SQL Server mirroring and I am getting the following error: The server network address "TCP://santosh-PC:5023" can not be reached or does not exist. Check the network address ...
1
vote
2answers
1k views

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server ...
1
vote
2answers
571 views

Diagnosing poor performance on IIS / ASP.NET / MSSQL app

I'm trying to diagnose the cause of poor performance from a third-party web application we've deployed; the environment is: ASP.NET on IIS, Windows 2003 Server SQL Server 2008 on a separate Windows ...
1
vote
2answers
292 views

not able to attach mdf file sql server 2008

I installed the sql server 2008 enterprise version that i got from mcts 433 prep kit. after installing i tried to attach the adventureworks mdf file and got the error below "the server principal ...
1
vote
2answers
168 views

SQL server availability issue: large query stops other connections from connecting

I've got a high-spec (multicore, RAID) server running MS SQL 2008, with several databases on it. I have a low throughput process that periodically needs a small amount of information from one of the ...
1
vote
2answers
3k views

Could not continue scan with NOLOCK due to data movement during installation

I am running Windows Server 2008 Standard Edition R2 x64 and I installed SQL Server 2008 Developer Edition. All of the preliminary checks run fine (Apart from a warning about Windows Firewall and ...
0
votes
2answers
27 views

SQL 2008 Failure after compressing HDD

I've absent-mindedly let Windows Server 2003 compress a HDD to try and save some space. That same drive contains an instance of SQL Server 2008. Since compressing, all the Databases have taken ...
0
votes
2answers
192 views

Cannot open SQL 2005 database in SQL server Management Studio 2008 R2 on Windows 7

I have Windows 7 64bit as my OS + SQL Server 2008 R2 installed. I can connect to SQL Databases (2008), but cannot connect to a SQL 2005 database. I can, however, connect to the 2005 SQL Database on ...
0
votes
2answers
39 views

using multiple schemes in a clustered sql server 2008 Database

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
0
votes
2answers
261 views

Unable to shrink the transaction log file in Sql Server 2008

Am using the below to script shrink the transaction log *USE AVPC GO BACKUP DATABASE AVPC TO DISK = 'H:\DBBackup\AVPC\FullBackUp\AVPC.bak' USE AVPC GO BACKUP LOG AVPC TO DISK = ...
0
votes
2answers
663 views

SQL Server 2008 Express R2 restores after restart (and fails)

Almost every time I restart the machine hosting a SQL Server 2008 R2 express server, the database goes through the restore process. Most of the time, the database will become stuck in the restore ...
0
votes
2answers
547 views

Installing SQL Server 2008 SP2 fails in 2003 cluster setup

When I try to install SP2 (or simply "repair" the SQL Server installation), the dependency check finds the following problem: Rule "Not clustered or the cluster service is up and online." failed. ...
0
votes
2answers
133 views

Install SQL Server 2005 on computer with an existing SQL Server 2008 installation

I have a Windows XP 64 bit workstation. I installed SQL Server 2008 R2 Standard x64. After that, I installed SQL Server 2005 Standard x64. Installation completed with no issues, but no instance was ...
0
votes
2answers
208 views

Trouble installing SQL Server 2008

Greetings, As a developer I want to have SQL Server 2008 installed on my laptop. However when trying to install the management tools (basic and complete) it keeps whining about Another version ...
0
votes
2answers
104 views

Sql Server Database Backup

How Can I backup An Sql Server Database To My Local Drive From Remote Server
0
votes
2answers
249 views

MVC2 Application Performance on Windows Server 2008 R2 with IIS7.5

I originally posted this on StackOverflow but I feel as though the problem lies with the hardware / OS configuration. I'm hoping that someone here has had a similar experience and can offer some ...
0
votes
2answers
604 views

SQL Maintenance Cleanup Task Working but Not Deleting

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 days. When I run the job, it gives me a success message but older .bak files are still ...
0
votes
2answers
62 views

WIll DAC allow me to run queries on a pegged SQL Server instance?

Background: We have a SQL Server instance that has pegged out a few times in the last few weeks. No one has been able to figure out how to get on and kill processes so they have just been rebooting ...
0
votes
2answers
181 views

setting MAXDOP server default value

Hi I've a server with 2 physical processors with 8 cores each. Looking through Management Studio Shows me a tree with NUMA 0 and NUMA 1 and inside 8 childs. The current maxdop is on 0, should I set ...
0
votes
2answers
948 views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
2answers
258 views

Custom word breakers in SQL Server 2008

We're implementing a tagging system for our site, where tags are delimited by a comma (",") and using fulltext-search in sql server to search for items tagged with something. The problem is, whe're ...
0
votes
2answers
103 views

Web Hosting Company that Allows custom SMTP servers, multi domains, .NET 4.0 and mixed hosting

I am in search of a new Hosting company. I currently use GoDaddy, but I've had enough with their service so i'm looking for a hosting company that can meet my criteria. Currently I have 10+ Websites ...
0
votes
2answers
311 views

SQL Server Snapshot Replication Subscriber (Editable or Read-Only)

I need to create a copy of my SQL 2008 R2 Enterprise database and have it located on the same server as the original. I will be using this second copy of the database as the target of a mostly ...
0
votes
2answers
125 views

Why is it recommended that SQL Server not be run on the domain contoller in an SBS 2008 system?

We are building up our SBS 2008 R2 server and had in mind to put an SQL Server on the same box, same system. First uses of the system are a local file server, VPN for the same purpose, and a central ...
0
votes
2answers
529 views

Problem with installing SQL Server 2008 SP2 on Win XP

I'm not much of an IT person but I've been struggling with this issue for hours and I hope maybe someone here will know how to assist me. I've just installed SQL Server 2008 Developer, I've chosen the ...
0
votes
2answers
428 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
0
votes
2answers
273 views

Copy SQL Server data from one location to another over the internet

How can I copy certain SQL server data from one server to another without opening direct access to SQL server in the firewall? I thought of things like integration services in combination with an ...
0
votes
2answers
495 views

What is causing intermittent connections problems from web server to sql server 2008 r2?

We have 4 API servers and 2 web servers that connect to a SQL 2008 R2 server. Recently we've noticed that the web servers sometimes can't find the SQL server. This doesn't happen for every connection, ...
0
votes
2answers
312 views

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK ...
0
votes
2answers
182 views

How to install SQL Server 2008 32 bit to Windows 2003 Server 64 bit?

How to install SQL Server 2008 32 bit to Windows 2003 Server 64 bit?
0
votes
2answers
492 views

Is it possible to determine the top users of SqlServer analysis services?

We're trying to figure out how many licenses we need of a desktop data analysis package which connects directly to our SSAS instance. I'd like know if it's possible to query the history of connection ...
0
votes
2answers
3k views

Enable anonymous access to report builder in reporting services 2008

I have a 2008 reporting services server installed on windows 2003 server. I am trying to allow anonymous access to the report builder folder so that my users do not have to select the remember ...
-2
votes
2answers
70 views

Uninstall SQL Server

how do I uninstall SQL Server 2008 manually? Add/remove programs does not uninstall everything. Thanks in advance.