"Gary Chang" <v-garych@online.microsoft.com> wrote in message
news:fKsgT3gSEHA.796@cpmsftngxa10.phx.gbl...
> Hi Damon,
>
> Do you have installed the SQL Server 2000 SP1 or SP2 *before* the
> installment of the VS.NET?
>
> Please make sure the MSSDI98.DLL in the following directories:
> C:\Program Files\Microsoft SQL Server\MSSQL$SQL\Binn
> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
> is from your Server 2000 SP1 or SP2(e.g. C:\sql2ksp1\x86\other\sdi
> directory) instead of from the VS.NET(e.g. D:\Program Files\Microsoft
> Visual Studio .NET\sqlserver) , you can check their versions to validate
> that.
>
>
> If the above apporach does not work or does not apply, there are a two
more
> troubleshooting steps that may be necessary to pursue. These include:
>
> a) Re-registering SQLDBREG2.EXE and proxy\stub dll SQLDBG.DLL
>
> b) Checking DCOM security configuration settings:
> Run DCOMCNFG.EXE.
> In the Distributed COM Configuration Properties window, select the Default
> Security tab. Under Default Access Permissions, click Edit Default. If
> group Everyone does not already have permissions, you may add it by
> clicking
> Add. Select the local machine name from the List Name From list. Select
> Everyone and make sure that Type of Access is set to Allow Access. Then
> click OK.
>
> OR
>
> If you prefer to limit debugging to specific users, you can add individual
> domain user accounts (e.g. domain\account) with administrator privileges.
> If you choose to add only domain accounts instead of Everyone, make sure
to
> add the SYSTEM account as well.
> Switch to the Applications tab of the Distributed COM Configuration
> Properties dialog.
> Scroll through the Applications list and select SQLDBREG. Then click
> Properties. Select the Identity tab and make sure that The interactive
user
> is selected as the user to run this application.
> Click OK to close the dialog box.
> Restart the SQL Server service.
>
> Reboot your machine.
>
>
> Additionally you can refer to the following MSDN link:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/htm
>
l/vxtbstroubleshootingsqldebuggingsetuperrormessageunabletostartsqldebugsess
> ion.asp
>
>
> Thanks!
> Best regards,
>
> Gary Chang
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --------------------
>

"Gary Chang" <v-garych@online.microsoft.com> wrote in message
news:ZATwWLqSEHA.328@cpmsftngxa10.phx.gbl...
> Hi Damon,
>
> Since you have installed the SQL Server 2K SP3, there would be a sql2ksp3
> directory in your machine, please copy the SP3's MSSDI98.DLL from the
> sql2ksp3 directory(e.g. C:\sql2ksp3\x86\other\sdi) to your E:\program
> files\microsoft SQL server\mssql\binn, overwriting the VS.NET 's DLL.
>
> Then if it does not work or does not apply, you can try to re-register
> SQLDBREG2.EXE and proxy\stub dll SQLDBG.DLL.
>
>
> Thanks!
>
> Best regards,
>
> Gary Chang
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --------------------
>

> ... Also the DLL from the service pack is 7.11.2316.0 which is an older
version than
> the one that comes with visual studio .NET 7.11.3077.0.

> I would like to try and re-register SQLDBREG2.EXE and proxy\stub dll
> SQLDBG.DLL. Do you have some instructions for re-registering these on
> Windows 2003 server? The only registratoin instructions I have found for
> these is for Windows 2000 server.

"Gary Chang" <v-garych@online.microsoft.com> wrote in message
news:IZ723lTTEHA.2988@cpmsftngxa10.phx.gbl...
> Hi Damon,
>
> > ... Also the DLL from the service pack is 7.11.2316.0 which is an older
> version than
> > the one that comes with visual studio .NET 7.11.3077.0.
> yes, it is as expected.
>
> > I would like to try and re-register SQLDBREG2.EXE and proxy\stub dll
> > SQLDBG.DLL. Do you have some instructions for re-registering these on
> > Windows 2003 server? The only registratoin instructions I have found for
> > these is for Windows 2000 server.
>
> The registratoin instructions under Windows 2003 server would be same as
> Windows 2000 server, does it not work?
>
>
> Thanks!
>
> Best regards,
>
> Gary Chang
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --------------------
>