What to use linked server to go from client C to Server A to Server B using Windows Authentication. Also Server A and Server B are going to running...

Greg Larsen

04-29-2007 07:30 PM
Sue Hoegemeier

Gday, I have a SQL Server 2005 Enterprise edition installation in our office. When I run the Sql Server Agent, I get a Failure Audit: Login Failed...

Steven Spencer \(Spinalogic\)

04-29-2007 10:20 AM
Tom Moreau

Hi i have an SBS2003 server with SQL installed on it. I have just set up a Windows 2003 standard server, and installed SQL 2000 SP3 onto it. Am...

Alex

04-27-2007 04:33 AM
Alex

What is the best data type for time intervals? I have a CSV file that I want to import using DTS. col4 in the data sample below represents time...

Tim Burkart

04-27-2007 02:15 AM
David Portas

I downloaded the newest set of samples and instructions from MS. I successfully unpacked them, and the AdventureWorks_DAta.mdf and ldf are there. ...

ShirleyH

04-26-2007 03:56 PM
Roger Wolter[MSFT]

Dear Sirs, I failed to install SQL Server 2005 Standard in cluster invironment. Below please find the details. I have created three Domain Groups,...

Igor

04-26-2007 01:34 PM
Jasper Smith

We are using SQL Server 2005, and Database Mail was working fine. We replaced our Exchange 5.5 machine with a Exchange 2007 machine. Now I...

George Wynne

04-26-2007 09:11 AM
George Wynne

We have a United Parcel Service (UPS) application named Worldship 9.0 installed on a Windows 2003 server. Worldship creates a System DSN...

Will

04-26-2007 06:40 AM
Andrea Montanari

I need to install Idera's SQLsafe 4.0 onto clustered production sql servers(sql2005 enterprise, 64-bit; Window 2003 enterprise), which requires ..NET...

Claudia

04-26-2007 05:59 AM
Hank Arnold

A year ago I installed licensed copy of sql2000 (sp3), installed Developer Express, and eventually MSDN 2005 developer or standard edition...

04-26-2007 02:40 AM
Charles Wang[MSFT]

I already have Express Edition installed on Windows Vista as part of installing VS2005 and I have upgraded the Express Edition to SP2. Now, I am...

Dale

04-25-2007 10:04 PM
Dale

On a 4 dual core, hyper threading server, how many tempdb files I should configure in order to reduce schema lock contention? 8, or 16? I see...

Lijun Zhang

04-25-2007 06:29 PM
Hari Prasad

Hi everyone, I'm doing an edition upgrading from SQL server 2005 standard edition to enterprise edition. Everything was fine except that I ran into...

test

04-25-2007 04:39 PM
test

How do you give a user full rights to modify any SQL DTS packages, even those not owned by them without giving them SysAdmin rights to the server? I...

WMB

04-25-2007 10:21 AM
WMB

I have a reporting services project and noticed my installed instance (default) did not install Reporting Services. After much pain, I...

orourksj@gmail.com

04-25-2007 09:11 AM
Jasper Smith

Hi Guys, Just getting this error message when Upgrading Sql express 2005 to sql workgroup 2005? Can some one please assist me im new to sql and need...

Tony

04-25-2007 04:52 AM
Tony

