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.
| Author |
Topic |
|
sharmikanna
Starting Member
5 Posts |
 Posted - 2004-10-05 : 16:56:34
|
| While installing sqlserver8.0, i chose windows authentication mode(instead of mixed mode). But later i changed it to mixed mode(browsing the properties and security tab in the enterprise manager)Recently i took a backup of a database from a different server and restored it here.My problem is - the database shows up fine with the enterprise manager but while opening the query analyser, the database doesnt show up (if loggedin sql authentication mode though it shows fine in windows authentication mode) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-05 : 17:06:30
|
| The permissions for each account must be different. So check the permissions of the SQL account that you are using and compare it to the Windows account.Tara |
 |
|
|
sharmikanna
Starting Member
5 Posts |
Posted - 2004-10-05 : 17:10:29
|
| There must not be probelm with permission bcoz the database does show up in enterprise manager. The problem is only with the Query analyser.Thanks for the reply.Any further help is appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-05 : 17:15:54
|
| But what authentication are you using in Enterprise Manager? And can you get into that database without any problems using SQL authentication inside Enterprise Manager?So log into EM using the SQL account. Navigate to the database that you can't see in Query Analyzer. Open up the tables. Are you able to do this in EM? If so, now log into Query Analyzer using the SQL account, then do this:USE DBNameGOSELECT * FROM sysobjectsGODoes that work for the database that you are having problems with?Tara |
|
|
|
sharmikanna
Starting Member
5 Posts |
Posted - 2004-10-05 : 17:19:21
|
| Yes, the problem was with permission only. The logon failed for the user. So created a new user and now works fine. Hats off to you. You are a genius in DB. |
|
|
|
|
|
|
Authentication mode prob in sql