1
vote
1answer
26 views

Unable to connect to MSSQLServer 2008 R2

I have setup SQL Server 2008 R2 on a desktop (Windows 7). All the client protocols are enabled. I am trying to connect to this instance from my laptop. The laptop and the desktop are on the same ...
1
vote
3answers
43 views

Restore MS SQL 2008 Database from files

is it possible to restore a MSSQL server by copying its directory/data files? I have a damaged hard disk and was able to salvage the C:\Program Files (x86)\SQL Server 2008\MSSQL\MSSQL10.MYDATABASE ...
0
votes
1answer
340 views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
1
vote
1answer
219 views

Error upgrading from SQL Server 2008 to SQL Server 2008 R2

I needed to restore a database (created in SQL Server 2008 R2 - version 10.50.1600) to a new DB in Server 2008 (version - 10.00.2531). I got the error - Restore failed for Server .... Additional info ...
0
votes
1answer
660 views

Can't enable 'sa' account in SQL Server 2008

I'm trying to enable 'sa' account in SQL Server 2008 through the MS SQL Server Management Studio Express. When I set the properties through the 'Properties' section of the login and click Ok, there ...
2
votes
1answer
302 views

Microsoft SQL Server Management Studio causing system freeze

I'm experiencing very slow response from MSSMS and it causes other applications to slow down. Specially Skype crashes after few seconds from opening MSSMS, showing an error called "Disk I/O Error". ...
2
votes
1answer
99 views

SQL server 2008 enterprise installation error on Windows 7

When I try to install SQL Server 2008 enterprise on my Windows 7 machine, I get this error message. When I click on Retry, I get the same error again. Error reading from file ...
0
votes
1answer
604 views

How to detach a sql server 2008 database that is not in database list?

I installed SQL Server 2008 on Windows 7. Then I created a database. After 2 days I reinstalled Windows and SQL Server. Now I am trying to attach my database file, but I have encountered the error ...
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 ...
1
vote
2answers
2k views

C#/SQL Server: Login failed when connecting from remote machine

I've got an SQL Server 2008 Express set up on one machine and am trying to connect with my C# app to the server from another machine (both Win 7). The server machine has a user account for me in the ...
3
votes
1answer
786 views

Unable to start SQL Server 2008 service

I am running SQL Server 2008 R2, and I am having an issue with my local server instance. At first, this only happened occasionally and seemingly completely randomly, but was fixed when I restarted my ...
0
votes
1answer
84 views

How to configure Reporting server on SQL Server 2008, Windows 7

I want to configure reporting server on sql server 2008.I m using Windows 7 Operating System . I configure reporting manager using Reporting Services Configuration Manager and provide Service ...
0
votes
0answers
35 views

MSSQL doesn't start consistently

On my dev box, MSSQL is set to "Automatic," but it doesn't start with boot every time. If it didn't start EVERY time it would at least make sense. Sometimes it starts, sometimes it doesn't, completely ...
1
vote
1answer
128 views

How can a local account access a database on another computer?

I'm not even sure if this is possible, but I figured I'd ask. I have two computers, these computers are not part of a domain, but they are on the same network. On each computer, the local ...
1
vote
0answers
500 views

Delete the default instance of SQL Server 2008

I'm trying to uninstall SQL Server 2008. I went through add remove programs and deleted all the SQL Server programs which didn't remove the services and the instances... I manually deleted the ...
1
vote
1answer
6k views

CREATE DATABASE permission denied in database 'master' … A database with the same name exists, or specified file

Background: I'm trying to get the Live Demos of Telerik's Rad Controls for ASP.NET AJAX working on my local machine in IIS 7. I'm getting an error when I view the ComboBox demo. Error I get: ...
1
vote
1answer
320 views

Where is my SQL Server 2008 R2 / Windows 7 install?

I ran the SQL Server 2008 R2 Install on my Windows 7 Professional (32bit) os. Everything ran fine, no errors. I ran the SP1 install, again, all green, no errors. I run the System Configuration Checker ...
0
votes
0answers
145 views

Can't start SQL Server 2008 - weird path in the log

I know there are thousands of questions about staring SQL Server, but I can't find the solution to my problem. I can't start it and the log file reads: CREATE FILE encountered operating system error ...
1
vote
4answers
561 views

Can't start SQL Server 2008 - weird path in the log

I can't start it and the log file reads: CREATE FILE encountered operating system error 21(failed to retrieve text for this error. Reason: 15100) while attempting to open or create the physical ...
0
votes
2answers
389 views

Sql server 2008 stopped recieving network connections after SP2 installed?

After SP2 I was unable to connect to MS-SQLServer 2008. I found that Sql Server Browser service was stopped. I enabled Browser but it did not help. Everything was fine before SP2? Anyone had similar ...
1
vote
3answers
9k views

Access is denied error installing SQL Server 2008 on Windows 7

Attempting to install SQL Server 2008 R2, Standard, Developer Edition, and/or Express on Windows 7 Enterprise, I keep getting 'Access is denied' at the very end of the installation. Contents of log: ...
0
votes
1answer
1k views

Export Import error 'SSIS Data Flow Task could not be created' … registering DTSPipeline.dll, cannot create task “STOCK:PipelineTask”

I'm about to throw in the towel on this one. Running SQL Server 2008 enterprise on Windows 7 x64. Can't get past this issue. When I try to Import / Export Data from databases through SQL Server ...
0
votes
1answer
7k views

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

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, ...
2
votes
2answers
3k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
5
votes
3answers
2k views

SQL Server 2008 R2 Enterprise database has unexpected 4GB database size limit

I have SQL Server 2008 R2 Enterprise installed on a local Windows 7 x64 workstation. When I create a database on the server, it unexpectedly has a 4GB size limit (Database properties in SQL Server ...
0
votes
1answer
226 views

SQL authentication not authenticating in MS SQL Server 2008

When I try to connect to the SQL Server running on localhost using Windows Authentication in SQL Server Management Studio, I am able to connect but when I try to connect using SQL authentication, it ...
2
votes
4answers
10k views

Error when restoring database (Windows 7 test environment)

I have a windows 7 operating system as a test environment. I have SQL Server EE installed with two instances, named as test and production. I took a full backup from AdventureWorks database from test ...
2
votes
1answer
2k views

How do I login to SQL Server without having to use “Run as Administrator” when starting Management Studio, in Windows 7?

When I start Management Studio, unless I use the "Run as Administrator" selection, I cannot login to my local SQL Server. Is this normal? I am a normal developer and don't believe I have a need for ...
1
vote
1answer
3k 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? ...
3
votes
3answers
2k views

Install Sql Server Developer Edition 32-bit (or Enterprise Edition) on Windows 7 Home Premium 64-bit

Is there any work around to Successfully install SQL server 2008 32-bit on Windows 7 Home premium 64-bit ? If this is the case I first installed VS 2008 SP 1 on my machine and when I click on ...
0
votes
1answer
2k views

Error when installing SQL Server 2008 on Windows 7

When installing SQL Server 2008 on a Windows 7 machine, it experiences the following error. TITLE: Microsoft SQL Server 2008 Setup ------------------------------ The following error has ...
4
votes
5answers
40k views

Installing SQL Server 2008 on Windows 7 64-bit

I'm having a shocking time trying to install SQL Server 2008 on 64-bit Windows 7. When I run setup.exe, I get the following error message: Microsoft .NET Framework 3.5 installation has failed. ...