sql2005创建远程登录帐户的sql语句（sql2008远程连接失败更改服务）真没想到

CREATE LOGIN HNJM WITH PASSWORD=’hnjmxy123′

USE [job]

GO

CREATE USER HNJM FOR LOGIN HNJM

GRANT SELECT ON ServerAttachments TO HNJM

GRANT SELECT ON ServerCompanies TO HNJM

GRANT SELECT ON ServerDocument TO HNJM

GRANT SELECT ON ServerFrontUsers TO HNJM

GRANT SELECT ON ServerJobPostings TO HNJM

GRANT SELECT ON ServerRecommendedCompanies TO HNJM

GRANT SELECT ON ServerRecommendedPostings TO HNJM

GRANT SELECT ON ServerCompanyJobPostingUpdate TO HNJM