Sunday, February 19, 2012

Developer Edition & Windows Server 2003 Small Business Server

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
"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> 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
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

No comments:

Post a Comment