Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting listed error message during install of Goldmine to SQL

Status
Not open for further replies.

mcintosh78

Programmer
Feb 26, 2007
24
US
SQLState=42000, NativeError=18452.
I am new to SQL, so be gentle.
 
Based on a brief search through the internet, it appears as though your error message is an indication of a failed login.

With SQL Server, there are 2 methods of authenticating logins. The default login mode (when you install SQL Server) is Windows Authentication. Windows authentication uses your windows login to authenticate your log in to the database.

SQL Authentication requires you to type in a user name and password.

I think your error message indicates that you attempted a SQL authentication, but SQL Authentication is not enabled on your server. To enable SQL Authentication:

Open SQL Server Management Studio
Right click your server, click properties.
click on the "Security" tab at the top left of the window.
Make sure "SQL Server and Windows Authentication mode" is selected.

You will probably need to restart the SQL Service before the setting takes affect. To restart the service, right click on the server name and click restart.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top