A nice long trial and I installed SQL on Windows 7 thanks to the following articles: - Attempt to perform an unauthorized operation error Giving my...

par7133

08-11-2009 07:00 PM
par7133

Sorry to crosspost, but no answer in SSIS forum. I have binged and googled this issue. We have SQL 2005 Enterprise behind a firewall on Server...

Jim Craddock

08-11-2009 03:50 PM
Lucas Kartawidjaja

Hi, My goal is to install AdventureWorks on a local db. I decided to install the the version with Advanced Services...

Liam Caffrey

08-11-2009 03:29 PM
Russell Fields

We have a small (125MB) but important (accessed by 50 users) SQL Server 2000 database that is backed up nightly. The SQL backup process takes less...

timo

08-11-2009 11:09 AM
Russell Fields

Hi, Posting again with a little detail. (with answers to Mr. Russell Fields) Whenever my Server Machine (Windows 2008 Server) restarts. My SQL...

M.K

08-11-2009 08:52 AM
Russell Fields

HI, Whenever my Server Machine (Windows 2008 Server) restarts. My SQL Server 2008 DB engine & every thing starts normally. But the SQLSERVER...

M.K

08-06-2009 10:59 PM
M.K

Hi Name of my server is ABC, i am going to install SQL Server 2008 Enterpirse on it. I dont want the default instance name "MSSQLSERVER" Even for...

Kashif Saeed

08-06-2009 07:40 PM
Mike

I have SQL 2005 installed and I installed SQL 2008 express a few months ago. This week MS update told me I needed to patch SQL 2008 but the patch...

Leon McCalla

08-06-2009 09:58 AM
xJonx

Thank you for this solution!! "mmgm" wrote:

ginger8990

08-04-2009 04:48 PM
Dash

I am using unuttended install for a while for single machines, My current requirement is to install SQL 2008 on 75 enviornment from SQL 2005 side...

Prakash Heda

08-04-2009 01:32 PM
Prakash Heda

Hi, I see in BOL that 1.5 times the amount of physical RAM is suggested and 3 times if you are running Full Text Search. Is this true for 64-bit as...

Chris Wood

08-04-2009 01:25 PM
Prakash Heda

How large should the pagefile be for a server with 128 GB of RAM? I have 400 GB of local storage, and the DBs will be on a SAN. thanks in advance

JOH

08-04-2009 01:09 PM
Prakash Heda

Hello, My environment: - Windows 2003 R2 SP2 Standard Edition - SQL Server 2008 EE I found the SQL engine installed successfully, it did the...

Dennis

08-04-2009 12:51 PM
Prakash Heda

I installed SQL Server 2008 Workgroup version that I downloaded from MSDN subscription site, and I want to use the Integration Services. But each...

Marilyn

08-04-2009 10:37 AM
Marilyn

I'm trying to understand which value to use in creating primary partition in my win2003 server to use with sql 2005. Using diskpart, this seems the...

joker197cinque

08-03-2009 12:26 PM
Linchi Shea

Not sure, if this is the right place, but... In Inoosetup 5.3.2 I use - and usually this works ok: try SQLServer :=...

Bernd Maierhofer

08-03-2009 07:30 AM
Bernd Maierhofer

Hi folks My PC is running Vista Ultimate 64-bit SP2 I have been attempting to install SP1 but had some errors which prevented the install. After...

Ross

08-01-2009 01:13 PM
Richard Mueller [MVP]

I'm trying to do some work with Reporting Services on SQL 2005, using the Business Intelligence Development Studio. I had SQL 2008 installed on...

Carl

07-31-2009 08:32 PM
Jeffrey Williams

http://www.nanometer.ru/users/microsoft-lsd-tv.html doctor-lsd-tv (AT) yandex (DOT) com tel.8_9195265461 patent Japan

doctor-lsd-tv Google

07-31-2009 06:29 PM
doctor-lsd-tv Google

Hi, I get this error when installing Management Tools and Business Intelligence Development Studio: Error 1310.Error writing to...

Dawid Kolodziejczyk

07-30-2009 06:25 AM
David Kolodziejczyk

When ever i run setup.exe , i recieves an error: "Managed SQL server installer has encounterd a problem and needs to close. We are sorry for the...

Ashish

07-28-2009 04:38 PM
Erland Sommarskog

A production SQL server was accidentally moved (I found out about it after the fact)from it's existing physical box (Windows Server 2003, SQL Server...

Blasting Cap

07-27-2009 04:23 PM
Lucas Kartawidjaja

Hi, after install sp1, when i try to connecto to sql server, i get the error: Error 18401, server is in script upgrade mode is reported any ideas?

Ruben

07-27-2009 02:40 PM
Lucas Kartawidjaja

Hi ALL, when I try to install SQL Server 2008 I get the following error message in the end '' is not a valid login or you do not have...

Kashif Saeed

07-26-2009 10:05 PM
Kashif Saeed

Is there a recommended installation order for SQL 2008, VS 2008 and their service packs? I thought I read something about problems with these two...

Patrick Jackman

07-26-2009 08:15 PM
Patrick Jackman

Hello: We have SQL Server 2005 Standard Edition 64-bit on our 64-bit Windows Server 2003. Also, we have a 32-bit Windows Server 2003 that has an...

