MS SQL
From Indie IT Wiki
Revision as of 13:56, 16 April 2014 by imported>Plittlefield
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
