RSS feed

SQL Server 2008 Error: is not a valid login or you do not have permission

Published by: Ritu (1/27/2009 3:09:37 PM)

JAN 27 2009

I am installing sql server 2008 on my machine running on windows xp professional, I am getting this error no doubt i try installing it on any style. Advance and non-advance fail to install on my machine. Any help can set me up and running sql server 2008 will be appreciated.

 

Domain Controller Removed from SQL Server 2008 Database Server >>

<< How to fetch a specific record from a table

 

COMMENT

Name: Sangeeta

If you are using SQL Server Standard Edition then check for the Service Pack of your OS and if you are using SQL Server Enterprise Edition then you need to install it on Windows Server 2008 or Windows Server 2003 OS.

Name: ninjai

computer name cannot be the same as account name

Name: Max

The Developer edition installs fine on one Vista machine, and fails with this error on another

’’ is not a valid login or you do not have permission.

I started with upgrade from 2005, but now I am out of options.

Last attempt:

Uninstalled every-thing 2008 and 2005
Logged in with new admin user (which is different from machine name)
Started setup as administrator...

And it still trying to create empty users and server names...

2009-11-22 21:07:13 ACE: Setting registry value. Key = ’HKEY_LOCAL_MACHINE\SOFTW
ARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\SQLServerAgent’, Field =
’MSXServerName’, Value = ’’


2009-11-22 21:07:13 ACE: Setting registry value. Key = ’HKEY_LOCAL_MACHINE\SOFTW
ARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\SQLServerAgent’, Field =
’ServerHost’, Value = ’’

2009-11-22 21:12:59 Slp: --SafeSqlCommand: if exists(select * from sys.server_pr
incipals where name = N’’) DROP LOGIN [];

2009-11-22 21:12:59 Slp: --SafeSqlCommand: EXEC sys.sp_addsrvrolemember N’’, N’s
ysadmin’
2009-11-22 21:12:59 Slp: Sco: SqlException: Message:’’ is not a valid login or y
ou do not have permission.

This is really annoying. Can it at least check that it has basic parameters, before continue with the install. This try-n-error with 30 min in between really nuts.

Name: Kashif

@ninjai

You are correct, Thanks for saving me.

*Name:
*Comment:
You can use HTML tags here.
*Code: Please enter the sum of 5+2