I have a Computer which running Sql express as server (FASTCOPY\SQLEXPRESS)
I went to SQL Server Suface Area
and click on surface area configuration
Then Choose Remote Connections
And click Local and remote connection
Then select SQL Server Browser , and startupType Automatic, and start it
Now for Client Computer
Start menu , Control Panel , then System and Maintenance
Then Administrative Tools
Then Computer Management ,
Then from Services and Applications ,
SQL Native Client Configuration , then Client Protocols
Then enabled each of TCP/IP , Named Pipes and Shared Memory
and Now in the APP within VB2008
MyConnectionString = "Data Source=FASTCOPY\SQLEXPRESS;Initial Catalog=inventory;User ID=sa;Password=xxxxx"
but the problem doesn't work , and give error that may remote connection not selected.
Can any body help.