I have tried for three hours to connect to a network machine running SQL Server Express 2008 from a vb.net client. Will not work. Here is what I have done.
Enabled SQL Browser
No Windows or any fire wall running on either client or server.
TCP is enabled in Server configuration tool for server and client. Port 1433
Using Mixed mode security.
Shared folder for SQL mdf file is wide open privileges. Share is the Data folder of the SQL install location.
PORT UI tool reports port is not listening.
Error I get in database connection wizard of VB.net (long time out) is as follows.
"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 the SQL Server is configured for remote connections. ( provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)"
I have looked at countless forum fixes for this to no avail at all. Reinstalled SQL Express and took all defaults - still no luck. Any help is appreciated.
- Edited by gedkins Tuesday, July 14, 2009 9:49 PM
(1) Is it possible that you specify the server with instance name (computer\SQLEXPRESS) but the SQL Server is installed as a "default" instance (guessing based on the default port number 1433)?
(2) You say: "PORT UI tool reports port is not listening": if this refers to the SQL Server TCP port than you need to ensure that SQL Server is listening on a TCP port, e.g. by enabling TCP in SQL Server Configuration Manager, and then restarting the SQL Server.
friends i too am trying trying to make a shared connection of a same database file in an office. I have chosen vb.net as programming language and sql server as database. Please any one of you can kindly help me whenever i face any shots of problem. I shall be very greatful if any one responds to my message
Some ideas that might help: How to Troubleshoot Connecting to the SQL Server Database Engine
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty