Re: SQLDriverConnect error

Mike,


That did it. Changed it for the whole group to 1 of the other databases and
now the users can connect without any problems.
Thanks for your assistance

Regards,

Adrie de Regt
Netherlands


"Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx> wrote in message
news:eRN3ZDiCGHA.312@xxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxx
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Adrie de Regt" <a.deregt@xxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:%23kcmgkeCGHA.1028@xxxxxxxxxxxxxxxxxxxxxxx
> > 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
> >
> >
>
>


.

Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)