I am working to virtualize sql server 2005 in order to support a virtual application that makes use of it but I am encountering some difficulties. When I start Sql Server ...
See more...
I am working to virtualize sql server 2005 in order to support a virtual application that makes use of it but I am encountering some difficulties. When I start Sql Server management studio and authenticate using Sql Server Authentication I recieve the following error. “A network-related or instance-specific error occurred whileestablishing a connection to SQL Server. The server was not found orwas not accessible. Verify that the instance name is correct and thatSQL Server is configured to allow remote connections. (provider: SQLNetwork Interfaces, error: 26 – Error Locating Server/InstanceSpecified) ” I have attached a graphic of the origional error message. I am using the following script gleaned from the forums to force to the sandbox all of the databases within the package as suggested in other posts. 'SQL Force to sandbox script Sub ForceToSandbox(FileName) Const ForAppending = 8 Dim Fso, F, Ts Set Fso = CreateObject("Scripting.FileSystemObject") Set F = Fso.GetFile(ExpandPath(FileName)) Set Ts = f.OpenAsTextStream(ForAppending) Ts.Close() MsgBox(FileName) End Sub Function OnFirstSandboxOwner ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\distmdl.mdf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\distmdl.ldf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master.mdf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mastlog.ldf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\model.mdf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\modellog.ldf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\msdbdata.mdf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\msdblog.ldf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mssqlsystemresource.mdf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mssqlsystemresource.ldf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\tempdb.mdf") ForceToSandbox("%ProgramFilesDir%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\templog.ldf") End Function Additionally, I am following the portion of the step by step guide: Change the folder isolation level for "%AppData%\Microsoft\Crypto\RSA" from FULL to MERGED by editing the ##Attributes.ini file in that directory and changing "DirectoryIsolationMode=Full" to "DirectoryIsolationMode=Merged". Though I am making the change in %Common AppData%\Microsoft\Crypto\RSA because the folder path doesn't exist in %AppData%. My Sql Server settings: named instance: ML Use the built in System Account: Local System Authentication mode: Mixed Mode Authentication Any advice for rectifying this issue is appreciated.