if not exists (select * from master.dbo.syslogins where loginname = N'username') BEGIN declare @logindb varchar(132), @loginlang varchar(132) select @logindb = N'dbname', @loginlang = N'us_english' if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb) select @logindb = N'master' if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english') select @loginlang = @@language exec sp_addlogin N'username', N'password', @logindb, @loginlang END GOif not exists (select * from dbo.sysusers where name = N'username' and uid < 16382) EXEC sp_grantdbaccess N'username', N'password' GO
选择“Database Engine”的远程连接,设置为允许远程连接即可
odbc数据连接建立也成功了,但不知道要怎么才能连接数据库?我新建登陆名后是不是要新建用户?如果是的该怎么建?
BEGIN
declare @logindb varchar(132), @loginlang varchar(132) select @logindb = N'dbname', @loginlang = N'us_english'
if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
select @logindb = N'master'
if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
select @loginlang = @@language exec sp_addlogin N'username', N'password', @logindb, @loginlang
END
GOif not exists (select * from dbo.sysusers where name = N'username' and uid < 16382)
EXEC sp_grantdbaccess N'username', N'password'
GO