default windows authentication is greyed out, how can i change to be abled to allow use different windows authentication id to login ?

DD

07-06-2010 11:13 AM
Erland Sommarskog

We have 2 id under windows adminsitarotr groups, admin1 id is buid in admin id can launch the sql managemetn studio but for admin2 id, when click the...

DD

07-06-2010 05:18 AM
DD

System: Win 2003 Server R2 Standard Edition SP2 SQL Server 2005: Standard edition SP2 During installation of SP3 I have got the following...

znaika

07-05-2010 04:21 AM
Erland Sommarskog

I apologize for my frustration showing, but... After nearly 3 weeks, I have not had a reply to a previous post - this statement needs upadting: "Post...

bbirindelli

07-04-2010 10:10 PM
znaika

Is it possible to have multiple backup chains for a database? For example, I would like to maintain daily full backups on a local network drive, but...

kingston via SQLMonster.com

07-03-2010 03:24 PM
Erland Sommarskog

During the SQL installation,using the Mixed Mode, we ceated a windows login sqladmin and added this windows login id in the Specify SQL...

DD

07-02-2010 06:12 PM
Erland Sommarskog

I've recently installed Visual Studio 2010 Professional on a new development notebook PC running Windows 7 Professional. I want to move my VS2005...

CDH

07-02-2010 06:06 PM
Erland Sommarskog

I'm getting this error when trying to setup SQL on a 2 node server cluster. Both servers have access to 2 volumes on the SAN. Neither Cluster Disk 1...

jkennedy

07-01-2010 04:07 PM
jkennedy

Hello, Is the procedure to change database recovery model from full to simple?Is ot only change in properties or we need do something more.I would...

Arti

07-01-2010 07:24 AM
Dan

I'm trying to install SQL 2008 R2 from my Action Pack subscription on my Windows 7 Home Premium x64 box. The setup doesn't say it's not...

Andre

06-30-2010 11:07 AM
Andre

I'm trying to install SQL Server 2005 Developer Edition on my Windows 7 (Ultimate) laptop. When the installer gets to the 'workstation components,...

cometbill

06-30-2010 05:14 AM
cometbill

Is anybody using InnoSetup for installing and deploying a MSSQL Express database? I used SQLDMO but would like to update this. Additionally we...

Bernd Maierhofer

06-30-2010 03:05 AM
Bernd Maierhofer

I have tried the trial version of Microsoft Dynamic POS and it is great specially when I saw that when you install the software, SQL...

Jay

06-28-2010 09:06 AM
Jay

....that worked for me, trying to install sql2005 developer. Used the ms clean up tool as noted in post and installed the msxml6 msi, worked for...

bill jackson

06-27-2010 09:41 AM
bill jackson

Hi Friends, SQL 2008 - TDE encryption I'm trying to apply TDE for one of my databases, all seems run fine, except that when I run SELECT...

Pat.Rick

06-25-2010 04:13 PM
Pat.Rick

I'm trying to upgrade my sql 2005 to sql 2008. In the setup I'm ale to get as far as the Reporting Services Authentication screen when I encounter...

Don Powell

06-24-2010 02:17 PM
Kevin Bradley

This posting is related to "SQL Server 2008 Standard Edition on windows XP". I have the problem both when installing SQL Server 2008 Standard...

Guy

06-24-2010 01:41 PM
Martin Beechen

System: Win 7 Ultimate SQL 2000, SQL 2005 and VS 2008 The install goes on fine till the System Configuration Check and it tells me that my Visual...

dpc

06-23-2010 05:48 PM
Erland Sommarskog

Hello, I can't figure this out.And i hope there's someone way around that help's me. I have a sharepoint (wss3.0) list with A,B and C fields.I found...

nieto

06-23-2010 11:21 AM
nieto

Hello, I have downloaded SQL Server standard edition from MSDN in French. I try to install it on a windows 7 Professionnel. I get the error : "TITLE:...

Francois C

06-18-2010 08:11 AM
Diesel@srn.invalid

Hi I've downloaded SQL Server 2008 R2 Developer (license key states pre-pidded). Then I install the product with no problem. The license key...

pon2010

06-16-2010 01:35 AM
Jagi

Hi, My company runs an SBS 2003 server and has a number of third party products (backup software, virus checker, etc.) and MS products (Sharepoint)...

ever90321@mypacks.net

06-08-2010 06:00 PM
ever90321@mypacks.net

I have downloaded and am preparing to install CU8 on my test instance. In the hotfix.txt file, it lists (supposedly) all the kb's included in...

cc

06-07-2010 05:30 PM
Erland Sommarskog

Hi, I am in the process of installing SQL 2005 on a 2 node cluster. When I enter the virtual server name I get the following error message: ...

Teresa G Wilson

06-07-2010 11:47 AM
Teresa G Wilson

Hi- I have been trying to get a silent SQL SERVER Express install to work on 2008 and was wondering if anyone had any luck. I can't even get the...

