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 2005 Forums
 Transact-SQL (2005)
 Security - login default database

Author  Topic 

Korigami
Starting Member

9 Posts

Posted - 2009-02-19 : 03:48:04
Hi

I have set up a login for a database that is picking up a group of users and this has been setup with windows authentication.

However even though I've set the default database to be a particular database it is still pulling through as master.

Any ideas on how to sort this?

We have other servers with copies of this database on and they are able to pick up this group fine and log in with the correct default database.

Many thanks

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-02-19 : 05:34:52
Might want to go thru this,
http://support.microsoft.com/kb/196076
Go to Top of Page

Korigami
Starting Member

9 Posts

Posted - 2009-02-19 : 07:26:07
thanks for this, but doesn't seem to have made a difference... could it be the group that has been set up is not quite right?
Go to Top of Page
   

- Advertisement -