Can't connect to SQL Server 2000 with Visual Studio 2005

I've been using Delphi for years (Win 32) and connecting to my SQL Server
databases with no problem.
I am now trying to learn both VB and C#. (Visual studio 2005)
From the Data menu, I select Add New Data Source
I then choose Database
I select Microsoft SQL Server as the Data Source
The Add Connection Dialog appears
It populates the Server name dropdown with both of my SQL servers.
However, when I try to select a database name, the dropdown is never
populated.
If I manually enter a known database name and try to connect, I get a
TimeOut Expired (or server not responding) error.
This happens whether I use windows authentication or SQL server
authentication.
This drill works fine with Delphi (Win 32) and connects without a hitch.
Any help would be appreciated.
Regards,
Dave
Take a look at my connecting whitepaper on my blog. It lays down the basics.
I expect the rights are not setup correctly or you've chosen a server
instance that's not visible on the network.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Dave Davis" <online@.blindsided.org> wrote in message
news:uvZV0Qt3HHA.4400@.TK2MSFTNGP06.phx.gbl...
> I've been using Delphi for years (Win 32) and connecting to my SQL Server
> databases with no problem.
> I am now trying to learn both VB and C#. (Visual studio 2005)
> From the Data menu, I select Add New Data Source
> I then choose Database
> I select Microsoft SQL Server as the Data Source
> The Add Connection Dialog appears
> It populates the Server name dropdown with both of my SQL servers.
> However, when I try to select a database name, the dropdown is never
> populated.
> If I manually enter a known database name and try to connect, I get a
> TimeOut Expired (or server not responding) error.
> This happens whether I use windows authentication or SQL server
> authentication.
> This drill works fine with Delphi (Win 32) and connects without a hitch.
> Any help would be appreciated.
> Regards,
> Dave
>
|||Bill,
Remember, I connect without any problems using Borland's Delphi. I have for
years.
I also connect with no problems using ASP.
If the rights aren't setup properly or the instance wasn't visible on the
network it seems to me that I couldn't connect with anything.
Or, does .net require different rights or something else different in the
SQL server setup?
Thanks,
Dave
"William Vaughn" <billvaNoSPAM@.betav.com> wrote in message
news:elZYHTv3HHA.1484@.TK2MSFTNGP06.phx.gbl...
> Take a look at my connecting whitepaper on my blog. It lays down the
> basics. I expect the rights are not setup correctly or you've chosen a
> server instance that's not visible on the network.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ------
> "Dave Davis" <online@.blindsided.org> wrote in message
> news:uvZV0Qt3HHA.4400@.TK2MSFTNGP06.phx.gbl...
>