Developer Edition & Windows Server 2003 Small Business Server

Developer Edition & Windows Server 2003 Small Business Server

Post by am4zMTZzY » Mon, 19 Jul 2004 03:28:01


I have Small Business Server 2003 and am teaching myself VB.Net. I 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?

SteveC
 
 
 

Developer Edition & Windows Server 2003 Small Business Server

Post by Rick Sawte » Mon, 19 Jul 2004 10:11:00


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.

HTH

Rick Sawtell
MCT, MCSD, MCDBA