failed to install sql server express due to Cannot alter the login 'sa'

Hi,

I am using dell precision m60 laptop with xp professional sp2. I had trouble to install sql server due to "Cannot alter the login 'sa'". I am part of administrators for this machine. Below is the log. Any idea? thanks. -dale

SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.

Error Code: 0x80073b2f (15151)
Windows Error Text:Source File Name: lib\odbc_statement.h
Compiler Timestamp: Mon Jun 13 14:30:24 2005
Function Name: OdbcStatement::execute_batch@.CnfgSQL@.120
Source Line Number: 91

- Context --

Connecting to SQL Server
ExecuteSqlCommands
USE [master]
<Started SQL statement: Tue Feb 28 15:10:40 2006>declare @.ServerName nvarchar(255) if not exists (select * from sysservers) begin select @.ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName')) execute sys.sp_addserver @.ServerName, local end
<Finished SQL statement: Tue Feb 28 15:10:41 2006>
<Started SQL statement: Tue Feb 28 15:10:41 2006>ALTER DATABASE model SET RECOVERY SIMPLE
<Finished SQL statement: Tue Feb 28 15:10:41 2006>
<Started SQL statement: Tue Feb 28 15:10:41 2006>EXEC sp_configure N'show advanced options', 1 RECONFIGURE WITH OVERRIDE
<Finished SQL statement: Tue Feb 28 15:10:41 2006>
<Started SQL statement: Tue Feb 28 15:10:41 2006>DECLARE @.Name AS nvarchar(128), @.LangID AS smallint SELECT @.Name=name, @.LangID=langid FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @.Name EXEC sp_configure N'default language', @.LangID EXEC sp_configure N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE
<Finished SQL statement: Tue Feb 28 15:10:41 2006>
<Started SQL statement: Tue Feb 28 15:10:41 2006>EXEC sp_configure N'show advanced options', 0 RECONFIGURE WITH OVERRIDE
<Finished SQL statement: Tue Feb 28 15:10:41 2006>

Looks like if SQL Server 2005 RTM is installed in a Domain where a windows Group named 'sa', 'SA', 'Sa' or 'sA' exists, installation fails when Integrated Security is chosen. However, despite having the Windows group in the Domain, installation with Mixed Security work fine. After having installed successfully with Mixed Secuirty, the server properties can be changed to accept Integrated Security connections only. This should work.|||thanks, Jeff. It is working now.

Failed to access IIS metabase

