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 |
|
Jay123
Yak Posting Veteran
54 Posts |
 Posted - 2010-01-25 : 14:50:13
|
| i created a new login.now when the login's default database is master, it works fine.but when i try to change the default database to one i created i get the following error:2010-01-25 19:47:32.46 Logon Error: 18456, Severity: 14, State: 40.2010-01-25 19:47:32.46 Logon Login failed for user 'login1'. Reason: Failed to open the database specified in the login properties. [CLIENT: <local machine>]Thanks for taking look |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-25 : 14:53:45
|
| You need to give the login permission to access the database you set as their default db |
 |
|
|
Jay123
Yak Posting Veteran
54 Posts |
Posted - 2010-01-25 : 15:07:42
|
| Thanks russel, i dont think i have ever had a reply that quick.that was he problem i was having.1 question i do have is i used to run sql and vwd on xp, but now i have 7.did it create permision automaticly or something on xp becuse i dont remember having to do this before. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-01-25 : 15:15:17
|
quote:
Originally posted by Jay123
Thanks russel, i dont think i have ever had a reply that quick.
That's an eternityquote:
did it create permision automaticly or something on xp becuse i dont remember having to do this before.
No Miracles...you just forgot or someone did it for youBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-25 : 15:25:13
|
quote:
Originally posted by Jay123
Thanks russel, i dont think i have ever had a reply that quick.
quote:
Originally posted by X002548
That's an eternity
I must've read it while Brett was grabbing another beer  |
|
|
|
|
|
|
Trouble creating logins