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 ...
1
vote
2answers
2k views

SQLExpress service unable to start Error code 17053

A user was instructed by their software support to upgrade a program and install SQLExpress as part of the installation process. Since that time, the service has been able to start, citing error ...
1
vote
1answer
67 views

Avoiding SQL Server 2005 tables with same names, but with different owners

What is the most likely cause of this behavor with SQL Server 2005? TEST #1: I run Management Studio Express, connect to my local database with "windows authentication" and see that I have 1 ...
0
votes
1answer
272 views

Flush MSSQL Express in Memory Data to Disk Without Service Shutdown

I am attempting to configure a MSSQL 2005 Express db to flush its in memory data to disk so that the data can be captured by using disk snapshot software. I have been unable to find any particular way ...
1
vote
3answers
3k views

SQL Server access is slow on client machines

I was out on a clients site today and installed some custom software that accesses a SQL server 2005 database that resides on a server on the clients site. The software runs fine when ran directly ...
1
vote
3answers
1k views

SQL Server 2005 Express: Where is the Profiler?

i'm reading on Microsoft's site that SQL Server 2005 Express Edition has Profiler: Profiler Express Local and Relational Servers only. (i'm not sure what a non-relational SQL Server is, ...
1
vote
1answer
254 views

SQL 2005 Express: How to get those performance reports?

How do get go about being able to view those performance reports on SQL Server 2005 Express Edition; you know, these things (with the charts and bar graphs): What are they called What do i have to ...
2
votes
4answers
708 views

Tune SQL Server Express using Profiler?

I have a SQL Server 2005 database... a copy of it is running in development on a full version of SQL server. Another copy is running in SQL Server 2005 Express on a web server. I've used SQL Profiler ...
0
votes
1answer
1k views

MS SQL Server 2005 Express rebuild master DB problem

There has been a power loss on our server and i cannot start the SQL service because the master DB is corrupted (as the log states). I found many articles recommending running the setup.exe with ...
0
votes
2answers
142 views

SQL Server 2005 and SQL Server Express on the same machine?

Can we have both version installed on the same computer?
1
vote
2answers
220 views

SQL Server Express 2005 cannot connect

I have a SQL Server Express 2005 install on a godaddy virtual terminal which currently is only connected to(locally with mgt studio) every few days or so. Every time i try to connect I get a cannot ...
0
votes
1answer
957 views

How to DENY access for a particular database for login “sa” and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create ...
1
vote
1answer
1k views

Cannot stop SQL Server recovering database

I wanted to physically move the files associated with a database in SQLServer 2005 Express. I backed up the database, detached the database, copied the files to a different drive, and then reattached. ...
1
vote
3answers
919 views

Can't Upgrade an MDF from SQL 2005 - 2008

I'm trying to deploy an MDF file to my live server, but this also means going from SQL Express 2005 to 2008. I'm getting the following error in my web page. Database 'xxx.MDF' cannot be upgraded ...
0
votes
1answer
102 views

SQL Server queries take forever to enumerate the dataset?

I've got an interesting sounding problem with SQL queries run from a particular machine. This machine is a VM running Windows Server 2003, and it has SQL Server Express 2005 on it. The VM was ...
1
vote
2answers
404 views

Which Performance Counters to use for SQL Server 2005 Express

Usage Scenario I have a SQL 2005 database running in an instance of SQL Server 2005 Express Edition. There are two different .Net applications running that constantly connect to this database and ...