Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

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

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
0
votes
2 answers

Why can't I log into SQL Server using Windows Integrated Security?

I'm trying to write a small app that will log into SQL Server to perform some admin functions. When I connect to SQL Server using the following connection string, I can log in fine: Data Source=Localhost\SqlExpress;Initial Catalog=PeteDb;User…
Pete2k
  • 251
  • 1
  • 2
  • 5
0
votes
1 answer

SQL Server autonomously logging into servers

Possible Duplicate: My server’s been hacked EMERGENCY I have a compromised machine that is attempting several hundred connections a minute to log into other mssql machines around the world. Event Viewer is showing hundreds of Event ID 18456…
grr_arg
  • 1
  • 1
0
votes
1 answer

Cannot log into SQL Server 2008

I created a login name in SQL Server 2008 by right click on security then new->login specify a name , password and server map. Right-click on SQL Server instance at root of Object Explorer, click on Properties Select Security from the left…
mehdi
0
votes
1 answer

How to properly re-add a windows administrator user to SQL Server

I recently installed SQL Server on a Windows 2008 machine. Down the line the machine was renamed from and when I recently deployed and executed a SSIS package I got the following error message: The job failed. Unable to determine if the owner…
Thomas
  • 157
  • 1
  • 6
0
votes
2 answers

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 created. If I run 2005 or 2008 tools, there is no…
ahpitre
0
votes
1 answer

Windows 2003 IIS webserver (testserver) is slow

I have a test environment for my Asp.Net 4.0 web applications. It runs on a Dedicated Windows 2003 Webserver (IIS 6) But it's slow! The machine never has 100% cpu and the same for memory. When I run the application on the production server, it's…
JP Hellemons
  • 267
  • 6
  • 16
0
votes
2 answers

SQL 2008 Install gone bad!

I've had a failed install of SQL 2008 on a windows server 2008 box and now when I try and uninstall the uninstall fails and asks me if I'd like to remove it from the list. If I do a repair I get so many errors and I think I know where it went wrong…
John
  • 343
  • 2
  • 6
  • 13
0
votes
1 answer

SQL express 08 R2 running on Windows datacenter server 08 optimization

I am running SQL server express R2 on Win Server Data Center 08 (basically Ec2 micro instance). My total allowed memory is 613 MB. When I launched the instance for the first time my total consumed memory in task manager (performance) was hovering…
JKZrulaz
  • 1
0
votes
1 answer

Sql Server 2008 Backup in External Hard Disk Drive

Possible Duplicate: SQL Server database on an external hard disk drive I want to take the backup of our companys SQL Server 2008 databalse in an External Drive which is hosted in Windows 2008 server. But when I try to schedule the backup thru…
Venkatesh.A
  • 1
  • 1
0
votes
2 answers

Move SQL Server Databases to new installation

I am reinstalling Windows on a developer workstation, that runs SQL Server 2008R2 and contains a lot of SQL Server databases (~50). After the reinstall, I want the SQL Server up and running with the same databases as easy as possible. It is just a…
Kjensen
  • 1,039
  • 10
  • 28
  • 39
0
votes
1 answer

Amazon EC2 SQL Instance with Cheap redundancy

I'm looking at transitioning from a dedicated hosting provide to Amazon's EC2 instances. The website is an asp/asp.net website with SQL Server 2008 as it's backend. It has zero redundancy as is besides the 24 hardware replacement we have in the…
Josh
  • 113
  • 1
  • 8
0
votes
2 answers

SQL Server 2008 High safety: Is a buletproof configuration possible, in terms of data loss?

I'm designing a SQL Server architecture with two SQL servers and I'm planning to implement database mirroring between the two. I need to minimize the data loss in case of a server breakdown (whatever the reason). I'm looking at SQL Server 2008…
Boris B.
  • 105
  • 5
0
votes
4 answers

SQL Server 2008 R2 Express and VMware

We have used SQL Server Express - various versions without issue. However we have an install on a VMware machine and there are severe performance issues. I have contacted VMware and Microsoft - Microsoft don't explicitly support Express as its a…
Ian P
  • 103
  • 6
0
votes
1 answer

Clustered index rebuild appears to do nothing

I have a table with a clustered index, which shows ~70% fragmentation on a SQL Server 2008 database. I'm trying to rebuild this index: ALTER INDEX PK_Table1Index ON Table1 REBUILD The statement returns immediately with success, however the…
Lucky Luke
  • 1,634
  • 1
  • 11
  • 12
0
votes
2 answers

cannot change sql server 2008 express installation folder

I am trying to install SQl Server 2008 Express (not R2, and I can't move to that) on windows 2003. I downloaded SQLEXPR32_x86_ENU.exe from the Microsoft site and am going thru the installer. I want to install it on a different drive, however I can't…
wal
  • 147
  • 3
  • 12
1 2 3
…
99 100