I have installed SQL Server 2005, including Reporting Services 2005 on
Windows XP Professional in a standalone environment. I can see the Reports
and ReportServer folders in IIS in Administrative Tools and all settings
appear to be appropriate.
My first problem is that, when I try to access
"http://localhost/ReportServer", I get an error "Failed to access IIS
metabase". I have looked at KB article
"http://support.microsoft.com/?kbid=267904" which is referred to in the error
message but it appears to relate to Windows Server 2003.
Secondly, I expected to get the same error when trying to access
"http://localhost/Reports" but in this case I get a message "Directory
Listing Denied" which seems to indicate that the metabase is not an issue
here. I can see the directory listing if I activiate this option in IIS in
Admin Tools but I can't browse the contents of the Reports web page.
Can anyone provide me with a solution? I have also listed this problem in
Windows Server - IIS in case it is an IIS problem.
Thank you.The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
Try registering in the command line using the following ..
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
and reset the iis. I think that will solve all the problem.
Let me know.
Thanks
Bava
"NeilW" wrote:
> I have installed SQL Server 2005, including Reporting Services 2005 on
> Windows XP Professional in a standalone environment. I can see the Reports
> and ReportServer folders in IIS in Administrative Tools and all settings
> appear to be appropriate.
> My first problem is that, when I try to access
> "http://localhost/ReportServer", I get an error "Failed to access IIS
> metabase". I have looked at KB article
> "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> message but it appears to relate to Windows Server 2003.
> Secondly, I expected to get the same error when trying to access
> "http://localhost/Reports" but in this case I get a message "Directory
> Listing Denied" which seems to indicate that the metabase is not an issue
> here. I can see the directory listing if I activiate this option in IIS in
> Admin Tools but I can't browse the contents of the Reports web page.
> Can anyone provide me with a solution? I have also listed this problem in
> Windows Server - IIS in case it is an IIS problem.
> Thank you.
>|||Your solution worked perfectly. Thanks very much.
"Bava Mani" wrote:
> The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
> Try registering in the command line using the following ..
> C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
> and reset the iis. I think that will solve all the problem.
> Let me know.
> Thanks
> Bava
> "NeilW" wrote:
> > I have installed SQL Server 2005, including Reporting Services 2005 on
> > Windows XP Professional in a standalone environment. I can see the Reports
> > and ReportServer folders in IIS in Administrative Tools and all settings
> > appear to be appropriate.
> >
> > My first problem is that, when I try to access
> > "http://localhost/ReportServer", I get an error "Failed to access IIS
> > metabase". I have looked at KB article
> > "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> > message but it appears to relate to Windows Server 2003.
> >
> > Secondly, I expected to get the same error when trying to access
> > "http://localhost/Reports" but in this case I get a message "Directory
> > Listing Denied" which seems to indicate that the metabase is not an issue
> > here. I can see the directory listing if I activiate this option in IIS in
> > Admin Tools but I can't browse the contents of the Reports web page.
> >
> > Can anyone provide me with a solution? I have also listed this problem in
> > Windows Server - IIS in case it is an IIS problem.
> >
> > Thank you.
> >|||I have this same problem, however the solution given here did not work. Here
is what I have done:
1) Run a repair install of .Net 2.0
2) Totally reinstall .Net 2.0
3) Run aspnet_regiis.exe -i
4) Run aspnet_regiis.exe -ga ASPNET
Still have the problem. Any more ideas?
--
James
"Bava Mani" wrote:
> The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
> Try registering in the command line using the following ..
> C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
> and reset the iis. I think that will solve all the problem.
> Let me know.
> Thanks
> Bava
> "NeilW" wrote:
> > I have installed SQL Server 2005, including Reporting Services 2005 on
> > Windows XP Professional in a standalone environment. I can see the Reports
> > and ReportServer folders in IIS in Administrative Tools and all settings
> > appear to be appropriate.
> >
> > My first problem is that, when I try to access
> > "http://localhost/ReportServer", I get an error "Failed to access IIS
> > metabase". I have looked at KB article
> > "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> > message but it appears to relate to Windows Server 2003.
> >
> > Secondly, I expected to get the same error when trying to access
> > "http://localhost/Reports" but in this case I get a message "Directory
> > Listing Denied" which seems to indicate that the metabase is not an issue
> > here. I can see the directory listing if I activiate this option in IIS in
> > Admin Tools but I can't browse the contents of the Reports web page.
> >
> > Can anyone provide me with a solution? I have also listed this problem in
> > Windows Server - IIS in case it is an IIS problem.
> >
> > Thank you.
> >|||Can you give me the error msg that it says. send me more details of when and
where you get the error.
Thanks
Bava
"James" wrote:
> I have this same problem, however the solution given here did not work. Here
> is what I have done:
> 1) Run a repair install of .Net 2.0
> 2) Totally reinstall .Net 2.0
> 3) Run aspnet_regiis.exe -i
> 4) Run aspnet_regiis.exe -ga ASPNET
> Still have the problem. Any more ideas?
> --
> James
>
> "Bava Mani" wrote:
> > The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
> > Try registering in the command line using the following ..
> > C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
> > and reset the iis. I think that will solve all the problem.
> > Let me know.
> >
> > Thanks
> > Bava
> >
> > "NeilW" wrote:
> >
> > > I have installed SQL Server 2005, including Reporting Services 2005 on
> > > Windows XP Professional in a standalone environment. I can see the Reports
> > > and ReportServer folders in IIS in Administrative Tools and all settings
> > > appear to be appropriate.
> > >
> > > My first problem is that, when I try to access
> > > "http://localhost/ReportServer", I get an error "Failed to access IIS
> > > metabase". I have looked at KB article
> > > "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> > > message but it appears to relate to Windows Server 2003.
> > >
> > > Secondly, I expected to get the same error when trying to access
> > > "http://localhost/Reports" but in this case I get a message "Directory
> > > Listing Denied" which seems to indicate that the metabase is not an issue
> > > here. I can see the directory listing if I activiate this option in IIS in
> > > Admin Tools but I can't browse the contents of the Reports web page.
> > >
> > > Can anyone provide me with a solution? I have also listed this problem in
> > > Windows Server - IIS in case it is an IIS problem.
> > >
> > > Thank you.
> > >

