VC6 program can't find VS2005 SQLServer

"Andrea Montanari" wrote in


> actually this is not a "good" design as manipulating services state
> requires privileged permissions (starting/stopping/..)

It's an embedded system on dedicated hardware inside industrial equipment.
It "owns" the machine.

> anyway, the very first obvious check is the connection string... is
> the provided instance name correct?

Ok, I think I found where that gets set up.

Is there a utility within VS2005 that lets me inspect the bundled server to
verify that it has the desired initial DB and user? (I'm used to phpMyAdmin
for admin'ing web DB's.)
 >> Stay informed about: VC6 program can't find VS2005 SQLServer 

hi Kenneth,
Kenneth Porter wrote:
>
>> anyway, the very first obvious check is the connection string... is
>> the provided instance name correct?
>
> Ok, I think I found where that gets set up.
>
> Is there a utility within VS2005 that lets me inspect the bundled
> server to verify that it has the desired initial DB and user? (I'm
> used to phpMyAdmin for admin'ing web DB's.)

you can have a look at SMO object model, a managed component for .Net, which
lets you perform administrative tasks with SQL Server.. you can list
available SQL Server instances and manage them, if required.. for database
listing, you just can query sys.databases catalog view to see if your
desired one(s) is/are there..
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply
 >> Stay informed about: VC6 program can't find VS2005 SQLServer 

"Andrea Montanari" wrote in


>> Is there a utility within VS2005 that lets me inspect the bundled
>> server to verify that it has the desired initial DB and user? (I'm
>> used to phpMyAdmin for admin'ing web DB's.)
>
> you can have a look at SMO object model, a managed component for .Net,
> which lets you perform administrative tasks with SQL Server.. you can
> list available SQL Server instances and manage them, if required.. for
> database listing, you just can query sys.databases catalog view to see
> if your desired one(s) is/are there..

I also found Management Studio Express Edition and Web Data Administrator.
Now I need to figure out how to get those talking to the server instance I
can see running with the Services snap-in. The web one wouldn't connect
with either the sa account or the local machine's administrator account, so
I'm hoping MSEE will do it. Otherwise I'll try uninstalling and
reinstalling SQL Server.
 >> Stay informed about: VC6 program can't find VS2005 SQLServer