Solved

SQL Server2008

Posted on 2011-03-17
1
333 Views
Last Modified: 2012-05-11
I have a sql server 2008 with a default instance, I move a configuration management database from a sql server 2005 to the new sql server 2008 and I could connect to the database. the problem is: the collation was different and I was requested to create a new instance on the new 2008 server with the collation of the database. I created the new name instance and move the configuration management database to it and then try to run the configuration program but I could not connect the configuration management database on the new name instance, I received this message: configuration manager R2 sp2 could not connect or execute sql query.
Does anyone knows what could be the problem.
0
Comment
Question by:vera2006
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
rkharko earned 500 total points
ID: 35156985
In the SQL Server 2008 is changed the default security policy that disables SQL Server Authentication mode and you need to have membership of Administrators group of server machine in order to connect to SQL Server 2008 via Windows Authentication mode

 see here some more info
Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out

How to: Change Server Authentication Mode
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question