0
votes
1answer
701 views

SQL Server 2008/2012 Express install fails on scenarioengine.exe [closed]

I'm trying to install SQL Server 2012 Express on a Windows 7 64-bit PC. It also fails to install SQL Server 2008 R2. The bootstrapper extracts all the files, runs setup.exe (with UAC popup) then ...
1
vote
1answer
2k views

MSSQL 2008 R2 Update Error

I've been getting the following error: 84B20001 "WindowsUpdate_84B20001" "WindowsUpdate_dt000" I've tried just about everything but uninstall/reinstall which seems too much of a hassle. I gave ...
0
votes
1answer
93 views

MS SQL Server not running on Win7

I have installed all of the available components of "MS_SQL_05" as a named instance on Win-7. I had a default instance running of MSSQL08. While installing the MSSQL05 instance I choose to use windows ...
3
votes
1answer
886 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 ...
-1
votes
1answer
213 views

Fresh install of SQLSERVER 2008 r2 Express, what's my server name? [closed]

See this image: http://imgur.com/WxAQc It's a fresh Win7 install, fresh 2008 r2 install. For the life of me I can't work out what to enter as server name, I've tried: TOM Localhost SQLEXPRESS ...
0
votes
1answer
1k views

How to really shutdown MS SQL SERVER? Or is my Windows Explorer messed up?

My questions seem to be unrelated BUT Windows Explorer might be causing the problem I see when I use SQL Management Studio (Windows 7 64-bit). a. Recently, since 2 weeks or so ago, my Windows ...
0
votes
2answers
44 views

Network MSSQL with local failover

I currently have a database setup where my MSSQL 2008 R2 server runs on my local network, but the program runs on a notebook that is normally mobile and away from the network. VPN works, but I'm ...
0
votes
2answers
2k views

SQL Server 2005 Express on Windows 7: Service does not start during installation [closed]

During SQL Server 2005 Express installation on a computer with Windows 7 Home Premium x64, the installation failed upon trying to start the instance service. No log file was created in the instance ...
0
votes
0answers
146 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
616 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 ...
3
votes
3answers
1k views

Timeouts when connecting to SQL Server since installing SP1 for Windows 7

I just installed SP1 for windows 7 and I have severe performance degradation when connecting to SQL Server 2005 since then. Establishing connection takes more than 30 seconds while it's instantaneous ...
1
vote
2answers
252 views

Windows 7 Backup Complains it can't backups two non-existent folders

I am running scheduled daily backups using Windows 7 Backup on my Windows 7 Ultimate Laptop. It constantly gives me the following errors in the backup log: Backup encountered a problem while backing ...
2
votes
1answer
854 views

Cannot generate SSPI context from SQL Server Management Studio (2005)

Yesterday I went through some troubles to set up a DB on my local machine. I finally got that working, but now today I am getting an error when I try to connect to a remote machine. Cannot generate ...
0
votes
1answer
2k views

MS SQL service won't start after power outage (3 Updates)

There was a brief power outage a few days ago where i live, and when i rebooted my Windows 7 computer with MS SQL 2008 R2 on it, everything seems to be working fine, except the MS SQL service wont ...
2
votes
2answers
4k 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 ...
1
vote
2answers
2k views

where can I find php_mssql.dll?

I'm trying to get PHP set up to connect to a SQL Server database. I'm looking for the php_mssql.dll file to put in my extensions directory but for the life of me can't locate it online. Can anyone ...
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 ...
3
votes
3answers
1k views

SQL Server 2005 SP3 on Windows 7 - No Management Studio

I've been trying for a day and a half now to get SQL Server 2005, DEV edition, to work on Windows 7, 64 bit prof. I install from the disk, then run SP 3. I get a failure on the Client Components ...
1
vote
1answer
698 views

“NT AUTHORITY\ANONYMOUS LOGON” error in Windows 7 (ASP.NET & Web Service)

I have an asp.net web app which works fine in Windows XP machine in a domain. I am porting it to a Windows 7 stand alone machine. The app uses a web service which makes a call to sql server. The web ...
2
votes
2answers
2k views