Hi I have 2 installers for my VB.NET app, one for the client app (exe, dlls, config etc.), one for server components (shared data files, sql express...

Richard Bysouth

04-24-2007 08:18 PM
Richard Bysouth

We have a requirement to utilize MS-DTC from internet facing to an internal system running SQL Server 2000. Can the DTC be stand alone on a...

Alexis

04-24-2007 10:38 AM
Alexis

Is there a white paper for this upgrade or does anyone know the proceedure and complications that may occur.

wayne

04-24-2007 12:35 AM
Hari Prasad

Hello, I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before removing MSDE 1.0, a database apparently was not properly detached...

jim

04-23-2007 04:26 PM
jim

Does anyone know what these accounts...

Lijun Zhang

04-23-2007 04:01 PM
Jasper Smith

Does anyone know what are these accounts for after install SQL...

Lijun Zhang

04-23-2007 02:45 PM
Lijun Zhang

If I install build 3159, does that also install all post sp2 patches previously released? or does that just fix one specific problem? Thanks!

Steve

04-23-2007 01:29 PM
Chris Wood

I have installed the latest MS Web Data Administrator and whilst connecting to a SQL Server 2000 instance ok, I receive the following error...

nigeaman

04-23-2007 09:52 AM
Hari Prasad

Hi I have server with OS Win2003 SP1 Enterprisde edition, SQL serevr 2000 SP4 Ent.edt. with 8 GB RAM. In boot ini /3GB /PAE AWE enabled on SQL. I...

branoL

04-23-2007 05:28 AM
branoL

Hi, i am creating an installation program which first installs SQL Server 2005 Express Edition with SP2. Then it executes a CREATE DATABASE statement...

Olav

04-22-2007 08:24 PM
Deepanshu Garg

I have installed Visual Web Developer 2005 Express and SQLserver 2005 Express (SQLserver Management Studio Express). To install SQLserver 2005...

Jeffrey

04-22-2007 11:08 AM
Andrea Montanari

Hi, I have sql server express 2005 installed on my machine. This version is very first before sp2. How to upgrade to sp2 - everything I found was...

Vilius

04-22-2007 11:08 AM
Andrea Montanari

Do I have to set up a sql server database on a sql server? Or can I do this on any server

BABRESA

04-21-2007 04:26 PM
Hari Prasad

Hello, I'm trying to set up SQLMail on on a SQL2K (SP4) instance hosted on a Win2K3 (SP1) server. We're utilizing a managed Exchange 2K3 account...

Matty Z

04-20-2007 01:32 PM
Matty Z

We are trying to do an in-place upgrade from SQL 2005 express to workgroup edition. As it is an upgrade we use the command line “setup...

Antonio Quiroga

04-20-2007 11:52 AM
Antonio Quiroga

I would like to keep my SQL Servers as up to date as possible so I was a little concerned when hotfix KB934458 simply refused to install. I looked...

Wells Caughey

04-20-2007 11:46 AM
chris

I have sql 2005 installed on my notebook and my desktop pc, alongside sql 2000. OIn the desktop everything is fine, and I can choose version 70, 80...

balone351

04-20-2007 10:31 AM
Roger Wolter[MSFT]

Will SQL Server 2000 Enterprise Manager (and Query Analyzer) run on Windows Vista? And, if so, are there any known issues? I know that the 2K...

eM eL

04-19-2007 11:09 PM
eM eL

(1)Does SSIS need to be installed for legacy DTS packages to run? (2) Upon successful side by side migration from SQL server 2000 to SQL Server 2005...

Joe

04-19-2007 06:22 PM
Joe

I'm quite new to SQL and no one in my shop knows a lot about it. I've looked around, tried some stuff, but still am not having any luck. Here's...

Mike

04-19-2007 02:03 PM
Jasper Smith

OK, I think I've searched all the current messages in this group, and I can't find a reference to the problem I'm having. I have a WinXPSP2 box...

Eric F

04-19-2007 12:17 PM
Eric F

Hi All, I have a system with WindowsXP Professional and would like to install SQL Server2000 on it as a server. When I tried to install it, the...

Gloria

04-19-2007 11:56 AM
Tiago Costa

Hi, on Windows x64, installed sql 2005 64- but there is no BIDS (Run | Programs second Instance but still no BIDS. Any Ideas? thanks

PhilippeH

04-19-2007 02:40 AM
PhilippeH

Hi. I've been told by a SQL Svr support engineer that my server's hardware does not support SQL Svr 2005 Std Edition (he mentioned memory as the...

Salvador

04-19-2007 12:10 AM
Salvador

Trying to install Active/active cluster on Win 2003/SQL 2005. We're unable to get past the Remote Account Info screen. Keep getting message that...

DBABurgess

04-18-2007 03:56 PM
DBABurgess

Hi, I'm working on a project to build an installation CD with the installation of MSSQL Express on it. I build a Template.ini with these...

microsoft.com

04-18-2007 01:21 PM
microsoft.com

We have SQL 2005 EE version. MS CRM 3.0 Professional supports data mining. Do I need to have Analysis Services feature installed in SQL2005 in order...

gocrm

04-18-2007 12:54 PM
gocrm

At the moment, we have SQL2000 Standard Edition running as the only instance (it is a named instance) on the server, with one of the two NICs...

JohnD

04-18-2007 12:29 PM
Geoff N. Hiten

Hi, when i create a new user in a .MDF file, the hour of creation in the field "createdate" of table "membership" is exactly 2 hours less than the...

Dan

04-18-2007 10:19 AM
Dan

Hi, in table aspnet_membership of ASPNETDB.MDF, there are two fields "email" and "lowered email" with the same value for each user. Can somebody...

Dan

04-18-2007 10:15 AM
Dan

I am trying to install SQL Server 2005 on Server 2003 r2 Installing dotnet framework gives errors. This happens just trying to install the redist...

JeffreyC

04-18-2007 07:02 AM
JeffreyC

Hello, To make a long story short, all of my applications are currently running on a trial version of SQL 2000. I'm working on porting them out to...

evanhill

04-17-2007 11:16 AM
evanhill

Hello, SQL Server Express 2005 SP2 is not upgrading. How can I capture its installation log to post it here for solution? Thank you.

Athena

04-17-2007 08:44 AM
Athena

I'm trying to install SQL Server 2005 Express so I can use it with Visual Studio 2005 Professional to develop some practice ASP web apps. The...

cj

04-17-2007 01:22 AM
Charles Wang[MSFT]