SQL Server 2005 Configuration Manager --网络配置--协议看看 TCP/IP 协议是否禁用了
2. 修改了计算机名称,但是现在改回原名称也同样有上面的问题. --user master go exec sp_configure ‘allow updates’,1 reconfigure with overrideupdate sysservers set srvname='XXX',datasource='XXX' where srvname='XXX'exec sp_configure ‘allow updates’,0 reconfigure with override
--user master
go
exec sp_configure ‘allow updates’,1
reconfigure with overrideupdate sysservers set srvname='XXX',datasource='XXX' where srvname='XXX'exec sp_configure ‘allow updates’,0
reconfigure with override