Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

error creating database

  Asked By: Keaton    Date: Jul 30    Category: Sharepoint    Views: 659

I’m in the process of creating a test environment, the WSS install goes fine, but when the configuration screen opens, I received the following error;

Login failed for user 'HOMEA\HQVGSPSDN1$'. (Error code: 18456).

Any ideas on the cause, and how to remedy the situation?



5 Answers Found

Answer #1    Answered By: Darrius Whitfield     Answered On: Jul 30

Looks like a SQL error  make sure that the account you are using for WSS has SQL admin privileges

Answer #2    Answered By: Adrienne Greene     Answered On: Jul 30

Just to make sure, will local admin rights work, or does the install  require domain admin rights?

Answer #3    Answered By: Joshuah Huber     Answered On: Jul 30

Option C: the user  must have DBOwner rights on the specified database. If the database  is on the same server as sharepoint, then having local admin priviledges should do the trick.

Answer #4    Answered By: Ciara Collier     Answered On: Jul 30
Answer #5    Answered By: Keenan Whitehead     Answered On: Jul 30

Finally found the problem. IIS was using it’s default user  name instead of the account I had created in SQL. After putting in the correct information, the rest of the install  went without a problem.

Didn't find what you were looking for? Find more on error creating database Or get search suggestion and latest updates.