Remote Sql Server Connection String

[Lamont J]

I have configured Sql Server Express on a server, Enabling TCP/IP and Named Pipes to accept remote connections. However when i attempt to connect from VB.net on another PC on the same network I get the following Error: Failed to login user "ServerName\Use r".

Can anyone offer some server setting and a ADO.NET Connection string.

The attached file has the Sql Server Settings.

Any help would be greatly appreciated.

[kadghar]

Many times this is a problem in your SQL server or in your firewall.

Perhaps you aren't running all the services you need to connect, or perhaps you have to open the SQL server ports in your firewall.

[shrimant]

• Turn off all firewalls, with WIn XP and up, by default the firewalls are turned on.
• First of all try connecting to the SQL server on the SQL server machine, the simplest way would be to create a ODBC and on the last step click the test connection button on the ODBC interface.
• A typlical SQL server connection string for .NET should look like this: [connectionStrin g="Data Source=<SQL SERVERNAME/IP ADDRESS>;Initia l Catalog=<DATABA SE>;User ID=<USERID>;pas sword=<PASSWORD >" providerName="S ystem.Data.SqlC lient]