SQL Server 2008 R2: Failed to open the explicitly specified database
-
Monday, April 30, 2012 9:44 PM
I am trying to install WS_FTP Server using a remote Microsoft SQL database. We have a server at Rackspace setup to be a secure FTP server, and another server at Rackspace provisioned as a Microsoft SQL server running Windows 2008 R2 running the latest and the greatest.
During installation of WS_FTP Server, I am prompted to enter in a Server\Instance, Port (1433), Database username, and Password. For Server\Instance, I just enter in the hostname of the server (i.e. SRV-SFTP). Port is already automatically filled. I created a user 'wsftp1' under SRV-SQL1 (SQL Server 10.50.2500 - COMPANY\AdminAccount)\Security\Logins in Microsoft SQL Server Management Studio. I also created a database under SRV-SQL1 (SQL Server 10.50.2500 - COMPANY\Databases called 'wsftp1'. When I created this database, I made user 'wsftp1' the Owner.
When I run through the WS_FTP Server installation (when it actually copies files, configures, writes registry keys, creates services, starts up, etcetera) I encounter a bunch of errors, identical to the ones at http://forums.ipswitch.com/Topic46458-8-1.aspx (year 2008, version 6). I am using the latest version 7.5 for WS_FTP Server.
I look in the SRV-SQL1 (SQL Server 10.50.2500 - COMPANY\Management\SQL Server Logs\Current - 4/30/2012 3:05:00 PM log file, and it has a half a dozen pairs of errors.
The first error is:
Date 4/30/2012 3:59:35 PM
Log SQL Server (Current - 4/30/2012 3:33:00 PM)Source Logon
Message
Error: 18456, Severity: 14, State: 38.The second error is:
Date 4/30/2012 3:59:35 PM
Log SQL Server (Current - 4/30/2012 3:33:00 PM)Source Logon
Message
Login failed for user 'wsftp1'. Reason: Failed to open the explicitly specified database. [CLIENT: xxx.xxx.xxx.xxx]I don't know what to do. :( I have spent an hour or so just doing hard Googling without finding a distinct solution (mostly because I lack Microsoft SQL experience and knowledge). Would this be PostgreSQL or MySQL, I would know what to do (because I have almost a decade of deep experience in the webhosting industry and running my own company).
EDIT: Unmentioned detail -- I also set the default database to 'wsftp1' for the user 'wsftp1'
- Edited by hlrse Monday, April 30, 2012 9:45 PM
All Replies
-
Monday, April 30, 2012 10:05 PMModerator
Hello,
Please see the following post:
http://blogs.msdn.com/b/sqlsakthi/archive/2011/02/06/how-to-troubleshoot-connectivity-failure-error-with-sql-server.aspx
I would recommend you also to configure Windows Firewall or disable it.
http://msdn.microsoft.com/en-us/library/cc646023(v=sql.105).aspx
Let us know if this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Edited by Alberto MorilloMVP, Moderator Monday, April 30, 2012 10:09 PM
-
Wednesday, May 02, 2012 8:37 AMModerator
Hi Hlrse,
Error: 18456, Severity: 14, State: 38 indicates that user does not have access to the database.
In WS_FTP Server Installation and Configuration Guide, we can found this reference:
If you chose Microsoft SQL Server for your database (in step 2), next you will be asked to enter the Server's name or IP address with the instance name (formatted as Server/Instance), a Port number (the install autofills SQl Server's default value of 1433), the Master Database Username, and Password. Click Next. So your user wsftp1 also need permissions in Master database.For more information, suggest your read the Installation Guide in WS_FTP website.
Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Proposed As Answer by Alberto MorilloMVP, Moderator Wednesday, May 02, 2012 11:30 AM
- Marked As Answer by Iric WenModerator Tuesday, May 08, 2012 1:04 AM
.png)
