SQL connection string

Question

website needs to go live which i have placed on client server.i have gven all permissions for IIS.in web.config file i have also given SQL connection string as :

<appSettings>
<add key="ConnectionString" value="Data Source=USER\SQLEXPRESS;Initial Catalog=people_metrix;User ID=MyUser;Password=abc123"/>  </appSettings>

In sql server 2005 have allowed remote connections(TCP/IP and named pipes).
but am not able to login to webasite.Username and password exist in database.

In server,firewall is on and there is no IP address(Obtains IP adress automatically).Is Login not happening due to these reasons ?

edited to remove sa (though revision history is still there) — Mitch Wheat
– Mitch Wheat, Commented May 5, 2009 at 4:24

Mitch Wheat · Accepted Answer · 2009-05-05 04:32:19Z

1

Please don't EVER use 'sa' in a connection string. EVER!

First try connecting using SQL Server Management studio with your connection string credentials (and not sa!).

Does the firewall on SQl sServer machine allow traffic on port 1433?

To allow connections to SQL Server by TCP port, perform the following steps.

Click Start | Control Panel | Network Connections
Right click on the network adapter that services inbound connections to SQL Server and select Properties
Select Advanced | Windows Firewall | Settings
Select Exceptions | Add Port
Under Name put "SQL Server" and under Port Number select 1433. Use TCP as the protocol.
Click OK to close out all dialogs.

If you're using anything other than standard TCP/IP to access SQL Server, you'll need to enable different ports. To allow RPC over Named Pipes instead of TCP, open port 445 in the same way that I described above.

See this MS support article for configuring remote connections: How to configure SQL Server 2005 to allow remote connections

edited May 5, 2009 at 4:32

answered May 5, 2009 at 4:23

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Guddu Over a year ago

it is connecting using SQL Server Management studio

Mitch Wheat Over a year ago

I did it by mistake, and you can't retract!

ChrisLively · Accepted Answer · 2009-05-05 04:30:42Z

0

You might check out connectionstrings.com

It has several connection string examples.

answered May 5, 2009 at 4:30

ChrisLively

88.3k27 gold badges174 silver badges249 bronze badges

1 Comment

Mitch Wheat Over a year ago

there doesn't appear to be anything wrong with the connection string (except the already noted use of sa)

Collectives™ on Stack Overflow

SQL connection string

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related