MS SQL
From Indie IT Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
HOWTO: Edit Users
One you'll need to verify that the user you created has the ability to log on. Check the properties inside Sql Server Management Studio. To do this, connect to the database in SSMS. Then find the Security folder. Expand it, and expand the Logins folder. Find the login you are trying to use, right click and choose properties.
On the left is a tree "General", "Server Roles", "User Mapping", "Securables" and "Status". In status make sure that "Permission to connect to database engine" is set to Grant and Login is enabled.
HOWTO: Add ODBC Data Source In 64 Bit Windows System
c:\windows\syswow64\odbcad32.exe
FISH
from the second to last post on this page try this:
C:\>sc create SQLAgent binPath= "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE" type= own start= auto depend= netbios
