Report Server Database Collation differs from SQL Server

Last Post 01 Jun 2007 11:48 AM by Maxer. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Maxer
New Member
New Member

--
01 Jun 2007 05:19 AM
It appears that the collation for my SQL server: SQL_Latin1_General_CP1_CI_AS differs from what my report server has set: Latin1_General_CI_AS_KS_WS

I'm a bit confused by this as I guess I assumed that what I selected for SQL server during the installation would be used by all the databases on the system when they were created (including the report server database).

So as I understand it I need to change the collation of my report server, and to do that I basically have to create a new reprot server database on the SQL server.

However, how can I ensure that the new database will use the proper collation? (How can I check what my DEFAULT collation is set for on the server?)
Maxer
New Member
New Member

--
01 Jun 2007 11:48 AM
Are you saying "Not really" to being able to set a default for all databases, or being able to set the collation on the report server, or to it mattering what they are set for?
You are not authorized to post a reply.

Acceptable Use Policy