"Adrie de Regt" <a.deregt@remove.this.hccnet.nl> wrote in message
news:%23kcmgkeCGHA.1028@TK2MSFTNGP11.phx.gbl...
> ls,
>
>
> We run MSSQL 2000 on a W2K3 machine. There is an accounting software
> (Exact
> Globe) that access its data by means of SQL. For some reason I can only
> connect to the SQL server as ADMINISTRATOR. Though I created a group, put
> members into the group. I put this group in logins/security under SQL.
> They
> should hace enough rights to access the databases. When I login (start the
> accounting software) ans try to open a database it says:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> requested in login '001'. Login fails.
> SQL State: 37000
> DB error: 4060
> EDL error: An error has occurred in the execution of the ODBC function
> 'SQLDriverConnect'.
>
> I hope someone can point me in the right direction to solve this problem
>
>
> Regards,
>
> Adrie de Regt
> Netherlands
>
>

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:eRN3ZDiCGHA.312@TK2MSFTNGP09.phx.gbl...
> Hi
>
> The error says that for the user that is logging into SQL Server, SQL
Server
> can not open the default database as configured for the login.
>
> For login 001, you need to give the user another default database. You do
> this though Enterprise Manager, Logins. Right click on the login and
select
> properties. Then at the bottom of the screen, select another default DB
and
> press OK.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Adrie de Regt" <a.deregt@remove.this.hccnet.nl> wrote in message
> news:%23kcmgkeCGHA.1028@TK2MSFTNGP11.phx.gbl...
> > ls,
> >
> >
> > We run MSSQL 2000 on a W2K3 machine. There is an accounting software
> > (Exact
> > Globe) that access its data by means of SQL. For some reason I can only
> > connect to the SQL server as ADMINISTRATOR. Though I created a group,
put
> > members into the group. I put this group in logins/security under SQL.
> > They
> > should hace enough rights to access the databases. When I login (start
the
> > accounting software) ans try to open a database it says:
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> > requested in login '001'. Login fails.
> > SQL State: 37000
> > DB error: 4060
> > EDL error: An error has occurred in the execution of the ODBC function
> > 'SQLDriverConnect'.
> >
> > I hope someone can point me in the right direction to solve this problem
> >
> >
> > Regards,
> >
> > Adrie de Regt
> > Netherlands
> >
> >
>
>