Extremely Slow connection time

Hi
I have recently reinstalled XP Professional as well as the MSSQL client tool
s.
Our SQL 2000 server is running Win2K with 512MB RAM, and has been doing so f
or quite a while, no changes where done to the server while I reinstalled XP
on my PC.
Now my connection to the SQL server is extremely sluggish, e.g. connecting v
ia the Query Analyzer takes up to 2 minutes, and so do any other subsequent
actions, for example opening the list of databases, tables or stored procedu
res on the object browser.
All my queries take ages to get going even for the simplest queries.
Previously the response was very reasonable, as are the other developers PCs
in the company, with similar set up.
I have tried using both forms of security but have no joy either way. I have
used the IP address – no go.
If I ping the NetBIOS name of the server the response is instantaneous.
Please help!!Did you remember to install SQL Server 2000 SP3a after the reinstall?
Without it, you are vulnerable to the Slammer.
Hope this helps.
Dan Guzman
SQL Server MVP
"Herbert Schroder" <herberts@.mweb.co.za> wrote in message
news:9FF54BCC-2F28-4F5A-9D6A-06A4D4B1CA41@.microsoft.com...
> Hi
> I have recently reinstalled XP Professional as well as the MSSQL client
tools.
> Our SQL 2000 server is running Win2K with 512MB RAM, and has been doing so
for quite a while, no changes where done to the server while I reinstalled
XP on my PC.
> Now my connection to the SQL server is extremely sluggish, e.g. connecting
via the Query Analyzer takes up to 2 minutes, and so do any other subsequent
actions, for example opening the list of databases, tables or stored
procedures on the object browser.
> All my queries take ages to get going even for the simplest queries.
> Previously the response was very reasonable, as are the other developers
PCs in the company, with similar set up.
> I have tried using both forms of security but have no joy either way. I
have used the IP address - no go.
> If I ping the NetBIOS name of the server the response is instantaneous.
>
> Please help!!
>

Extremely Slow connection time

Hi
I have recently reinstalled XP Professional as well as the MSSQL client tools.
Our SQL 2000 server is running Win2K with 512MB RAM, and has been doing so for quite a while, no changes where done to the server while I reinstalled XP on my PC.
Now my connection to the SQL server is extremely sluggish, e.g. connecting via the Query Analyzer takes up to 2 minutes, and so do any other subsequent actions, for example opening the list of databases, tables or stored procedures on the object browser.
All my queries take ages to get going even for the simplest queries.
Previously the response was very reasonable, as are the other developers PCs in the company, with similar set up.
I have tried using both forms of security but have no joy either way. I have used the IP address – no go.
If I ping the NetBIOS name of the server the response is instantaneous.
Please help!!
Did you remember to install SQL Server 2000 SP3a after the reinstall?
Without it, you are vulnerable to the Slammer.
Hope this helps.
Dan Guzman
SQL Server MVP
"Herbert Schroder" <herberts@.mweb.co.za> wrote in message
news:9FF54BCC-2F28-4F5A-9D6A-06A4D4B1CA41@.microsoft.com...
> Hi
> I have recently reinstalled XP Professional as well as the MSSQL client
tools.
> Our SQL 2000 server is running Win2K with 512MB RAM, and has been doing so
for quite a while, no changes where done to the server while I reinstalled
XP on my PC.
> Now my connection to the SQL server is extremely sluggish, e.g. connecting
via the Query Analyzer takes up to 2 minutes, and so do any other subsequent
actions, for example opening the list of databases, tables or stored
procedures on the object browser.
> All my queries take ages to get going even for the simplest queries.
> Previously the response was very reasonable, as are the other developers
PCs in the company, with similar set up.
> I have tried using both forms of security but have no joy either way. I
have used the IP address - no go.
> If I ping the NetBIOS name of the server the response is instantaneous.
>
> Please help!!
>