Need help with SQL Server 2008 SQL_Latin1_General_

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Need help with SQL Server 2008 SQL_Latin1_General_

Author

Topic

learningsql00
Starting Member

28 Posts

Posted - 2012-02-10 : 09:29:45

I have installed SQL Server 2008 R2...

The installation was successful..I did mixed mode and everything...

Now I am using a problem that will be using SQL Server for storing information..

This program is telling me that..I need to have "SQL_Latin1_General_CP1_CI_AS"

But It is already installed. When I go to SQL Server Mangmt Studio -> Right click on Server Name (Object Explorer) -> Properties

I see : Server Collation: SQL_Latin1_General_CP1_CI_AS

I guess it means it is installed correctly.

Any advise ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-10 : 10:33:48

This program is telling me that..I need to have "SQL_Latin1_General_CP1_CI_AS"

which program?

Also is database currently empty or have you added tables in it?if yes, check if any one of table columns are having different collation setting

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

learningsql00
Starting Member

28 Posts

Posted - 2012-02-10 : 11:38:21

quote:
Originally posted by visakh16
which program?

Also is database currently empty or have you added tables in it?if yes, check if any one of table columns are having different collation setting

------------------------------------------------------------------------------------------------------

Right now there is no database / tables involves.
The problem I am talking about is "System Center Configuration Manager"
For installing that problem, SQL Server 2008 is required.
So as a prerequisite, it is checking the sql server and telling me that I don't have "SQL_Latin1_General_CP1_CI_AS" which is wrong because I do have it installed like I mentioned above.

Any advise ? what to see and where to see ?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources