問(wèn)題描述

我正在從 VB 6 應(yīng)用程序運(yùn)行 SQL Server 2005 數(shù)據(jù)庫(kù).我連接到數(shù)據(jù)庫(kù)通過(guò) ODBC DSN.

I'm running a SQL Server 2005 database from a VB 6 Application. I connect to the database through an ODBC DSN.

我將運(yùn)行 SQL 服務(wù)器默認(rèn)實(shí)例的計(jì)算機(jī)從軟件"重命名為IT".然后我運(yùn)行 sp_dropserver 和 sp_addserver 存儲(chǔ)過(guò)程來(lái)重命名實(shí)例.

I renamed the computer on which I'm running the default instance of SQL server from 'Software' to 'IT'. I then ran the sp_dropserver and sp_addserver stored procedures to rename the instance.

重新啟動(dòng) SQL Server 服務(wù)后，服務(wù)器能夠使用新的 SQL Server 名稱.

On restarting the SQL Server service, the server was able to pick up on the new SQL Server name.

將ODBC數(shù)據(jù)源名稱配置為新名稱后，連接正常.我能夠運(yùn)行我的應(yīng)用程序并通過(guò) ADO 記錄集讀取記錄.但是我無(wú)法使用 .Update 方法更新任何記錄集.我收到以下錯(cuò)誤... SQL Server 未配置數(shù)據(jù)訪問(wèn)

After configuring the ODBC data source name to the new name, the connection was Ok. I'm able to run my application and read records through ADO record sets. However I'm unable to update any recordset using the .Update method. I get the following error instead ... SQL Server not configured for data access

如何在重命名的服務(wù)器實(shí)例上啟用數(shù)據(jù)訪問(wèn)?

How can I enable data access on the renamed server instance?

推薦答案

如何:重命名承載 SQL Server 2005 獨(dú)立實(shí)例的計(jì)算機(jī)

您應(yīng)該能夠在任何鏈接服務(wù)器上運(yùn)行它，但不能.它不是鏈接服務(wù)器.這是本地的.

You should be able to run this but not against any linked server. It's not a linked server. It's local.

EXEC sp_serveroption 'YourServer', 'DATA ACCESS', TRUE

這篇關(guān)于未針對(duì)數(shù)據(jù)訪問(wèn)配置 SQL Server的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！