doug

06-07-2010 07:18 AM
Amir Farid Abbasi

Can SQL sever 2008 sp1 be applied to sql server R2 editions? Is the answer of the question true about other MS products that have R2 in their name?

Leon_Amirreza

06-06-2010 10:56 AM
Erland Sommarskog

They're saying they won't fix it. In this specific case, it is because they can not go back in time and push a lower version of MSXML6 with XP...

Chris Wood

06-06-2010 09:54 AM
Dilip S

I believe its possible to record, or to retrieve a script from an sql installation, and to deploy this to multiple other sql installations. Can...

W.a.Sdanou

06-05-2010 04:52 PM
Erland Sommarskog

I had to remove and reinstall SQL Server 2005 Standard. Despite having removed the the two report server databases, the roles, the directories and...

Mark Gould

06-04-2010 12:33 PM
Asif Mohammed

Hello, I like to setup a SQL 2008 two node cluster on Windows 2008 R2. I prefer to have SQL binaries installed on a shared drive (say a LUN on SAN)...

TSAM

06-03-2010 09:22 AM
TSAM

I have Windows service that it is Hitting my database MS SQL SERVER 2005 in every 10 sec. and running sp's (each of size max is 2kb). that's why I...

ravi kiran

06-02-2010 05:43 PM
Erland Sommarskog

Microsoft Sql server price list has about 900 items. Is somewhere an explanation for the acronyms used in it? I'm speeking of OLV, NL, MVL, OLP, AE,...

agostino

06-01-2010 08:55 AM
agostino

I have tried to install sql server 2008 on a windows server 2008 and running into this problem repeatedly. Any suggestions on what to do to make the...

rman

06-01-2010 06:23 AM
rman

I have tried multiple installs on several different servers and they all complete with errors. The Error is access denied when installing the...

Dave Twing

06-01-2010 06:21 AM
rman

Guys, I've noticed something odd about the msdn downloads which someone could comment on. For example, under sql server 2008 r2 I can see downloads...

PHS

05-31-2010 01:11 PM
PHS

Is it possible to install ONLY SQL 2008 configuration manager and not the entire client tools? Anybody?

cc

05-30-2010 04:15 PM
Erland Sommarskog

I have run Windows Update and it installed a number of items and now says there are no new items to install. However looking back over several...

Jonathan

05-30-2010 02:32 PM
Erland Sommarskog

Hi, for some reason sql 2005 business intelligence development studio seems to have been removed from my machine. When running the installation disk...

Jonathan

05-27-2010 11:51 PM
Jonathan

I have a SQL Server 2008 stored procedure that works fine, it uses Change Data Tracking to find some inserted rows and does stuff. I used a Visual...

SnapDive

05-27-2010 05:51 PM
Erland Sommarskog

Hi, I've often wondered about OS-Level defraging my data disks of my SQL Server 2005 server. Is it recommended, is there anything I should be...

Linn Kubler

05-27-2010 05:36 PM
Erland Sommarskog

I'm getting this error; "This SQL Server Setup media is not supported on a X64 system" in a little pop-up when trying to run setup.exe in the root...

Matt Elton

05-27-2010 05:22 PM
Matt Elton

Attention ,please! The most luxurious male straighteners currently are on the market ! With updated look and feel, the mini styler is really cutting...

ghdfans2010

05-27-2010 06:16 AM
ghdfans2010

I am getting the following error when I try and install SQL Server 2008. SQL Server Setup has encountered the following error: MsiGetProductInfo...

Neil8Ken

05-26-2010 08:56 AM
Andrew Nyago

I have run Upgrade Advisor successfully with only minor advisories. Configurator runs successfully. When I upgrade the following error...

JWittmann

05-25-2010 11:55 AM
JWittmann

Hi trying to install ms2005 sql express fails with the following system error. Title: .Net SqlClient Data Provider Message: A netword-related or...

Jonathan

05-24-2010 06:56 PM
Jonathan

I have issues installing SQL 2005 Express using an ini file on some non-English Windows installations. I receive a 28075 error when trying to use...

jordabi

05-24-2010 05:30 PM
Erland Sommarskog

I have downloaded SQL Server 2008 R2 Enterprise from MSDN Subscription downloads. When I try to install, after it checked hardware & software,...

Andre

05-24-2010 05:28 PM
Erland Sommarskog

Hi Guys, I am new on SSMA tool. I have new cluster server that installed sql server 2008 in windows 2003 and I installed ssma tool which will...

Iter

05-23-2010 11:23 AM
Iter

I am trying to install SQL Server 2008 and the setup indicated it needed a hotfix and so I said ok and it installed the hotfix. Then it said I had...

DavidC

05-22-2010 04:31 PM
Dave Patrick

Hi, I downloaded SS2008 R2 I am with an evaluation license 2 questions: - is it time limited ? - in the future I can change the license type to put...

bob123

05-22-2010 08:37 AM
Erland Sommarskog