mcintosh78
Programmer
SQLState=42000, NativeError=18452.
I am new to SQL, so be gentle.
I am new to SQL, so be gentle.
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 strongm 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
- Thread starter mcintosh78
- Start date
- Status
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
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
Similar threads
- Locked
- Question
