sql server 2005 will work on 2008 server and RAM 8GB [Resolved]

Posted by Yrajudba under Sql Server on 6/24/2011 | Points: 10 | Views : 2297 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

i am installing 2005 ms sql server Enterprise edition 64 bit on 2008 windows server with RAM 8 GB.
can anybody let me know. will it support.
when i try to login to sql server with windows account. it is showing error: Microsoft SQL Server,Error:18456

can any help me onthis

Thanks
Raju

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Yrajudba on: 6/24/2011 [Member] Starter | Points: 25

0	Thanks a lot Pandian, really superb, its working fine. Regards, Raju Yrajudba, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: SheoNarayan on: 6/24/2011 [Administrator] HonoraryPlatinum | Points: 25

0	Hi Yrajudba, Looks like you should be able to install SQL Server 2005 on Windows Server 2008, read the system requirement here http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx. The error you are getting is related with proper credentials and configurations, read it here http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx . Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Yrajudba, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Yrajudba,

Looks like you should be able to install SQL Server 2005 on Windows Server 2008, read the system requirement here http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx.

The error you are getting is related with proper credentials and configurations, read it here http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx .

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: PandianS on: 6/24/2011 [Member] [MVP] Silver | Points: 25

0	Hi - The Error "18456" seems to be, You have not created/mapped Windows user (Windows Authentication) in SQL Server..... - Login into SQL Server using SQL Authentication and create windows login USE [master] GO CREATE LOGIN [MachineName\UserName] FROM WINDOWS WITH DEFAULT_DATABASE=[master] GO EXEC master..sp_addsrvrolemember @loginame = N'MachineName\UserName', @rolename = N'sysadmin' GO Cheers www.sqlserverbuddy.blogspot.com Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Yrajudba, if this helps please login to Mark As Answer. \| Alert Moderator

Hi

- The Error "18456" seems to be, You have not created/mapped Windows user (Windows Authentication) in SQL Server.....
- Login into SQL Server using SQL Authentication and create windows login

USE [master]

GO

CREATE LOGIN [MachineName\UserName] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

GO

EXEC master..sp_addsrvrolemember @loginame = N'MachineName\UserName', @rolename = N'sysadmin'

GO

Cheers
www.sqlserverbuddy.blogspot.com

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts