Reave's Posts

Okay, repeated the test again. I was successful using a default instance on sql server 2005 express. Does the version of sql server 2005 I use affect wheather or not it will function? ... See more...
Okay, repeated the test again. I was successful using a default instance on sql server 2005 express. Does the version of sql server 2005 I use affect wheather or not it will function? Or does it have to do with wheather or not I used a named instance or the default one.
I performed the capture again. This time I used the user name that I was logged in as to perform the install. I did notice that this drifted the Microsoft/Crypto/RSA folder into the %appdata% f... See more...
I performed the capture again. This time I used the user name that I was logged in as to perform the install. I did notice that this drifted the Microsoft/Crypto/RSA folder into the %appdata% folder instead of %common appdata% so I was able to more faithfully carry out the directions from the step by step guide for sql. However I am still getting the same error message when I launch sql server management studio wheather I set the package to merged or writecopy.
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.
I have an application that uses an unattended installed of sql so I'm unable to check if its configuration is inline with what is posted in the SQL/MSDE step by step guide on the Thinapp blog. ... See more...
I have an application that uses an unattended installed of sql so I'm unable to check if its configuration is inline with what is posted in the SQL/MSDE step by step guide on the Thinapp blog. However, something is deffinitely not right as can be seen from the error message which I have attached along with the log. Error Message: MDSWrapper COM Error -- StartSQLService Error code -x80040424 Description: Unable to start MSSQLSERVER service: 127.0.0.1\JMPS_SQL_SERVER. Microsoft SQL-DMO Service Control Error: The specified service does not exist as an installed service. - Error code -x80070424 - The specified service does not exist as an installed service. Any assistance would be greatly appreciated.