Questions tagged [sql-server-2008]

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

Filter by
Sorted by
Tagged with
2
votes
3answers
1k views

SQL Server 2008 - Secure remote access

I wish to allow remote access to an SQL Server database from a Microsoft Access database to allow my client to build reports as and when they wish. I can do this without any issue by opening the ...
2
votes
1answer
677 views

Intermittent unavailability of an instance in a failover cluster while a standby node is offline in a SQL Server 2008 failover cluster

I've got a small failover cluster that I run for the websites my company has. During a RAM upgrade of the standby server, our websites started to show errors about not being able to access the ...
2
votes
1answer
2k views

SQL Server Windows Auth Login sees Domain as untrusted

I've had someone set up a domain controller on windows 2008 on one server, and sql server 2008 on another. The domain seems to be working fine, I'm logged on as a domain user on both servers, nothing ...
2
votes
3answers
4k views

What would be the optimal disk config for SQL Server 2008 R2?

We have a new Dell R710 server that came with the following storage configuration: 8 x 146GB SAS 10k 6Gbps disks 1 x Perc H700 Integrated Controller (2 x 4 disks - 2 ports each supporting 4 disks) ...
2
votes
1answer
2k views

Best Way to “Upgrade” SQL Server Express to Web Edition

I'm in the position where I've run into the limitations of SQL server express and have bought a license for SQL Server Web edition. What is currently installed on the server is SQL Server 2008 ...
2
votes
2answers
119 views

Sql Server 2008 Backup and Restore

I have a production critical database which is in Simple Recover Model Currently. We take a Full Backup Every night at 2:30AM. Now I have to change the recovery model back to full. I have to design ...
1
vote
1answer
508 views

Windows server 2008 web edition with SQL Server (Limits?)

I've read through a lot of the material covering the limitations of windows web edition 2008, but I'm nervous about making the call to go ahead and use it. One small point I noticed was that Web ...
1
vote
1answer
918 views

SQL Server 2008 Install fails error reading etwcls.mof

I receive the following error when trying to install Sql Server 2008 Standard on a Windows Server 2008 box. Error reading from file D:\x64\setup\sql_engine_core_inst_msi\PFiles\SqlServr\MSSQL.X\MSSQL\...
1
vote
1answer
5k views

Installing SQL Server 2008 32bit on 64bit : WoW64 error

Consider a problem installing SQL Server 2008 on Windows 7 x64. The installer gives some WoW64 error. Is it possible to install a 32-bit version of SQL Server 2008 on a 64-bit OS like Windows 7 x64? ...
1
vote
2answers
3k views

How to allow TCP connection over the network to SQL Server 2008 Express?

I've installed SQL Server 2008 Express. I connected to it and created a Database with Microsoft SQL Management Studio. But I cannot connect (with same url, username and password) to the DB from my ...
1
vote
2answers
5k views

Disabled SSLv3 to combat Poodle now cannot connect to SQL “Connection forcibly closed by remote host”

I have disabled SSL3 on my web server to combat the Poodle Vulnerability and now I am unable to connect to my SQL server using SQL Authentication. I just get "Connection forcibly closed by remote ...
1
vote
2answers
14k views

SQL Maintenance Cleanup Task 'Success' But not deleting files

I have a maintenance plan setup for a databases on a server. As part of the backup is a Maintenance Cleanup Task. SQL Version 2008 The task that 'succeeds' is setup as: Delete backup files Correct ...
1
vote
2answers
184 views

Many huge files in Sharepoint… Any “stubbing” or “shortcutting” software exist?

I'm in an industry that uses a lot of scanned documents and large attachments (100MB), and I see our Sharepoint database growing quickly. What options do I have for managing this rapid growth? Can ...
1
vote
3answers
6k views

SQL Server Shrink File Fails

I have a large database 1.5 TB, which contains image data. There is an archiving process that has been implemented which has removed a large portion of the data. I want to shrink the size of the data ...
1
vote
1answer
389 views

SQL Server moving to new file

I am trying to do a shrink on my data file, after large delete. It is failing and I am unable to get it working. I am probably going to have to move to new data file. I am trying to find out if doing ...
1
vote
2answers
337 views

Problems installing SQL Server 2008 SP2

I installed a 90 day Eval version of SQL Server 2008 SP2 downloaded from Microsoft. I ran ths installation and it all went thru without any errors. Then i opened the Configuration menu to see if the ...
1
vote
3answers
211 views

basics of SQL Server 2008 backups

