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 |
|
veda_sqldba
Starting Member
6 Posts |
 Posted - 2010-09-03 : 05:20:16
|
| Hi, Our app team is unable to log into the ssms 2008. This team is mapped to a Active Directory group which has all neccessary permissions given to log into SqlServer Management Studio.They are able to log to SSMS 2000 and SSMS 2005 databases but they cant login to SSMS 2008.The error msg is as follows:Unable to login to server.Cannot Connect to defaultdatabase,Lohin failed[sql server error:4064]I browsed through the all forums and blogs and tired various options Deleted the login AD group in sqlserver, users and recreated them.Changed the default database to master for this login group.Changed the compatibility level from 80 to 100.but none worked.NOTE:Application team is logging to the SSMS via utility "ShellRunAs".Can someone please help.VEDA |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-03 : 09:58:18
|
| they log in to SQL Server, not SSMS. SSMS is just a tool to connect to SQL Server with.WHY are they using runas? If these users are in an AD group, just give the group permissions is SQL Server and have them log in using their windows credentials. |
 |
|
|
veda_sqldba
Starting Member
6 Posts |
Posted - 2010-09-03 : 11:09:29
|
| Yes Rusell, you ar right they login to sql server. What i meant was in this physical server, there are various instances out of which some are version 2000, 2005,2008.This particular Ad group logins are able to login to other instances but not to 2008 instance.Other than version difference , everthing else like the db properties, the default db, connection properties everything are same among all instances.VEDA |
|
|
|
|
|
|
Unable to login to ssms 2008