| Author |
Topic |
|
Korigami
Starting Member
9 Posts |
 Posted - 2009-02-19 : 07:44:28
|
| HiI 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 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 12:17:39
|
| Do they have access to those databases? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Korigami
Starting Member
9 Posts |
Posted - 2009-02-23 : 06:00:20
|
| Hi Thank you for your responses - what do you mean do they have access to these databases - I am trying to set up the login at the moment?The users are using SQL server management studio - and they are part of another group - but this has the same default database set upMany thanksK |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-02-25 : 07:16:21
|
quote:
Originally posted by Korigami
Hi Thank you for your responses - what do you mean do they have access to these databases - I am trying to set up the login at the moment?The users are using SQL server management studio - and they are part of another group - but this has the same default database set upMany thanksK
try restarting the sql services after setting the default db for the login....Regards,Ahmad Osama |
|
|
|
Korigami
Starting Member
9 Posts |
Posted - 2009-02-26 : 03:52:49
|
| HiI've tried restarting the sql services after setting the default db. Is it possible it could be to do with the server?Many thanksK |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-02-26 : 06:30:56
|
quote:
Originally posted by Korigami
HiI've tried restarting the sql services after setting the default db. Is it possible it could be to do with the server?Many thanksK
I dont have a logic behind it right now ...I can only say that it worked in my case....I'll find out ...Regards,Ahmad Osama |
|
|
|
Korigami
Starting Member
9 Posts |
Posted - 2009-02-26 : 07:07:11
|
| I have just checked a few things on the server, and can see that it is not as up to date as the other servers. So am currently downloading Service Patch 2 to install on the server. Hopefully will fix the problem but maybe not? I will keep you posted!CheersK |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Korigami
Starting Member
9 Posts |
Posted - 2009-03-05 : 09:21:16
|
| still not having any joy with this - i've installed service pack 2 and still doesnt seem to be picking up the correct default db. any ideas anyone? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Security - logins & default database