We don't have a DBA and I have to do backups. We have only one database that is 3gb (the others are less than 100mb). The 3gb database is write-heavy, and has very important data. I set up daily ...
1
vote
1answer
302 views

Managing mass SQL Server ODBC Changes when migrating to a new SQL Server

How do you manage changing out a SQL Server and updating all the clients that connect to it to point to the new server? If I have SQLSERVER1, then buy new hardware and call the new server SQLSERVER2 ...
1
vote
4answers
4k views

Two MS SQL Instances, one database file

Is it possible to have one database file attached to two different instances of SQL? Consider that the MDF is located on a NAS and I want a primary and secondary instance of MS SQL on two different ...
1
vote
2answers
7k views

Can't connect to local database in SQL Server (2008) Management Studio

An IT guy at work remoted into and installed SQL Server 2008 Developer on my terminal, and at first everything seemed to be set up correctly. However, when I go into the Management Studio, I can't ...
1
vote
4answers
583 views

How to look at what is going on in a pegged SQL Server instance?

I have a SQL Server instance that is pegging out my server. I'd like to look at what jobs are running, but it's so slammed that I can't even log in. Is there some secret way to get in and look at ...
0
votes
3answers
2k views

Failover clustering: tempdb on SAN?

We are considering clustering our SQL Server 2008 EE instances. The storage is on SAN. Can we put tempdb data/log files on SAN? What are the pros and cons on this solution? For optimal performance, ...
0
votes
2answers
135 views

sql server 2008: should i be running differential or transactional logs or both HELP!

i have two databases: this one was set up by a third party and they do not allow us to change the database to full recovery. so it is my understanding that if a database is in simple mode, then the ...
0
votes
1answer
1k views

installing sql server 2008 32bit on 64bit os

Hey guys i am facing a problem installing sql server 2008 on Windows 7 x64. it gives some wow64 error. can some one tell me is it possible to install 32bit version on 64bit OS. if yes, then please ...
0
votes
6answers
7k views

Connecting remotely to an SQL server inside a LAN

I am using SQL server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan. The problems rises when I try ...
0
votes
1answer
1k views

Installing both SQL 2000 and SQL 2008 on the same machine

Is it possible to install BOTH 2000 and 2008 on the same machine (and have them as different instances) Ideally, I want the 2008 to be default instance, with 2000 named "legacy" or something... We ...
0
votes
2answers
1k views

Tools to manage sql 2008 database mirroring?

We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring. What I'm looking for is a tool or scripts that will help ...
0
votes
3answers
5k views

MS SQL Server Firewall Ports

I've recently found myself in the position of quickly deploying a production app on SQL Server 2008 (EXPRESS), and I've been having some issues with configuring firewall rules between our web server ...
0
votes
1answer
2k views

SQL Server 2008 Access Denied

I am trying to install SQL Server 2008 R1 on a Windows 7 Enterprise Edition machine...I have tried multiple times and each time I get an access denied error for the Database Engine, Replication and ...
0
votes
1answer
2k views

SQL Sever 2008 R2 Installation error: Unsupported 16-bit Application

Running Windows Web Server 2008 R2 and I'm trying to install SQL Server 2008 R2 Standard from MSDNAA (includes install package for x86, x64, and ia64). I receive the following error while trying to ...
0
votes
4answers
6k views

Connecting to SQL Server 2008 through an ADSL Router

I'm trying to connect to a SQL Server 2008 instance over the Internet through an ADSL Modem/Router. I've already configured the router to forward ports TCP 1433 and UDP 1434 to the IP of the server. I'...
0
votes
6answers
10k views

SQL 2008 install on Windows Server 2008 Permission Denied errors

When trying to install SQL 2008 on W2K8 I get about 6 permission denied errors even though I'm installing logged on as a domain admin? Any one else experienced this? Thanks John Overall summary: ...
0
votes
1answer
2k views

Programmatically Copy Database like SQL Server 2008 Copy Database Wizard

I need the ability to copy a database similar to what the Copy Database wizard accomplishes in SQL Server, but in a more automated (i.e. command line) fashion. I am writing a small application in C# ...
0
votes
2answers
247 views

The Transactional Log is Full

I am getting below error. The transaction log for database 'CRM_QA_V6' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases likely ...
-3
votes
1answer
1k views

SQL Server 2008 R2 Express accepts only local connections? [closed]

Coming from question SQL Server 2008 connection tagged under sql-server-2008-express Chris S wrote in SQL Server 2008 R2 vs. SQL Server 2008 R2 Express: "The biggest different I see others have ...

1
2