purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
MCT, MCSD, MCDBA