找不到存储过程 ‘Password‘。

 declare @dbpwd as nvarchar(50)
 declare @dbcatalog as nvarchar(50)
 declare @dbserver as nvarchar(50)
 declare @accid as nvarchar(50)
 declare @dbpwdgo as nvarchar(50)
 
 set @dbpwd = '12345679a'
 set @dbcatalog = 'UFDATA_999_2014'
 set @dbserver = 'U8V13'
 set @accid =  '1000000001'
 set @dbpwdgo = '12345679a'
 
INSERT INTO MES_Comm_MAINACC (connstr,accid,caddress,cdbpwd,cdatabase)
VALUES ('Provider=SQLOLEDB.1;Password=' + @dbpwd
 + ';Persist Security Info=True;User ID=sa;Initial Catalog=' +
 @dbcatalog + ';Data Source=' + @dbserver +
 ';Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=' +
 @dbserver + ';Use Encryption for Data=False;Tag with column collation when possible=False',
 @accid,@dbserver,@dbpwd,@dbcatalog)

UPDATE MES_Comm_MAINACC SET CONNSTR= 'Provider=SQLOLEDB.1;Password=' + @dbpwd + ';Persist Security Info=True;User ID=sa;Initial Catalog=' + @dbcatalog + ';Data Source=' + @dbserver + ';Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID='
  + @dbserver +';Use Encryption for Data=False;Tag with column collation when possible=False', CADDRESS = @dbserver,CDBPWD=@dbpwdgo

GO

找不到存储过程 'Password'。

按照此错误信息应该就是系统缺少‘password’这个存储过程，所以只要给系统添加这个存储过程就可以了，具解决方式如下：

打开“查询分析器”，登录的时候选择“Windows验证”而非默认的“SQL Server身份验证”，在MES_Comm_MAINACC 表右键选择“新建查询”下执行以下语句：