troubleshooting Question

Opening SQL Server 2008 Remotely

Avatar of Joe Kaminski
Joe KaminskiFlag for United States of America asked on
RoutersMicrosoft SQL Server 2008
17 Comments2 Solutions398 ViewsLast Modified:
I have a Windows Server 2008 R2 network.  On the server resides a vb.net executable application program and a SQL Server 2008 database.  When I am logged directly onto the server I can launch the executable and open the database.  Unfortuantely, Windows Server 2008 does not support Windows 7 style graphics (i.e., forms with rounded corners and banners with opacity).  However, when I navigate from my desktop to the folder on the server with the executable and launch the executable I do get the Windows 7 style graphics, but I get the following error when I try to open the database with these statements.

        SqlConnection0.ConnectionString = "Data Source=" + strDataServer + ";Integrated Security=True;Initial Catalog=" + strDataBase
            SqlConnection0.Open()

strDataServer = "BDP-Server/SQLEXPRESS
strDataBase    = "BDP_Systems"

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)

SQL is configured with the "Allow Remote Connections" box checked.

Any thoughts?

Thanks.
ASKER CERTIFIED SOLUTION
CmdoProg2

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros