MS SQL

From Indie IT Wiki
(Redirected from Ms sql)
Jump to: navigation, search

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