childofthe1980s

07-26-2009 05:10 PM
Erland Sommarskog

Microsoft Windows Server 2003 Microsoft SQL Server 2005 Developer Edition This is the DVD ( .iso ) package downloaded from MSDN Subscriptions. I...

John A Grandy

07-26-2009 12:16 AM
Jeffrey Williams

I have a SQL Server 2005 box that got demoted from a production server to a test server. The original name of the box was 'BASH' and has been...

Zorpiedoman

07-25-2009 05:04 PM
Erland Sommarskog

A third party vendor installed SQL 2005 in an incorrectly named 'C:\Pogram Files' directory. I've successfully moved the master, model, msdb db's...

kzakoski

07-25-2009 01:03 PM
Ekrem Önsoy

You'll want to ask in a reporting services newsgroup forum, where you'll get much more specialized folks who know the answer.

Learner

07-24-2009 03:12 PM
Aaron Bertrand [SQL Server MVP]

Hello: We are moving data fronm a SQL 2000 server to a SQL 2005 server. How do you copy DTS package files from one SQL server to another? Can you...

childofthe1980s

07-24-2009 01:34 PM
Lucas Kartawidjaja

Hello: How can you tell if a SQL 2005 install was conducted with the Local System Account? childofthe1980s

childofthe1980s

07-23-2009 10:10 PM
Santhosh Sivarajan

Hello: Someone told me that, upon installing SQL Server 2005, it is not a good idea to install with the Local System Account if you are in an...

childofthe1980s

07-22-2009 04:55 PM
Santhosh Sivarajan

Windows Server 2003 box ( not known to me until now ) In SSMS Express Edition , I run SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY...

John A Grandy

07-22-2009 04:17 PM
Ekrem Önsoy

God Bless You Everyone, I recently upgraded from SQL Express 2008 to SP1. Now my user instances are messed up. When I go into the ASP configuration...

Anthony Smith

07-22-2009 06:26 AM
John Bell

Hi, I try to install SQL 2008 Developer on Vista 64 bit, which should be possible. However I alwas get an error like the following: Unable to open...

Jan

07-20-2009 04:16 PM
Ekrem Önsoy

Hello, I installed SQL express 2005 on a windows 2003 x64 R2 server that is our domain controller as it has plenty of processing power and memory. ...

boe

07-20-2009 10:21 AM
Lucas Kartawidjaja

Hello: in SQL 2005 SP3 (.4035), I used the Management Studio to access the properties of the model database. I want to tell the model...

SQL Programmer

07-18-2009 05:44 PM
Erland Sommarskog

(cross-post addded to SQL Setup) "Alex396" <Alex396 (AT) discussions (DOT) microsoft.com> wrote Try converting your hex code to decimal and...

Robert Aldwinckle

07-17-2009 01:06 PM
lilms_m

I installed SQL Server 2008 under a VMware Windows 2008 Server. When I went to add the Administrators group to the logins under SQL Server, I get a...

Steve

07-17-2009 09:43 AM
Jelle J.

Hello: I installed SQL Server 2005 Standard for a 64-bit server. I did not install it on the C drive. I installed it on a separate drive. I'm...

childofthe1980s

07-17-2009 08:06 AM
childofthe1980s

32 bit MSSQl 2005 SP3 on a 64bit Windows Server 2003 SP2 host. My database is 1.5gb, and something unknown happens during the day to make the size of...

SnapDive

07-15-2009 09:57 PM
Mark Han[MSFT]

Below is our issue for SQL Express 2005 (SP3) We have an application that utilizes SQL Express 2005 as database. The application is installed...

Jerome Pacificar

07-15-2009 01:51 PM
Ekrem Önsoy

<http://msdn.microsoft.com/en-us/library/ms175037%28SQL.90%29.aspx> describes the PARAMETERIZATION FORCED option for SQL Server 2005 databases. I...

Robert Carnegie

07-15-2009 12:30 PM
Robert Carnegie

I'm prepping a server for SQL 2k5 x64 running on Windows 2k8 x64. What can I do to performance tune this server so that it runs as fast as possible....

CK

07-14-2009 08:41 PM
Andrew J. Kelly

At my site we've generally used SQL Server authentication, but now we have two AD domains (production and test) and are starting to use...

Mark_E

07-14-2009 06:43 PM
bass_player

OK. I made the mistake of putting a trial version of sql 2008 on my computer. I have a valid Microsoft Action Pack license for the product. Here is...

Steve

07-13-2009 01:09 PM
Steve

Hi, I have installed Sql Server 2005 express edition as administrator of the machine. I need to give access to end user who will be accessing it...

Pravin

07-10-2009 05:53 PM
Ekrem Önsoy

Hello: One of our DBAs told me that, if a client has purchased SQL 2005, then the SQL can be downloaded from the MSDN website. All well and...

SQL Programmer

07-10-2009 05:45 PM
Ekrem Önsoy

I'm in a bit of a wacky situation. I have not shut the server off (it runs in my garage 24X7) in the nearly 9 years that it has been there. I...

Dobermann

07-10-2009 05:22 AM
Dobermann