I had a problem installing SQL Server 2008 Management studio on Windows XP, with an error (http://cid-b712073b3513eb8e.office.live.com/self.aspx/.Public/SQLManagementStudio%5E_x86%5E_ENU.exe-setup%20error.JPG) appearing as soon as I ran the setup program.

Since I had...

With SQL tools you mean software such as redgate?

🙂

It's the 'enterprise' edition; a bit too large to upload here though :). The wizard is displayed on Win 2008 Server 2008 machines after the installation is finished.

Well the actual syntax should be slightly different according to my book:

As expected the connection...

Thanks. Tried a couple of connection strings, but I probably need to dig memberships (ASP.NET) because they are not being accepted, for example:

web.config

...

connectionStringName="Data Source=DEV01\JOEY;User ID=sa; Password=password;"

...

Returns this error:

The...

"You must use SQL Server Express with Advanced Services SP3 to upgrade instances of SQL Server Express with Advanced Services to SP3."

Release notes at (http://download.microsoft.com/download/F/4/E/F4E80C76-3B69-4A42-A90B-79AEACA1177D/SQLExpress2005SP3RelNotes.htm#download)

I thought it was a mistake, because I have the Advanced Edition.

"You must use SQL Server Express with Advanced Services SP3 to upgrade instances of SQL Server Express with Advanced...

Well I ran the wizard downloaded at

http://www.microsoft.com/downloads/thankyou.aspx?familyId=b448b0d0-ee79-48f6-b50a-7c4f028c2e3d&displayLang=en, and, it seems I the latest SP is already installed, since my only option is to 'upgrade'.

When I...

Attached web.config.

Thanks for your reply, however, I did not quite understand what to do other than downloading SP3, which I wasn't aware of 🙂

1. Already checked through the SAC and under...

I would like to give you the required connection string, however, I'm not sure how to go about it, so specific questions would be appreciated.

Basically I'm using ASP.NET membership (following...

Well, I can try re-installing, however, I got the same error message when I ran the ASP.NET installation wizard on another machine with a similar setup however running Win 2008...

Well, I've run the ASP.NET Server Setup Wizard (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe), however I'm getting the following error. I can view tables from MS SQL Server Management Studio Express.

System.Web.HttpException: Unable to connect...

Thanks that worked.

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Jonathan>sqlcmd -E -Stcp:armani -Slocalhost\SQLEXPRESS

1>

That worked thanks,

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Jonathan>sqlcmd -E -Stcp:armani -Slocalhost\SQLEXPRESS

1>