Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: User logon failure



Permlink Replies: 2 - Last Post: Dec 3, 2014 4:18 PM Last Post By: Gerald Morris
Gerald Morris

Posts: 13
Registered: 11/13/00
User logon failure
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 2, 2014 4:41 PM
I have installed XE3 64bit on Windows 2008R2

I have backed up and restored a database to this server

I am able to access the database using sysdba with no problems.

I added a new global user WEBUSER in IBConsole, and granted user privileges for that user in the database

When I attempt to connect as WEBUSER to the database I get the following error
Error connecting to the requested database
Database D:\TestFolder\TestDatabase.GDB shutdown

Any advice appreciated
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: User logon failure
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 2, 2014 8:05 PM   in response to: Gerald Morris in response to: Gerald Morris
Gerald Morris wrote:
I have installed XE3 64bit on Windows 2008R2

I have backed up and restored a database to this server

I am able to access the database using sysdba with no problems.

I added a new global user WEBUSER in IBConsole, and granted user privileges for that user in the database

When I attempt to connect as WEBUSER to the database I get the following error
Error connecting to the requested database
Database D:\TestFolder\TestDatabase.GDB shutdown

Any advice appreciated

Right click on the database, Goto Maintenance and then Database Restart. when
a database has been shutdown, no user but sysdba can connect to it.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
And so I patrol in the valley of the shadow of the tricolor
I must fear evil. For I am but mortal and mortals can only die.
Asking questions, pleading answers from the nameless
faceless watchers that stalk the carpeted corridors of Whitehall.
(Fish)
Gerald Morris

Posts: 13
Registered: 11/13/00
Re: User logon failure
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 3, 2014 4:18 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Thanks Jeff for your very helpful answer
That solved my problem

Gerald
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02