How to connect to IIS and SQL Server Express on Windows 7 host from XP Mode

I am running IIS and SQL Server 2008 Express on my Windows 7 host, and I'd like to be able to connect to them in XP Mode. My host machine is not a part of a domain, only a workgroup. So far, I've ...
3
votes
3answers
9k views

Installing SQLServer 2005 on Windows 7 64bit

It's 3 days I'm trying to install SqlServer 2005 under Windows 7 64 bit on my computer. First let me tell you what I've done and what I've got till now . 1-I Installed Windows 7 64 Bit on my computer ...
2
votes
5answers
495 views

Could I use Windows 7 instead of Windows SBS 2008 for this server?

First off, I'm not a sys admin. I'm just a software developer trying to help out my parents' small business. Right now they have one server, a domain controller with a P4 processor running Windows ...
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
3answers
5k views

Error configuring SQL Reporting Services 2005 on Windows 7

I've installed SQL Server 2005 with Reporting Services on Windows 7 Ultimate x64 and when I try to configure it when clicking on "Windows Service Identity" I get this error message: There was an ...
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 ...
0
votes
2answers
132 views

What is the best way to configure windows firewall to open up sql server to lan computers

Should I configure a specific port for SQL Server and open that port up to the lan IP address range or open up the firewall based on the program, and wouldn't this require making a rule for each ...
1
vote
1answer
2k views

SQL Server 2008 Express + Reporting Services on Windows 7

I'm trying to install SQL Server Express 2008 and Reporting Services on a x64 Windows 7 Machine for development purposes. I've installed SQL Server 2008 Express with the Microsoft Web Platform ...
2
votes
1answer
147 views

SQL Server Bulk Insert Issue on Windows7

I’ve got an application that uses SQL Server Express 2005 SP3. This application is distributed to several hundred users, each of whom is running XP. However, our company will be moving to Windows7 ...
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 ...
5
votes
7answers
27k views

Can I run SQL Server Management Studio in Windows 7?

I've recently upgraded my OS to Windows 7, but this new OS wouldn't let me install SQL Server Management Studio. Is there a way to get around it?
1
vote
2answers
1k views

Legacy VB6 application under Win7 SQL error

We have a rather unfortunate legacy application at work, written originally in VB6 it predates anybody in our IT department by at least 5 years. We have a contracted developer for ongoing maintenance ...
2
votes
3answers
2k views

SQL server queries are really slow only on first run

Somewhat strange problem... when I start my .NET app for the first time after rebooting my machine, the SQL Server queries are really slow... when I pause the debugger, I notice that it's hanging on ...
1
vote
2answers
457 views

Why can't I connect to SQL 2008 from Windows 7 without a hosts entry?

On new installs of Windows 7, we cannot connect to SQL 2008 instances--even by just IP addresss--without opening the firewall port 1433 and adding a hosts file. The firewall port is obvious, but why ...
1
vote
1answer
677 views

SQLServer 2008 BIDS On Windows 7 - 64bit

I am trying to install Sql Server 2008 Business Intelligence Development Suite on VS2008 in a Windows 7 (64bit) machine. The installer is aborting with an unspecified error for which I have not been ...
1
vote
1answer
1k views

Security problem when connecting to SQL from Windows 7

I need to connect to a SQL Server 2005 from a Windows 7 machine that is not joined to the domain. This has always worked on XP but on Win7 I get the following error (when connecting via TCP/IP): ...
2
votes
2answers
2k views

How do I configure ASP.NET to use SQL Server 2008?

I recently installed Windows 7 on my computer, and just set up Visual Studio 2010 and SQL Server 2008. On my old installation, I used VS 2008 and SQL Server Express 2005. I have a simple ASP.NET ...
2
votes
2answers
167 views

Problem restoring a SQL Server 2008 DB running Windows 7 64-bit

Has anybody else had this issue? I am running SQL Server 2008 Express and am attempting to restore a database from file. When I click the 'Add' button to choose my backup file SQL Server stops ...