| Author |
 Topic  |
|
|
MadCow
Honorable But Hopeless Addict
Canada
1834 Posts
Status: offline |
 Posted - 04/11/2012 : 10:48:17 AM
|
Trying to install this piece of software on my SQL 2008 Server. I am logged on the SQL Server using an account which is local admin and has SQL SysAdmin, ServerAdmin, SetupAdmin & Public Roles. When I run the setup and at one point where it tries to create the database
I enter the SQL Server Name, Instance name the DB name and click Next … I am presented with the following error ….
Cannot open database “DB Name” requested by the login. The login failed. Login failed for user “domain\username”
Yesterday I was able to install the first part of this same application with the same account on this very same SQL Server and it created the DB and all was well but today it gives me error.
Application log on the SQL server shows the following:
Login failed for user 'Domain\username'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
Any ideas?
Thank you
|
Sunny
__________________________________________________________________________
"Everyone is susceptible to the notion that when you begin to do well, you begin to see no boundary lines and forget the rules apply" - Eliot Spitzer
|
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
Posted - 04/11/2012 : 1:21:18 PM
|
What is the application?
Is there a SPN for the sql instance?
Do you have access to the database?
Who is the owner of the database?
Some apps require dbcreator and security admin to install.
Others even more.
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
 |
|
|
MadCow
Honorable But Hopeless Addict
Canada
1834 Posts
Status: offline |
Posted - 04/11/2012 : 1:35:46 PM
|
Thanks Curt for your response.
I understand the message is beguiling and appears as if it is trying to access/open the DB. In fact the DB does not exist and the installation is trying to create the DB.
App is SecureVantage ACS optimizer. Not sure how I can find out the SPN for this specific instance.
|
Sunny
__________________________________________________________________________
"Everyone is susceptible to the notion that when you begin to do well, you begin to see no boundary lines and forget the rules apply" - Eliot Spitzer
|
|
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
Posted - 04/11/2012 : 2:02:59 PM
|
Ok, give the account the dbcreator role and the security administration role.
You can use the Setspn <server name> -L command to see if there is a service principal name for the default instance of SQL.
Use a domain account and add that account to the local admins group on the box.
Let's see what happens now.
quote:
Originally posted by MadCow
Thanks Curt for your response.
I understand the message is beguiling and appears as if it is trying to access/open the DB. In fact the DB does not exist and the installation is trying to create the DB.
App is SecureVantage ACS optimizer. Not sure how I can find out the SPN for this specific instance.
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
|
MadCow
Honorable But Hopeless Addict
Canada
1834 Posts
Status: offline |
Posted - 04/11/2012 : 2:50:12 PM
|
Thanks Curt.
Assigned all the roles and still the same error.
I don't see any SPN for this SQL Instance.
|
Sunny
__________________________________________________________________________
"Everyone is susceptible to the notion that when you begin to do well, you begin to see no boundary lines and forget the rules apply" - Eliot Spitzer
|
|
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
Posted - 04/11/2012 : 4:36:18 PM
|
That's not good.
Is the application run on a server outside of the SQL server?
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
Posted - 04/11/2012 : 4:39:50 PM
|
setspn -L O-PBPCOLMET Registered ServicePrincipalNames for CN=O-PBPCOLMET,CN=Computers,DC=sysnetwork
> ,DC=com:
> MSSQLSvc/o-sqlcm.sysnetwork.com:1433
> WSMAN/O-PBPCOLMET.sysnetwork.com
> WSMAN/O-PBPCOLMET
> TERMSRV/O-PBPCOLMET
> TERMSRV/O-PBPCOLMET.sysnetwork.com
> RestrictedKrbHost/O-PBPCOLMET
> HOST/O-PBPCOLMET
> RestrictedKrbHost/O-PBPCOLMET.sysnetwork.com
> HOST/O-PBPCOLMET.sysnetwork.com
You should get a return from the setspn command that should look like this.
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
|
MadCow
Honorable But Hopeless Addict
Canada
1834 Posts
Status: offline |
Posted - 04/16/2012 : 3:33:53 PM
|
Since the error message states
"cannot open database "operationsmanagerAC" requested by the login.
I am thinking to create the DB manually, assign all the appropriate rights and then fire up the setup ...what say you?
Thanks. |
Sunny
__________________________________________________________________________
"Everyone is susceptible to the notion that when you begin to do well, you begin to see no boundary lines and forget the rules apply" - Eliot Spitzer
|
|
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
Posted - 04/16/2012 : 4:22:05 PM
|
On the support forums we get a lot of developers who can't get what we often call the network right for modern applications.
The installs and database creations of these installation programs are often pretty good but if you create it manually and succeed with the install, you will only just begin with problems.
quote:
Originally posted by MadCow
Since the error message states
"cannot open database "operationsmanagerAC" requested by the login.
I am thinking to create the DB manually, assign all the appropriate rights and then fire up the setup ...what say you?
Thanks.
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
| |
Topic |
|
SQL Login Failed - Event ID:18456
