Unable to create DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TLuebke - 27 Jul 2006 14:36 GMT

I run an SQL server to support a college DB class. I just upgraded my box
from 2000 to 2005. that said... while testing a student log-on I get an
error trying to create a DB even though the account has the DBcreator role
checked.

Clicking New Database gives me - Cannot show requested Dialog -failed to
connect to server X.X.X.X - cannot open user default database. Login failed
Login failed for user DBA9 (MSSQL error 4064)

Any thought?

Todd

Reply to this Message

10001110101 - 27 Jul 2006 14:53 GMT

Check the SQL server login for the student login and make sure that
login has access to its default database - if it should even. If not
change the default database to master and try reconnecting.

> I run an SQL server to support a college DB class. I just upgraded my box
> from 2000 to 2005. that said... while testing a student log-on I get an
[quoted text clipped - 8 lines]
>
> Todd

Reply to this Message

TLuebke - 27 Jul 2006 19:03 GMT

Problem Solved -Thanks

> Check the SQL server login for the student login and make sure that
> login has access to its default database - if it should even. If not
[quoted text clipped - 11 lines]
> >
> > Todd

Reply to this Message